Symptom
You faced an error message while uploading a List Price via Microsoft Excel Add-in.
Environment
SAP Business by Design
Reproducing the Issue
- Go to Product Portfolio work center.
- Select List Prices View.
- Click on New - List Prices from Microsoft Excel.
- In the template add all the necessary information.
- Right click to unhide the Scale columns.
- In Scale 1 quantity enter a quantity higher than zero.
- In Scale 1 price enter a price.
- In Scale 2 quantity enter a quantity.
- In Scale 2 price enter a price.
- Click on Save Data to.
Error message: scale amounts are not in descending order.
Cause
Using Excel Add-in you cannot start the Scale from a number different than zero, this is an Add-in limitation.
Resolution
You need provide a Scale quantity in increasing order and Scale price should be in decreasing order, Scale price should be 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