Skip to main content
Solved

Adding totals to our Filters

  • February 20, 2025
  • 5 replies
  • 72 views

  • Freshman II
  • 5 replies

Hi all - I'm only new here and to the product.  Just hoping I could get some assistance with this.
We have several filters for different things in our Invoice/Memo and Bills/Adjustment areas.  Just wondering is there a way we can get a total to that filter - screenshot below.  Thanks heaps.

 

 

Best answer by Nilkanth Dipak

Hi ​@Elke,

You want to see totals for columns as below, right?

If I understood your issue correctly, you just need to add Total Aggregate Function to your column, that’s it.

 

Hope, it helps!

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

5 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 566 replies
  • February 20, 2025

Hi ​@Elke 

Your screenshot is Generic Inquiry. For Generic Inquiry we can create a total Column but cannot create a total Row

 

If you want to create a total Row in the report then you can use Report Designer to create the report as shown in the screenshot below.

 

Best Regards,

NNT


  • Author
  • Freshman II
  • 5 replies
  • February 20, 2025

okay, thank you

 


Nilkanth Dipak
Semi-Pro II
Forum|alt.badge.img+10
  • Semi-Pro II
  • 442 replies
  • Answer
  • February 20, 2025

Hi ​@Elke,

You want to see totals for columns as below, right?

If I understood your issue correctly, you just need to add Total Aggregate Function to your column, that’s it.

 

Hope, it helps!


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 733 replies
  • February 20, 2025

  

nhatnghetinh wrote:

Hi ​@Elke 

Your screenshot is Generic Inquiry. For Generic Inquiry we can create a total Column but cannot create a total Row

 

If you want to create a total Row in the report then you can use Report Designer to create the report as shown in the screenshot below.

 

Best Regards,

NNT

​@nhatnghetinh Actually we can create this using Total Aggregate Function on the GI, which is hidden by default but can be brought out from the column configurator


  • Author
  • Freshman II
  • 5 replies
  • February 20, 2025

Thanks ​@Nilkanth Dipak - that worked - appreciate your help πŸ˜Š


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