Skip to main content

My stock count is wrong: what do I check first?

Before you adjust anything, rule out the six everyday reasons a shelf count and the screen disagree.

You counted 20 on the shelf and the screen says 25. It's tempting to post an adjustment straight away. Check these six things first: most mismatches are the screen counting something you didn't, and an adjustment would then make it wrong for real.

​

1. Is the right warehouse selected?

Every stock number follows the warehouse chosen at the top right of the screen. All adds up every warehouse.

​

The warehouse picker, with All at the top

​

Our butter dish showed 20 with one warehouse selected and 25 on All, because 5 had been transferred to a second warehouse.

​

2. Did you count every bin?

Open the item and click the Inventory tab. It lists every bin, and for lot-tracked items every lot, with its own quantity. Stock in a receiving or overflow bin is easy to miss on a walk-through.

​

Stock in two warehouses on the item's Inventory tab

​

If stock is booked in a bin it isn't really in, fix it with a move, not an adjustment. See Why is stock showing in the wrong place?.

​

3. Is some of it on a shipment in progress?

Check Committed in the item's header. That's stock on shipments your team has started, and some of it may already be pulled from the shelf. Picked units leave their bin rows on the Inventory tab, but the header's On hand keeps counting them until the shipment is marked shipped.

​

4. Has a delivery arrived that nobody received?

If the goods are on the shelf but their confirmed purchase order hasn't been received, they show in Expected, not On hand. Receive the order instead of adjusting.

​

5. Are you counting in the same unit?

The screen counts in the item's base unit, shown in the UOM column, for example ea. If you counted cases, multiply by the units in a case first.

​

6. What moved since the last good count?

Open the item and click the Transactions tab. It lists every receipt, shipment, adjustment, move and transfer, newest first, with who made it. Search for a document, or Export the list. A receipt entered twice or an adjustment posted the wrong way round stands out quickly. See See where stock went: an item's transaction history.

​

A kit holds no stock of its own, so count its parts instead.

​

Once you've ruled these out

Post an adjustment for the difference, bin by bin, with a note saying it's a count correction. Do a stock count, including year-end walks through it.

​

Related articles

Did this answer your question?