Production Reports

Where Dashboards are visual and meant for browsing, reports are list-shaped and meant for filtering, exporting and sharing. The production side has grown well past the original handful, so they're grouped here by the question they answer.

Planning and progress

Production Release Overview — readiness of every Production Order to be released. Surfaces orders waiting on materials, missing Tech Pack readiness, missing Batch plans. Use it before your weekly release meeting.

Production Batch Status — every active Batch with state, current operation, planned vs actual completion, and quantity completed. The tabular cousin of the Where Is It dashboard; useful when you want to export to a spreadsheet.

Batch Production Tracker — real-time progress per Batch: percent complete by operation, hours elapsed, hours remaining. The report a production manager keeps open in a browser tab during a busy week.

Production Order Bottlenecks — for active orders, the operation that's currently the constraint. Often Stitching, sometimes Wash or Finishing. Knowing the bottleneck is the first step to relieving it.

Production Unit Load — same data as the unit load dashboard, in a sortable table. Useful when you want to send a "who's overloaded next week" list to your scheduling lead.

Production Unit Queue — what's waiting at each unit right now.

Material Procurement Status — where each order stands on getting the material it needs.

Cutting

Marker Order Efficiency — per Marker Order: yield, fabric consumed per ply, total pieces, and an efficiency score against expected yield for the pattern. Use it to spot patterns whose markers are drifting from spec.

Marker Batch Usage — which batches each marker was used on, so a yield number can be traced back to real cuts.

Labour and cost

Batch Card Labor Summary — labour minutes and cost per Batch Card, grouped by Production Unit and operation. For daily labour reconciliation, payroll inputs, and finding units where actual minutes consistently diverge from SMV.

Batch Card Assembly Summary — the same work seen by assembly operation rather than by card.

Operator Efficiency — output against standard, per operator.

Operation Cost Variance — planned cost against actual labour cost per order and operation, with the variance in both currency and percent, plus labour hours. The report that turns "that order felt expensive" into a number.

Operation Steps Needing Cost Data — steps that can never produce an actual cost because they're missing a cost source, supplier, service item or estimate. Clear this list before month end; the same check gates closing an order.

Subcontracting

Three reports covering the external half of production cost. Full context in Subcontracting.

Subcontract Billing Queue — done, unbilled external work grouped by supplier and service item, with pending pieces, the resolved rate and the estimated amount. Has a Create Bill action. The "who do we owe" screen at month end.

Subcontract Three-Way — earned (from the operation ledger) vs committed (PO) vs invoiced (PI), one row per supplier, batch and operation, with open commitments, unbilled work and over-billing derived from them. Open it when a supplier's statement doesn't match yours.

Subcontract Reconciliation — invoiced quantity against ledger quantity per buying-document line, with the variance and both net amounts. The month-end tie-out.

Audit and exceptions

The reports you run to find work that was recorded wrong, rather than work that went wrong.

WIP Aging — pieces sitting at an operation and how long they've been idle, oldest first. It nets what arrived at each operation against what left, so it surfaces work that was pushed in but never pushed on — the operator who forgot the second half of a handoff.

Consumption Pending — submitted ledger entries whose stock consumption never posted. When material isn't there (or the source warehouse is wrong), the consumption Stock Entry is left as a draft and the operation is recorded without the material ever being drawn. Stock and material cost are understated until someone finishes it. This report is how those stop piling up quietly.

Operation Over Transfers — ledger entries that moved more quantity out of an operation than had arrived there, driving its running balance negative. These are the entries behind phantom and negative stock.

Batch Card Quantity Check — cards whose quantities don't reconcile with their batch.

Production Batch Inspection Gaps — batches that moved on without the inspection they were supposed to have.

Stock Movement Timeline — every movement against a batch in order, for when you need to reconstruct what happened.

External Unit Balance — what each external unit is currently holding, netted from dispatches and recoveries.

Machines

Machine Maintenance — breakdowns, MTTR, downtime and availability per machine. Lives in the Maintenance workspace.

Building your own reports

Any list view in Production can be turned into a saved report through Frappe's Report Builder. Common ones factories build for themselves:

  • A "Batches completed this week by Brand" report for brand reporting.
  • A "Defects by operation this month" report for quality reviews.
  • A "Cuts per table per week" report for cutting-room capacity.

If you find yourself filtering the same list view the same way every Monday, save it as a Report. Future you will thank present you.

WhatsApp