Product: Dynamics GP (Standard/Advance)

Article Link: http://help.truecommerce.com/en/articles/6554991-dynamics-gp-standard-advance-error-string-or-binary-data-would-be-truncated-the-statement-has-been-terminated

Error: String or binary data would be truncated. The statement has been terminated.

Issue: When exporting a Purchase Order (850) to Dynamics GP - you receive the error: String or binary data would be truncated. The statement has been terminated.

Reason: This is usually caused by a field you're passing to be greater in length than what Dynamics GP is going to accept

The Quick Fix

You'll need to grab a log of your data first, with that data you'll want to find the ExportTransactions() xmlRequest line and break it out. Compare the data to the length field within Dynamics GP's API Guide.

If a value is longer than supported - have it truncated by either the Trading Partner or through the Integration Layer

Getting a Log

Dynamics GP API - Header

Dynamics GP API - Line

rev 9/13/22