Production Stock Summary

The Production Stock Summary report is GarmentFlow's combined view of stock and production. Where Stock Balance shows you what you have by item and warehouse, the Production Stock Summary shows it through the lens of Production Orders and Batches — what's planned, what's issued, what's in WIP, what's available.

What it shows

For each item appearing in active Production Orders or Batches:

Planned Qty — total demand across active Production Orders/Batches.
Issued Qty — how much has actually left the Raw Material warehouse via Material Transfer Stock Entries.
Consumed Qty — how much has been recorded as consumed via Operation Ledger Entries.
WIP Balance — what's currently sitting in WIP warehouses (Issued minus Consumed).
Raw Material Balance — what's left at the Raw Material warehouse.
Net Available — Raw Material Balance minus what's reserved but not yet issued.

The report groups by item, with sub-rows per Production Batch (so you can see "300m of olive twill is committed to Batch B-001 and 200m to Batch B-005").

When to use it

This is the report a planner opens before releasing a new Order. It answers: given what's already in flight, what's actually available to commit?

A few patterns:

Before releasing an Order: filter to the Order's items. The Net Available column tells you whether the Order can run on existing stock.
Before authorizing additional Batches: same question, scoped to a specific Batch family.
During a mid-month review: scan for items with high Planned but low Issued — work that's planned but hasn't moved into production yet, suggesting a Material Request bottleneck.
For brand reporting: per-brand or per-Tech-Pack rollups for the brand's production-status updates.

How it differs from the standard ERPNext Stock Balance

ERPNext's Stock Balance shows current state per item × warehouse. The Production Stock Summary shows the same data with production context layered on:

Aggregates across all WIP warehouses into one WIP Balance.
Shows planned demand from open Production Orders/Batches.
Subtracts reserved-but-not-issued from Raw Material to give Net Available.

In practice: when a planner asks a stock question, the Production Stock Summary answers it faster. When a financial team asks an inventory-valuation question, the Stock Balance is the right tool.

A working example

You're holding a planning meeting. Three Production Orders are being reviewed for next-week release; all three use "Cotton Single Jersey 180 GSM — Heather Grey."

Production Stock Summary, filtered to that item:

Planned: 3,200m across all active Orders/Batches (existing plus the three being reviewed).
Issued: 1,500m (existing Batches that have started).
Consumed: 1,100m (work already done).
WIP Balance: 400m (still sitting in WIP, not yet consumed).
Raw Material Balance: 2,400m.
Net Available: 1,900m (Raw Material minus 500m reserved for an unstarted existing Batch).

The three new Orders together need 1,700m. Net Available is 1,900m. Math works, but only barely. The planner decides to release two of the three and hold the third until a PR for next week lands.

The same data is technically derivable from Stock Balance + a couple of other reports, but it would take five minutes of cross-referencing. The Production Stock Summary gives it in one screen.

What to do next

For the dashboards that read from this same data and surface it visually, see Dashboards.