To explain what I'm doing I'll first explain what happens when we run the MRP function within SAP B1 v8.82.
We run the function for Company wide warehouses with a 6 month window showing Purchase Orders, Sales Orders and Production Orders. The Stock Data Source is by Company.
We have around 300 lines of data showing. Some items are already purchased and our only method of finding this out is to go through individual items, go to Available to Promise, etc to see if it is ordered for this specific job. I would prefer if the demand has been met that we do not see it on the MRP screen again. The ideal scenario is that the MRP report is empty as all demands are met. But this is not the case and as well as other tasks during the day we still go down through this 300+ lines of data.
So I have been looking at considering using something like the following which looks at basic information where Demand = In Stock-Committed+On Order and using this simplified formula to drive procurement.
SELECT T0.[ItemCode], T0.[ItemName], T2.[ItmsGrpNam], T1.[IsCommited] As 'Committed',( T0.[OnHand] + T0.[OnOrder]) As 'In Stock and on Order', T0.[LastPurDat], T0.[MinLevel],T0.[MinOrdrQty] , T0.[AvgPrice]
FROM [dbo].[OITM] T0
INNER JOIN [dbo].[OITW] T1 ON T0.ItemCode = T1.ItemCode
INNER JOIN [dbo].[OITB] T2 ON T0.ItmsGrpCod = T2.ItmsGrpCod
WHERE ( T0.[OnHand] + T1.[OnOrder] ) < T1.[IsCommited] and T1.[IsCommited] <> '0' and T0.[PrcrmntMtd] <> 'M'
ORDER BY T2.[ItmsGrpNam]
I have not used minimum stock levels as part of this but should be quite easy to incorporate.
I would appreciate your views on where this process may fail as I find the MRP just too time consuming and as much as I've looked at videos and tutorials I can't see a way to improve the functionality to where I want it.