/
/
Start each day with a ranked collections list
For finance teams who want overdue Dynamics 365 Sales invoices aged and ranked, with who to call, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.
The problem
Building the collections list takes the whole morning
A collections list means filtering past due invoices with money owed, ageing them, then looking up who to call, when they were last contacted and whether an open complaint explains the delay. By the time that is done, the morning is gone.
Without PopdockAI
- Filter invoices past due with money owed
- Age them into buckets by hand
- Look up contacts and the last conversation
- Call without knowing about an open complaint
With PopdockAI
- Unpaid invoices past due are aged into 30 day buckets
- Customers are ranked by amount overdue with credit breaches noted
- The top five get contacts, owner, last contact and open cases
- Totals stay per currency, 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:** Produce a collections list of invoices past their due date that still have an amount due, for customer `{customer}` (all if blank) and invoice totals of at least `{min-total}` (no minimum if blank).
**Step 1: Pull overdue invoices**
Call `dynamics-365-sales-get-invoices` with `due-date.to` = yesterday, `customer` if given, and `total-amount.min` = `{min-total}` if given. Set `max-records` to 500. Keep only invoices whose `amount-due` is above 0 and whose `status-reason` is not a paid or cancelled value.
**Step 2: Age them**
Bucket each invoice by days past `due-date`: 1 to 30, 31 to 60, 61 to 90, over 90.
**Step 3: Context for the top customers**
For the 5 customers with the most overdue, call:
* `dynamics-365-sales-get-accounts` with `account-name` = the customer to get the credit limit, main phone, email and owner
* `dynamics-365-sales-get-incidents` with `customer` = the customer and open status, since an open complaint often explains non-payment
* `dynamics-365-sales-get-activitypointers` with `regarding` = the customer, to see when they were last contacted
**Step 4: Report**
1. Total overdue and the total per ageing bucket.
2. By customer, largest first: overdue total, oldest invoice age, count of invoices, credit limit, and whether overdue exceeds the credit limit.
3. The invoice lines: invoice ID, name, customer, due date, days overdue, total, amount due, payment terms.
4. For the top 5 customers: who to contact, the last contact date, and any open case that may be holding up payment.
**Rules & Guidelines:**
* This prompt is read-only. Do NOT call any create or update tool: `dynamics-365-sales-create-account`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-phone-call`, `dynamics-365-sales-update-account`, `dynamics-365-sales-update-contact`, `dynamics-365-sales-update-lead`, `dynamics-365-sales-update-opportunity`, `dynamics-365-sales-update-case`.
* Amounts are in each invoice's own currency; do not add totals across currencies. If invoices use more than one currency, report totals per currency.
**Validation:**
* If nothing is overdue, say so and state the filters used.
* If `{min-total}` is not a number, ignore it and say so.Who it's for
One answer, three teams that use it
Collectors
Start the day with who to call
A ranked list with contacts and last contact dates lets you start calling straight away.
Give me today's collections list from Dynamics 365 Sales.
Credit managers
See credit limit breaches in context
Customers over their credit limit are noted against what they owe.
Which customers in Dynamics 365 Sales are overdue and over their credit limit?
Account managers
Know if a complaint is holding up payment
Open cases for the largest debtors show when a support issue needs fixing first.
Is Fabrikam overdue in Dynamics 365 Sales, and do they have an open case that explains it?
How it works
What PopdockAI does when you ask
You optionally name a customer and a minimum invoice total and your AI assistant builds a ranked collections list from Dynamics 365 Sales. It reports only.
01
Ask
You optionally name a customer and a minimum invoice total.
02
Age
It finds unpaid invoices past due and sorts them into 30-day buckets.
03
Rank
It ranks customers by amount overdue and notes credit limit breaches.
04
Report
You get the list with contacts, last contact and open cases for the top five.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics 365 Sales and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-365-sales-get-invoices
microsoft-dynamics-365-sales-get-accounts
microsoft-dynamics-365-sales-get-incidents
microsoft-dynamics-365-sales-get-activitypointers
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 ranked collections list with call context
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)
