Skip to Content
0
Former Member
Dec 30, 2011 at 08:44 AM

MIN MAX INVENTORY

29 Views

Dear Experts

I have run the below query to get the data on min and max inventory by warehouse. Now after changing the min and max inventory want to upload the file.

Please guide me on the template required for uploading data into system

SELECT T0.[ItemCode], T0.[ItemName], T1.[WhsCode], T1.[MinStock], T1.[MaxStock] FROM OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode

Thanks

Parikshit