Purpose
This report provides a quick, aggregated view into the history of previous inventories taken. You must have at least two (2) physical inventories completed to run this report for the selected location. The dates are limited to the past two years, and only one location can be selected at a time.
The report combines data for inventories, including products and scancode. It is available for ADM Admins.
Report Format
- Scancode: scancode of the product under inventory list
- Product Description: Description of the product under inventory list
- Cat 1: the first level category the item is assigned to
- TaxCat: lists the tax category the item is in, if any
- Start Date Qty: Quantity that was present on start.
- Adds: the qty added to the inventory for this item
- Removes: the qty removed or deleted from the inventory for this item
- Sales: sold items under the inventory
- Expected: remaining quantities in the inventory to be sold
- End Date Qty: end date quantity by productId
- Variance: the end date qty - expected qty for this item
- Unit Price: price per unit of product
- Unit cost: cost per unit of product
- Variance Cost: the variance qty * the cost of the item
- Last Inventory: the date of the last time this item was inventoried.
- On-Hand Inv: the current on-hand inventory for this item
- Inv cost: total cost of inventory
- Last Stockout: the date of last stockout for the item
Selection/Filter Criteria
| Parameter Name | Mandatory/Optional | Default Value (if any) |
| Report name | Mandatory | Inventory Variance |
| Date Range | Mandatory | dates will be limited to 2 years back from today's date. |
| Group by | Optional | |
| Search by | optional | |
| Location list | Mandatory | Only Single selection of location is allowed. |
| Active Locations only | Toggle | Active locations |
| Hide Zero variances | Toggle |
Selection Fields
Report Details