SAP Knowledge Base Article - Public

2678020 - Error Message : Company XXX not found when you click on Save Data to

Symptom

You have downloaded the Expense and Income Statement Plan from Microsoft Excel and filled it.

Now you want to Save the Data but when you click on Save Data to, you receive the error message: Company XXX not found (XXX represents the company ID).

Environment

Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Go to the Planning view.
  3. Click on New > Plan Version from Microsoft Excel.
  4. Select New Expense and Income Statement Plan - Multi Company and click on Download.
  5. Complete the file.
  6. Click on Save Data to.

Error message : Company XXX not found.

Cause

You can see a green triangle on the top left of each cells of the Company Column. If you select one of these cells, you will see a warning.

The XXX ID in the system is a number. However, in the file the XXX, despite it being a number, it is considered as a text. In consequence, the system consider that XXX is a number and do not find XXX as a text in the system.

Resolution

  1. Select all the Company column.
  2. Click on the Warning.
  3. Select Convert to Number.

pour kba.png

Observation: Now you can click on Save Data to and the error does not appear anymore.

Keywords

Excel, text, number, error message, Add-in , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions