Material Certificate Reconciler - fictional demo

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

REC-1021

CONFLICTING PO-77451 · Kvarnbacken Verkstad AB

Two certificates carry the same reference

One reference, two documents

CFR-KVR-3316-M-3.1

printed as “Certifikatnr” on page 1

CFR-KVR-3316-M-3.1-a.pdf
CFR-KVR-3316-M-3.1-b.pdf

In common

Heat number Heat-3316-M · Lot number LOT-3316-01 · Purchase order PO-77451

Next step

Request a corrected certificate: two documents carry the same certificate reference.

Internal receipt record

Record reference	REC-1021
PO number	PO-77451
Receipt number	RCP-900021
Supplier	SUP-KVARNBACKEN
Received heat	Heat-3316-M
Received lot	LOT-3316-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-1021,PO-77451,RCP-900021,SUP-KVARNBACKEN,Heat-3316-M,LOT-3316-01,Heat-3316-M,S355J2+N,Plate 20mm,20mm x 1200mm x 4000mm,9 t,3.1,Duplicate certificate reference - two files identify this heat and lot under the same certificate reference.

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

Supplier certificate

Document CFR-KVR-3316-M-3.1-a.pdf

Page 1

Printed as Certifikatnr

Value read CFR-KVR-3316-M-3.1

Open the PDF →

Technical details

Run	3fe7e4f13e02cf7c
Rule	anchored_certificate_conflicts
Exception class	duplicate_certificate_reference
Reason recorded by the run	CFR-KVR-3316-M-3.1-a.pdf, CFR-KVR-3316-M-3.1-b.pdf carry the same certificate reference CFR-KVR-3316-M-3.1, so no single document can be assigned to this record.

Checks for heat Heat-3316-M · 2 certificate(s) considered

CFR-KVR-3316-M-3.1-a.pdf, CFR-KVR-3316-M-3.1-b.pdf carry the same certificate reference CFR-KVR-3316-M-3.1, so no single document can be assigned to this record.

Certificate

Anchored by

Checks

CFR-KVR-3316-M-3.1-a.pdf

Heat, Lot, Order reference

Heat	MATCH	received Heat-3316-M / certificate Heat-3316-M source: CFR-KVR-3316-M-3.1-a.pdf page 1 [extract_kvarnbacken_verkstad]
Lot	MATCH	received LOT-3316-01 / certificate LOT-3316-01 source: CFR-KVR-3316-M-3.1-a.pdf page 1 [extract_kvarnbacken_verkstad]
Order reference	MATCH	received PO-77451 / certificate PO-77451 source: CFR-KVR-3316-M-3.1-a.pdf page 1 [extract_kvarnbacken_verkstad]
Certificate reference	CONFLICT	received - / certificate CFR-KVR-3316-M-3.1 source: CFR-KVR-3316-M-3.1-a.pdf page 1 [extract_kvarnbacken_verkstad]
Certificate type	MATCH	received 3.1 / certificate 3.1 source: CFR-KVR-3316-M-3.1-a.pdf page 1 [extract_kvarnbacken_verkstad]
Supplier informational only	MATCH	received SUP-KVARNBACKEN (Kvarnbacken Verkstad AB) / certificate Kvarnbacken Verkstad AB source: CFR-KVR-3316-M-3.1-a.pdf page 1 [extract_kvarnbacken_verkstad]

CFR-KVR-3316-M-3.1-b.pdf

Heat, Lot, Order reference

Heat	MATCH	received Heat-3316-M / certificate Heat-3316-M source: CFR-KVR-3316-M-3.1-b.pdf page 1 [extract_kvarnbacken_verkstad]
Lot	MATCH	received LOT-3316-01 / certificate LOT-3316-01 source: CFR-KVR-3316-M-3.1-b.pdf page 1 [extract_kvarnbacken_verkstad]
Order reference	MATCH	received PO-77451 / certificate PO-77451 source: CFR-KVR-3316-M-3.1-b.pdf page 1 [extract_kvarnbacken_verkstad]
Certificate reference	CONFLICT	received - / certificate CFR-KVR-3316-M-3.1 source: CFR-KVR-3316-M-3.1-b.pdf page 1 [extract_kvarnbacken_verkstad]
Certificate type	MATCH	received 3.1 / certificate 3.1 source: CFR-KVR-3316-M-3.1-b.pdf page 1 [extract_kvarnbacken_verkstad]
Supplier informational only	MATCH	received SUP-KVARNBACKEN (Kvarnbacken Verkstad AB) / certificate Kvarnbacken Verkstad AB source: CFR-KVR-3316-M-3.1-b.pdf page 1 [extract_kvarnbacken_verkstad]

Every value the rules read

CFR-KVR-3316-M-3.1-a.pdf - page 1 - heat_number = Heat-3316-M   [heat_identity: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-a.pdf - page 1 - lot_number = LOT-3316-01   [lot_identity: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-a.pdf - page 1 - po_number = PO-77451   [transaction_reference: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-a.pdf - page 1 - certificate_number = CFR-KVR-3316-M-3.1   [certificate_reference: CONFLICT, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-a.pdf - page 1 - certificate_type = 3.1   [certificate_type: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-a.pdf - page 1 - supplier = Kvarnbacken Verkstad AB   [supplier_identity: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-b.pdf - page 1 - heat_number = Heat-3316-M   [heat_identity: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-b.pdf - page 1 - lot_number = LOT-3316-01   [lot_identity: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-b.pdf - page 1 - po_number = PO-77451   [transaction_reference: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-b.pdf - page 1 - certificate_number = CFR-KVR-3316-M-3.1   [certificate_reference: CONFLICT, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-b.pdf - page 1 - certificate_type = 3.1   [certificate_type: MATCH, adapter extract_kvarnbacken_verkstad]
CFR-KVR-3316-M-3.1-b.pdf - page 1 - supplier = Kvarnbacken Verkstad AB   [supplier_identity: MATCH, adapter extract_kvarnbacken_verkstad]

← REC-1015

Review item 6 of 6