Symptom
You find that not all Sales Orders which shows on the OWL (Object Work List) are showing at the report which uses the data source of 'sales order item'.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Select List under Reports view.
- Open the Sales Order Volume report.
- Filter for the In Preparation status.
- Sales Order ABC (ABC represents the ID of the missing Sales Order) is missing in the report.
Cause
The data source 'sales order item' is on item level and the inconsistent items are not shown in the report which uses this data source.
For these sales orders in which all the items are inconsistent and hence they are not visible.
Resolution
As a workaround,
If you would like to see all Inconsistent Sales Orders you can check this as follows:
- Go to the Sales Orders work center.
- Select the Sales Orders view.
- In the Show field select Incorrect Orders.
- Click on the Go button.
- The system will return all inconsistent Sales Orders.
If you would like to see only the Sales Order in a particular status e.g. In Preparation you can use the Advance Filter and filter for the respective Status.
You can then also Export the result list via the Export -> To Microsoft Excel button.
See Also
KBA 2724953 - In Preparation Sales Order Missing in the Report
Keywords
Sales Order, Incorrect Orders, In Preparation, sales order item, report , KBA , SRD-CRM-ORD , Orders & Contracts , Problem