This report shows summary of stock movements in specified From - To timeframe together with stock on hand value on To date.



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required 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:

After setting inputs described above, when you press update button, report will refresh as per inputs



Location

 Location name.

SKU

 Product SKU.

Product

 The name of the product.

Unit

 Product unit of measure.

Quantity On Hand

 Quantity on hand on To date.

In

 Quantity of stock moved into the location within From - To time frame.

Out

 Quantity of stock moved out of the location within From - To time frame.

Unit Cost

 Unit cost of the stock on To date in base currency.

Stock On Hand

 Stock on hand on To date in base currency.

Tags

 Comma-separated product tags.

Category

 Product category.

Brand

 Product brand.

Family

 Product family name.

Volume On Hand

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

Stock Locator

 Location in the warehouse.

Product Additional Attribute 1-10

 Values of product additional attributes.