Pick up unread vendor replies
Every 3 minutes the workflow reads up to 10 emails from Microsoft Outlook and keeps only the unread ones, so processed replies are not handled again.
Reads unread vendor replies in Microsoft Outlook, interprets availability and pricing with OpenAI and creates a purchase order in SAP Business One for the items the vendor can supply
Apps used in this template
About this template
Buyers lose time reading vendor replies to stock requests and keying the confirmed quantities, prices and dates into SAP Business One. This template checks Microsoft Outlook every 3 minutes for up to 10 unread vendor replies, uses OpenAI to read availability, quantity, price and delivery date per item, and creates a purchase order in SAP Business One for the items the vendor can fully or partly supply.
Key benefits
Inside the flow
Every 3 minutes the workflow reads up to 10 unread vendor replies from Microsoft Outlook and has OpenAI extract item availability, quantity, price and delivery date. Items the vendor can supply are built into a purchase order in SAP Business One, and the email is marked as read.
Every 3 minutes the workflow reads up to 10 emails from Microsoft Outlook and keeps only the unread ones, so processed replies are not handled again.
Each email is cleaned into subject, sender, received time and readable body. The vendor, warehouse, response type and item details needed for the order are extracted.
OpenAI reads the reply against the original request and returns availability, supplied quantity, delivery date, quoted unit price, substitutions and comments for each item. The original request data stays the source of truth.
Each item is marked Available, Partial, Not Available or Unknown. The quoted price is compared with the original unit cost to record the change type, amount and percentage.
Items with a positive supply quantity are built into a purchase order with quantities, line totals, expected delivery date and a PO reference. Vendor, document dates, quantities, unit prices and warehouse are mapped into SAP Business One.
Once the reply is processed, the original email in Microsoft Outlook is marked as read so the next check skips it.
What this procurement automation changes for purchasing and finance teams
01
Purchase orders include only items the vendor can supply in full or in part, so buyers do not order against stock that is not coming.
02
Vendor replies are turned into structured order lines, which removes retyping quantities, prices and dates into SAP Business One.
03
Quoted prices are compared with the original cost and the difference is calculated before the purchase order is created.
04
Vendor delivery dates are captured and an expected delivery date is set on the order, which shows purchasing when stock should arrive.
05
Only unread emails are processed and each is marked as read afterward, which helps prevent the same reply creating a second order.
01
Purchase orders include only items the vendor can supply in full or in part, so buyers do not order against stock that is not coming.
02
Vendor replies are turned into structured order lines, which removes retyping quantities, prices and dates into SAP Business One.
03
Quoted prices are compared with the original cost and the difference is calculated before the purchase order is created.
04
Vendor delivery dates are captured and an expected delivery date is set on the order, which shows purchasing when stock should arrive.
05
Only unread emails are processed and each is marked as read afterward, which helps prevent the same reply creating a second order.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every trigger and action this template uses is available in the appse ai builder, so the same flow can be rebuilt with your own routing, thresholds and destinations.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.