Stock Balance

The Stock Balance report is the snapshot. For every item × warehouse combination, it shows the current balance — quantity on hand, with valuation. It's the "what do I have right now" report, and it's the second-most-opened report in most factories (after the dashboards).

What it shows

Columns:

Item Code and Item Name.
Warehouse.
Opening Qty — balance at the start of the report's date range.
In Qty / Out Qty — gross in and out during the range.
Balance Qty — current balance.
Valuation Rate — current rate per unit.
Balance Value — Balance Qty × Valuation Rate.

By default, it shows current balance for all items across all warehouses. Filter aggressively or it's a wall of rows.

How to use it

Pre-production check. Filter to the items on a new Production Order; confirm they're in stock at the warehouses you'll source from. If not, raise a PO or expedite an existing one.
End-of-month inventory. Run for the last day of the month; balance value tells you the inventory at month-end (used in financial closes).
Specific lookup. "Do we have 200m of indigo denim?" Filter to the item; see all warehouses; sum the balances.
Negative-balance check. Sort by Balance Qty ascending. Any negative balances are a sign of mis-posting — investigate them.

What it doesn't show

A snapshot doesn't tell you trajectory. The Stock Balance says "you have 500m of fleece" but doesn't tell you "you're consuming 200m a week, so you have 2.5 weeks of cover." For trajectory, look at the Stock Movement Timeline report or pull a weekly snapshot over several weeks.

The Stock Balance also doesn't show reserved quantities. An item with 500m on hand might have 400m reserved against open Production Batches; only 100m is genuinely uncommitted. For the reserved view, look at Stock Reservation Entries or at the Batch-side Materials section (which shows reserved per row — see Stock reservation on Production Batch).

A working example

You're planning whether to release a new Production Order. The Order needs 800m of "Cotton Twill 240 GSM — Olive" and 1200m of "Cotton Twill 240 GSM — Stone."

Stock Balance, filtered to those two items:

Olive: 1100m in Raw Material warehouse. Plenty.
Stone: 750m in Raw Material, 600m in WIP (already transferred to another Batch). Not plenty — 150m short for what you need, even before checking reservations.

You either: hold the release; raise a PO for 200m more; reduce the Order's quantity. The Stock Balance gave you the answer in 30 seconds — the planning conversation is now grounded in real data.

What to do next

For the garment-factory lens on the same data, see Production Stock Summary.