Apex Code Development You need to sign in to do that
Don't have an account?
hari0853701703454959 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)
Hi friends,
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)
Trigger updateamount on invoicelineitem (after insert){
List <Account> acclist = new List<Account>();
List<Id> accIds = new List<id>();
for(invoicelineitem it : trigger.new){
accIds.add(it.invoice.accountId);
}
for(account acc: [select id, invoice amount from account where id IN:accIds]) {
for((invoicelineitem it : trigger.new){
if(it.invoice.accountid == acc.id){
acc.invoiceamount = it.totalprice;
acclist.add(acc);
}
}
}
// update the accounts
update acclist;
}
what are the changes I have done in trigger anybody can suggest
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)
Trigger updateamount on invoicelineitem (after insert){
List <Account> acclist = new List<Account>();
List<Id> accIds = new List<id>();
for(invoicelineitem it : trigger.new){
accIds.add(it.invoice.accountId);
}
for(account acc: [select id, invoice amount from account where id IN:accIds]) {
for((invoicelineitem it : trigger.new){
if(it.invoice.accountid == acc.id){
acc.invoiceamount = it.totalprice;
acclist.add(acc);
}
}
}
// update the accounts
update acclist;
}
what are the changes I have done in trigger anybody can suggest
Firstly, I am not sure why you need a trigger on Invoice Line Items, instead of on Invoice as when the line item is created, the Invoice also gets updated with the new amount (via rollup summary), So all you have to do is write a trigger on invoice to update the Invoice Amount.
Whatever you are doing in Invoice Line Item makes sense, but then you need to write update and delete actions as well on Line Item.
Please recheck and see if it helps.