Video demonstration
Step by step instructions
This report is used to indicate variances in your Stock on Hand from your last stocktake to your current stocktake. It can be used to identify any potential problems with your current store processes.
For example, if your Stock Variance Report for the Blackmores location indicates most products have increased in SOH, then perhaps an invoice was not entered.
Stock Variance reports should be run for each category individually. This report can be run by Product, Department, Company, Brand, I.E.U, Class, Location, Price Policy, Preferred Supplier and KVI.
1. From Stock Manager, click the Reports menu.
2. Click 4.Stock Reports and select 7.Stock Variance Report.
The Stock Variance Report window is displayed.
3. Click the Sorted by dropdown and select the category you wish to report by.
4. Check Report on the entire range to report on all products/categories. This option will ensure products added in the future are also included in future scheduled reports.
5. Alternatively, to report on only a select range of products/categories, specify the range in the From and To fields.
6. In the Starting Date field enter the date for the previous stocktake.
7. In the Ending Date field enter the date for the current stocktake.
8. Check Show Detail to include detailed product level information in the report. When checked, the report will include MNPN, Product Number, Barcode and Product Name. Alternatively, leave Show Detail unchecked to generate a summary report.
9. Click Run to run the report immediately or click Schedule to set the report to be generated and emailed according to a specified schedule. Refer to Schedule a report for guidance.
Example report (Show Detail checked)
- A negative quantity indicates the store has gained this stock.
- A positive quantity indicates the store has lost this stock.
