Symptom
The following error occurs when adding a product to a price list: Item for Product ID XYZ already exists.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Product and Service Portfolio work center.
- Select the Price Lists view.
- Select the respective price list type in the drop-down list for example, Customer Specific Price List.
- Open Price List ABC (ABC represents the name of the Price List).
- Navigate to the Items tab.
- Click on the Add Row button.
- Enter Product XYZ with the respective amount (XYZ represents the ID of the product).
- Click on the Save button.
- The following error occurs:
Item for Product ID XYZ already exists.
However, you are not able to see the duplicated entry in the list displayed in the items tab.
Cause
By default the Number of items displayed in the list is 100. You entered a duplicated entry but the number of items exceed the default number of 100 displayed in the Price List and therefore you are not able to see the duplicated entry.
It is not possible to change the default value of 100 items to any other value.
The reason why we defaulted the Number of items displayed in the Price List in the Items tab to 100 is for performance reasons.
Resolution
- Go to the Product and Service Portfolio work center.
- Select the Price Lists view.
- Select the respective price list type in the drop-down list for example, Customer Specific Price List.
- Open Price List ABC (ABC represents the name of the Price List).
- Navigate to the Items tab.
- By default the Number of items displayed in the list is 100.
- If your Price list exceeds 100 items you will see the following information message:
More than 100 item(s) exist. - You can increase the number of items displayed and then filter for Product ID XYZ.
- You will see the duplicated entry and can amend it accordingly.
Keywords
Price List; 100; item(s) exist; duplicate , KBA , AP-PMD , Price Master Data Management , AP-PRC-PR , Pricing , Problem