Customer experience | Sales, Customer Insights,...

Total Amount field on Invoice entity not getting calculated accurately unless I open Invoice record

(0) Share

Report

Posted on by Sachin Ligam

Hi,

I am creating Invoice and Invoice Line Item entity records programmatically. Here, I am facing issue in calculation of OOB Total Amount field of Invoice entity i.e. somehow the Total Amount is not getting calculated properly on home grid and advance find of Invoice entity. But, when I open the respective Invoice record then Total Amount field is getting calculated correctly and then it gets displayed correctly on home grid and advance find as well.

I have checked by retrieving Invoice entity records as well in my script but the retrieved result is also not returning correct Total Amount.

Anyone have idea about this behaviour.

Thanks in advance!

Sachin

I have the same question (0)

All responses (3)

Answers (0)

Sort by

LuHao 40,892 on at

Like (0)

Report
Copy link

Link copied!

Hi Sachin,

Did you add the script on the Invoice form to calculate the Total Amount field, like Javascript?

If so, then such a script will indeed only work when the form is loaded.

You have to use a plug-in to achieve the calculation.

Was this reply helpful? Yes No
Sachin Ligam 45 on at

Like (0)

Report
Copy link

Link copied!

Hi Lu Hao,

Thanks for your response.

I am using OOB Total Amount field which is getting calculated OOB. I haven't added custom field and custom code.

Thanks!

Sachin

Was this reply helpful? Yes No
Suggested answer

LuHao 40,892 on at

Like (0)

Report
Copy link

Link copied!

Hi Sachin,

You can try using an on-demand workflow to update invoices created programmatically, I think it will make the OOB Total Amount field recalculated.

Use a field's existing value to update it, which means the data does not change, just trigger a save event.

Then run this on-demand workflow for Invoices.

Was this reply helpful? Yes No