Solved

Getting all the totals from a subreport on the main report

  • 26 September 2023
  • 2 replies
  • 39 views
V
Rank
Userlevel 2
Badge

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.

icon

Best answer by vpoulson 5 October 2023, 14:43

View original
1 Attachment

2 replies

V
Rank
Userlevel 2
Badge

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.

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
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