📄 Understanding Quantity on Hand Discrepancies

What This Covers

Why Odoo's Quantity on Hand (QOH) might not match your physical count, and how to fix it.

Common Causes

  1. Unreceived PO items — Items may be physically on the shelf but the receipt hasn't been validated in Odoo. Check Inventory > Operations > Receipts for pending receipts.
  2. Unvalidated deliveries — Items shipped but the delivery order is still in "Ready" status. Validate it to deduct from QOH.
  3. Open POS session — POS sales don't deduct inventory until the session is closed (in some configurations). Close all open sessions.
  4. Consignment items — Consignment stock may or may not count in your QOH depending on the location setup. Check the stock location's ownership settings.
  5. Multi-warehouse confusion — QOH is per-warehouse. Make sure you're looking at the right warehouse filter.

How to Fix

  1. Go to Inventory > Operations > Physical Inventory (or Inventory Adjustments).
  2. Search for the product.
  3. Enter the actual counted quantity.
  4. Click Apply. Odoo creates an adjustment move to reconcile the system count to your physical count.
  5. For serialized items, you'll need to specify which serial numbers are present/missing.

Common Errors

  • QOH shows negative — Something was sold or transferred before being received. Check for delivery orders or POS sales that went out before the receipt was validated.
  • Website shows "In Stock" but QOH is 0 — The website may be using "Available" quantity (which includes incoming) or the cache hasn't updated. Check the product's website publication settings.

Still Need Help?

Submit a ticket with: the product name/SKU, expected quantity, Odoo quantity, and which warehouse.