Symptom
When using Forecast Consumption Report and Confirmation Journal Report, you get different results of XXX and YYY.
XXX = quantity in Forecast Consumption Report.
YYY = quantity in Confirmation Journal report
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Supply Planning work center.
- Select common task Forecast Consumption Report.
- Filter by relevant product and relevant period.
- Notice that Consumed Forecast is quantity XXX.
- Go to Business Analytics work center.
- Select Design Reports view.
- Find Confirmation Journal report (SCMCFJU01_Q0001)
- Open the report
- Filter by relevant product and relevant period.
- Notice that the Amount of Effective Quantities is YYY instead XXX.
Cause
Once Sales Order is created in the system Forecast consumption report will get updated with Consumed Forecast quantity.
As once Outbound Delivery is released and Goods Activity Confirmation is created at that time that Confirmation Journal will fetch the Goods Activity Confirmation and show the quantity.
As the dates of creation of the Sales Order and creation of the Outbound Delivery can be different, the reports will display different values.
Resolution
System is working as designed.
Keywords
report, forecast, forecasting , KBA , report , forecast , forecasting , AP-SDM-MSD , Material Supply and Demand View , How To