Getting Warehouse name of a item

[Former Member]

Hi ,

I have a list of items which is store in 3 different warehouse .

at the time of creation of Items i selected a particular warehouse for a particular item in inventory data tab.

Now i want to get list of all item of a particular warehouse through query?

Regards

[Former Member]

Hi Sandeep,

You can try a simple query like this:

Select ItemCode, Whscode, Onhand, Avgprice from OITW T0
Where  T0.WhsCode = '[%0]') and T0.OnHand >= '[%1]'

If item code is not enough, you can join OITM table for more information.

Thanks,

Gordon

[Former Member]

Hi Sandeep

The table to use is OITW.

SELECT T0.ItemCode WHERE T0.WhsName (or T0.WhsCode) = 'Warehouse 01'

Kind regards

Peter Juby

[jitin_chawla]

Hi,

You can check the Inventory in Warehouse Report which is the standard report which can run warehouse wise.

You can write a query from table of Item Master Data taking the Item Code and Item Description as the fields 'where' Warehouse = [%0].

Regards,

Jitin

[Former Member]

hi,

there is already implemented a report. Have a look under Stock Management -> Reports -> Stock in Warehouse Report

Regards