Under 60 Seconds for EDI Batch Processing Through Intelligent Automation

The Challenge The client faced several operational challenges in managing retail purchasing and supplier transactions. Staff manually entered Electronic Data Interchange (EDI) data into SAP, …

The Challenge

The client faced several operational challenges in managing retail purchasing and supplier transactions. Staff manually entered Electronic Data Interchange (EDI) data into SAP, increasing the risk of errors in SKU details, batch expiry dates, and discount information.
 
Each transaction also required multiple validations, including drug licenses, stock availability, promotional offers, and supplier contracts.
 
Discrepancies such as out-of-stock items and expired promotions disrupted replenishment processes, leaving store shelves empty and affecting sales.
 
Purchasing managers also had to review and approve more than 300 exceptions daily, creating bottlenecks across the supply chain. Furthermore, the lack of a reliable audit trail increased the risk of counterfeit drugs and supplier overpayments.
 
These inefficiencies contributed to an 18% out-of-stock rate across SKUs, resulting in lost sales and potential regulatory penalties.

The Solution

CMC Global implemented an automated retail purchasing workflow using Workato and Gemini to streamline EDI processing, validate supplier transactions, and manage purchasing exceptions.
 
The Workato bot continuously monitors EDI inboxes and automatically collects XML, EDIFACT, and Excel files from more than 50 suppliers. Using Gemini OCR and data parsing, it extracts key information, including SKUs, batch numbers, expiry dates, quantities, prices, and discount codes, even from scanned PDF documents.
 
The solution then performs four automated validations to verify drug license validity, stock availability, promotional bonuses and discounts, and supplier contract compliance.
 
Any discrepancies are recorded in a PostgreSQL exception table for tracking and follow-up.
 
Based on the validation results, the workflow either automatically creates a purchase order (PO) in SAP or sends an approval request to the purchasing manager via Slack when issues require manual review.
 
Once processed, automated notifications are sent to suppliers and stores with PO confirmation and estimated delivery details.

The Result

The project has achieved measurable outcomes in operational efficiency

  • < 60 seconds for EDI Batch Processing
  • 0 Errors in order data
  • 90% of Orders Automatically Approved
  • <3% Out-of-stock rate