Why Am I Getting the Error "String or Binary Data Would Be Truncated" While Importing a Transaction?

If you receive the error message "String or Binary data would be truncated" while accepting a voucher during transaction import, it indicates that one or more fields—commonly the Invoice Number—exceed the allowed character limit.

  • Specifically, the Invoice Number field should not exceed 50 characters.

  • To resolve the issue, reduce the character count of the respective form in the Invoice Number field to 50 or fewer and update the source bill before retrying the import.