Net Demand --> Stock on Hand AND Carry over Negative Projected Stock in current period - SAP IBP

[mzahmed]

Greetings Experts

Is there a way where the Stock on Hand for the current period AND carried over negative projected inventory from the previous period is taken into consideration for the current period Net Demand?

This is how the Net Demand is calculated for the current period:

Net Demand (1) = Dependent Demand (1) + Independent Demand (1) + Inventory Target (1) – Stock on Hand (1)

The definition of all later/future periods would then look like the following:

Net Demand (t) = Dependent Demand (t) + Independent Demand (t) + Inventory Target (t) – Projected Inventory (t-1)

We would like the Net Demand to look like the following in the current period:

Net Demand (1) = Dependent Demand (1) + Independent Demand (1) + Inventory Target (1) – Stock on Hand (1) – Projected Inventory (t-1) (Only if Projected Inventory is negative)

Please advise how this can be achieved.

Regards,

Mohammad

[mkorndoerfer · Accepted solution]

Hi Mohammad,

No, it's not possible to change the calculation of standard supply key figures as they are hard-coded in the operator. Also, I don't understand why you're trying to do this as the key figure Stock on Hand was created exactly for this purpose: copy the Projected Stock (t-1) into Stock on Hand (t). It looks like you are annulling the stock equation by doing this.

Could you please clarify?

In any case, what you can do, however, in this example, is to use the key figure INVENTORYCORRECTION with the value of Projected Stock from the previous period. This key figure is used to simulate receipts/supplies, so it accepts both positive and negative values.

Best regards,
Matheus

[former_member654033]

Check this

[mzahmed]

Hi Girish

We have this set up. What it doesn't do is that it does not take the Negative Projected Stock into consideration in the current week since it it considers the Stock On Hand.

Is it correct that the system considers the current week as the "Initial period", every time and therefore applies the first formula below?

Net Demand (1) = Dependent Demand (1) + Independent Demand (1) + Inventory Target (1) – Stock on Hand (1)

Regards,

Mohammad

[former_member654033]

Past week adjustments you need to do manually with Custom key figure and increase the demand in current week accordingly. Supply planning engine will only plan current and future periods and it will carry forward any -ve projected stock only in current and future period.