Building a traceable chain from raw stock to finished weld isn't a documentation exercise — it's a material control process. The documentation follows the material. If the material control process has gaps, no documentation system can fix them.
The framework below reflects what actually works in fabrication shops that pass Code stamp audits and stringent third-party inspections consistently. It's not theoretical. Each step is operational.
Step 1: Incoming Material Receipt
Receive the cert with the material. Match the heat number on the mill cert to the heat number stamped or stenciled on the material. If they don't match, the material goes to hold — not to stock.
Record the following in your receiving record: heat number, material grade, specification (e.g., ASTM A516 Gr. 70), cert reference number, and the location where the material is staged. This is the anchor record. Every downstream document will reference this heat number.
Tag the material at receiving. The heat number tag goes on the material when it's received — not when it's needed for a job. Tags that are added later, after the fact, are a source of error.
Step 2: Stock and Remnant Management
When material is cut, the remnant inherits the original heat number. Tag the remnant immediately — before it moves to the remnant rack. A remnant without a heat number tag cannot go back to open stock under any circumstances. It goes to a designated quarantine location pending positive material identification.
Periodic cycle counts should verify that heat tags haven't separated from the physical material. This is especially important in racks where restacking dislodges paper or adhesive tags.
Track remnants by location and heat number. When a remnant is pulled for a job, the same receiving record linkage applies as for full-length material.
Step 3: Material Release to the Job
This is the step where most fabrication shops lose the traceability thread. Material is released by size and grade — "grab me a piece of A516-70, one inch, about four feet." No heat number is recorded.
Release material by heat number. When stock is pulled for a job, the release record must capture: job number, BOM line item reference, heat number, and cert reference. If more than one heat is available, the choice of which heat to use must be recorded — not just the fact that material was pulled.
If multiple heats are used on a single joint (for example, a nozzle and the shell plate at the same location), both heat numbers are recorded on the release record.
Step 4: Weld Map Linkage
The weld map is where material traceability and weld process traceability converge. A complete weld map entry for each joint must include:
- Base material heat number(s) — from the release record
- Filler material lot number — electrode or wire, tracked by lot, not by brand
- WPS/PQR number — the qualified welding procedure for that joint configuration
Filler material is often the weakest link. It's ordered in bulk, stored in a rod oven or wire cabinet, and used without recording which lot went to which joint. If a filler lot later shows a quality issue, the scope of investigation becomes every weld on every job that used that lot — because there's no joint-level record.
The fix is simple: issue filler material to specific jobs by lot number, and record the lot number on the traveler or weld map at the time of welding.
Step 5: Final Inspection Package Assembly
The final cert package is assembled from the records created at each prior step. It should not require any reconstruction. If every step above was executed correctly, the package is a retrieval exercise, not an investigation.
A complete package for a pressure vessel or structural assembly includes:
- MTCs for every heat used on the job
- Weld map with heat number references for base and filler material at each joint
- WPS/PQR documentation for each weld procedure used
- Welder qualification records
- NDE reports referencing joint numbers
- PWHT records where applicable
Verify the package against the BOM before final inspection. Every BOM line item should have a corresponding heat number and MTC in the package. Any gap identified at this stage is a gap that would have failed the audit.
Why Spreadsheets Break This Process
Spreadsheets can capture each of these records individually. What they can't do is maintain the linkages automatically. When a heat number changes, when a remnant is used across multiple jobs, when a filler lot runs out mid-job — each of those events requires a manual update to multiple spreadsheet cells across multiple tabs.
Over time, the linkages drift. Records are updated in one place and not another. The audit package looks complete until someone traces a specific joint back to its MTC and finds the chain has a broken link.
A structured system — whether purpose-built or configured from your existing ERP — enforces the linkage rules at the point of entry, not at the point of audit.