FA Troubleshooting: Posting error - Cannot set column 'RefNo2'. The value violates the Max Length limit of this column.: Difference between revisions
FA Troubleshooting: Posting error - Cannot set column 'RefNo2'. The value violates the Max Length limit of this column. (view source)
Revision as of 04:36, 27 June 2023
, 10 months agono edit summary
(Created page with "'''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. Fil...") |
No edit summary |
||
Line 12:
<u><b>Solution (1):</b></u>
It is advisable to change to a shorter asset code.
Line 27:
By: Soh Wee 180518, KM 180521, P180522▼
<u><b>Solution (2):</b></u>
▲By: Soh Wee 180518, KM 180521, P180522
Extend the RefNo2 maximum length to 50 in table JEDTL and GLDTL.
1) Perform backup, and login <span style='color:red'>AutoCount Management Studio</span>, go to <span style='color:red'>Tools > SQL Query</span>.
[[File:Asset ref2 3.png]]
2) Run the following 2 SQL queries:<br/>
alter table jedtl alter column refno2 nvarchar(50)<br/>
alter table gldtl alter column refno2 nvarchar(50)
[[File:Asset ref2 4.png]]
After extended the ‘RefNo2’ maximum length to 50, you can successfully post the journal.
[[File:Asset ref2 5.png|1100px]]
[[File:Asset ref2 6.png]]
By: Park Yao 230615, Lay Swan 230623, P230626
{{NavigateForUser}}
[[Category:Users]]
| |||