Adaco: Interim Outlet Variance Report

Interim Outlet Variance Report

The Interim 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 Interim Inventory.

• To run this report, go to Report Center > Inventory Reports > Interim Outlet Variance
• ​To open the report criteria screen, double-click Interim Outlet Variance report or select the report and click Run Report, as per Fig.1

Note: this report is only available when Allow Interim Inventory, located under Property > Administration > Property Preferences > Inventory, is enabled.

Fig.1 - Running the Interim Outlet Variance Report

Report Criteria:

Enter report criteria below to get desired results, as per Fig.2 below.
 

Fig.2 - Report Criteria for the Interim Outlet Variance Report

Fields	Description
Reporting Period	All interim inventories that have been opened and closed.
Start / End Date	Pre-filled fields based on the open and close dates of the interim inventory.
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.
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 Onhand Cost with Avg. Price: generates the report with only products where the inventory cost is not the same as the cost under the System Onhand 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.

 
Report Results

When the Interim Outlet Variance report is generated, the result should look similar to Fig.3.

Fig.3 - Interim Outlet Variance Report results

 

Fields	Description
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.
Unit	The inventory unit of the product.
Description	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 received of the product within the outlet and starting from the last interim that has been closed.
Requisitions	The quantity requisitioned and transferred of the product within the outlet and starting from the last interim that.
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 OnHand	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 = SYSTEM ON HAND - INVENTORY UNIT COUNT
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.