Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 17, 2020 at 02:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2020 at 11:39 AM

    Check this


    a.jpg (49.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.