Questions Comparison of subtotals in both a subreport and main report

Hello,

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.

Example:

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.

1. 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.

2. 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.

Any advice?

THANKS!