Lab trials

Trial consumption is NOT stock-tracked (founder decision): materials used in a trial are noted with their quantities in the R&D request's progress log — no reservation, no deduction, no Committed netting. Trial amounts are too small to matter; the shared-pool reservation concept is dropped. Costs shown are estimates off the live moving-average, for costing reference only.

6 trials

Trial #	Formulation	Ver	Batch size	Trial materials (qty from log)	Est. cost	Materials used (log only)	Result	By	Date
					MYR

Project Gaia — static mockup in Filament v3 idiom. No backend. Material names/costs reference the real raw-material pool; trials are illustrative.

Lab trial

TRL-26-016

Not saved

Trial #

Series TRL-{yy}-{seq} — next after TRL-26-015.

Formulation / version *

FK formulation_versions.id — lines below prefill from the formulation, editable per trial.

Linked R&D request

Trial materials + result are ALSO written to the request progress log (type Trial, trial # auto-increments).

Batch size

Units locked to the admin units list — staff never type units; conversions hard-coded.

Date

DatePicker — snapshot, defaults to today.

Result

Trial materials

Not stock-tracked (founder decision): no lot pick, no reservation, no deduction — quantities are logged to the R&D request progress log only. Costs are estimates off the live moving-average.

#	Material	Qty	UoM admin units	Avg cost MYR / uom	Est. line cost
	free text — not in item master				MYR

Est. total: MYR

Notes

On create: writes lab_trials + lab_trial_lines and appends a Trial entry to the linked request log. No stock movement.

Lab trials — field manifest

Field	Filament component	Type	Source	FK target
Trial #	TextColumn (series TRL-{yy}-{seq})	string	stored: lab_trials.code	—
Formulation / Ver	TextColumn::url()	FK	stored: lab_trials.formulation_version_id	formulation_versions.id
Batch size	TextColumn	qty + uom	stored: lab_trials.batch_qty	—
Trial materials	Repeater lines → derived summary	relation	stored: lab_trial_lines (variant_id nullable, qty, uom) — quantity notes only; no batch pick, no stock movement (founder decision)	variants (nullable)
Est. cost	TextColumn::numeric()	money	derived: Σ qty × current moving-average — an estimate for costing reference; nothing is posted or expensed	—
Materials used (log only)	TextColumn chip "Logged"	static	quantities recorded in the linked R&D request's progress log — trial consumption is NOT stock-tracked; the shared-pool reservation concept (Reserved / Issued) is dropped (founder decision)	rnd_progress_log
Result	TextColumn badge + notes on detail	enum + text	stored: lab_trials.result, .notes	—
Create trial (slide-over)	CreateAction::slideOver()	action	stored: lab_trials (code, formulation_version_id, rnd_request_id nullable, batch_qty, uom, trial_date, by_user_id, result enum, scheduled_date, notes)	formulation_versions.id · rnd_requests.id · users.id
Trial line (repeater)	Repeater rows in the slide-over	relation	stored: lab_trial_lines (variant_id nullable, free_text, qty, uom) — qty in admin-locked units, never typed; no batch, no stock movement	variants (nullable) · units (admin-locked)

Engine notes

Trial = a lab event under an R&D request (rnd-requests.html): mix, taste, record the result. Materials and quantities are written into the request's progress log — the movement ledger is untouched.
Founder decision: trial amounts are too small to matter for stock. No reservation, no Committed netting, no rnd_issue movement — Planning and Buy simply ignore R&D.
Est. cost rides the live moving-average so the costing section inside the request's In-development stage has a defensible number without touching stock.