Skip to main content
Solved

25RI Generic Inquiry SUM Aggregate $

  • June 1, 2026
  • 1 reply
  • 24 views
S
Freshman I

"In Acumatica 25R1 Generic Inquiry, where do I set SUM aggregate for dollar fields? My Grouping tab only shows Active and Data Field columns."

Best answer by BenjaminCrisman

​@swhitley This is on the Results grid, there is a column for Aggregate Function you can specify SUM. This will of course only work if there is a grouping. If you don’t see the column it’s because it’s in the column configurator (file cabinet looking thing) in the top left corner of the grid.

 

​​​​

      1 reply

      BenjaminCrisman
      Acumatica Employee
      Forum|alt.badge.img+4
      • BenjaminCrisman
      • Acumatica Support Team
      • Answer
      • June 1, 2026

      ​@swhitley This is on the Results grid, there is a column for Aggregate Function you can specify SUM. This will of course only work if there is a grouping. If you don’t see the column it’s because it’s in the column configurator (file cabinet looking thing) in the top left corner of the grid.

       

      ​​​​

        Terms & ConditionsAccessibility statement
        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