/
/
Know which customers to chase first, today
For collections and finance teams who want overdue receivables ranked by asking their AI assistant.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
The chase list is stale before collections even starts
Collections staff export an aging report from Dynamics GP and then check each customer by hand for balance and recent payments. By the time the list is ready it is stale, and customers with real exposure are easy to miss.
Without PopdockAI
- Export an aging report from Dynamics GP
- Look up each customer's balance and contact
- Check whether recent payments were applied
- Work from a list that is already out of date
With PopdockAI
- Open receivables past your threshold read live
- Balance, salesperson and contact added for the top ten
- Recent payments checked against older documents
- No adding across currencies, and nothing 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 overdue receivables in `{company}` (default company if empty) and recommend which customers to chase first, looking at documents at least `{min-days-past-due}` days past due (default 30).
**Step 1: Pull open receivables**
Call `powergp-online-get-receivablestransactions` with `company` set to `{company}` when given and `due-date.to` set to today minus the days threshold. Keep rows where `unapplied-amount` is above zero. Set `max-records` to 500.
**Step 2: Add customer context**
For the 10 customers with the largest overdue total, call `powergp-online-get-customers` with `customer-number` and read `balance-due`, `salesperson` and `contact-person`. Then call `powergp-online-get-receivablesapply` with `customer-number` to see whether recent payments were applied to older documents.
**Step 3: Report**
Give a table: customer number, customer name, overdue total, oldest days past due, number of open documents, balance due. Group by aging bucket (31-60, 61-90, 90+). Finish with a ranked chase list of at most 10 customers and one sentence of reasoning each.
**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 call payables tools for this job.
* Amounts are in the document currency; if `currency-id` varies, say so instead of summing across currencies.
* If the call hit the 500 record limit, say the totals are partial.
**Validation:**
* If no rows come back, say no receivables are past due at that threshold and stop.
* If a customer name appears under more than one customer number, report the numbers separately.Who it's for
One answer, three teams that use it
Collections specialists
Know who to call first today
Up to ten customers ranked with one sentence of reasoning each, from live data.
Who should I chase first today for anything more than 60 days past due?
Credit managers
See overdue by aging bucket
Open receivables grouped by bucket show where the overdue money sits.
Group our overdue receivables over 30 days by aging bucket in the Contoso company.
Controllers
Check payments landed on the right invoices
Recent payments applied to older documents are checked for the worst customers, so the ranking is fair.
For the customers most past due, were recent payments applied to their oldest invoices?
How it works
What PopdockAI does when you ask
You choose how many days past due to look at and your AI assistant reads PowerGP Online. It stops if nothing is overdue and says when results are partial.
01
Ask
You choose a days past due threshold, or use the default.
02
Read
It pulls open receivables past the threshold.
03
Enrich
It adds balance, contact and recent payment history for the worst customers.
04
Report
It groups by aging bucket and ranks up to ten customers to chase.
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-receivablestransactions
powergp-online-get-customers
powergp-online-get-receivablesapply
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
A current, ranked chase list every morning
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)
