Inventory Movement Summary Report

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


Input

The following table shows the inputs for this report.


From
Beginning date of required report; user-configurable
To
Closing/end date of required report; user-configurable
Update
Button allowing refresh of the report results
Apply Filter
Button allowing setting of filter on the report fields
Export
Button allowing user to export report data in Excel, PDF or RTF format

 

Output

After setting inputs described above, when you click the Update button, the report will refresh as per inputs.


Location

 Location name

SKU

 Product SKU

Product

 The name of the product

Unit

The product's unit of measure

Quantity On Hand

 Quantity on hand as of the To date

In

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

Out

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

Unit Cost

 Unit cost of the stock as of the To date in base currency

Stock On Hand

 Stock on hand as of the 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 a product's additional attributes

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.