The Challenge
Every day, the owner had to review purchase requests, look up items, quantities, delivery dates, and suppliers, then create each purchase order and email separately.
From purchase request to supplier PO in one flow
Automated the procurement work of checking ERP purchase requests, creating supplier-specific purchase orders, and sending them by email.
Customer identity and live operating data have been anonymized and reconstructed.
Volume1,000 per month
Before15 min per item
AfterAutomated
Verified impactApprox. 250 hours per month
The Input
ERP purchase requests · supplier and item masters · requested receipt dates
Work Loop
- 01
Check for new purchase requests on the defined schedule.
- 02
Validate supplier, item, quantity, and delivery conditions against operating rules.
- 03
Create purchase orders and separate the items that require approval.
- 04
Email approved orders to each supplier and retain the sending history.
Verified Outcomes
Estimated from operating records and owner validation
- Automated 1,000 recurring purchase orders per month
- Owners review only exceptions and approval items
- Purchase orders and email delivery history retained in one place
ERPExcelEmailApproval