Home > Reports > Screen Shots/Explanations > Stocktake Variance Report

Stocktake Variance Report

What Is It?

This report is produced from the Stocktake form. It is generated after the stock counts have been entered into the system and shows the variance between actual and expected stock levels. Only items that have a variance are shown. Each item will show the IPN, description, Expected Count, Total Actual Count, Variance and Last Counted. The Variance is calculated by subtracting the Expected Count from the Actual Count.

Usually the Total Actual Count and the Last Counted numbers will be the same. However, linked items require special handling. The user will be able to enter the count for each of the linked items, for example cartons, six-packs and singles. However, the system will convert this back to the single stock holding item, for example singles. If the total converted count is not the same as the expected count then a variance has occurred. In this case the main stock holding item will be shown first and then underneath it the linked items are listed. The total converted count will be reported as the Total Actual Count only against the main item along with the Expected Count and Variance. However, against each item the Last Counted column will show the count for that specific item. For example, if the user counted two cartons of beer and four six-packs the report would show the single item first (since it is the stock holding item) with a Total Actual Count of 72 and a Last Counted of zero. Underneath this would be listed the six-pack with a Total Actual Count of zero and a Last Counted of four, and the carton with a Total Actual Count of zero and a Last Counted of two.

You can control whether the linked items should be printed or not by using the Stocktake Reports tab in System Settings.

There is a column provided on the report for the user to write a recount number. Thus the report can be used a worksheet.

What Are The Report Parameters?

There are no parameters since this report is produced as part of the stocktake function.

Paper Requirements

This report prints on A4 paper in Landscape mode.

Sample Report

Figure: Example Stocktake Variance Report

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)