I want to add a new column for the custom calculation on total of all inventory item’s Ext.Price. How do achieve that. The value should update as the new field is added to the details tab.
Answer
Add custom column for total
Best answer by Naveen Boga
Hi,
- Extend the SOOrder DAC and add a new field
- Write a field selecting an event for this field and add logic to get the Ext Price sum from the Details tab
- FieldSelecting code will be useful to show the updated sum in the header level. Apart from this override a Persist() method and add the same logic to get the sum from the Details tab and assign it to the extended field and update the caches.
+19Hi,
- Extend the SOOrder DAC and add a new field
- Write a field selecting an event for this field and add logic to get the Ext Price sum from the Details tab
- FieldSelecting code will be useful to show the updated sum in the header level. Apart from this override a Persist() method and add the same logic to get the sum from the Details tab and assign it to the extended field and update the caches.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+19Yes that is correct
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.