/
/
Know which customers are waiting on late production
For planners who want late Dynamics GP manufacturing orders traced to customers and outsourcing holdups, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Late production with no idea who is waiting
When manufacturing orders in Dynamics GP run late, you need to know which customers are waiting and whether an outsourced step is the holdup. Answering means tracing each order to sales orders and checking outsourcing one at a time.
Without PopdockAI
- List manufacturing orders past due
- Trace each one to its linked sales orders
- Check outsourced steps and shipments at vendors
- Guess which customers to warn first
With PopdockAI
- Orders past due and not finished are read
- Each is traced to linked sales orders, or marked build to stock
- Outsourced steps not shipped and shipments at the vendor are checked
- Customer-facing orders come first, with no guessed causes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find manufacturing orders (posting to site `{site-id}`, default all sites) that are past their due date and not finished, and show which customers are waiting on them and whether outsourced operations are the holdup.
Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.
**Step 1: Late orders**
Call `dynamics-gp-get-mfg-order` with `due-date.to` set to yesterday and `post-to-site` set to `{site-id}` when given. Keep orders whose `manufacturing-order-status` is not complete, closed or cancelled. Note days late from `due-date` and `manufacturing-order-priority`.
**Step 2: Who is waiting**
For each late order call `dynamics-gp-get-mfg-so-mo-link` filtered by `manufacturing-order-number`. For each linked `sales-order-number`, call `dynamics-gp-get-rm-sales-trx` filtered by `sop-number` to get `customer-name` and `requested-ship-date`. Orders with no link are build-to-stock.
**Step 3: Outsourcing**
For each late order:
* `dynamics-gp-get-mfg-suggested-outsourcing-shipment` filtered by `manufacturing-order`: outsourced steps not yet shipped to the vendor, with `ship-by-date`.
* `dynamics-gp-get-mfg-recorded-outsourcing-shipment` filtered by `manufacturing-order`: shipments that went out, are not `voided` and have no `return-date` yet (still at the vendor).
**Step 4: Report**
Customer-facing orders first, then build-to-stock. For each: MO number, item, end quantity, status, due date, days late, customer and sales order (if any), promised date, and the likely holdup (not shipped to outsourcer, at outsourcer since a date, or none found). Close with a count of late orders and customers affected.
**Rules & Guidelines:**
* Read-only. Do not call `dynamics-gp-rm-sales-trx-update`, `dynamics-gp-pm-purchase-order-add` or any tool whose name does not contain `get`.
* When no outsourcing record explains the delay, say "no outsourcing holdup found"; do not speculate about shop-floor causes the tools cannot see.
**Validation:**
* If no orders are late, say so and list orders due in the next 7 days.Who it's for
One answer, three teams that use it
Production planners
Push the orders customers are waiting on
Customer-facing late orders come first with days late, so you know where to push.
Which late Dynamics GP manufacturing orders at the MAIN plant have customers waiting?
Customer service reps
Warn customers before they chase
Each late order shows the customer and requested ship date, so you can call ahead.
Is Fabrikam waiting on any late manufacturing orders in Dynamics GP?
Supply chain managers
Find outsourcing holdups
Outsourced steps not shipped or still at the vendor are shown as the likely holdup.
Which late Dynamics GP manufacturing orders are held up by an outsourced step?
How it works
What PopdockAI does when you ask
You optionally pick a site, and your AI assistant traces late Dynamics GP manufacturing orders to customers and outsourcing. It reports and changes nothing.
01
Ask
You optionally pick a site.
02
Read
It reads manufacturing orders past due and not finished.
03
Trace
It links each to sales orders and checks outsourced steps and shipments.
04
Report
You get customer-facing orders first, with days late and the likely holdup.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics GP and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-gp-get-mfg-order
microsoft-dynamics-gp-get-mfg-so-mo-link
microsoft-dynamics-gp-get-rm-sales-trx
microsoft-dynamics-gp-get-mfg-suggested-outsourcing-shipment
microsoft-dynamics-gp-get-mfg-recorded-outsourcing-shipment
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Know which customers are waiting and why
Related use cases
More ways to put this data to work
Add Dynamics GP item buyers to a Constant Contact list
Ask your AI to add an item's buyers to a Constant Contact list and it totals each customer's purchases in Dynamics GP, checks them in Constant Contact and adds the missing ones after you confirm.
Learn More
Add missing Dynamics GP customers to a Constant Contact list
Ask your AI to add missing Dynamics GP customers to a Constant Contact list and it checks every email, then creates only the missing contacts after you confirm.
Learn More
Add missing Dynamics GP customers to a Mailchimp audience
Ask your AI to add missing Dynamics GP customers to a Mailchimp audience and it proposes only people not in the audience at all, adding them as pending after you confirm.
Learn More
Add tracking to a Dynamics GP sales order
Ask your AI to add tracking to a Dynamics GP sales order and it finds the document by your number or the customer's PO, asks if several match, and writes once after you confirm.
Learn More
Check whether a bill was already paid in Dynamics GP
Ask your AI whether a vendor invoice was already paid and it searches Dynamics GP and Sage Intacct payables and payments, then gives one verdict with the evidence.
Learn More
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.