You’re offline. This is a read only version of the page.
20
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?
Hi Willy,
Thank you!
I am still new in AX, can you please help me with display method?
Hi Nikolaos,
I forgot to mention that the NewField is on PurchReqTableListPage.
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.
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.
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.
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"?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (