Work order BOM — lots, design rows, trims & accessories. Matches the production BOM export format. Data auto-saves in this browser.
Every design row below has its own Ratio Working panel: plan how to cut its fabric roll (a known order plus meters-based fill channels), reconciled against that row's own MTRS. The result feeds that row's SIZE quantities directly as you type.
Every lot across every saved work order, in one place — factory, stage, dates and follow-up notes. Flags lots that are overdue or haven't been touched in a while.
| Work Order | Lot No | Type | Qty | Cutting Rpt | Recd Early | Received | Factory | Washing | Embroidery | Printing | Dispatched | Expected | Receivable | Status | QC | Kavya | Chandru | Done |
|---|
How much is sitting with each factory, and in what. The Production Tracker follows a single lot; this totals them up. Click a factory to see its lots, and a work order name to open it.
What the QC team has recorded on a factory visit — the checklist and the challans they collected. Read-only here: it is collected in the QC app and published across, so nothing on this tab can be edited or lost from this side.
Work orders that are on the production status sheet but have never been entered here, and whose status column is still blank. Reference only — nothing on this tab is a lot: it is not tracked, not counted anywhere else in the tool, and not editable. Read from the sheet on 6 Sep 2026.
Stock on hand for trims and accessories, checked against what every current work order needs. Import a fresh stock export any time — On Hand refreshes from the file, Required recalculates live from your lots. Needs a .xlsx file (not the old .xls format — in Excel, use File > Save As > .xlsx first).
| Category | Code | On Hand | Required | Balance |
|---|