Skip to Content

Blocking short date materials during the MRP run

Hi

The term 'short date' for our client is defined as 'X' days ahead of the expiry date of the material(batch) when it is deemed as blocked(unavailable) stock. Example, material M & with batch B has shelf life of, say, 31 dec 2008 - this material has 365 days from this date in unrestricted stock ie., 31 dec 2008 minus 365 days = 31 dec 2007. After 31 dec 2007, this material should be automatically moved to the 'blocked' stock for disposal as scrap. Since MRP does not have the provision to consider 'short date' - is there a way to make this work? I'm planning to develop a code to move all such materials to blocked stock everyday before the MRP run. Do you see any problems, doing this? Any suggestions, ideas, user exits,BAPI's etc to make this work? Any help is greatly appreciated.

Another question - to move a batch to a blocked stock via a program, I'm trying to mark MCH1-ZUSTD = X, but this does not move the batch to restricted stock - any suggestions how or what other field(s) should I consider to move a batch to 'restricted' status programmatically?? Batches are managed at the client level and we are in R/3 6.0.

regards

BE

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2007 at 06:28 PM

    Dear,

    The first question to block some of the stock from MRP is

    transfer the stock to a storage loc and in that storage location setting make the storage loc as not relevant to MRP in img,

    production >MRP >planning-->Define Storage Location MRP per Plant

    for a given plant and storage loc combination set the MRP indicator as 1.

    Maintain the material with this storage loc and in MRP 4 make storage loc indicator as 1.

    Now the question is how to transfer the material which are 365 days old from the production date?

    As you explained, you need to develop Z prg with a logic to get the materials numbers whose expiry date will fall as per your requirement and then move 311 movement type to transfer the stock to new storage loc where it is not planned by MRP.

    This should run before MRP run and in the MRP background job give the trigger that once the above prog is completed then only MRP should run.

    I think I answered your question

    If you need any more explanation please write back.

    Moving to restricted stock may not solve your problem unless in OPPQ the setting for blocked stock and restricted stock is off.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Brian Elfie

      Hi Brian,

      just to know... are you using the QM module ? If that would be the case, there is a very simple way to accomplish what you need: no separate SLoc, no manual blocking of materials. There is a transaction ( I think QA07 ? ) to block materials within X days before expiration that can be run as a job, every day or week.

      Having MRP configured not to consider "Blocked stock" would solve your problem.

      Regards

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 07:33 AM

    pl come back...

    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.