No batch mixing in MRP

[former_member700523]

Hi Experts,

I have following scenario for planning & need suggestions -

Y is having a BOM & X is child BOM component. X as a batch managed material. There is a requirement of 100 for parent Y. In BOM Y & X are in 1:1 ratio (bom header qty to component qty ratio 1:1). So the requirement of X will be 100. In inventory I have 2 batches of X. Batch B1 with 75 & batch B2 with 25 qtys. So a requirement of 100 onX can be covered. So MRP will not generate any procurement proposal for X.

But I want that MRP should see that for X we can not mix batches. In other words we can use only single batch. We can assume that the batch with highest qty in inventory OR with earliest expiry should be only considered by MRP. In this case it is B1 with qty = 75. So MRP relevant inventory for X should be only 75 batch B1 & not 100 (B1 & B2).

So can I get suggestions how this can be achieved in standard system? If not, will any kind of exits / enhancements / development possible ?

Regards,

MHP

[Caetano · Accepted solution]

Hi MHP

MRP does not consider the batches during the net requirements calculation and it does not carry out any kind of batch determination.

Your requirement cannot be addressed on the standard system, howeve, you can think about a BAdI implementation.

Take a look on the following document that I wrote with the most useful MRP BAdIs.

BR

Caetano

[former_member700523 · Accepted solution]

Hi All,

Thank you for all replies.

BADI is fine. But can play some tricks in std system for this ?

Example - Manage batch inventory using storage locations as included & excluded from MRP.

So in my case I will keep only 1 required batch in such astorage location which is included in MRP relevant plant stock. And will keep all other batches in storage location which is excluded from plant stock / MRP. And will move 1proper batch from MRP excluded SL to MRP included SL when the only batch in MRP included SL is consumed.

Thoughts on above and more tricks in std system are welcome.

So please provide replies.

Regards,

MHP

[former_member700523 · Accepted solution]

Hi Caetano,

Thanks for reply. Which BADI do you think is proper in my case ? Is it MD_CHANGE_MRP_DATA?

Also can you please provide some notes on BADI that you would suggest in my example.

Also can I have some tricks that we can use to get requirement covered. Refer 1 case given in my latest reply ?

Regards,

MHP

[Caetano · Accepted solution]

Hello

Yes, you can use this BAdI, for example, to manipulate the stock available for MRP using method CHANGE_MDPSX_MARD.

BR

Caetano

[former_member700523 · Accepted solution]

Hi All,

Closing this thread with points given.

Regards,

MHP

[former_member209265]

Hi,

Lets say it is possible to generate another proposal for remaining quantity(lets say 25). In this case after confirming another batch will be created for 25 nos. Don't you think again batch mixing will be there?

MRP runs on quantity and not the batch. So qty exists means MRP will not create any proposal. Will come back if I find any more information.

Regards,

Krishnendu.