All Collections
Business System Integrations
Dynamics GP (Standard/Advance)
Errors
Dynamics GP (Standard/Advance) - [ERROR] Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)
Dynamics GP (Standard/Advance) - [ERROR] Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)
Micah A. Parker avatar
Written by Micah A. Parker
Updated over a week ago

Product: Dynamics GP (Standard/Advance)

Article Link: http://help.truecommerce.com/en/articles/6589830-dynamics-gp-standard-advance-error-document-amount-does-not-equal-subtotal-freight-misc-taxamt-freighttax-misctax-tradedisc

Error: Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

Issue: When exporting an inbound Purchase Order (850) from your Trading Partner you receive the error message 'Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)'

Reason: Dynamics GP calculates the Total regardless of if Transaction Manager sends a pre-calculated value, if they do not match it will error

Solution

Mapping Manager

If you have access to Mapping Manager you'll need to make sure the Document Amount field is properly summing up all the following fields being passed

  • Subtotal (SUBTOTAL)

  • Freight (FREIGHT

  • Misc (MISCAMNT)

  • Tax Amount (TAXAMNT)

  • Freight Tax (FRTTXAMT)

  • Misc Tax (MSCTXAMT)

  • Trade Discount (TRDISAMT)

Row: taSopHdrInvInsert

Field: DOCAMNT

Example

Example: DOCAMNT does not properly round compared to Extended Prices

rev 9/26/22

Did this answer your question?