Getting all the totals from a subreport on the main report

  • 26 September 2023
  • 2 replies

Userlevel 2

I have a subreport that gets the total amount invoiced for a sales order.  In the main report i get sales orders with an invoice in a date range and then pass in the sales order number to the subreport to get the total invoice regardless if the invoice is in the entered date range.  The subreport works correctly but in the main report it is not giving me a correct total.  It will sum all but the last value from the subreport.  I’ve tried every combination of the ProcessOrder I can think of.  


Attached are the two reports.


Best answer by vpoulson 5 October 2023, 14:43

View original

2 replies

Userlevel 2

I found the solution.  I had the variable in the parent report in the group header. I moved it to the group footer and it is now calculating correctly.

Userlevel 7

Thank you for sharing your solution with the community @vpoulson!


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 — 2023  Acumatica, Inc. All rights reserved