In this guide 6 sections
Store each result once. Link chemistry, mechanical tests and NDT reports by heat number, then let a template per customer arrange them in the format asked for, so nobody retypes a figure. A named signatory approves the finished certificate last. Nothing is typed twice.
Where retyping creeps in
A certificate pulls from several rooms. That is the problem. Chemistry comes from the spectrometer, tensile and Charpy impact figures from the lab, Brinell hardness from the shop floor, and the radiography report from an outside house.
Someone then types the numbers into the customer’s Word or Excel form, and each figure risks a transposed digit that the auditor will find against the lab sheet.
The fix is not more careful typing but one stored result per test, read by every certificate for every customer, whatever layout each of them demands.
Store results against the heat or lot
Pick the unit the customer certifies by. Some want one certificate per heat, while others want one per lot or per purchase order line, so the record must carry both the heat and the lot.
Chemistry attaches to the heat. Mechanical results attach to the test bar or coupon, which in turn points back to the heat and the heat treatment batch. NDT reports attach to the lot, each carrying its method, the extent examined, the acceptance standard and the inspector who signed it.
Keep the original files. Spectrometer exports, tensile machine printouts and report PDFs stay attached to the numbers they produced, so the certificate can cite its source and an auditor can open it.
- Chemistry by element, tied to heat
- Test bar ID with tensile, yield, elongation and impact
- Heat treatment batch with chart reference
- NDT method, extent and result per lot
Build one template per customer
Customers all differ here. One wants a column for each element, another wants the specification clause and a statement of conformity, and a third asks for an EN 10204 type 3.1 layout.
Each template maps source fields to boxes, and the order supplies the grade and its limits so the certificate shows the requirement beside the result. A value outside limits blocks the certificate.
The signature block, the date and a certificate number from a running sequence come next, and the approved document locks as a PDF so no later edit goes unrecorded.
Check before release
A short review catches most errors. Does the heat on the certificate match the packing list, do the castings listed belong to that heat, and is every test the order requires actually present?
Software runs these checks itself and lists whatever is missing, including a Charpy set that was never logged or a hardness reading without a heat. A human then signs. Every number came from the lab record.
Keep a revision trail and never overwrite. If a certificate is reissued after a retest, the superseded copy stays visible beside the new one, marked with the reason, the date and the approver.
- Heat and lot match the packing list
- All tests required by the order are present
- Values sit within the stated grade limits
- Signatory and date recorded
Start with your busiest customer
Pick your busiest customer. Take three recent certificates and list every field with its source, because that list is both the template and the data you must capture.
Run the next real order through it. Compare the printed result with what you would have typed, and keep that comparison for a week before you switch other customers over.
One good template pays back quickly.
Certificate field source map
Every field on your busiest customer’s certificate gets a line on this single sheet: heat number, grade, each chemistry element, tensile, yield, elongation, impact, hardness and NDT result. Columns show where each value originates, who enters it, which file is attached, what limit it is checked against and who approved the entry.
Open a blank worksheet to printQuestions owners ask
Can one record produce certificates in different formats?
Yes. The data never changes, and each customer gets a template that arranges it, so adding a new customer means adding one template rather than re-entering any results.
What about results from an outside lab?
Attach the outside lab’s report file and enter its values once against the right heat or test bar, so the certificate cites that report as its source. Nothing is rekeyed.
Who should sign the certificate?
Whoever your customer contract or quality system names, which is usually the quality manager or an authorised inspector, and the signing date is stored on the certificate record. Software prepares the document. A person approves it.
What if a value is out of limits?
The system holds the certificate and shows which value failed, such as a low yield strength, a high carbon content or an impact result under the specified minimum. The team decides on retest, rework or rejection. Nothing leaves until then.