When do I need a DL Update & how do I do it?
This article highlights when you may need to update reporting and how to do so in Decision Logic’s web-based platform.
Overview
Specific actions that a user takes will automatically update reporting in Decision Logic. However, some actions require the user to update manually using DL Updates. Running these updates re-calculates the data involved in each report.
3 main reports can be updated using DL Updates:
Cost of Goods Sold (COGS) Overview
It is important to understand what data is used in the COGS calculation. Changes made affect COGS for the week leading up to the most recently posted inventory.
Running a DL COGS Update initiates the same calculations that are performed when an Inventory is Posted. In addition, IvA & TvA reporting updates are included for the week you are running the COGS update.
Required Actions (COGS)
The actions that do require DL Updates for COGS are listed below.
Sales
Changes in the POS were sent to Decision Logic after clearing sales and re-running them through the End of Day page or UDT.
IDs were mapped or changed through POS Admin.
Department, Order Type, Discount, Reduction (Comp/Void), Gift, etc., or Store-POS assignment
COGS Category (via COGS Maintenance)
Category Section parent-child relationship or structure
Category - Sales Department (Revenue Center) assignment
PPC Account - COGS Category assignments
Prepped Items
Inventoried prepped item recipe changes would change the amount of product associated with the entered inventory count.
Not Required Actions (COGS)
The actions that do not require DL Update for COGS are listed below
New
Changed Dates
Changed Amounts / Quantities
Deleted / Undeleted
Inventory
Approved Inventory Change Requests
Edited Quantities
Opened then Re-Posted
Update Single Store’s COGS
COGS update can only be run for the most current full week. Selecting a single store allows user to pick an inventory date in the current week to update COGS.
Running COGS Updates with this selection will re-calculate the Beginning Inventory posted for the Inventory Week displayed. This doubles as the Ending Inventory for the previous week.
Begin by navigating to:
Maintenance > Product > DL Updates
Select the Company, Region, Area, or Store.
Select the most recent Inventory Week Start Date.
The green dot represents the beginning of the Inventory Week Start.
The orange arrow represents the Period Start.
Click Apply.
Check the box next to the COGS Reporting Type.
Check the box next to the Company, Region, Area, or Store needing the update.
Click Run Updates for Selected Locations.
Update Multiple Store’s COGS
When selecting multiple stores, users are able to select from This Week or Last Week. The calendar to select a date does not appear when multiple stores are selected.
Running COGS Updates with this selection will re-calculate the Beginning Inventory posted for the Inventory Week displayed. This doubles as the Ending Inventory for the previous week.
Begin by navigating to:
Maintenance > Product > DL Updates
Select the Company, Region, Area, or All Stores.
Select This Week.
Click Apply.
Check the box next to the COGS Reporting Type.
Check the box next to the Company, Region, Area, or Store needing the update.
Click Run Updates for Selected Locations.
COGS Processed Status and the Refresh arrows below.
Ideal/Theoretical vs. Actual (IvA & TvA) Overview
Changes made affect IvA & TvA for the week before the most recent inventory week. Changes to Menu Item mapping and Menu Mix / PMix Sales, Recipes, and Prepped Items will be applied, and IvA and/or TvA calculations will be recalculated.
Below are the links to how Decision Logic uses data for the IvA and TvA calculations.
Required Actions (IvA & TvA)
The actions that do require DL Updates for IvA & TvA are listed below
Recipes
Changes made to Menu Items via Recipe Book / Menu Maintenance
Ingredients
Quantities
Prepped Items
Not Required Actions (IvA & TvA)
The actions that do not require DL Update for IvA & TvA are listed below.
Changes made for the previous inventory week:
Inventory Change Request Approvals.
Inventory reopen and repost.
Inventory edits.
Receiving an order with a receive date in the previous inventory week.
Moving an order receive date from the current week to the previous week.
Editing quantities received on an order with receive date in the previous week.
Table of Contents
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
Unable to access this feature in the Decision Logic platform?
Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile and/or add new features.
Some pages are client-specific.
Update Single Store’s IvA or TvA
Begin by navigating to:
Maintenance > Product > DL Updates
Select the Company, Region, Area, or Store.
Select an Inventory Date that is beyond the current week.
The green dot represents the beginning of the Inventory Week Start.
The orange arrow represents the Period Start.
Click Apply.
Check the box of the Reporting Type (IvA, TvA, or both) to update.
Check the box next to the Company, Region, Area, or Store needing the update.
Click Run Updates for Selected Locations.
Update Multiple Store’s IvA or TvA
Begin by navigating to:
Maintenance > Product > DL Updates
Select the Company, Region, Area, or All Stores.
Select Last Week.
Click Apply.
Check the box of the Reporting Type (IvA, TvA, or both) to update.
Check the box next to the Company, Region, Area, or Store needing the update.
Click Run Updates for Selected Locations.
IvA and TvA Processed Status and the Refresh arrows below.
Updating Multiple Weeks - COGS, IvA or TvA
Before updating multiple weeks, Decision Logic recommends that you update the current week first. COGS can only be updated for the current week and not weeks from the past. IvA and TvA can be updated for weeks in the past for single-stores. Updating for multiple locations only allows for the past week to be updated.
Begin by navigating to:
Maintenance > Product > DL Updates
Update COGS for the current week using the steps for either single-store or multiple-stores. Scroll above to see detailed steps.
Click Refresh until the status says Processed.
Update IvA and/or TvA for previous week(s) using the steps for either single-store or multiple-stores. Scroll above to see detailed steps.
COGS Processed Example
IvA and TvA Processed Example
Scope and Security
These updates will apply ALL changes to any of the tables mentioned.
Examples:
If both a chicken recipe and a steak recipe were changed - and the intention of running DL Updates is only to update IvA for the chicken recipes - the reporting will also update with the steak recipe changes.
If a price changed for a distributor item, the new theoretical cost could be unintentionally inflated/deflated, leading to the variance that was not previously present.
Limited access to this page is advised for the following reasons:
An Accounting Team may need to reconcile.
DL Updates may not be necessary.
Date limits for reporting changes may be imposed.
Running a DL update is not a cure-all for the changes discussed. The DL Update page should be a final step in maintaining reports for accuracy.
© 2024 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.
If you'd like to receive news on software releases and product updates, please sign up for our email list.