The Inventory Variance Report displays variances between your current inventory and inventory from the previous cycle. This report can be accessed from the Reports module or from the Inventory module under the ‘Reports’ tab.
The Inventory Variance Report is mostly used as an auditing tool, where large cost and quantity differences could point to a data entry error and should be investigated.
- Filter by location(s) or location group(s).
- Filter by inventory date. This report can only be run for a single date.
- Select the type of prices to display on the report.
- Filter by Inventory Cycle.
- Select whether the report breaks down recipes into basic ingredients or displays whole recipes.
- Filter by Inventory Item Group.
- To search for a specific inventory item, enter the name of the item into the ‘Inventory Item’ auto-fill field.
- To search for a specific GL code, enter the GL code into the ‘GL Code’ auto-fill field.
- Select whether or not to show storage locations.
- Select whether or not to show locations.
- Select whether or not to treat blanks as zeroes.
- This report can be viewed/exported in various formats. It can also be directly emailed.
Frequently Asked Questions
Q: Why is one of the storage locations I have set up not displaying on this report?
A: The Inventory Variance Report operates based on the inventory session that was in effect on the date for which the report is run. If a storage location was not present for that inventory cycle, it will not show here. If you reorganized your storage locations and want to mirror the setup on this report, reopen the inventory session and repost.
Q: Why is the report showing “No Data”?
A: One reason for encountering “No Data” is that your selected inventory date does not fall during a week that has recorded inventory. For data to be returned, the selected week and location must both have recorded inventory.