This report shows all stock movements in specified date interval. Filter by defines what dates are used as a base stock movement date or transaction effective 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
Filter by
Allow user to either filter by Stock Movement Date or by Transaction Effective Date
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, there are following output field available for this report 



SKU

 Product SKU.

Product

 The name of the product.

Unit

 Product unit of measure.

Location

 Location name.

Bin

 Bin where stock is located within Location.

Type

 Type of movement. In or Out of the location.

Reference

 Task Reference responsible for stock movement.

Date

 Effective date of stock movement

Quantity In

 Quantity of stock moved into the location

Quantity Out

 Quantity of stock moved out of the location

Cost In

 Cost of the stock moved into the warehouse in base currency.

Cost Out

 Cost of the stock moved out of the warehouse in base currency.

Year

 Year of effective date of stock movement.

Quarter

 Quarter of effective date of stock movement.

Month

 Month of effective date of stock movement.

Tags

 Comma-separated product tags.

Category

 Product category.

Brand

 Product brand.

Family

 Product family name.

Stock Locator

 Location in the warehouse.

Product Additional Attribute 1-10

 Values of product additional attributes.