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:

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.