Solved

Display a total on a Generic Inquiry.

  • 12 September 2023
  • 2 replies
  • 264 views

Userlevel 3
Badge

Is it possible to add a total (Summary) at the Bottom or the Top of a Generic Inquiry in an area as highlighted on the screen shot below.   We want to get a Total for all the orders in the list.

 

icon

Best answer by meganfriesen37 12 September 2023, 03:46

View original

2 replies

Userlevel 7
Badge +17

@sspencer Yes, we can show the Totals of each column-wise at bottom using the Total Aggregate function in generic inquiry. 

 

Please find the screenshots for your reference.

 

Userlevel 7
Badge +10

If you edit the generic inquiry, you can get the total at the Bottom Only.

Under the “Total Aggregate Function” column select the “Sum” option.
 

 

Then, at the bottom of your GI, you’ll get the total based on your current filter criteria.
 

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved