Skip to main content
Solved

Adding totals to our Filters

  • February 20, 2025
  • 5 replies
  • 67 views

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?

nhatnghetinh
Captain II
Forum|alt.badge.img+11

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


  • Freshman II
  • February 20, 2025

okay, thank you

 


Nilkanth Dipak
Semi-Pro I
Forum|alt.badge.img+10

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

  

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


  • Freshman II
  • February 20, 2025

Thanks ​@Nilkanth Dipak - that worked - appreciate your help 😊


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