Outlet Variance Report
- 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
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.
|Recipe Cost||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.
|Product Selection||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.
|Report Selection||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.
|Sort Order||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.
|Quantity||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.
|Display Option||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.
When 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.|
The name of the product.
Note: If a Bin Number is defined within the Product Detail, it will display as (Bin Number)/Product Description.
|Beginning Inventory||The ending inventory of the previously closed period.|
|Purchases||The quantity and cost received of the product within the outlet and starting from the last interim or month end that has been closed.|
|Requisitions||The quantity and cost requisitioned and transferred of the product within the outlet and starting from the last interim or month end that has been closed.|
The quantity and cost impacts due to:
|Sales||The quantity and cost 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 and cost 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 and cost the application thinks is currently on hand of the product.|
|Inventory Unit Count||The quantity and cost 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.