Purchase orders

+ Draft order + Purchase order

Open 23 Draft 2 Done 521

	Created date	Order #	Supplier	Total order value	Received date	Billing status
				MYR
				3,600,780.63 MYR	Total order value (Sum summarizer, all 521 done orders)

Showing 1–18 of 521 (sample rows from Katana snapshot, sorted by Received date desc)

Per page

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

Purchase orders (Done) — field manifest

Field	Filament component	Type	Source	FK target
(checkbox)	Table selection + DeleteBulkAction	selection	— (bulk delete of selected POs)	—
Created date	TextColumn::date()->sortable() + Filter (date range)	date	stored: purchase_orders.created_date	—
Order #	TextColumn::searchable(isIndividual)->url()	string	stored: purchase_orders.order_no — NOT unique (PO-555 appears twice in this sample), PK is internal id	—
Supplier	TextColumn::searchable(isIndividual)	string (display name)	stored: purchase_orders.supplier_id	suppliers.id
Total order value	TextColumn::numeric()->summarize(Sum)	money MYR	derived: Σ po_lines.qty × unit_price; 0 MYR done orders exist and still count in the total	po_lines
Received date	TextColumn::date()->sortable() — defaultSort desc + Filter (date range)	date	stored at receipt (last/final receipt date); drives Done tab membership	po_line_receipts
Billing status	TextColumn::badge() + SelectFilter	enum: Billed / Billed (n) / Not billed	derived from bill linkage, independent of receipt — a Done PO can still be Not billed	supplier_bills
Expected arrival	— (dropped: not shown on the Done tab — replaced by Received date)	date	stored: purchase_orders.expected_arrival_date	—
Delivery	— (dropped: every Done row is fully received, column is redundant here)	enum	derived: received vs ordered qty	—
Location scope	SelectFilter (header "All locations" dropdown)	FK filter	stored: purchase_orders.location_id	locations.id
Draft tab	— (dropped: Draft view not captured)	lifecycle tab	Open/Draft/Done partition POs by lifecycle state	—

Engine notes

Totals footer: Total: 3600780.63 MYR under Total order value — sums ALL 521 filtered Done orders, not just the visible page.
Done tab = purchase orders fully received; each row carries a Received date, so tab membership is driven by receipt state, not a manually set status.
Billing status is derived from bill linkage, independent of receipt: an order can be Done (received) yet "Not billed" (e.g. PO-559, PO-548); "Billed (n)" shows multiple bills against one PO.
Default sort is Received date descending (sort arrow rendered in that header).
0 MYR done orders exist (all NatusVincere Marketing Sdn Bhd rows) — zero-value POs are legal and still count in the total.
Order # is not enforced unique (duplicate "PO-555"), so the DB key must be an internal id, with order_no as editable text.
Money rendered as amount + de-emphasized currency code (MYR = factory default currency) — store amount + currency code.