SAP Knowledge Base Article - Public

2488571 - Unable to Import Chart of Accounts from Microsoft Excel

Symptom

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 incident.

Reproducing the Issue

  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 incident.

Cause

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

Resolution

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.

Keywords

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

Product

SAP BUSINESS BYDESIGN 1708