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.
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.
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
So, If we run the MRP today it has to create the corresponding Planned orders comparing to the stock of 75 Pcs not 100 Pcs. Right now its considering 100 Pcs. The 7 Month out expiry stock will be in the same status as the total stock i.e Unrestricted use. Please do the needful. Please let me know if you need any more information.
i donot see any logic in your issue. 25 qty iwhich s going to expair after 05/28/2009, whcih should not be considered when you run MRP today.....i donot see any meaning in this issue.
I will explain bit clearly about my requirement. Our business owners plan the forecast for 18 months and the MRP is ran everynight, So, it will check the available stock in MD04 screen and creates the corresponding Planned Orders for the next 18 months. User checks everyday when the material is going to get shorted and will update the forecast. So, in this scenario its considering the stock which is 7 month out expiry and showing the short dated qty but they can't sell the product if it has 7 month out expiry, another thing is even they can't sell the product they want that to be in unrestricted status.
Example
Plant Stock : 1000 Qty
This stock includes unrestricted stock which has more than 7 month out expiry and also less than 7 month expiry, restricted stock and stock in transfer.
When MRP runs it checks against the stock 1000 and think it created the Planned order in Jan 2009 assuming the requiremnt of 500 each month. But actually the stock which you can see is only 800 that can be sold b'cos 200 out of 1000 is 7 month out expiry. So, user says it has to exclude the 7 month expiry stock and has to create the Planned order in Dec 2008 considering Plant stock as 800. I hope you are clear now. Please let me know if you need any more information
You don't want system to consider this stock, since this has expired and can't be used. Move the stock which is 7 month out expiry to quality inspection or blocked stock according to business requirement. System will not consider this stock (according to your settings) and will create planned orders for equivalent quantity that has to be adjusted.
Business owner dont want to move the 7 month out expiry stock either into bloked or quality stock. They will move to blocked only 1 day before the batch expires. So, the 7 month out batch stock remains in unrestricted use only. Please suggest me some solution for this scenario.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.