Pos3/5/FNB: Sync error column Description hit MaxLength limit

Question :

When syncing, I received an error as shown below. How to solve it?

Cannot set column ‘Description’. The value violate the MaxLength limit of this column.

Possible Reason :

The description contains enormous value that does not match current limit of the description column. This is normally a result of copy and paste from excel format.

Solution :

1. login AutoCount POS/Accounting Management Studio > Tools > SQL Query > Yes > enter below query statement > Execute.

select * from Item where Description like '%'+char(13)+'%' or Description like '%'+char(10)+'%'

2. Having identified item listing as shown in query result, go to stock item and edit their description. Try not to copy paste from other source.

3. Perform speed sync again.

By: CK 20230523, Jacky 20230622, P230626 [000422]

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations