This report displays stock variances (stocktake count against existing system balance) for closed stocktakes.
This report should be run after a stocktake is completed to show the historical results from prior stocktakes.
It can be run for a longer time period than one stocktake to get a broader view of the stocktake performance at a site. Run over months, this report can provide the total usage/wastage/variance for all stocktakes. It cannot be used for a stocktake before it has been completed.
Note: If a stocktake is in progress for the period of the report, a message will be displayed beneath the report title warning you that variances may change.
Report Prompts
| Prompt | Description |
|
Date Range |
The date range for which you wish to print the report. Alternatively, you can select a particular Stocktake. |
|
Stocktake |
The stocktake for which you wish to print the report. For example: Dec 15 2014 Store Room. Alternatively, you can select a Date Range. |
|
Stock Location |
The Stock Location (for example: Behind POS) for which you wish to print the report. |
|
Stocktake Group |
The Stocktake Group for which you wish to print the report. |
|
Item Class |
The Item Class (for example: 3D Glasses) for which you wish to print the report. |
|
Vendor |
The Vendor (for example: Coca Cola) for which you wish to print the report. |
|
Stocktake Frequency |
The Frequency of the Stocktakes you wish to include in the report. |
|
Hide rows with zero |
Determines whether items in the stocktake that have a balance of zero will be hidden. |
|
Cost |
The costing method (for example: Weighted Average Cost) you wish to be displayed in the report. |
Terms Used
| Term | Description |
|
UOM |
The Item's packaging unit (or unit of measure). For example: a single packet of Caramel Popcorn is recorded as EA (each). |
|
Opening Balance |
The quantity of stock at the start of the stocktake. |
|
Plus Receipts |
Any stock receipts that happened during the stocktake. |
|
Plus Transfers |
Any stock transfers (from and to other cinemas) that happened during the stocktake. |
|
Plus Adjusts |
Any adjustments (increases or decreases) that happened during the stocktake. |
|
Less Wastage |
Any wastage that happened during the stocktake. For example: A Coca Cola bottle that was dropped. |
|
Less Sales |
Any sales that happened during the stocktake. |
|
Less Usage |
Any usage that happened during the stocktake. For example: a drink of Coca Cola includes both a straw and a cup. |
|
Closing Balance |
The physical stock count at the end of the stocktake. |
|
Closing Value (Net) |
The dollar value of the Closing Balance based on the Standard Cost. |
|
Variance Quantity |
The difference between the system balance (after receipts, transfers, adjustments, wastage, sales, and usage are taken into account) and the Closing Balance (stocktake count). |
|
Std Cost (Excl Tax) Gross Calculated Sales Variance Net Calculated Sales Variance
|
The standard unit cost, excluding tax. Note: This column's title and value, and whether it displays subtotals and grand totals, changes depending on the value of the System Setting StockReportsDisplayRetailValue. |
|
Variance Cost (Net) |
The total variance value, based on the standard unit cost. |
See also:
Comments
0 comments
Please sign in to leave a comment.