This article covers how to resolve the "string or binary data would be truncated" error in iplicit's Fixed Assets module. This error appears in the event log when an asset created from a purchase invoice fails to submit. It is caused by the asset description exceeding the maximum character limit allowed by the system.
Resolution
- Open the asset record from Asset > Assets from the Main Menu, or enter 'Assets' in the Quick Launch side menu
- Locate and open the affected asset
- Select 'Edit'
- Shorten the text in the 'Description' field
- Select 'Submit'
The asset will submit successfully once the description is within the character limit.
Customer search terms
String or binary data error on assets
Asset won't submit
Asset submit error
Asset description too long
Event log asset