Unit-Level Inventory Ledger

Problem class

Without a canonical inventory record, every downstream capability — picking, replenishment, auditing, promising — operates on stale or conflicting data. The ledger eliminates the "which number is right?" problem by providing one authoritative state.

Mechanism

Every physical inventory event (receipt, putaway, move, pick, adjustment, ship) generates a timestamped transaction against the ledger. Each transaction updates quantity-on-hand, location, status (available / held / damaged / in-transit), and lot/serial attributes. The ledger enforces double-entry logic: quantity leaving one location must arrive at another. Downstream systems subscribe to the ledger's event stream rather than maintaining shadow counts.

Required inputs

• Item master data (SKU, UOM, lot/serial policy)
• Location hierarchy (zone → aisle → rack → bin)
• Transaction capture devices (barcode scanners, RFID readers, manual entry terminals)
• Inbound receiving confirmations (ASN or PO-linked receipts)

Produced outputs

• Real-time quantity-on-hand by SKU × location × lot × status
• Transaction journal (full audit trail of every inventory movement)
• Available-to-promise feed for order management
• Reorder-point trigger events for procurement
• Variance alerts when physical ≠ expected

Industries where this is standard

• E-commerce same-day fulfillment
• Pharmaceutical cold-chain distribution
• Automotive aftermarket parts distribution
• 3PL multi-client warehousing
• Grocery retail distribution

Counterexamples

• Bulk commodity yards (sand, gravel, scrap metal) where inventory is measured by weight or volume via scales and sensors, not discrete units. Forcing unit-level tracking on continuous-flow bulk material creates false precision and unnecessary transaction overhead.
• Very small craft workshops (under ~200 SKUs, single operator) where a simple spreadsheet or visual Kanban is sufficient and the overhead of a formal ledger exceeds the cost of occasional stockouts.

Representative implementations

• Amazon's proprietary inventory system across 175+ fulfillment centers, tracking billions of units at bin-level granularity with sub-second updates.
• Walmart's global inventory visibility system powering both store and DC replenishment across 150+ DCs.
• Flexport's unit-level tracking for cross-border e-commerce logistics clients.
• Open-source: Odoo Inventory module — widely adopted mid-market WMS with full lot/serial tracking.

Common tooling categories

Warehouse management system (WMS) core ledger module + barcode/RFID capture layer + event bus for downstream subscriptions + item master data management.