Execution

 Selection fields

Report Purpose:

This Report shows the stock details of all the product with warehouse name.

Selection fields:

1) Product- Mention product search key that will display the stock detail for the selected product or else select Requery option it will display stock details of all the product.

2) Show Zero stock - If this field is selected then report will display only stock available items.

Output fields:

1) Product category - The name of the product category will be displayed.

2) Key - Product search key will be displayed.

3) Product - The name of the product will be displayed.

4) Part Type-The names of the Part Type will be displayed.

5) Description - The name of the product description will be displayed

6) Classification - Product classification details will be displayed

7) Warehouse - The name of warehouse for specific product will be displayed

8) Locator - Warehouse locator details will be displayed

9) On-hand qty - On-hand stock details will be displayed

10) Reserved qty - Sales order qty will be displayed for specific product

11) Ordered qty - Purchase order qty will be displayed for specific product

12) Available qty - Difference between on-hand qty & reserved qty

13) Unit - Unit of measurement