Manufacturing orders

Done at + Manufacturing order

Open Done 2

	Order #	Customer	Product	Category	Plan/Act. qty	Plan/Act time	Materials	Sub-assemblies	Operations	Total	Done date	Production
		—			pcs	… / …	MYR	MYR	MYR	MYR		Done
					212,000 / 212,000 pcs	… / …	84,766.75 MYR	0 MYR	0 MYR	84,766.75 MYR	Sum summarizers

Showing 1–2 of 2 done manufacturing orders (Done at: last 7 days)

Per page

Project Gaia — static mockup in Filament v3 table idiom. No backend. Sample data: Katana tenant snapshot 2026-04-12, location 11, Balakong Jaya.

Manufacturing orders (Done) — field manifest

Field	Filament component	Type	Source	FK target
Checkbox / ⓘ	automatic with BulkActions (export / print / delete)	ui	UI-only bulk select; header ⓘ tooltip slot dropped	—
Order #	TextColumn::searchable(isIndividual: true)->url()	string	stored: MO number '{prefix}-{number} / {sequence}'	manufacturing_orders.id
Customer	TextColumn::placeholder('—')	string, nullable	stored: FK customer via linked sales order; blank for make-to-stock MOs (both captured rows empty)	contacts.id
Product	TextColumn::searchable(isIndividual: true)	string	derived: product name + ' / ' + variant suffix	variants.id
Category	TextColumn (badge-style) + SelectFilter	string	stored: item master product category, read-only here	categories.id
Planned / Actual qty	TextColumn::state("{planned} / {actual}")->summarize(Sum)	qty pair + UoM	planned stored on MO; actual written at completion (actual = planned in both sample rows)	—
Planned / Actual time	TextColumn::placeholder('… / …')	duration pair, nullable	derived: Σ planned vs tracked operation durations; '… / …' when no operation time exists	—
Materials cost	TextColumn::numeric()->summarize(Sum)	money MYR	derived: Σ ingredient qty × moving-average cost at consumption (one MO shows 0.00 legitimately)	—
Sub-assemblies cost	TextColumn::numeric()->summarize(Sum)	money MYR	derived: cost of consumed manufactured-ingredient items, split from raw materials	—
Operations cost	TextColumn::numeric()->summarize(Sum)	money MYR	derived: Σ operation costs (time × rate or fixed) from MO operation rows	—
Total cost	TextColumn::numeric()->summarize(Sum)	money MYR	derived: Materials + Sub-assemblies + Operations (84766.75 + 0 + 0 checks out)	—
Done date	TextColumn::date()->sortable() (default sort desc)	date	stored: timestamp set when MO marked Done; drives the 'Done at' range filter	—
Production	SelectColumn (inline-editable badge, green)	enum	stored: MO status; reopening moves the MO back to the Open tab	—

Engine notes

Total cost = Materials + Sub-assemblies + Operations per row (84766.75 = 84766.75 + 0 + 0).
Totals over the filtered set: 212000 / 212000 pcs (= 12000 + 200000), … / … time, 84766.75 MYR materials, 0 MYR sub-assemblies, 0 MYR operations, 84766.75 MYR total (Katana pins this on top; Filament uses tfoot summarizers).
Row count '2 orders' reflects the active Done-at range + location filters.
Planned vs Actual pattern on both qty and time: MO stores planned values, completion writes actuals.
Time shows '… / …' placeholder when no operation time data exists — the totals row inherits the same placeholder.
Costs are location- and consumption-time based: materials cost captured at completion (moving average of consumed ingredients), so a done MO can legitimately show 0.00 MYR.
List is scoped to one inventory location — MOs live per location.
Done tab has its own toolbar variant: 'Done at' range picker replaces the Open tab's scheduling controls.