SAP Knowledge Base Article - Public

2085511 - 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, nothing happens.

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. Nothing happens.

Cause

Before clicking on Import from Microsoft Excel button, you have to add a row in the Chart of Accounts screen.

Resolution

In order to be able to import the Chart of Accounts from Microsoft Excel you need to click on Add Row first. Then you will be able to select the XML File.

Keywords

KBA , AP-ACC , Business ByDesign: Financial Accounting , How To

Product

SAP Business ByDesign all versions