When create new database import existing COA prompt error

Created by Ariel Hoong, Modified on Fri, 1 Sep, 2023 at 1:00 PM by Ariel Hoong

Scenario: 

Imported existing Chart Of Account to new database, when login prompt below error:


Solution:

How to Connect to Database use Microsoft SQL Server Management Studio:

https://support.qne.com.my/support/solutions/articles/81000385373-how-to-connect-to-database-use-microsoft-sql-server-management-studio 

 

You may refer the link above for the knowledge base solution. 

 

1) Go to SSMS (Microsoft SQL Server Management Studio) find out which GL account have issue. Can refer below and run script

 

select * from GLAccounts where id = 'FC5F23C3-79A0-4223-ACE3-0F91803687CD'

 

*refer to the error message and copy the id replace 'FC5F23C3-79A0-4223-ACE3-0F91803687CD'



2) After find out is GL account code 400-1200, go to SSMS and run below script:

 

update glaccounts

set Id = newid()

where glaccountcode = '400-1200'

 

*depend on the GL account code and replace ‘400-1200’


3) After run script able to login system 


 

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software



Refer attachment for details   

 

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