cancel
Showing results for 
Search instead for 
Did you mean: 

Blocking short date materials during the MRP run

former_member351306
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

former_member351306
Participant
0 Kudos

Hi Rajesh Vittal

Thank you for your inputs. I do plan to set restricted and block stock off at OPPQ, but my main concern in identifying those materials or batches with the short date condition. I guess Identifying the materials and moving them to blocked status or to a different location is a definite option. But, should I create a new st location for this purpose? Just blocking the material and then scrapping them will not be sufficient? Let me know your thoughts on a best practice, if any, or any other issues I should anticipate along this path.

Again, thanks a lot for the inputs - much appreciated.

thanks

BE.

Former Member
0 Kudos

Yes, you need to create a seperate storage loc and do this operation.

Follow what i explained, you will get what is required.

We followed this and is working fine...

Please let us know your concern so that I can address it.

I am not assuming that it is the best practice, but I found it is the efficient one.

The practicle problem is in actual stotres/WH moving the material from one place to other as per theb report i.e. we defiined a mov type-911 hence all material/batch mov type 911 report is used to do the transfer.

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

pl come back...