The typical situation
Booking requests arrive as emails, spreadsheets and PDFs in a dozen customer formats. Three people retype them into the ERP, then forward confirmations by hand. Mistakes show up as wrong consignee details on the documents.
Nobody in a business like this wants a new system. They want the same ERP with less typing.
What the data looked like
A year of booking emails and attachments, the ERP's booking records for the same period, and the customer master. The past bookings show what every field should have been for each email.
What we built
- A flow that reads each booking email and attachment, fills the ERP booking and holds it for one-click approval.
- Checks against the customer master, so an unknown consignee or a mismatched address goes to a person instead of the ERP.
- Automatic confirmations to the customer once a booking is approved.
- A daily log of what was automated, what was edited and what was rejected.
Typical outcome
| Measure | Before | After | Period |
|---|---|---|---|
| Hours spent retyping bookings | about 18 a day | about 4 a day | typical outcome |
| Bookings with data-entry errors | about 3% | under 1% | typical outcome |
What usually trips these projects up
Start with the five customers who send the most bookings. Covering every format from day one doubles the build for the last few percent of volume.