Skip to Content
0
Former Member
Mar 04, 2009 at 11:37 PM

Max/Min settings and MRP

811 Views

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