Skip to main content
Solved

Show total of a grid column on top of a process screen


Forum|alt.badge.img+1

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.

Best answer by Naveen Boga

@charithalakshan49  You can refer below article on the View Delegate.

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

View original
Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img+1

@Naveen Boga Can you help please?

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3407 replies
  • July 18, 2022

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.

 


Forum|alt.badge.img+1

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3407 replies
  • July 18, 2022

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

 


Forum|alt.badge.img+1

@Naveen Boga  Iā€™m not clear about the last step in your approach.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3407 replies
  • Answer
  • July 18, 2022

Forum|alt.badge.img+1

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings