This report displays stock variances (stocktake count against existing system balance) for open stocktakes.
This report should be run, usually several times, to check stocktake balances while a stocktake is being performed. The detail listed in the different columns can give a good indication of where large variances in the count of an item may have come from. It cannot be used once a stocktake has been completed.
Report Prompts
| Prompt | Description |
|
Date Range |
The date range for which you want to print the report. |
|
Stock Location |
The Stock Location (for example: Store Room) 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: Alcohol) 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 Zero Balances |
Determines whether items in the stocktake that have a balance of zero will be hidden. |
Terms Used
| Term | Description |
|
Unit |
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 have happened since the start of the stocktake. |
|
Plus Transfers |
Any stock transfers (from and to other cinemas) that have happened since the start of the stocktake. |
|
Plus Adjusts |
Any adjustments (increases or decreases) that have happened since the start of the stocktake. |
|
Less Wastage |
Any wastage that has happened since the start of the stocktake. For example: A Coca Cola bottle that was dropped. |
|
Less Sales |
Any sales that have happened since the start of the stocktake. |
|
Less Usage |
Any usage that has happened since the start of the stocktake. For example: a drink of Coca Cola includes both a straw and a cup. |
|
Stock at End |
The system stock balance as of the date of the stocktake (taking into account receipts, transfers, adjustments, wastage, sales, and usage). |
|
Stocktake Count |
The physical stock count at the time of Stocktake Entry. |
|
Count Value |
The dollar value of the Stocktake Count based on the standard unit cost, excluding tax. |
|
Variance Quantity |
The difference between Stock at End and 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, excluding tax. |
See also:
Comments
0 comments
Please sign in to leave a comment.