Symptom
You run the Sales Order Volume report, the Product ID XXX is displayed as XXX.2 for some sales orders. However, in the respective Sales Order the Product ID is correctly displayed as XXX((XXX is the ID of the Product)
Environment
SAP Business Bydesign
Reproducing the Issue
- Go to Sales Orders work center.
- Go to Reports View.
- Open report Sales Order Volume and click Apply to run the report.
- From the View list, add the Row Field - Product and Sales Order.
- You can see for some of the sales orders, the product ID is XXX.1 and for few orders you can see it is XXX.2(XXX is the ID of Product).
Cause
The reason why the Product ID is XXX.1 or XXX.2 is because you have a Material and a Service with same ID XXX, whenever you use the material in the sales order, the product ID in the report will be displayed as XXX.1 and when you use service, it will displayed as XXX.2.
Resolution
There is material and service with the same ID , in order to identify whether the product used in the sales order is a material or a service, the product ID is displayed in this manner. This behavior is same for all the reports and datasources related to sales documents.
Keywords
Sales Order Volume report; Customer invoice volume report; Sales order item; customer invoice item; data source; Product ID wrong; Incorrect Product ID; , KBA , product id wrong , sales order volume report , sales order item , incorrect product id , AP-SLO-SO , Sales Order , Problem