/
/
Find late and short sales orders before customers chase them
For operations teams who want the open order backlog checked against stock and receipts, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
The problem
Customers chase late orders before you notice them
When the sales backlog is not reviewed, customers chase late orders first. Finding late lines, checking stock and finding the next delivery means switching between orders, items and purchase lines.
Without PopdockAI
- Filter open orders for past shipment dates
- Check stock for each late item
- Look up incoming purchase lines for short items
- Answer the customer after they chase
With PopdockAI
- Outstanding lines past their shipment date are flagged
- Stock is compared with total demand across open orders
- Short items show their next expected receipt
- Lines that can ship now are grouped by order, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Review the open sales order backlog, optionally for customer `{customer-name}`, flagging late lines and lines that stock cannot cover.
Pass `{company}` as the company argument on every call. If `{company}` is empty, leave the company argument out so the connector's default company is used.
**Step 1: Open orders**
Call `business-central-get-sales-transaction` with document-type Order. If `{customer-name}` is given, pass it as sell-to-customer-name.contains.
**Step 2: Outstanding lines**
Call `business-central-get-sales-transaction-line` with document-type Order (and sell-to-customer-number when one customer was chosen). Keep lines where outstanding-quantity is above 0. A line is late when shipment-date is before today.
**Step 3: Stock check**
For each distinct item number on those lines (line-type Item), call `business-central-get-item` with item-number. Compare inventory with the total outstanding quantity across all open order lines for that item, and note quantity-on-purchase-order. For short items call `business-central-get-purchase-transaction-line` with number set to the item number and document-type Order to find the next expected-receipt-date.
**Step 4: Report**
* Summary: number of open orders, outstanding lines, late lines, value outstanding
* Late lines: order, customer, item, outstanding quantity, shipment date, days late
* Short items: item, on hand, needed by open orders, on purchase order, next receipt date
* Lines that can ship now (stock covers them), grouped by order
**Rules & Guidelines:**
* This prompt is read-only. Do not call any tool named business-central-create-* or business-central-update-*, in particular not `business-central-update-sales-order` or `business-central-update-sales-order-line`. Suggest date changes, do not make them.
* Stock is company-wide inventory; say that location-level availability is not checked.
**Validation:**
* If there are no open orders, say so and stop.Who it's for
One answer, three teams that use it
Customer service
Contact customers before they chase
Late lines with days late tell you who to call before a customer has to ask.
Which Business Central sales orders for Contoso are late, and by how many days?
Warehouse managers
Ship what you can today
Lines that can ship now are grouped by order, so the warehouse can get them out.
What open sales order lines in Business Central can ship today?
Supply planners
See which items are short and when stock arrives
Short items come with the next expected receipt, so you know when backlog will clear.
Which items are short against open sales orders in Business Central, and when is the next receipt?
How it works
What PopdockAI does when you ask
You optionally name a customer and your AI assistant reviews the open sales order backlog in Business Central. It suggests date changes rather than making them.
01
Ask
You optionally name a customer.
02
Read
It reads open sales orders and their outstanding lines.
03
Check
It compares stock with total demand and finds the next receipt for short items.
04
Report
You get late lines, short items and lines that can ship now.
The outcome
Late and short orders seen before customers ask
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
