Stock Qty vs Serial No Count

Stock Qty vs Serial No Count checks that, for every serialised item and warehouse, the number of Serial No records marked active in that warehouse equals the stock quantity in the Bin. Each physical unit must have exactly one live serial number, so a gap means a unit was received without a serial, a serial was marked delivered without reducing stock, or a cancelled voucher left a serial in the wrong status. Stock taking of laptops and phones depends on this list matching the shelf, and warranty claims depend on each serial being in the right place. Laptops at quantity 3 with only 2 active serials is the typical row. Run it before any stock count of serialised items.

Per item and warehouse: Count of active Serial No records - Bin actual qty = 0; a row appears when the difference is not zero

1. 01Go to Financial Reports > Stock Qty vs Serial No Count, or find it under Stock reports.
2. 02Set Company and optionally Item or Warehouse.
3. 03Read Item, Warehouse, Stock Qty, Serial No Count and Difference per row.
4. 04Open Stock > Serial No filtered by the item to see which serials are active and where.
5. 05Post a Stock Reconciliation with the correct serial numbers for the warehouse, or amend the voucher that missed one.
6. 06Create a Repost Item Valuation for the item and warehouse, then rerun until the difference is zero.

Run for serialised items before stock taking.

Laptops: stock quantity 3 but only 2 active serial numbers.