This report shows current stock level of all active products in all locations.



Input:

Following are input for this report



Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

Following are the output fields of the report



Location

 Location name.

SKU

 Product SKU.

Product

 The name of the product.

Unit

 Product unit of measure.

Quantity On Hand

 Quantity on hand now.

Allocated

 Stock allocated by pending Production and Sale tasks.

On Order

 Stock ordered from suppliers/currently being manufactured.

Unit Cost

 Unit cost of the product stock now in base currency.

Stock On Hand

 Stock on hand now in base currency.

Tags

 Comma-separated product tags.

Category

 Product category.

Brand

 Product brand.

Family

 Product family name.

Reorder Quantity

 Quantity of the product to reorder as configured for the product.

Minimum Before Reorder

 Minimum stock level for the product to appear on Reorder stock form.

Volume On Hand

 Volume on hand now calculated as Product Height * Product Width * Product Length * Quantity On Hand.

Product Additional Attribute 1-10

 Values of product additional attributes.