Product: Dynamics GP (Standard/Advance)
Error: Subtotal does not match the line item totals
Issue: Whenever exporting out an inbound Purchase Order (850) from your Trading Partner you receive the error message 'Subtotal does not match the line item totals'
Reason: Dynamics GP calculates the Subtotal even if Transaction Manager is doing the calculation on our end, if the resulting calculation for Transaction Manager does not match the Dynamics calculation - the system will error out.
The Fix
If you have Mapping Manager
You'll need to make sure that the XTNDPRCE (Extended Price) for each item line (taSopLineInvInsert_Items) totals up to the same amount as the SUBTOTAL (Subtotal) field in the Header (taSopHdrInvInsert).
This can occur do to rounding the extended price, but not the subtotal, or using a calculation that does not match what the item calculation is doing
If you do not have Mapping Manager
Please submit a support ticket to have an integration specialist make the changes for you
Example
Subtotal was not rounded based on XTNDPRCE resulting in ~.02 cents difference
rev 9/26/22