on 03-24-2010 10:03 AM
Hello Experts,
How is the day-end inventory for the current day calculated through SPW ?
Pravin
When calculating the day-end inventory for the current day, the system uses the SAP book inventory of the plant as the starting base inventory. The starting what-if inventory is either the SAP book inventory of the plant or the physical inventory of a location. The total quantities for items in unactualized nominations scheduled for a day in the past are added to the starting inventory.
Expected day-end inventory for the current day =
starting inventory
+ unactualized product receipts scheduled for days in the past
- unactualized product issues scheduled for days in the past
+ receipt of product on current day
- issue of product on current day
where:
Receipts of product for current day = proposals + production + SAP documents + scheduled receipts
Issue of product for current day = proposals + SAP documents + scheduled product issues + rack issues
Rack issues: SAP book inventory contains the actual rack issues. If the actuals for rack issues are greater than the corrected forecast, disregard the actual rack issues for the current day, because the actual rack issues are already correct in the SAP book inventory. If the corrected forecast is greater than the actual rack issues, the difference between forecast and the actuals is used to calculate the day-end inventory.
If the corrected forecast is more than zero, the system uses these figures to overwrite the forecast.
Hope this answers your query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When calculating the day-end inventory for the current day, the system uses the SAP book inventory of the plant as the starting base inventory. The starting what-if inventory is either the SAP book inventory of the plant or the physical inventory of a location. The total quantities for items in unactualized nominations scheduled for a day in the past are added to the starting inventory.
Expected day-end inventory for the current day =
starting inventory
+ unactualized product receipts scheduled for days in the past
- unactualized product issues scheduled for days in the past
+ receipt of product on current day
- issue of product on current day
where:
Receipts of product for current day = proposals + production + SAP documents + scheduled receipts
Issue of product for current day = proposals + SAP documents + scheduled product issues + rack issues
Rack issues: SAP book inventory contains the actual rack issues. If the actuals for rack issues are greater than the corrected forecast, disregard the actual rack issues for the current day, because the actual rack issues are already correct in the SAP book inventory. If the corrected forecast is greater than the actual rack issues, the difference between forecast and the actuals is used to calculate the day-end inventory.
If the corrected forecast is more than zero, the system uses these figures to overwrite the forecast.
Hope this answers your query.
Hello Pravin
When calculating the day-end inventory for the current day, the system uses the SAP book inventory of the plant as the starting base inventory. The starting what-if inventory is either the SAP book inventory of the plant or the physical inventory of a location. The total quantities for items in unactualized nominations scheduled for a day in the past are added to the starting inventory.
Expected day-end inventory for the current day =
starting inventory
+ unactualized product receipts scheduled for days in the past
- unactualized product issues scheduled for days in the past
+ receipt of product on current day
- issue of product on current day
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.