How do I update the Hot Item Variance Report?
This article is for Decision Logic Administrators who need to update the Hot Item IvA Reporting or the Hot Item Variance Report on Decision Logic’s platform.
Overview
The Hot Item Variance Report is used to view variances for multiple daily hot-item inventory counts. Stores will utilize the DL Updates page to update data for reporting.
Update Hot Item Variance Report
Users who have multiple hot item inventories per day enabled will update the Hot Item Variance Report in our DL Updates page.
Begin by navigating to:
Maintenance > Product > DL Updates
Select the Hot Item IvA tab.
Select All Stores.
Select a Date.
Click Apply.
Check the boxes next to the Company, Region, Area, or Stores that need updates.
Click Run Updates.
Hot Item IvA Calculation
Using the same format as Ideal vs. Actual (IvA) Reporting
Metric | Calculation |
|---|---|
Ideal vs. Actual (IvA) | Ideal vs. Actual is the amount used compared to the ideal amount used. This is found by using the following formula:
|
Ideal Usage | Ideal usage is the quantity entered for each Menu Item recipe multiplied by the Menu Item sales from the Menu Mix reporting pulled from the POS System. |
Helpful Tips
Sales should be posted in Decision Logic on the End of Day page or the DSR for the day before the ‘Beginning Inventory’ date selected.
Orders need to be received for the day before the Beginning date you select.
If using the EBR method to receive orders, the Invoice will also need to be sent from the Distributor.
Post at least two Inventory counts for items to get the Beginning and Ending Inventory reporting. These Inventory counts can be two consecutive dates or any two dates that have Inventory entry.
Hot Item report shows a single entry line. The amount is the sum of all inventoried items.
Prepped food Hot IvA reporting rolls up into the total ingredient amount under the Raw Ingredient. Therefore, if you are taking Inventory on a prepped item, you also need to add the Raw Ingredients to the Hot Item IvA inventory.
The Hot Item Inventory list does not show all Inventory locations and cannot be sorted but will follow the “sheet-to-shelf” order established in a store’s primary Inventory Guide.
Inventory items can be counted in multiple locations, but you will enter one total quantity. This is because Hot Items will only report once.
Hot Item IvA Requirement
Hot Item IvA report rolls up any prepped items to report under their raw ingredient. The raw ingredient also needs to be enabled as a Hot Item to get roll-up reporting for the prepped items.
© 2026 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.
Table of Contents
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.