• Balaram Admin
  • NEWBIE
  • 15 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 3
    Replies
Hi Guys,
Requirement: insert Contact Mailing address with Account Address when a create new contact and Mailing address is null...

 
1. custom object called invoice with field as
     a.invioce number(auto number)
     b.invioce date( date)
     c.Account Name(lookup with Account)
     d.invioce Amount(Roll up Summary,sumof allitems Price field of invioce Line Items object)
2.custom object called invoice Line Items with field as
    a.Invioce( Master Detail with Invioce)
    b.Product(Lookup with product)
    c.Quantity(Number)
     d.Unit Price(Currency)will contain price of one product
    e.Total Price((Formula, Quantity*Unit Price

My requirement:
Creat a  trigger on invoice line item to update account balence as sum fo all associated invoices amount for the account.(Create a custom field on Account Called "Account Balance" as currency data type)

write a trigger on invoice line item(child object) to update account balence as sum fo all associated invoices amount for the account.
child obj:invoice
fields:invioce number,invoice date, invoice amount(rollup), account name(lookup with account)
obj2: invoice line iteam
fields:invoice(MD with invoice),product,quantity,unit price,total price(Formula,Qua*UNT pri)
account coustem field: account balance(currency data type)
Hi Guys,
Requirement: insert Contact Mailing address with Account Address when a create new contact and Mailing address is null...

 
1. custom object called invoice with field as
     a.invioce number(auto number)
     b.invioce date( date)
     c.Account Name(lookup with Account)
     d.invioce Amount(Roll up Summary,sumof allitems Price field of invioce Line Items object)
2.custom object called invoice Line Items with field as
    a.Invioce( Master Detail with Invioce)
    b.Product(Lookup with product)
    c.Quantity(Number)
     d.Unit Price(Currency)will contain price of one product
    e.Total Price((Formula, Quantity*Unit Price

My requirement:
Creat a  trigger on invoice line item to update account balence as sum fo all associated invoices amount for the account.(Create a custom field on Account Called "Account Balance" as currency data type)

write a trigger on invoice line item(child object) to update account balence as sum fo all associated invoices amount for the account.
child obj:invoice
fields:invioce number,invoice date, invoice amount(rollup), account name(lookup with account)
obj2: invoice line iteam
fields:invoice(MD with invoice),product,quantity,unit price,total price(Formula,Qua*UNT pri)
account coustem field: account balance(currency data type)