Skip to main content
Use Min/Max to decide whether proposed inventory targets make sense for an item at a location. Some workspaces call this page Order/Line Points. Start with one supplier or product group you know, rather than trying to review the whole catalog at once. The question is what coverage the item needs next. A higher recommendation may protect growing sales or a longer wait for stock. A lower recommendation may avoid buying more of an item that is slowing down. Use the target breakdown and customer history to understand that decision before accepting or changing it. For a guided first pass, follow your first inventory review.

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

  1. Confirm the location you want to review.
  2. Use search or open a column header to choose the supplier, product group, or other filter values.
  3. 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.
  4. 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.
  5. Inspect both increases and decreases. A small percentage on an expensive item can matter more than a large percentage on a low-value item.
Use Reset in a column’s dialog to clear that column’s filter/sort. Clear All Filters opens a dialog with the available filter and sorting reset choices; choose the result you intend.

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

Where Stocking Status is shown, review Discontinue and Start Stocking separately from target variances. Check customer commitments before making a stocking decision.

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:
  1. Confirm the reviewed targets are approved. Use the row or toolbar Approve action for targets still awaiting approval.
  2. Select Export, choose the approved items to include, and review the item count and Impact Preview.
  3. 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.

FAQs

Can I upload Min/Max values from a spreadsheet?

Yes. Drag a CSV or XLSX file onto the Min/Max table, match its columns, review the sample, and start the import. This saves fixed overrides, with a reason and expiration, for the item/location pairs in your file. See upload Min/Max targets from a spreadsheet for the required fields and steps. To accept Lantern’s recommendations together, use bulk approval.

Do I have to review the whole catalog every time?

No. Review every item at least once to confirm that the plan fits your business and establish the targets your team accepts. Work in groups: filter changes you are comfortable accepting, review and bulk approve them, then focus on larger differences, stocking decisions, and business exceptions. After that, unchanged accepted targets remain approved and auto-approval can handle qualifying changes. Use Priority Center for the decisions needing attention. Follow your first review for the filtering and bulk-approval steps.

Sales are growing. Why is Lantern recommending less stock?

Your target covers a replenishment period. Quick delivery and frequent orders can support growing sales with less stock held at once. Review demand, lead time, ordering interval, and the buffer together. See why targets can be lower while sales grow.

Does Discontinue mean delete the product or get rid of our stock?

It asks whether to stop routinely stocking the item at that location. A 0/0 target ordinarily means no standing Min/Max stock target. It does not mean dispose of existing units or delete the product. Likewise, Start Stocking can appear for an item that already has units on hand. Physical stock and an ongoing replenishment policy are different things. See reviewing stocking decisions.

Why might we buy more before total inventory comes down?

Understocked items may need replenishment now, while excess stock elsewhere takes time to sell. Lower targets reduce future purchases; cash is released as excess stock sells down and you avoid unnecessary replacement purchases. Review increases and decreases together with your team’s purchasing budget. See why inventory can rise at the start.

Does approving a change update the ERP?

Approval records your review. Targets reach your ERP through your team’s configured export process. For a manual handoff, follow apply reviewed targets. Auto-Export, where enabled, is separate from auto-approval.