Skip to main content
Solved

Getting all the totals from a subreport on the main report


Forum|alt.badge.img

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

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.

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

2 replies

Forum|alt.badge.img
  • Author
  • Freshman II
  • 31 replies
  • Answer
  • October 5, 2023

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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • October 5, 2023

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


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