Symptom
- You log on to your system in a local language other than English, for example German. You want to download a Chart of Accounts template to Microsoft Excel related to a foreign language, for example CAFR - CAFR: French Chart of Accounts.
- After downloading the template you open the Excel file but the error message "We found a problem with some content in 'ABC.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook , click yes." (ABC.xlsx refers the Microsoft Excel file name).
Environment
SAP Business ByDesign
Reproducing the Issue
- Log on to your system in your local language, for example German.
- Access the Chart of Accounts, Financial Reporting Structures, Account Determination fine-tune activity, either from the Implementation project or from the Business Configuration Overview (if your system is live already).
- Under Chart of Accounts press Copy template chart of accounts.
- In the Template Chart of Accounts field select a chart of account related to a foreign language, for example CAFR - CAFR: French Chart of Accounts.
- Press Download Chart of Accounts to Microsoft Excel.
- After the file is downloaded and saved as ABC.xlsx open it.
- The error message "We found a problem with some content in 'ABC.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes."
- The file only contains one sheet. All financial reporting structure related sheets are missing.
Cause
In SAP Business ByDesign some downloaded content, for example chart of account templates, can only be fully generated when logged on in English or the relevant language, here French.
Resolution
- Log on to your system either in English or in the language related to the chart of accounts that you need to download, here French.
- Access the Chart of Accounts, Financial Reporting Structures, Account Determination fine-tune activity, either from the Implementation project or from the Business Configuration Overview (if your system is live already).
- Under Chart of Accounts press Copy template chart of accounts.
- In the Template Chart of Accounts field select a chart of account related to a foreign language, for example CAFR - CAFR: French Chart of Accounts.
- Press Download Chart of Accounts to Microsoft Excel.
- After the file is downloaded and saved as ABC.xlsx open it.
This time the file opens without any errors and all the necessary sheets are available.
Keywords
Kontenplan herunterladen, download chart of accounts, download to Microsoft excel, language, We found a problem with some content , KBA , problem bei einigen inhalten ms excel , kontenplan herunterladen , AP-ACC-AD-GLO , Cross-Country Extensions , Problem
Product
SAP Business ByDesign all versions