1. Supply Chain
  2. Features
  3. Counts and adjustments
Feature · Counts and adjustments

Counts and adjustments

Count stock on a schedule, post small variances, route large ones for review and run wall-to-wall physical inventories.

OverviewCycle Counts Pending Review
Supply Chain · Counts and adjustments

Cycle Counts Pending Review

Review waits for the inventory manager

New
Count numberWarehouseBinProductLot numberBook quantity
CC-73422WRH-110BNS-2999PRD-1039L26-7380700
CC-92888WRH-120BNS-9324PRD-8780L26-2616500
CC-86025WRH-150BNS-9496PRD-2541L26-8134460
CC-52259WRH-150BNS-5706PRD-4829L26-5332810
CC-64043WRH-130BNS-3288PRD-8458L26-1144580
6 of 6 records
WRH-110Cycle counts · CC-73422
BinBNS-2999
ProductPRD-1039
Lot numberL26-7380
Book quantity700
Counted quantity23
Example screen with sample data

What you can do

Keep the book quantity honest

Cycle counts check part of the warehouse on a schedule: a zone, a bin, a product or a lot. Each count records the scheduled date, the book quantity, the counted quantity, who counted and the variance. Counts move from Scheduled to Counted. When the variance is within tolerance, an adjustment movement is posted and the count is Adjusted. When it is larger, the count goes to Pending Review for the Inventory Manager, who investigates before any adjustment. Counts are Closed once settled.

Physical inventories count a whole warehouse at once. They move through Planning, Counting, Reconciling, Posted and Closed, with a coordinator, start and end dates and the total value of adjustments.

How the work is organized

  • Schedule by risk. Fast-moving and high-value items are counted more often.
  • Tolerance decides the route. Small variances post automatically as adjustments; large ones wait for review.
  • Physical inventory for the full picture. A wall-to-wall count reconciles every position and posts its adjustments together.

What to agree during setup

Agree the count frequency by ABC class. Agree the variance tolerance, by percentage and value. Agree who reviews large variances and what evidence they need, such as a recount. Agree the physical inventory calendar and the movement freeze during the count.

Check the handoff on an actual case

A cycle count on bin R-14-03 shows a book quantity of 480 bags of lot R-2602. The operator counts 478. The 0.4 percent variance is within the 2 percent tolerance, so an adjustment movement of minus 2 is posted and the count is Adjusted.

The next week, bin P-02-11 shows 120 cartons of a component on the books and 96 on the shelf. The 20 percent variance goes to Pending Review. The Inventory Manager checks recent movements and finds a pick recorded against the wrong bin. The pick is corrected with a movement to the right bin, the recount matches, and the count is closed without a write-off.

What your team sees

  • Cycle Counts Pending Review — Counts with large variances waiting for the Inventory Manager, with book and counted quantities.
  • My Cycle Counts — The signed-in operator’s assigned counts by zone and date.

Follow the work through

Plan the rollout with your warehouse leads.

What it keeps track of

Data model
Cycle counts
Scheduled partial inventory counts.
Physical inventories
Periodic full-warehouse wall-to-wall counts.
Stock movements
Every physical movement of stock.
Inventory
On-hand, allocated and available-to-promise stock per product, warehouse, bin and lot.
Bins
Bin-level storage locations within a warehouse.

Who uses it

Permissions
Inventory Manager
Reviews large variances and runs physical inventories.
Admin
Manages access.

Set up Supply Chain your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started