Quality Hold & Material Review Board

The problem this kills

A lot fails inspection, someone slaps a "HOLD" tag on it, and then... it disappears into the system. Maybe it's a row highlighted yellow in a spreadsheet. Maybe it's a sticky note on a pallet. Either way, three things go wrong: held material sits for weeks while nobody decides what to do with it, the Material Review Board can't see the full picture in one place, and - the nightmare - someone picks and ships held stock because nothing actually blocked it.

You end up chasing dispositions over email, rediscovering "lost" holds during an audit, and explaining to a customer why nonconforming material went out the door.

This tool ends that. Every held lot lives on one board with its age in plain view, the MRB reviews and signs off on each disposition, and nothing changes stock status until a person approves it.

What you'll build

An internal web app - login-protected, just for your team - that does the full hold lifecycle:

• Place a lot on hold: item, lot, quantity, location, hold reason, and the linked inspection or nonconformance reference. Enter it by hand or import a batch.
• See the MRB board: every open hold, sorted by how long it's been waiting, with overdue holds flagged.
• Block the stock: held lots are clearly marked "do not pick / do not ship" so the floor can't use them by mistake.
• Run the review: the Material Review Board picks a disposition - use-as-is, rework, return to supplier, or scrap - and a designated approver signs off.
• Record the action: the approved disposition is logged with who, what, and when, and the stock status flips only then.
• Stay on top of aging: overdue holds trigger an email so material never rots in quarantine.
• Export: a clean hold log and a stock-status change file in the exact columns your ERP or stockroom system expects.

What's inside the Implementation Plan

The plan is a single file you paste into an AI coding agent (Claude Code), and it builds the tool with you step by step.

The best part: it opens by interviewing you about your business. Before it writes a line of code, the plan has the agent ask how your holds work today - your item and lot naming, your hold reasons, who sits on your MRB, your approval rules, your volumes, and your weird edge cases (partial lots, split dispositions, supplier returns). Then it reads back a short tailored spec, you give a thumbs-up, and it builds a tool shaped to your process - not a generic template.

Inside you'll find: the discovery interview, a clear definition of done, the exact accounts to set up, the data model tuned to your answers, and a sequence of copy-paste prompts that build each piece - the hold form, the aging board, the MRB approval gate, the audit trail, the overdue email alerts, and the CSV import/export.

The governance it includes (this is the point)

This isn't a toy. The plan bakes in the controls a real quality system needs:

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own holds.
• A complete audit trail - who placed the hold, who approved the disposition, and exactly when.
• A hard human-in-the-loop approval gate - the tool drafts the disposition, the MRB reviews, and only an approver's sign-off changes stock status or releases material.
• Duplicate guards so the same lot-and-hold can't be entered or processed twice (dedupe key = lot + hold instance).

Who it's for

Quality engineers, Material Review Board members, and stockroom staff who are tired of held material slipping through the cracks - and who want a real, auditable hold board without waiting on IT or buying another module.

You've got this - paste the first prompt and let the agent interview you.