Guides·8 min read

Stock Ledger Traceability for Certified Materials: How It Works

Quick Answer

Quick Answer

Stock ledger traceability for certified materials means every stock entry carries a heat or lot number linked to its approved certificate, and every movement — receipt, cut, issue, transfer, return — is recorded against that heat-identified lot. This enables instant retrieval of the full material history from stock to component to finished product.

Material traceability is not just about knowing what grade is in the warehouse. It is about knowing which specific heat of that grade is in which location, what its certificate says, what work orders have consumed it, and what finished products it ended up in.

That level of granularity requires a stock ledger — an inventory record that tracks material at the heat-lot level rather than just by grade and quantity.


Why Standard Inventory Management Is Not Enough

Most ERP and inventory systems track material by item number, grade, and quantity. They answer the question: "How many tons of A516 Gr. 70 plate do we have on hand?"

That is useful for procurement and scheduling. It is not sufficient for quality traceability, which requires answering: "The plate in Work Order 4721 — what was its heat number, and can I pull the certificate?"

To answer that question, your stock ledger must track material at the heat-lot level, link each lot to its certificate, and preserve that linkage through every transaction.


The Building Blocks of a Traceable Stock Ledger

Heat-Level Lot Identification

Every stock entry for certified material should be identified by:

  • Material specification and grade (e.g., ASTM A516 Gr. 70)
  • Product form and dimensions (e.g., 25mm plate, 2438 × 6096mm)
  • Heat number — the primary traceability identifier, assigned by the producing mill
  • Certificate reference — the MTC or CoC that covers this heat
  • Quantity and unit (e.g., 12 pieces, 4.8 tonnes)
  • Stock location (warehouse bay, rack, slab yard zone)
  • Status (on hold, available, issued, quarantine)

A stock entry without a heat number is untraceable by definition. Any system that creates stock entries without capturing heat numbers is incompatible with traceable quality management.

Certificate Linkage

The certificate record — ideally stored in a document and data system rather than a simple file folder — must be linked to the stock entry at receipt. This linkage should be:

  • Bidirectional: from the certificate you can see all stock lots it covers; from the stock lot you can retrieve the certificate
  • Persistent: the link survives all stock movements, transfers, and partial withdrawals
  • Searchable: you can query by heat number, certificate number, material spec, or supplier

Transaction History

Every movement in the stock ledger creates a timestamped record:

Transaction TypeWhat It Records
ReceiptQuantity received, heat number, certificate linked, inspector who accepted
Cut / SplitParent lot, quantity removed, resulting child lot(s) with same heat reference
Issue to work orderWork order number, quantity issued, date, issuer identity
Return to stockWork order reference, condition on return, re-inspection if required
TransferFrom/to locations, authorizing person
Scrap / DisposalReason, authorizing person, certificate disposition
Hold / ReleaseReason for hold, resolution, approving quality role

This transaction history is the audit trail that enables full forward and reverse traceability.


Forward and Reverse Traceability

A well-designed stock ledger supports traceability in both directions:

Forward traceability answers: "Where did this heat of material end up?"

  • Start with the heat number or certificate
  • Trace through stock issues to work orders
  • Follow work orders to assembly records or finished product serial numbers
  • Determine which shipments or installations contain material from this heat

This is critical when a mill issues a material advisory or when a defect is found in a sample from a heat — you need to know if other pieces from the same heat are in production or in the field.

Reverse traceability answers: "What material was used in this component or product?"

  • Start with a finished product serial number or work order
  • Identify the stock lots issued to that work order
  • Retrieve the heat numbers and certificates for those lots

This is what a customer or auditor wants when they ask for the material certification package for a specific vessel, spool, or assembly.


Traceability Through Material Cuts

The most common traceability break point in fabrication shops occurs when material is cut from a larger piece. The plate that was received as a full sheet gets cut into nesting parts. The pipe length gets cut into spools. The bar gets parted into turned components.

In each case, the remaining material — the remnant — must retain the parent heat number. If the remnant goes back to stock without a heat marking or with a blank stock entry, it becomes untraced material.

Maintaining cut traceability requires:

  1. The cut operation is recorded as a stock transaction, not just a physical action
  2. The resulting pieces (parts issued to the work order + remnant returned to stock) are both assigned the parent heat number
  3. Physical markings are transferred to remnants before the parent identification tag is removed
  4. The system creates child stock entries linked to the parent heat and certificate

Integration With the Certificate Management System

Stock ledger traceability and certificate management are most effective when they operate as a single integrated system, not two separate tools with manual bridges between them.

When a certificate is approved in the quality system, it should automatically trigger the creation or update of the corresponding stock entry. When material is issued from the stock ledger, the certificate link should travel with the issuance record. When a finished product is assembled, the quality package should be automatically populated from the certificate records linked to the consumed lots.

TestCert is built on this integrated model — certificate approval, stock linkage, and work order traceability are connected by design, not patched together with spreadsheets.


What is the difference between a heat number and a lot number?

A heat number is assigned by the steelmaker or producing mill to a specific melt of metal — it identifies the precise batch of material produced in one furnace or casting run. A lot number is a broader identifier used by service centers, distributors, or fabricators to group material for their own tracking purposes. For traceability to base standard requirements, the heat number is the authoritative identifier. Lot numbers are useful for operational tracking but must be linked to underlying heat numbers to be meaningful in a quality context.

How should we handle stock traceability for mixed heats in a rack or bin?

Mixed heats in the same physical location are a traceability risk. Best practice is to segregate certified material by heat number — different heats in different locations, or clearly marked individual pieces. When physical co-location is unavoidable (e.g., small remnants in a common bin), each piece must be individually marked with its heat number and the bin must not be treated as a single stock entry. Avoid any practice that pools pieces from different heats into a single inventory record.

How far does traceability need to go? Does it need to follow the material all the way to the customer?

Traceability requirements depend on the end-use standard and customer specification. For pressure vessels (ASME), structural construction (AISC), and most energy sector applications, traceability must extend from the producing mill through fabrication to the finished product, with records retained for the required period. Some customers extend this requirement to installed equipment — the fabricator must be able to provide material records for any component, even years after delivery.

What should we do if a piece of material is found in stock with no heat marking?

Unidentified material must be placed on hold and subjected to positive material identification (PMI) — typically X-ray fluorescence (XRF) analysis, optical emission spectrometry, or hardness testing, depending on the information needed. If the material can be positively identified to a specific grade and the original heat can be determined, a documented disposition can allow it to be returned to stock. If positive identification is not possible, the material must be segregated from certified stock and not used for applications requiring traceable certification.

Can we use bar codes or QR codes for stock traceability?

Yes — bar codes or QR codes are an effective way to link physical material to digital records without manual search. The code on the material tag encodes the heat number or a stock record identifier; scanning it retrieves the certificate, transaction history, and current status. For this to work reliably, the code must survive the physical environment (heat, moisture, handling), and every stock transaction must use the scan rather than manual entry to maintain data integrity.

Ready to automate your certificate workflow?

Try TestCert free

Related Guides

Related pages