All Collections
Business System Integrations
Dynamics GP (Standard/Advance)
Errors
Dynamics GP (Standard/Advance) - [ERROR] Subtotal does not match the line item totals
Dynamics GP (Standard/Advance) - [ERROR] Subtotal does not match the line item totals
Micah A. Parker avatar
Written by Micah A. Parker
Updated over a week ago

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

Did this answer your question?