FA Troubleshooting: String or binary data would be truncated error when create new Asset

From AutoCount Resource Center

Question: When I create new Asset, error message prompt “Unknown Sql Exception (Number=8152, Message=String or binary data would be truncated.) when I want to save the Asset. Why?

Binary data1.png


Possible Reason :

The Remark or the field that you are keying in has exceeded max characters.
System will auto allocate the serial number into the asset detail when you create New Asset with Remark.
1. Maximum length for the asset detail is 40 characters only.
2. The comma will be the separator for the Serial Number. Example shown below:

Binary data2.png


Solution :

If you have remark longer than 40 characters, you may key in after the asset is created.
Which mean you need to firstly save the asset created with empty Remark, then edit the asset to key in your Remark.


By: Aimi 211217, Lay Swan 211228, P211229


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations