Forecast Comsumption

[Former Member]

Dear Guru's,

Scenario:Forecast is released in DP on 10th of the every Month, on 15th the SNP run is planned for that the forecast is released to SNP. but between 10 to 15th some actual billing takes place hence the forcast needs to be reduced by that quantity

present method is we download the forecast from the DP book & again load it (from LSMW) after deducting(manually)actual billing from the same

other information:

1. forecast is released in week bucket

2. startegy: 10 (make to stock)

We would like to remove the manual intervention ..please guide how to reduce the forecast automatically.

regards

Kiran

[Former Member · Accepted solution]

"but between 10 to 15th some actual billing takes place hence the forcast needs to be reduced by that quantity", does this mean that you are getting your sales orders and would consume the forecast?

and you are saying that you are using a make to stock strategy.

You can just have an extra row in planning book data view for the qty. to be reduced. Use a simple macro to deduct the fcst from the billed qty. then, you can use the new total to forecast or release.

Not sure if this works for you.

[Former Member]

if your strategy is 10 in APO - no consumption will take place

you try the following settings in the product masters

1. Set requirement Strategy - 20 in APO

2. Set consumption mode in the demand tab to backward/forward or both and set a consumption period (optional - otherwise the consumption is in the same bucket)

You might want to try deleting all existing forecast and release again to see Consumption

hope your sales orders are of type BM and they are CIFed