Skip to Content
author's profile photo Former Member
Former Member

MD04 - Plant/Available Stock

Hi All,

I am working in a Pharmaceutical industry. We are using Planning Strategy 40 (Planning with Final Assembly). Whenever MRP runs it checks against Plant/ Available stock in the MD04 screen. Plant Stock includes unrestricted use stock, restricted stock and stock in transfer. My business owner requirement is to consider the Plant stock that excludes 7 month out batch expiry stock. In our scenario the batch is moved to Blocked status only one day before the batch expires, till that time it will be in unrestricted use only. Now, how can I map this in SAP? I mean MRP has to consider the Plant/Available stock but the stock has to exclude the 7 month out unrestricted use batch stock. Please suggest me what best we can do to solve this issue. I appreciate your help in this regard.

Thanks

Krishna Nunna

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2008 at 04:01 PM

    can you give me an example?

    you have UN stock - 100 qty

    Stock which exceeds 7 months i.e.manufactering date is - 27.03.2008 is say 25 qty, should be exluded form 100 qty, hence qty to be considered is 100-25 = 75 qty

    Is it the requirement?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Krishna,

      I am assuming that you mean that even though the expiration date has not been reached, your customers will refuse to buy the stock, if the expiration date is only 7 months away. This is a pretty common scenario.

      Your business process does not make sense from the perspective of planning. On the one hand, the material cannot be sold, and evidently must be replaced according to the requirements of the forecast. On the other hand, the business owner insists on keeping the stock as 'unrestricted', which in effect means 'available for sales order fulfillment and for planning'.

      If I were an auditor, such a practice would raise a red flag for me. Some businesses have been known to use similar techniques to conceal the actual value of their onhand balances. Think Enron.

      Anyway, another method to solve the problem would be to move the old date code batches into a different plant, that does not use an MRP strategy, eg planning strategy 'ND'. The plant could also be configured so as not to be relevant for sales order fulfillment, if that also is a requirement.

      Seems like a lot of work to accommodate a sketchy business process.

      Regards,

      DB49

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2008 at 03:15 AM

    You cannot do this functionality in the standard SAP.

    Please check the SDN forum. Some one suggested the User exit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2008 at 09:02 AM

    Hi

    I dont think direct solution is there. What u can do is write a Z program to move all 7 months expiry batches to move to a restricted stock. This u schedule to run in background at a time before MRP run program everyday. In OPJJ deselect the check box for the field Incl. restricted-use stock. So the batches are not in blocked stock but in restricted stock and the MRP will not consider that. Just try and let me know.

    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.