Saving in Default Interface Account prompts messege : " Invalid Account code "

Created by Lucas Leong Yee Hong, Modified on Tue, 10 Nov, 2020 at 4:21 PM by Lucas Leong Yee Hong

Question: 

Step 1 : System Options - General - Account code - Format is xxxxxxxx and they didn't tick the column of 'Free Text Format for Account code'. Step 2 : File - General Maintenance - Default Interface Account - Prompt message 'Invalid Account Code.' 



Answer:


To solve this problem, have to go to QnE Management Tools - Tools - Intelligence SQL Queries - tick the column of 'Overwrite General SQL', key in the script as below in the rectangle column then click on Execute SQL icon.

update defaultinterfaceaccount set glaccountcode =''

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article