/
/
See held and late sales orders in one summary
For sales operations teams who want orders, holds and lines read together by asking their AI assistant.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
Held and late orders go unnoticed until the customer asks
Sales operations merge an order report, a hold report and a line report by hand to see what is booked, stuck and late. Orders sitting on a hold or past their requested ship date go unnoticed until the customer asks.
Without PopdockAI
- Run the sales order report
- Run the hold report and age each hold
- Check lines against requested ship dates
- Merge the three by hand
With PopdockAI
- Sales documents, process holds and lines read together
- Totals by document type and status
- Held documents with age and late documents listed
- Holds never released and documents never changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Summarize sales activity in `{company}` (default company if empty) from the last `{lookback-days}` days (default 30), for customer `{customer}` when given.
**Step 1: Resolve the customer (only if given)**
Call `powergp-online-get-customers` with `customer-number` equal to `{customer}`; if empty, retry with `customer-name.contains`. If several match, list them and stop.
**Step 2: Documents**
Call `powergp-online-get-salesdocuments` with `document-date.from` set to today minus the lookback and the customer number when known. Group by `document-type` and `sop-document-status`.
**Step 3: Holds**
Call `powergp-online-get-salesprocessholds` with the same filters. List the documents stuck on a hold with `process-hold`, `hold-description` and `hold-date`.
**Step 4: Lines**
Call `powergp-online-get-salestransactions` for the same window with `max-records` 500 and find the top 10 items by `extended-price`.
**Step 5: Report**
Totals by document type, documents on hold with age in days, documents past `requested-ship-date` that are not complete, and top items and customers.
**Rules & Guidelines:**
* This prompt is read-only. Only the get tools on this server exist; never try to change, post, approve, release or delete anything in Dynamics GP.
* Do not release holds or change documents.
**Validation:**
* If no documents are found, state the window and filters used and stop.Who it's for
One answer, three teams that use it
Sales operations
See stuck orders without merging reports
Documents on hold with their age in days are listed in one summary.
Which orders from the last 14 days are stuck on a hold, and for how long?
Sales managers
Know what is booked this month
Totals by document type and status plus the top items by value, ready for the pipeline meeting.
Summarize our sales documents for the last 30 days by type and status.
Customer service leads
Get ahead of late shipments
Documents past the requested ship date that are not complete are flagged before customers call.
Which orders for Northwind Traders are past their requested ship date?
How it works
What PopdockAI does when you ask
You give a lookback period and your AI assistant summarizes the pipeline from PowerGP Online. If a customer name matches several customers it stops and lists them.
01
Ask
You give a lookback period and optionally a customer.
02
Read
It pulls sales documents, process holds and order lines.
03
Group
It totals by document type and status and ages each hold.
04
Report
It lists held and late documents and the top items.
What PopdockAI provides
The tools behind the answer
Ready made tools for PowerGP Online and one secure connection to your AI tool. No code, no exports.
powergp-online-get-customers
powergp-online-get-salesdocuments
powergp-online-get-salesprocessholds
powergp-online-get-salestransactions
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
No held or late order sits unnoticed
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)
