Engineering
Grocery Retail · Logistics
Loading list against actual load
Container loading plans as XLSX against the goods-received manifests as PDF — line by line, automatically instead of by hand.
- Duration
- ~2 months
- Budget
- < 10.000 €
- Project team
- MQC 1 · Client 3
End-of-project survey
This client did not answer our end-of-project survey — so there are no scores to show.
The brief
- Build an automated run that checks XLSX loading plans against the PDF goods-received manifests and makes inbound tracking more accurate
- Replace the line-by-line check by hand that until then went through every pair of documents one at a time
The build
- One central document library, and a Power Automate workflow on it that compares loading list and goods received line by line
- AI for the matching itself: fuzzy hits across several fields, company names that differ, mixed weight units — kilograms to tonnes, converted exactly
The good
- The breakthrough was moving from rigid, rule-based Power Automate logic to an AI-driven approach — at the point where parsing the data the classical way stopped getting there
The bad
- Finding the right prompt for some of the matching calculations was harder than expected