Check stock on hand

Personas: Storekeeper (checks availability, traces movements), Manager (reads value and cost-of-sales) · Modules: Inventory Answer the three warehouse questions — how much is there, why, and what is it worth — without maintaining any stock number by hand: on-hand is always the live sum of the signed ledger.

Before you start: nothing special — the reports read whatever the ledger holds. a new company shows zeros until goods documents post (or opening balances are entered as direct movements).

1. How much — Storekeeper opens the on-hand reports

1. In the Inventory group, open the Stock on Hand report: one row per product and store with the on-hand quantity — the live sum of the signed ledger, always exact, never a cached number that can drift.
2. Stock on Hand by Product gives the same per product across all stores; it also feeds the dashboard's top-5 Stock on Hand list widget.

2. Why — Storekeeper traces the movement ledger

1. Open Stock Movements — one line per movement: date, product, store, direction (IN/OUT), signed quantity (positive in, negative out), unit, the document's price, and the source document's number.
2. Every posted line carries a typed link to exactly the document that posted it — goods receipt, goods issue, stock transfer, customer return, supplier return or stock adjustment — so the drilldown from a quantity to its paperwork is one click. Hand-entered lines (opening balances, one-off corrections) have no document link.
3. Each line also shows its valuation: cost (the acquisition price on receipts and supplier returns; the moving average everywhere else) and cost value (quantity × cost, signed) — the fuel for stock value and cost-of-sales.

3. What it's worth — Manager reads the costing

1. Open Product Costs: one row per product with the pool's quantity, average cost and value — the company-wide moving average, recalculated automatically on every movement. These rows are bookkeeping the system maintains; you never edit them.
2. The Stock Value report (and its dashboard top-5 widget) shows quantity and value per product; Monthly Cost Of Sales charts what the goods you issued actually cost you per month — goods issues only, so transfers and returns never inflate it.
3. Movements by Direction and Monthly Movements give the traffic view — counts and net quantities in vs. out, and per month.

What happened behind the scenes

• No on-hand table exists: Stock on Hand is computed from the ledger at read time, per product and store, so it can never disagree with the movements.
• The average cost pool is company-wide by design — a store-to-store transfer is net zero on it, so internal moves never drift the average. When a pool empties, the last known cost is kept.
• Opening balances: enter a direct stock movement with a positive quantity and the unit cost in its price — it becomes the product's starting cost.

See also

• Inventory module · Fulfil a sales order · Replenish stock with a purchase order · Move and count stock