SAP Knowledge Base Article - Public

3385868 - Error message uploading a List Price via Excel.

Symptom

An error message was encountered during the uploading of a List Price via Microsoft Excel Add-in.

Environment

SAP Business byDesign

Reproducing the Issue

  1. Go to Product Portfolio work center.
  2. Select List Prices View.
  3. Click on New - List Prices from Microsoft Excel.
  4. In the template add all the necessary information.
  5. Right click to unhide the Scale columns.
  6. In Scale 1 quantity enter a quantity higher than zero.
  7. In Scale 1 price enter a price.
  8. In Scale 2 quantity enter a quantity.
  9. In Scale 2 price enter a price.
  10. Click on Save Data to.

Error message: scale amounts are not in descending order.

Cause

The Excel Add-in has a limitation that prevents starting the scale from a number other than zero.

Resolution

The requirement is to provide a Scale quantity in increasing order and to ensure that the Scale price is in decreasing order, with the price being less than the previous amount.

Keywords

List Price, Excel add-in, Scale, Price, Quantity , KBA , AP-PMD-PPS , Procurement Price Specification , How To

Product

SAP Business ByDesign all versions