Automated Business Central Open Order Queue
Every morning, WebRun opens Business Central, finds sales orders still open past their requested delivery date, reads what is holding each one, writes the queue into Google Sheets ordered by how late it is, and puts a short order-desk block in Google Calendar so the list gets worked rather than ageing.
How do I find open sales orders past their delivery date in Business Central?
WebRun opens Business Central every morning, finds sales orders still open past their requested delivery date, and reads what is holding each one. It writes the queue into Google Sheets ordered by days late and blocks order-desk time in Google Calendar, so waiting customers get shipments instead of silence.
- Overdue orders are ranked by days late every morning
- Each order arrives with the blocker already identified
- Cleared orders drop off automatically from live order status
Built for order desk teams · distributors · wholesale operations · finance and operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
businesscentral.dynamics.comin a real browser with your saved login - no setup, no API keys. -
1
Microsoft Dynamics 365 Business Central - find overdue open orders
businesscentral.dynamics.com
WebRun opens Business Central to find overdue open orders. - Open the sales order list and filter to orders that are still open
- Keep the ones whose requested delivery date has passed, and record the customer, the value, and the days late
- Read what is holding each order: stock not available, a warehouse shipment not posted, or a line still unpicked
- Skip orders already marked on hold for a reason you have set
Done when Every overdue open sales order is listed with its customer, value, days late, and blocker.
-
2
Google Sheets - list them by days late
google.com
WebRun opens Google Sheets to list them by days late. - Write one row per overdue order with the order number, customer, value, days late, and blocker
- Sort so the latest and largest orders sit at the top of the sheet
- Clear rows for orders that shipped or posted since the previous run, keeping a dated history of what was cleared
Done when The sheet holds today's overdue orders ranked by days late, with yesterday's cleared ones removed.
-
3
Google Calendar - block time to clear the queue
calendar.google.com
WebRun opens Google Calendar to block time to clear the queue. - Create a short order-desk block on today's calendar when the queue is not empty
- Put the count of overdue orders and the total value in the event title
- Skip the block entirely on a morning with nothing overdue
Done when Today's calendar has an order-desk block sized to the queue, or none if the queue is clear.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it post shipments or invoice anything?
No. WebRun reads the order list and reports. Posting a warehouse shipment, releasing an order, or invoicing a customer stays with your team, so nothing is posted in Business Central by a run.
Does it contact the customer?
No. The queue is internal, going to your sheet and your own calendar. No email or message reaches a customer, so any update to a buyer is written and sent by a person.
How does it know what is holding an order?
It reads the order lines and their status: stock unavailable, a shipment not yet posted, or lines still unpicked. That reason is written next to each order in the sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.