SAP Knowledge Base Article - Public

2951812 - Upload of Price List From Microsoft Excel Fails due to the Comma (,) is Used in Amount

Symptom

You are trying to use an Excel template to upload a pricelist, but the records are not saved.

Environment

SAP Business Bydesign

Reproducing the Issue

  1. Fill in the required details in the Excel template.
  2. Login to the system via the Excel.
  3. Click on "Save Data To".

0 Record(s) are saved successfully to SAP Business Bydesign.

Cause

There are many situations lead to the upload failure.

Here in this case, the issue occurs because you have maintained a Comma(,) in between the numbers in the amount column.

Resolution

You should not use the Comma separator for the numbers, the correct format to pass the number is 123456.70

See Also

2938699 - Unable to Upload Price List Via Excel 

Keywords

"Pricelist", "Excel Upload" , KBA , AP-PMD , Price Master Data Management , Problem

Product

SAP Business ByDesign all versions