Outlet Variance Report
The Outlet Variance report is used to see if there are any discrepancies between what was counted and what the system has calculated to be on hand for a selected Period Inventory.
- To run the Outlet Variance report, go to Report Centre>Inventory Reports>Outlet Variance.
- Double-click Outlet Variance Report or select the report and click Run Report, to open the report criteria screen, as per Fig. 01.
Fig. 01 - Running the Outlet Variance report
Enter report criteria below to get desired results, as per Fig. 02 below.
Fig. 02 - Report Criteria for the Outlet Variance report
|Select Outlet||All outlets available for selection for the report.
Note: only outlets marked as Perpetual may be selected, as defined in Property>Setup>Location>Outlet.
|Reporting Period||All period inventories that have been opened and closed.|
|Start / End Date||Pre-filled fields based on the open and close dates of the period inventory.|
|On hand Cost||
With Original Transactions: generates the report with the original price for the product/recipe during the transaction. Sum of All Transaction Costs.
Note: including zero cost transactions.
With Average Cost: generates the report with an average price if there were several transactions with different prices.
Transaction prices: generates the report with the cost of the recipe during the transaction. ($10)
Recost recipe prices: generates the report with the cost of the recipe before the recost job has run on the server. ($15)
Last Costed Recipe Cost: generates the report with the cost of the recipe after the recost job has run on the server. ($20)
For example, a recipe is transferred from the Storeroom to an outlet and at the moment of transaction the recipe cost was $10.
Then the price of ingredients was changed so that the recipe cost became $15; this was recosted in the system using a job running on the server.
Later on, the price of ingredients was changed to make recipe cost $20 (but the job has not run on the server yet).
|Preliminary||When enabled, the period selection will be limited to the current inventory period.
Note: this option is available only when inventory is in progress.
|Use Selling Price for Sales Transactions||
If unchecked - the Source Detail area on the report will show the recipe's cost, according to the option selected in the recipe cost control on the criteria dialog.
If checked - the Source Detail area on the report will show recipe price from the sales transaction.
All Products: generates the report with all products.
Selected Products: generates the report with only chosen products.
Selected Categories: generates the report with only chosen categories.
Selected Locations: generates the report with only chosen locations.
Selected Accounts: generates the report with only chosen accounts.
Selected Recipe: generates the report with only chosen recipes.
All Recipes: generates the report with all recipes.
All Items: generates the report with all products and all recipes.
Product: generates the report with only product information.
Product with Transaction Detail: generates the report with recipe creation, retail sales, received purchase orders, and posted outlet requisitions information.
Category Totals: generates the report with only the overall amounts of the products assigned to the category.
Category and Subcategory: generates the report numerically first by the category number and then by the subcategory number, as defined under Property>Setup>Categories>Categories.
Inventory: generates the report by the setup in the outlet guide, as defined under Inventory>Maintain Guides.
Category: generates the report numerically by the category number, as defined under Property>Setup>Categories>Categories.
Account: generates the report numerically by the account number, as defined under Property>Setup>Accounts>Accounting.
Inventory Cumulative: generates the report with the summed up values of products/recipes which are found in several locations within an outlet.
Note: this option is intended for location outlets.
Non Zero Quantity: generates the report with only products that do not have a 0 quantity in the Inventory Unit Count column.
All: generates the report with all products.
Variance Only: generates the report with only products that have a discrepancy.
Different On hand Cost with Avg. Price: generates the report with only products where the inventory cost is not the same as the cost under the System On hand column.
Quantity Details Only: generates the report with only the information per each column headers.
Include Cost Details: generates the report with the inventory cost information per each column header.
Report ResultsWhen the Outlet Variance report is generated, the result should look similar to Fig. 03.
Fig. 03 - Outlet Variance Report results
|Document Map||Allows the user to quickly access different outlet and categories within the outlet easily in the report.|
|Product No.||The Adaco number for the product.|
|#||This indicator is intended to show if product/recipe cost was changed during the selected period.
For example, if there were two receivings of a product during a period, one at a price of 2 dollars and one at a price of 3 dollars.
|Unit||The Inventory Unit of the product.|
|Description||The name of the product.|
|Beginning Inventory||The ending inventory of the previously closed period.|
|Purchases||The quantity received of the product within the outlet and starting from the last interim or month end that has been closed.|
|Requisitions||The quantity requisitioned and transferred of the product within the outlet and starting from the last interim or month end that has been closed.|
|Inventory Adj.||The quantity of the product that has either been manually, Inventory>Inventory Adjustment, or automatically modified by the application upon closing Interim or Period Inventory, Inventory>Close Interim Inventory or Inventory>Close Period.|
|Sales||The quantity of the item sold via POS or manual entry. If Retail Products, the quantity will show against the Products; if Recipes, the quantity will show against the Recipes.|
|Recipe||The quantity of the item converted via Sales or internal transactions. As Recipes are created, Products are deducted; as Recipes are sold or requisitioned/transferred, Recipes are deducted.|
|System On Hand||The quantity the application thinks is currently on hand of the product.|
|Inventory Unit Count||The quantity of the product that has been entered in the Physical Inventory Count screen, which is located under Inventory>Physical Inventory Count.|
|Variance||Displays the discrepancy of the product within the outlet.
Calculation:VARIANCE = INVENTORY UNIT COUNT - SYSTEM ON HAND
On Hand = 20, Count = 10,
10-20 = -10 variance correct
20-10 = +10 variance incorrect
On Hand = -1, Count = 2
2 - (-1) = +3 variance correct
(-1) - 2 = -3 variance incorrect
|Outlet Total||The sum of all the products in the outlet.|
|Account||The Adaco account number.|
|Account Name||The name of the account.|
|Cost||The total inventory cost per account.|
|Account Total||The sum cost of all accounts.|
|Accounts Grand Totals Recap||
Account: the Adaco account number.
Account Name: the name of the account.
Total: the sum inventory cost per account in all outlets.
Accounts Grand Total: the sum cost of all accounts in all outlets.