2488571 - Unable to Import Chart of Accounts from Microsoft Excel

You upload your first Chart of Accounts using the option Import From Microsoft Excel, however when you select the template, you receive the error message:

An error occurred. Try resuming your work. If you still face issues, open an case.

1. Go to Business Configuration Work Center.
2. Go to Implementation Projects View.
3. Select the respective project and click on Open Activity List.
4. Go to Fine-Tune Tab and search for activity Charts of Accounts, Financial Reporting Structures, Account Determination.
5. Click on Open button.
6. Select Edit chart of accounts.
7. Click on Import from Microsoft Excel button.
8. Click on Browse, select the file and click on Open.
9. Error appears: An error occurred. Try resume your work. If you still face issues, open an case.

This error is appearing because you are not using the correct Import Template.

Anytime that you want to upload a Chart of Accounts using the Import from Microsoft Excel option, you must download a new template, this can be done by following the below steps:

1. Go to Business Configuration work center.
2. Open Implementation Projects subview.
3. Select the project and click on open activity list.
4. Navigate to Fine Tune and select the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
5. Click on Edit chart of accounts.
6. Select Import from Microsoft Excel.
7. Select Download.

Make sure that you save the download file as .XML (XML DATA)
Then add all  required changes to this file.
Make sure you make all the changes in Columns E (Open Item Management) and F (G/L Account Posting Block) manually -> selecting the options from the dropdown.

Save this file again as an .XML (XML DATA).

Now, you can upload the amended file successfully.

Please note: Do not open this file again for editing before uploading, as this corrupts the data and you will not be able to upload it. You will have to do the whole process again.

KBA , SRD-FIN-GL , General Ledger , How To