Show total of a grid column on top of a process screen
Hi,
On top of Release AR Documents screen, I want to show the total of a grid column . How do I do that? Can I do this by using PXFormula() or using RowSelected event?
Can anyone help me?
Thanks.
Page 1 / 1
@Naveen Boga Can you help please?
Hi @charithalakshan49 Thanks for reaching out to me, and here are my suggestions, and hope that helps.
Adding a field in the processing screen and displaying the sum of the grid records is not recommended. In Acumatica no where we can see such behavior.
All these screens will run in the background and if we add such functionality, this may lead to performance issues.
Instead of adding customization in the processing screen and you wanted to sum the grid column, simply you can create a GI with Total Aggregate function (Where it will show the sum of the grid column in the bottom → This is default Acumatica behavior.)
You can use below joins and create a GI.
@Naveen Boga Thank you for the quick response. However, since the requirement is to show the total in the process screen, Is there any way to do that without using a GI?
@charithalakshan49 This is customization not recommended, still, since you wanted to go this customization. Here is the approach.
Create a Filter DAC with Total field
Add Filter view in the Graph.
Add this DAC as a Primary View in the .aspx page
Modify the Processing View with the Filter DAC
Sum the grid column in the View Delete logic and display it in the Header Level.
@Naveen Boga I’m not clear about the last step in your approach.
@charithalakshan49 You can refer below article on the View Delegate.