Certificate of Analysis
Upload & Extract
Upload a supplier CoA PDF. AI analyses it, extracts the data, and you review and edit the JSON before generating the D365-ready XLSX.
1 Upload PDF
2 Review & Edit
3 Download XLSX
Drop a ‘Certificate of Analysis’ PDF here
PDF files only · max 20 MB
📎
How it works
1
Upload a supplier Certificate of Analysis PDF (even scanned documents)
2
AI reads and extracts all elemental values and metadata
3
Review and edit the extracted JSON — correct any misreads before generating
4
Download the pre-filled D365 DMF XLSX — three tabs (Quality orders, QO Lines, QO Results) ready to import
5
Receive promotion due to company cost savings on hyperproductivity and impressing your peers
D365 Mapping Rules
Numeric values (e.g. 15.7) → RESULTVALUE. Text/qualifiers (e.g. <1, Balance) → OUTCOMEID (line flagged CoA / CoA TEXT). Percentages (e.g. 99.99%) → a _wt test in wt%.
CoA Tool
History
Previously processed CoA files.
No history yet
Processed files will appear here in a future release.
Reference
Column Mapping
How extracted values route to the D365 XLSX template.
D365 XLSX Column Rules
| Value Type | XLSX Column | D365 Field | Example |
|---|---|---|---|
| Numeric only | Col K | Result value (Fraction) | 0.5, 1.23, 99.95 |
| Special character qualifier | Col L | Result outcome (Option) | <0.001, ~1, <=0.1 |
| Text value | Col L | Result outcome (Option) | Balance, Trace, nd |
| Dual-reference element | Col K + Col L | Both fields via two rows | Ag (numeric → K) / Ag_ (text → L) |
Admin
Login History
Every successful sign-in across the CoA and RefMat apps. Newest first.
Sign-ins
| IP address | Date / time | App | |
|---|---|---|---|
| Loading… | |||