Stocktake Count Variance Report

This reports output detail about variances between the expected (system) quantity and the actual (counted) quantity.

Header Details

• Report process date and time
• Period end date
• Page number

Line Details

The report output will be sorted using the sorting option selected when the stocktake was prepared. One line prints for each unique item/location/lot number (if in use) combination, and these details display:

• Inventory code
• Description
• Location
• Serial/lot number (if applicable)
• Dimension (if applicable and option to output is selected)
• Unit cost
• Expected (system) quantity
• Counted quantity
• Variance quantity
• Variance value
• Variance %

A summary is printed at the bottom of the report, which indicates how many items were included in the stocktake, and displays the total expected value (expected quantity x unit cost), the total counted value (counted quantity x unit cost), and the total variance value. If the stocktake has progressed to a Stocktake Completed status, only the summary information prints on the report.

Variance

Select either:

• Print Items with Variance Only
• Print all Items

Include uncounted items

Select this option to include items for which no inventory level is available in the report. Only the names of the items will appear in the report.

Print by Bin

Select this option to sort the report by the warehouse bins which hold items.

Sorting

Select either:

• By Code
• By Location

These options do not display if you select the Print by Bin option.