SAP Knowledge Base Article - Public

2607216 - Price List Preview is not Sorted Alphabetically

Symptom

You click on Preview in a Price List and expect the Positions to be sorted Alphabetically by Product ID, but they are not.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Product and Service Portfolio Workcenter.
  2. Select the Price Lists View.
  3. Open any Price List.
  4. Click on Preview.

The Preview is not sorted alphabetically by Product ID.

Cause

  • Currently there is no sorting in Price Lists and entries in a Price List are shown by date of entry.
  • The first Position entered in a Price list will be shown first and the last Position entered in a Price List will be shown last.
  • This is the expected System Behaviour.

Resolution

  1. You need to enter the products in a sorted order while creating the price list.
  2. This can done via Microsoft Excel and the Excel Add-in. You can download the unsorted details from the existing price list and sort them in excel. The sorted list can then be used to fill the details for the new price list.
  3. You can find more Information in Help Documentation Upload Price or Discount Lists using Microsoft Excel.

See Also

Easy Price Maintenance in SAP Business ByDesign blog, click here.

Keywords

Price List, Sort, Alphabetical, Product ID, Preview, Preislisten, Sortieren, Produkt ID, Vorschau , KBA , AP-PRC-PC , Calculation , Problem

Product

SAP Business ByDesign 1711 ; SAP Business ByDesign 1802