Automated BOM Extraction to Zoho ERP (Control Relay Panels)
Per-job turnaround targeted to drop from 3-4 days to under 3 hours, monthly capacity to scale from 12-20 to 75-80 panels, and duplicate item-master entries eliminated through automated de-duplication against Zoho ERP
Manually extracting BOM data from customer rear-view drawings and free-issue BOM files was not scalable at a volume of 12-20 jobs per month without expanding the team assigned to BOM release. A single job took three to four days to process, consuming roughly 24 days of manual effort a month and delaying BOM release until after production had already started.
- Devices and quantities had to be manually read off rear-view drawings, including scanned drawings
- Legend and BOM entries arrived in inconsistent formats, split across multiple excel sheets.
- New items were checked against the item master by hand, and inconsistent naming produced duplicate entries.
Adeos deployed a layout-detection pipeline to extract, consolidate, and de-duplicate BOM data from rear-view drawings and legend files into a Zoho-ready Excel output.
- Handled multiple drawing formats in the client's jobs, including scanned PDFs and unstructured excel sheets.
- Consolidates legend and BOM entries from Excel or PDF, whether descriptions are split across multiple rows or already one row per item.
- Checks every new item against an uploaded Zoho Item Master export before flagging it as new.
- Flags only low-confidence extractions for review, keeping manual effort limited to exceptions.
| Impact Metric | Before | After |
|---|---|---|
Turnaround per Job | 3-4 days | Under 3 hours |
Monthly Volume Capacity | 12-20 jobs/month | 75-80 panels/month |
Dedicated Manual Effort | ~24 days/month | ~4 days/month |
Engineers cannot manually re-verify every BOM line as job volume grows. The pipeline flags only the extractions it is not confident about, and routes those to review. This keeps BOM release moving without adding headcount to the process.
Experience similar transformation today.
Ready to see how our engineering-first AI solutions can streamline your operations and drive real impact?
Browse More Success Stories
Dimension Extraction and Welding Calculations for Power Boiler Manufacturing
One extraction workflow distributed to 3 departments, reducing per-drawing review from days to hours across a 50–100 drawing project cycle.
Filtered Dimension Extraction for Lift Manufacturing
80–90% reduction in manual effort per drawing, processing capacity scaled to 200 drawings per day, consistent two-sheet Excel output for every extraction
Hugarex: Enterprise Encryption & Key Management
Customer onboarding was cut from 5 days to 10 minutes, 100% audit trail coverage achieved, and annual audit costs eliminated across a 3-continent key management operation.