Troubleshooting: Import items error - Cannot set column ‘ItemGroup’. The value violates the MaxLength limit of this column.

From AutoCount Resource Center

Question: I’ve Exported All Data from ‘Company A’ and then when I trying to Import All Data to ‘Company B’, error message prompted: Cannot set column ‘ItemGroup’. The value violates the MaxLength limit of this column.

Version: 1.8 / 1.9 / 2.0

Exceed maxlength1.png

Possible Reason:

There is some Item Group length has exceeded the original length.

‘Company A’ has changed the User-Defined Data Type Size for Item Group to greater length. Therefore, in ‘Company A’ can maintain Item Group longer than its original length. But in ‘Company B’ the User-Defined Data Type Size for Item Group still remains as original state.

E.g. Item Group length for Company A has been changed to 10 characters but Item Group Length for Company B still remains as original size which is 8.

Exceed maxlength2.png

Company A

Exceed maxlength3.png

Company B


1. In your Windows Start Menu, look for AutoCount Accounting 1.8 Management Studio.

Exceed maxlength4.png

2. Login into ‘Company B’ Account Book.

Exceed maxlength5.png

3. Go to Tools > Change User-Defined Data Types Size.

Exceed maxlength6.png

4. Under User-Defined Data Type Name, look for d_ItemGroup.

Exceed maxlength8.png

5. Change the User-Defined Data Type Size to the size that same with ‘A Company’ (E.g.: 10) and then click on Change.

Exceed maxlength9.png

6. A change successful message will be prompted, click on OK.

Exceed maxlength10.png

7. Now, do the Import All Data again and it should be import successfully without any error message.

Exceed maxlength11.png

**Note: Same situation may happen in other fields as well, such as Account No., Area Code, Item Code, Item Type, Department, Project, Location, and UOM. You may use the same way as above to solve the issue.

By: CY 171027, KM 171030, P171103

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