MIN MAX INVENTORY

[Former Member]

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

[Former Member · Accepted solution]

Dear Parikshit,

It is OITW - ItemWarehouseInfo.xlt under Inventory\Item Master Data

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks all the experts.

Problem solved

[Former Member]

Hi Parikshit........

You want to import what?

Stock or Min or Max inventory Limit?

If Stock then you can use oInventoryGenEntry Template for Document and Line

If Limit then you may use OITM and oItemWarehouseInfo........

Regards,

Rahul

[Former Member]

HI Parikshit

You can use oInventoryGenEntry template to enter your Stock.

Thanks & regard

Khan Imran