calc (sum) line amount

(0) Share

Report

Posted on by HelioBuenos

Hi,

I have a question. How can I sum LineAmount of PurchRequisition based on PurchReqId? I need to show sum of LineAmount based on the PurchReqId into new field (NewField).
Should I add method in table or form?

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (1)

Report

I guess you're going to write a display method. You should put it to the table, because then you can cache it. It's extremely important from performance perspective.

By the way, why did you attach tags "Connector for CRM" and "Administration and Setup"?

Was this reply helpful? Yes No
HelioBuenos 62 on at

Like (0)

Report

Hi Martin,
[quote]
I guess you're going to write a display method. You should put it to the table, because then you can cache it. It's extremely important from performance perspective.

By the way, why did you attach tags "Connector for CRM" and "Administration and Setup"?
[/quote]
Is there any other alternative way instead of write a display method?

I have edited the tags you mention.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Yes, you can also maintain the sum in some physical field. But that's a lot of effort since you need to capture every possible process that can impact the sum, and trigger recalculation of that field.

So, if you just want to show the sum of lineAmount, a display method is most likely the best approach.

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi HelioBuenos,

You could also extend the PurchReqTable table and add your new field. Then extend the PurchReqLine table, and write your code of the calculation logic to its INSERT \ Update \ DELETE method.

Here is a same thread:

community.dynamics.com/.../in-x-calculate

Hope this helps.

Was this reply helpful? Yes No
HelioBuenos 62 on at

Like (0)

Report

Hi Nikolaos,

I forgot to mention that the NewField is on PurchReqTableListPage.

Was this reply helpful? Yes No
HelioBuenos 62 on at

Like (0)

Report

I am still new in AX, can you please help me with display method?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (1)

Report

Hi HelioBuenos,

Please read this document:

docs.microsoft.com/.../using-the-display-method-modifier

Was this reply helpful? Yes No
HelioBuenos 62 on at

Like (0)

Report

Hi Willy,

Thank you!

Was this reply helpful? Yes No