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