Read one row
Use the terminology comparison
for Order Point / Line Point labels. Read each column’s description when using
other variance fields: an Inventory Variance compares the target with
on-hand inventory, while Max Variance compares the two targets.
The dollar comparison helps prioritize review. It is not a promise of immediate
cash savings or a purchase quantity.
Build a focused review view
- Confirm the location you want to review.
- Use search or open a column header to choose the supplier, product group, or other filter values.
- In a numeric column such as Max Variance (%), choose High to Low or Low to High, then select Apply. The sort/filter choices take effect when you apply them.
- Open Columns to show the fields you need. Its searchable checkboxes change visibility immediately. Keep item, location, current/new targets, and the relevant variance visible together.
- Inspect both increases and decreases. A small percentage on an expensive item can matter more than a large percentage on a low-value item.
Clear straightforward changes first
For your initial review, cover every item at least once by working in groups. Open the Actions column filter, choose Unapproved, and select Apply. Then use Max Variance (%) to group changes your team is comfortable accepting. Add a Max Variance ($) range where that column is shown. In Order/Line Points, use the corresponding Line Point Variance columns. Review the group and bulk approve it, giving higher-cost items a closer look and keeping stocking decisions and known exceptions for separate review. This can clear much of the routine work so you can focus closely on larger differences and decisions with greater service or inventory impact. Follow approve small changes in groups for the complete procedure.Understand an unexpected target
Select an underlined New Min or New Max to see how Lantern arrived at the target. Inspect the demand and supply information, limits, Manual Override, and Final Inventory Levels. Keep coverage measured in days separate from inventory quantities measured in units. An override lock can show Permanent Override or Until [date], its reason, and the underlying recommended values. Select the lock to inspect the item’s history. Then open Forecast on the row to investigate demand and customer activity. If demand does not explain the target, check lead time, order frequency, or classification and safety stock.Choose the next action
- The recommendation fits: approve the reviewed target, then apply it through your team’s export process.
- You have a specific business exception: choose the appropriate override or boundary.
- You already have different targets in a spreadsheet: upload them together as overrides for the relevant items and locations.
- Routine changes should need less manual review: review personal buyer rules where My rules is available, or ask your Lantern admin about company tolerances.
Before a bulk action
Select the items you want to change, or filter the table to the group you need. Before confirming, check whether the dialog applies to selected items or all filtered items, and confirm the item count.Apply reviewed targets
Your team’s export setup carries reviewed targets into your buying process. For a manual export:- Confirm the reviewed targets are approved. Use the row or toolbar Approve action for targets still awaiting approval.
- Select Export, choose the approved items to include, and review the item count and Impact Preview.
- Choose the export option your team uses:
- Connected ERP: select Export to followed by the ERP name. Review Confirm Export, select the export button showing the item count, and check Export Results for the outcome.
- Spreadsheet import: choose Download Excel, follow your team’s import process, and confirm the resulting targets in your ERP.