FA Troubleshooting: Posting error - Cannot set column 'RefNo2'. The value violates the Max Length limit of this column.

From AutoCount Resource Center

Question: When I click on save & post to journal, it shows me an error:’’ Cannot set column 'RefNo2'. The value violates the Max Length limit of this column.

Asset ref2 1.png

Possible Reason:

This is due to the Asset Code is too long. Maximum length for ref2 in Journal entry is limited 20 characters only. Once the asset code is more 20 characters, it can’t be posted to journal.

Solution (1):

It is advisable to change to a shorter asset code.


For Posting Journal Method, select the option of summary- by Account Code. Once you choose this option, asset code wouldn’t be posted into journal.

Go to Asset Register > Setting; change the posting method from Details to Summary -by Account Code. Click on Save to exit.

Asset ref2 2.png

By: Soh Wee 180518, KM 180521, P180522

Solution (2):

Extend the RefNo2 maximum length to 50 in table JEDTL and GLDTL.

1) Perform backup, and login AutoCount Management Studio, go to Tools > SQL Query.

Asset ref2 3.png

2) Run the following 2 SQL queries:
alter table jedtl alter column refno2 nvarchar(50)
alter table gldtl alter column refno2 nvarchar(50)

Asset ref2 4.png

After extended the ‘RefNo2’ maximum length to 50, you can successfully post the journal.

Asset ref2 5.png

Asset ref2 6.png

By: Park Yao 230615, Lay Swan 230623, P230626

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