Skip to main content
Avalara Help Center

How do I resolve "String or binary data would be truncated. The statement has been terminated." in Sage 500?

Overview

You are trying to validate your credentials in the AvaTax Setup configuration but receive "String or binary data would be truncated. The statement has been terminated."

Environment

Sage 500

Resolution

  • Make sure all Sage 500 users are logged out of Sage 500 and that Sage 500 is closed.
  • Uninstall AvaTax on the Server
  • Reinstall AvaTax on the Server
  • Re-enter credentials and validate

Note: You must install AvaTax for Sage 500 on your Sage 500 server and on the workstation of every Sage 500 user who needs to use AvaTax.

Next steps 

For more information, see Sage 500