Skip to main content

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.

@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.

https://asiablog.acumatica.com/2016/06/using-pxview-in-dataview-delegate.html


@Naveen Boga  I referred the article but I did not get the idea of it. Can you help further please?


Reply