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

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.

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.

Or,

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.

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.

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

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

By: Park Yao 230615, Lay Swan 230623, P230626

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