MS adds forecast Level 0 lines after DTF is passed

Hej Eva,

There are two ways forecast columns gets reduced (and/or set to zero).

I will just focus when the level 1 part setup is setup to “Drop Unconsumed Forecast” within DTF !

Within MS Level 1 calculation itself (simplified just to focus on reducing forecast columns:

1. Old open demands/supplies from previous execution are removed and reloaded

2. System recalculates forecast consumption from scratch. And here it starts with demands in chronological order and so on. Backward- and Forward consumption windows are considered.

3. Once that is done, the MS Level 1 calculation continues to analyze how to reduce UNCONSUMED forecast within DTF:

 If “(forecast level 0 + forecast level 1 - consumed forecast) = unconsumed forecast” becomes a positive value then reduce the forecasts with unconsumed forecast. (looking at your yellow figures above we can see that they are consumed - system thinks they will be “shipped out through the door” and reduced when they are shipped in the customer order flow - explained below)

4. Then system continues with the calculation of proposed MS receipts …

When shipping the part

From the order delivery process system calls master scheduling to reduce forecast and consumed forecast. Planned Due Date of the customer order line and shipped qty is used.

First it uses backward consumption window - considering Planned Due Date. Here it reduces forecast using Ms Dates in descending order. Basically it reduces the forecast and consumed forecast with what has been shipped (there are some details under the hood regarding how level 0- and level 1 columns gets updated if both of them have value > 0)

System can continue backwards until backward consumption window. I mean if the Qty Shipped is large, larger than consumed forecast system keeps track of this and going backward and kind of consumes of the qty shipped. Hard to explain in words :-( Hope u get it.  

Then if there in any remaining “unconsumed Qty Shipped” system goes forward using the forward consumption window. And now it reduces forecast using Ms Dates in ascending order.

***

In later Cloud versions we have corrected two defects when it comes to forecast reduction when shipping the part. One was about we didn’t care about checking the backward boundary in “First it uses backward consumption window - considering Planned Due Date”. Another is about if you are using both level 0 and level 1 forecast for the same part.

Ooooh lots of text above, sorry for the long answer. Hope you can digest it over a nice chocolate bar.

Cheers,

Mats 

Thank you for the explanation Mats! I have been discussing it with the customer and we have read the text several times and still don’t understand how the lines that are added behind DTF can appear 🤔 but since this concerns APP10, we will look forward to the development done in IFS Cloud and hope that it will resolve this issue as well. Until then, we have to use a configuration that removes the lines in question.

Take care! 

Eva