SAP Knowledge Base Article - Public

3450593 - List Price of a Product in an New Manual Invoice Changes when Adding Another Product

Symptom

The List Price of a Product in an New Manual Invoice is not as expected and/or changes when adding Another Product.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Customer Invoicing work center.
  2. Select New Manual Invoice in the Common Tasks.
  3. Enter the respective Account, Sales Unit etc. 
  4. Navigate to the Items tab. 
  5. Add Product XYZ (XYZ represents the ID of the Product).
  6. You can see that a List Price is determined e.g. as 5.00. 
  7. Add another Product. 
  8. The List Price of the previously added Product changes to 0.00. 

Cause

The product XYZ is maintained in 2 price lists that could apply for the created Invoice.

For example, in Customer Group Specific Price List ABC and in Base Price List EFG  (ABC and EFG represent the Name of the Price Lists).

In the Base Price List EFG the Amount is maintained as 5.00 in our example.

The Customer Group Specific Price List ABC should be first determined as per access sequence, before the Base Price List EFG is determined. However, since the scale of the price for the product in Customer Group Specific Price List ABC does not start with 0 or 1 but the quantity maintained is 1 the system cannot properly determine the price and adds both price lists in the Pricing and Invoicing tab and the Pricing sub tab which makes the document inconsistent.

 

Go to the Customer Invoicing work center.

Select New Manual Invoice in the Common Tasks.

The respective data in the General tab.

Navigate to the Items tab.

Add Product XYZ.

Navigate to the Pricing and Invoicing tab and the Pricing sub tab.

Expand line item 10.

You can see that the Price Components List Price is there twice.

The first one with the Amount 5.00 which is determined from the Base Price List EFG

And the second one with the Amount 0.00 which is determined from the Customer Group Specific Price List ABC and this line is red since there is no Price maintained in the scales for 1 pcs.

 

This means that there was an issue with the determination of the List Price as there can only be one Price Component of type List Price for an item.

 

Check the first Price List:

  1. Go to the Product and Service Portfolio work center.
  2. Select the Price Lists view.
  3. Show Base Price List
  4. Open Base Price List EFC

 You can see that the Product XYZ is maintained with 5.00 for 1 unit.

 

Check the second Price List:

  1. Show: Customer Group Specific Price List.
  2. Open the Price List ABC.
  3. Navigate to the Items tab.
  4. Search for Product XYZ.

You can see that there is a scale maintained and the scale does not start with 0 of 1 as unit but starts e.g. with 500 units.

The quantity in your Invoice for the Item is 1 unit hence no price can be determined, and the List Price is 0.00.

 

You need to ensure that you scale always starts with 0.

 

The reason why the system changes the List Price to 0.00 when adding a new product occurs because when you add the new product the system will remove the duplicated entry of the base price list and since there is no scale maintained for 1 unit the system determines the list price 0.00.

Resolution

To solve the issue, please change the scales in the Customer Group Specific Price List ABC for Product XYZ accordingly and add a scale with a 0 unit and the respective Amount. Then release the Price List.  

Once this is done, the price maintained in the Customer Group Specific Price List ABC for the product will be determined accordingly.

Keywords

Scale; Scales; Price List; duplicated; twice; changes; List Price; 0.00; zero price;  , KBA , AP-PRC-PC , Calculation , Problem

Product

SAP Business ByDesign all versions