SAP Knowledge Base Article - Public

2679269 - You Cannot Update the List Prices via Excel Upload.

Symptom

You Cannot Update the List Prices via Excel.

Environment

SAP Business by Design

Reproducing the Issue

  1. Go to Work Centre Product Portfolio.
  2. Go to List Prices.
  3. Choose All List Prices and click execute the query.
    (you can see here the List Prices)
  4. Open the Excel document `XYZ.xlsx` (XYZ represents the document name).
  5. Change the Prices for List Prices and save it.
  6. Go to SAP Business by Design Tab in Excel.
  7. Log On with User Credentials and click Refresh.
    (New Prices will not transfer to system the system overwrite the old prices in the excel document).

Cause

In Work Center-Product Portfolio, List Prices is a view of the prices in the system for the products. If the Price Lists need to be updated, it has to be done via Work Center-Product and Service Portfolio.

Resolution

  1. Go to Workcenter Product and Service Portfolio.
  2. Open to Price Lists.

Here you can download the Excel template by clicking on Download, the Excel template will be downloaded. Then the relevant Price List information needs to be filled in the Excel template and then should be saved back to Business by Design system.

Keywords

Price List, List Prices, Update via Excel, Product Portfolio, , KBA , SRM-CAT-PI , Product Information , SRM-KM , SRM Knowledge Management , Problem

Product

SAP Business ByDesign all versions