Importing Min Max settings

[LordJames]

How can I import the Inventory "Order point Quantity" and Order up to Quantity" into GP 10. I have about 7000 records in an excel file from our old system with Min Max settings by warehouse and bin I'd like to use but I can't find an Intergration or Table Imoport to correctly handle this. Anyone have a backend SQL script that will work?

 

[PTina]

If I'm not mistaken I think you should be able to update the Item Quantity Master from Integration Manager when doing the Item Master loads. I don't have IM now so I can't verify if it is one of the associated tables that gets updated with the Item Master load.

However to just update the table try you could use the Table Import utility with the Destination Table being Item Quantity Master (IV00102 - IV_Item_Mstr_Qtys) . Be careful using the table import as it does not do all of the checks and balances that Integration Manager does.

 

[ale1981]

Table IV00102 holds the item quantites.

The fields you need are;

ORDRPNTQTY = MIN
ORDRUPTOLVL = MAX

I am on GP 7.5 but imagine these are fairly similar.