Hello,
I want to correctly set the Item Master's minimum and maximum inventory settings so that the MRP shows me what I need to order to stay at the maximum inventory level at all times, regardless of whether there are open SO's.
For example, on item X my Item Master settings are:
Maximum Inventory (OITM MaxLevel): 5
Minimum: (OITM MinLevel): 1
My current on-hand inventory is 1, with no open SO's or PO's.
When I run the MRP, on the Data Source screen, I have checked the boxes for Existing Inventory, Purchase Orders, Sales Orders, Minimum Inventory. I am not using a forecast. I'm running 2007 A. MRP shows nothing to order when I run it.
In trying to find the problem, I ran a query on all fields in the OITM table. I found several fields that I do not see in the Item Master and wonder if the entries in these fields are causing the problem. Fields showing on the query and their quantities are:
Pref. Qty in Purchase Units: 4
Reorder Point: 0
Minimum Order Quantity: 1
Any ideas?
Thanks,
Shelby