In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Comparison of subtotals in both a subreport and main report
I have an integration with a 3rd party EDI provider into Acumatica.
I need the ability to compare the incoming EDI (derived from non-standard Acumatica tables) total amount of the EDI sales order with the Acumatica sales order total amount.
EDI sales order total = $50 (data stored in custom tables)
Acumatica Sales Order total = $51
Print this record on my new custom report because the sales order TOTALS don’t match.
Discounts are involved which are causing the discrepancies I need to report.
- I have written a report that accurately reports the Sales Order number and the total from the EDI tables.
I intend to use this as a subreport.
The total is in a group footing as it sums up the individual lines of the order.
This part works.
- I can write a main report that will accurately calculate the total of the actual Acumatica sales order.
However, this too will have the order total in a footer as a subtotal. (main report)
So I have a subtotal on a group in a subreport that I want to compare to a subtotal field on a main report. I only want to report the sales order if there is a difference between the 2 sales order totals.
This seemed doable until I actually tried to put this together.