Connectors

/

PowerGP Online

/

Summarize PowerGP Online sales pipeline and holds
Report

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.

Try PopdockAI free
Get a live demo
Summarize PowerGP Online sales pipeline and holds
Summarize our sales activity for the last 30 days and tell me which orders are stuck on hold or past their ship date.
There were 212 sales documents in the last 30 days, with 9 stuck on hold. - Orders: 148 totaling 612,300.00 - On hold: 9, oldest 18 days, mostly credit hold - Past requested ship date: 6 orders not complete - Top item: Widget A100, 38,900.00 Want the held documents listed with hold reasons?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-customers
powergp-online-get-salesdocuments
powergp-online-get-salesprocessholds
powergp-online-get-salestransactions

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

PowerGP Online

PowerGP Online
Run it on your own PowerGP Online data.

Connect PowerGP Online, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It pulls sales documents, process holds and order lines.

powergp-online-get-customers
powergp-online-get-salesdocuments
powergp-online-get-salesprocessholds
powergp-online-get-salestransactions

03

Group

It totals by document type and status and ages each hold.

No items found.

04

Report

It lists held and late documents and the top items.

Your AI tool

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.

get-data

powergp-online-get-customers

Returns customers from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-salesdocuments

Returns sales documents from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-salesprocessholds

Returns sales process holds from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-salestransactions

Returns sales transactions from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
Read only.Nothing in PowerGP Online Changes

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.

How Popdock AI secures your data

The outcome

No held or late order sits unnoticed

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation