How do I update the Hot Item IvA Report or 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
Decision Logic offers two types of reports for Hot Item Inventory:
Hot Item IvA Report - used for single, daily hot item inventory.
Hot Item Variance Report - used for multiple daily hot item inventory counts.
Users or stores who only enter Hot Item Inventory once a day (daily) will utilize the Hot Item IvA report and, therefore, will use the Update Hot IvA feature.
Users or stores who have Multiple Hot Item Inventories enabled will utilize the DL Updates page. The DL Updates page-route updates the Hot Item Variance Report.
Please reach out to your Decision Logic Account Manager to discuss and enable multiple hot item inventories per day, and to gain access to the Hot Item Variance Report.
Enabling multiple hot item inventories per day will remove access to Hot Item IvA Report and will be replaced with Hot Item Variance Report.
Update Hot Item IvA Report
Users who utilize once-only daily hot item inventories and do not have multiple hot item inventories enabled will follow the steps below to update their Hot Item IvA Report. If an order is received for a Hot Item after counts have been entered and posted, you will need to Update Hot IvA.
Begin by navigating to Maintenance > Product > Update Hot IvA
Select the Company, Region and Group followed by the Date.
Check the box next to the Store you need to update
Select Update.
Click OK on the confirmation pop-up box.
Running this update can also correct missing Ideal Quantities. If your user permissions do not allow you to access this page, the alternative option is to open your Hot Item Inventory and update the count.
Suppose an order is received with a Received Date prior to the most recently posted Hot Item Inventory. In that case, an update will need to be run to recalculate the Hot Item IvA with this purchase included. Therefore, choose the date after the purchase.
If on 01/03 I received an order with receive date 01/01, I would run Update Hot IvA for 01/02 to recalculate the data with the newly received order.
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.
© 2025 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.