The Stocktake Discrepancy Report will show stock items counted in a Stocktake or items counted in any Stocktake within a Date Range.
The Report will show any discrepancies between the counted value before and after the Stocktake.
Access the Report
The are two ways to access the Stocktake Discrepancy Report.
- From the Stocktake screen using the Report button in the bottom right corner
- This will show items from the Current Stocktake only
- From the Main Screen of Retailer, click Stock Maintenance → Stocktake → Stocktake Discrepancy
- This will show all items from all Stocktakes
- This can be filtered by Department, Category or Date Counted
Running the Report
From the Stocktake Screen
Click the Report button in the bottom right corner of the Stocktake Screen.
Tick the options below you wish and click Ok
- Only show items with a discrepancy
- Include discrepancies where QOH was previously less than zero that have not been stocktaked
From the Stocktake Discrepancy Report screen
From the Main Screen of Retailer, click Stock Maintenance → Stocktake → Stocktake Discrepancy
Double Click a Department to Select or Unselect it to be included in the Report
After clicking a Department, double click a Category to Select or Unselect it to be included in the Report
You can also use the 'Select All' or 'Unselect All' buttons to Tick or Untick all Departments and Categories
Only show items with a discrepancy
Show Items with no Category - Tick this option to include Stock Items that have a Department but no Category set
Show Store Locales - Tick this option to show Stock Item Locales on the report. See Store Locales
List Items Stocktaked within a Date Range. You can then select a Start Date and End Date
Reading the Report
Barcode - Barcode of the stock item
Description - The Long Description of the stock item
Cost Price - The current inc GST Cost Price of the stock item. Note this is not the Cost Price at the time of the Stocktake
Date - The Date the item was first counted in the Stocktake
Qty on Hand - The Quantity on Hand at the time the item was first counted in the Stocktake
Value (Prior to Last Stocktake) - The Total Inc GST Cost Value of the Stock based on the QOH prior to Last Stocktake
Counted - The Quantity of the item counted in the Stocktake
Value (During Last Stocktake) - The Total Inc GST Cost Value of the Stock based on the Quantity counted in the Stocktake
Stocktake Discrepancy % Quantity Increase - Calculated as (Quantity Counted in Last Stocktake - Quantity prior to Last Stocktake) ÷ (Quantity prior to Last Stocktake)
Stocktake Discrepancy Quantity - The difference between Quantity Counted in Last Stocktake and Quantity prior to Last Stocktake
Value (Stocktake Discrepancy) - The difference between the value During Last Stocktake and prior to Last Stocktake. Note calculated using the current inc GST Cost Price not the Cost Price at the time of the Stocktake
Exporting the Report
You
can export the report to either a PDF document or Excel spreadsheet from the Report Preview screen:
- PDF - Click on the red PDF button at the top of the Report Preview and choose your save destination.
- Excel spreadsheet -
Click on the Print button 🖨️ in the top left of the Report Preview. Tick 'Print to File' and
select 'Xlsx Data File'. Click on the three dots button [...] to choose
your save destination. Click OK to save the file.
- Excel spreadsheet - Another option is to click the Export button at the top of the Report Preview. This is not recommended as the exported file is formatted like the Report Preview