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:

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.


Asset ref2 2.png



By: Soh Wee 180518, KM 180521, P180522



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