BOM Extraction from Drawing and Spec Documents 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.
- 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.
- A single job took three to four days to process.
The layout-detection pipeline uses ADEOS to extract BOM and legend data from rear-view drawings, subsequently consolidating and de-duplicating records into Zoho-ready Excel outputs.
- Handles 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 | <3 hrs |
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
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
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.
Automated Comparison of Customer Drawings and Recreated CAD Files
Verification turnaround time reduced from 3 hours to 15 minutes, missing dimension detection improved to 93%, and manual review reduced to flagged discrepancies for quality engineers