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
Enter report criteria below to get desired results, as per Fig.2 below.
Fig.2 - Report Criteria for the Interim Outlet Variance Report
|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.
When the Interim Outlet Variance report is generated, the result should look similar to Fig.3.
Fig.3 - Interim 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.|
|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 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.|
Displays the discrepancy of the product within the outlet.
|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.
Please sign in to leave a comment.