[Optimum] How to import Chart of Account from existing database after database creation (User forgot to select “Import Chart of Account from another database)
First Part: Login to existing database (already with complete set of Chart of Account)
- Go to Tools > Customization Centre > QNE Optimum
2. Go to NavigationItems > Items > General Ledger > Items > GL Account
Set Visible to “True”
3. Save and re-login to system
4. Go to General Ledger > you can see there’s added tab “ GL Account”
*Which is consist of all GL account that you created in Chart of Account
5. Ctrl + A to select all > right click > IO > Export > to Excel / Xml > save to your desktop
Second part: Login to new database
- Go to General Ledger > Chart of Account > Click “Import From”
- Select the file that you export from [First part – Step 5]
- Click “Next”
4. Click “Guess Mapping” > Import
5. Click “Finish” if status as SUCCESS
6. Double check Chart of Account with added GL account
7. Go to Tools > Customization Centre > QNE Optimum
>NavigationItems > Items > General Ledger > Items > GL Account
Set Visible to “False” (refer [First part – Step 1 to 2])
Please refer attachment for detail
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article