cancel
Showing results for 
Search instead for 
Did you mean: 

SPW

Former Member
0 Kudos

Hello Experts,

How is the day-end inventory for the current day calculated through SPW ?

Pravin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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