Skip to main content

Reviewing Counts and Updating Inventory

Review count discrepancies in the web app and update inventory with Update Inv., with what happens to each count line and how counted quantities are applied.

Overview

After operators complete their count tasks, a supervisor reviews the results and updates inventory in the web app.

The Update Inv. button adjusts inventory to the counted quantities. Where you use it decides which lines are updated and what happens to lines that are not counted yet.

Inventory can also be updated by an operator on mobile (see Counting on the Mobile App) or automatically for lines with no difference (see Auto-Update No-Difference Count Lines). For the full process, see A Guide to Managing and Executing Cycle Counts.

When to use it

  • Check counted quantities against system quantities before you change inventory.

  • Update inventory for whole count plans, or only for selected locations or SKUs.

  • Close a count plan that still has uncounted lines.

  • Understand how a count changed allocated quantity, Receiving Dates and transactions.

Prerequisites

  • Count lines in Count Completed, counted on the mobile app.

  • A role with permission to update count plan inventory.

  • Optional: Mandatory Adjustment Reason for Cycle Count Updates turned on, to require a reason for count updates with a quantity difference (see Mandatory Adjustment Reason for Inventory Operations).


Review discrepancies

  1. Go to the Count Plan screen and click the plan.

  2. Open the Location Details or SKU Details tab.

  3. Compare the system inventory with the physical count, line by line. Optional: use the Warehouse filter to narrow the list to one warehouse; it combines with the other filters, and Export As Excel exports only the filtered lines.

For the meaning of each column and how % Difference is calculated, see Analyzing Cycle Count Results. To count a line again, see Creating and Managing a Recount.

💡 % Difference is only filled for lines in Count Completed, Recount Created or Inventory Updated. Lines in Pending, Ready to Count, Count Started or Cancelled show no difference, including in the Excel export, because no count has been submitted for them.


Update inventory

  1. On the Count Plan screen select one or more plans, or on the Location Details / SKU Details screen select the lines you want to approve.

  2. Click Update Inv. The info (i) icon next to the button explains the rule for that screen (see the table below), even when the button is disabled.

  3. If the selection contains lines that are not complete, an Attention pop-up appears before anything is sent. If all selected lines are complete, no pop-up is shown.

    • Count Plan screen: the pop-up says "Selected count plans contain lines that are not in Completed status." Under "If you proceed:" it lists "Inventory will be updated for Completed lines only" and "Lines not in Completed status will be canceled". It then shows "Some of the lines in the following count plans will be cancelled: (N)" with the plan codes, which you can copy with the copy button, and an info box: "To view the details, you can go to the Location Details or SKU Details screen." Here, Completed means lines in Count Completed.

    • Location Details / SKU Details: the pop-up warns that inventory is updated only for lines in Count Completed and the other lines are not affected.

    Click Proceed to continue, or Cancel to close the pop-up without changes (your selection is kept).

  4. If Mandatory Adjustment Reason for Cycle Count Updates is on, select a reason. The prompt appears only when at least one selected Count Completed line has a quantity difference. See Mandatory Adjustment Reason for Inventory Operations.

Inventory is adjusted and a "Count" transaction is created, which you can see in the Transaction History Report.

Only lines in Count Completed are ever updated. What happens to the other selected lines depends on where you run the action:

Where

Count Completed lines

Other lines

Tooltip

Count Plan (whole plan)

Inventory is updated; lines become Inventory Updated

Lines in Pending, Ready to Count or Count Started become Cancelled with no inventory change, and their open mobile tasks are cancelled. Recount Created and Cancelled lines are not changed

"Triggers inventory update for count lines with the Count Completed status in the selected count plans. Lines in other statuses will be canceled."

Location Details

Inventory is updated; lines become Inventory Updated

Skipped; they stay in their current status for further action

"Triggers inventory update for locations in Count Completed status. Locations in any other status will remain unchanged."

SKU Details

Inventory is updated; lines become Inventory Updated

Skipped; they stay in their current status for further action

"Triggers inventory update for SKUs in Count Completed status. SKUs in any other status will remain unchanged."

Mobile Complete Count & Update Inventory

Only the location just counted (see Counting on the Mobile App)

Not affected

—

Checks on the Count Plan screen, in this order:

  1. You must have permission to update count plan inventory; otherwise an authorization error is shown first.

  2. All selected plans must belong to the same warehouse. Otherwise the update is blocked with "Inventory updates cannot be performed for multiple warehouses simultaneously. Please select count plans from a single warehouse to proceed." Your selection is kept.

  3. The usual status checks then apply.

⚠️ LP moved after the count. When you click Update Inv. on the Location Details or SKU Details screen, counted LPs are checked again. If a counted LP now has inventory in other locations or was moved to another location after the count, the update is refused with "Count inventory update cannot be finalized since counted LPs have inventory in other locations or moved to another location after the counting."


How counted quantities are applied

  • If the operator counted in a different pack type than the stored inventory, the inventory is replaced with what was counted, in the pack type the operator counted. The total in units follows the pack-type ratio. Example: 20 Unit are stored and the operator counts 5 × 6pack, so the location then holds 5 × 6pack (30 units).

  • Allocated quantity in the location is kept. The counted quantity becomes the location total and the free quantity is adjusted.

  • If a product has several inventory rows in a location with different Receiving Dates, an under-count is removed from the oldest Receiving Date first. An over-count is added as a new row with today's Receiving Date and no PO Number.

  • Each adjusted row appears as a Count transaction in the Transaction History Report.

Example: 2 units are allocated in the location and the operator counts 10. The location total becomes 10, with 8 free.


Common questions

Why did some lines become Cancelled after I updated inventory? Update Inv. on the Count Plan screen closes the whole plan: lines that were not in Count Completed are cancelled with no inventory change, as the Attention pop-up warns before you proceed. To update only the completed lines and keep the others open, use Update Inv. on the Location Details or SKU Details screen.

Why is % Difference empty for some lines? No count has been submitted for them yet. % Difference is only filled for lines in Count Completed, Recount Created or Inventory Updated.

Why was my inventory update blocked? On the Count Plan screen, all selected plans must belong to the same warehouse, and you need permission to update count plan inventory. On Location Details or SKU Details, the update is refused if a counted LP now has inventory in other locations or was moved to another location after the count: "Count inventory update cannot be finalized since counted LPs have inventory in other locations or moved to another location after the counting."

Did this answer your question?