Material Certificate Reconciler - fictional demo

25 checked = 19 established from evidence + 6 left for human judgment · summary

REC-1005

CONFLICTING PO-77435 · Northbay Steel Oy

Heat number does not match

Received heat

Receipt record

Heat-4890-W

versus pos 9 0 / 9
pos 11 W / V

Supplier certificate

Heat-4899-V

Exportreceived_lots.csv

RowREC-1005

Recorded asReceived heat

Value readHeat-4890-W

DocumentMTC-NB-4899-V-3.1.pdf

Page1

Printed asHeat No.

Value readHeat-4899-V

In common

Purchase order PO-77435

Next step

Verify the conflicting heat reference with the supplier.

Internal receipt record

Export received_lots.csv

Row REC-1005

Recorded as Received heat

Value read Heat-4890-W

Record reference	REC-1005
PO number	PO-77435
Receipt number	RCP-900005
Supplier	SUP-NORTHBAY
Received heat	Heat-4890-W
Received lot	LOT-4890-01
Material	S355J2+N · Plate 20mm
Certificate type required	3.1

Show the original export row

lot_ref,po_number,receipt_number,supplier_id,heat_number,lot_number,required_heat_numbers,material_grade,material_designation,dimensions,quantity,expected_cert_type,note REC-1005,PO-77435,RCP-900005,SUP-NORTHBAY,Heat-4890-W,LOT-4890-01,Heat-4890-W,S355J2+N,Plate 20mm,20mm x 1500mm x 6000mm,20 t,3.1,Wrong-heat exception - the only certificate quoting this PO names a different heat and lot.

The line this record was read from, in received_lots.csv. Open the whole export →

Supplier certificate

Document MTC-NB-4899-V-3.1.pdf

Page 1

Printed as Heat No.

Value read Heat-4899-V

Open the PDF →

Technical details

Run	3fe7e4f13e02cf7c
Rule	anchored_certificate_conflicts
Exception class	certificate_heat_does_not_match_received_lot
Export column read	heat_number
Reason recorded by the run	MTC-NB-4899-V-3.1.pdf is anchored to this record, but its heat 'Heat-4899-V' differs from the received heat 'Heat-4890-W'.

Checks for heat Heat-4890-W · 1 certificate(s) considered

MTC-NB-4899-V-3.1.pdf is anchored to this record, but its heat 'Heat-4899-V' differs from the received heat 'Heat-4890-W'.

Certificate

Anchored by

Checks

MTC-NB-4899-V-3.1.pdf

Order reference

Heat	CONFLICT	received Heat-4890-W / certificate Heat-4899-V source: MTC-NB-4899-V-3.1.pdf page 1 [extract_northbay_steel]
Lot	CONFLICT	received LOT-4890-01 / certificate LOT-4899-01 source: MTC-NB-4899-V-3.1.pdf page 1 [extract_northbay_steel]
Order reference	MATCH	received PO-77435 / certificate PO-77435 source: MTC-NB-4899-V-3.1.pdf page 1 [extract_northbay_steel]
Certificate reference	MATCH	received - / certificate MTC-NB-4899-V-3.1 source: MTC-NB-4899-V-3.1.pdf page 1 [extract_northbay_steel]
Certificate type	MATCH	received 3.1 / certificate 3.1 source: MTC-NB-4899-V-3.1.pdf page 1 [extract_northbay_steel]
Supplier informational only	MATCH	received SUP-NORTHBAY (Northbay Steel Oy) / certificate Northbay Steel Oy source: MTC-NB-4899-V-3.1.pdf page 1 [extract_northbay_steel]

Every value the rules read

MTC-NB-4899-V-3.1.pdf - page 1 - heat_number = Heat-4899-V   [heat_identity: CONFLICT, adapter extract_northbay_steel]
MTC-NB-4899-V-3.1.pdf - page 1 - lot_number = LOT-4899-01   [lot_identity: CONFLICT, adapter extract_northbay_steel]
MTC-NB-4899-V-3.1.pdf - page 1 - po_number = PO-77435   [transaction_reference: MATCH, adapter extract_northbay_steel]
MTC-NB-4899-V-3.1.pdf - page 1 - certificate_number = MTC-NB-4899-V-3.1   [certificate_reference: MATCH, adapter extract_northbay_steel]
MTC-NB-4899-V-3.1.pdf - page 1 - certificate_type = 3.1   [certificate_type: MATCH, adapter extract_northbay_steel]
MTC-NB-4899-V-3.1.pdf - page 1 - supplier = Northbay Steel Oy   [supplier_identity: MATCH, adapter extract_northbay_steel]

Review item 1 of 6

Next review item: REC-1008 →