ConnectWise 'UpdateBatch' returned an error: System.Data.SqlClient.Sql.Exception (0x80131904): String or binary data would be truncated.

Applies to: ConnectWise Manage, Xero, QuickBooks Online

Error

How can this happen?

There's a special character in your Invoice, PO Packling Slip or PO Number, or Inventory Adjustment ID.

It could also be that the Packing Slip combined with the PO number contains more than 50 characters. ConnectWise Manage doesn't allow a batch ID longer than 50 characters.

Solution

Check the PO number or Packing Slip if it contains invalid characters. Symbols that shouldn't be used include:

  • |
  • '
  • #

Check if the PO number and Packing Slip combined is more than 50 characters. If so, use shorter PO number or Packing Slip

Note for Inventory Adjustments

The ID for an Inventory Adjustment cannot contain any special characters. If it does, then a support ticket will need to be logged with ConnectWise to have them remove the illegal characters from the Inventory Adjustment ID/ Name or Description.

P
Paul is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.