Connectors

/

Microsoft Dynamics 365 Sales

/

Dynamics 365 Sales collections review
Report

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.

Try PopdockAI free
Get a live demo
Dynamics 365 Sales collections review
Give me today's collections list from Dynamics 365 Sales for invoices over 1,000.
14 invoices totalling 96,300 are past due, across 8 customers. - Largest: Contoso owes 28,500, 61 to 90 days overdue, over its credit limit - Call: Jordan Lee, last contacted 12 September - Possible reason: Contoso has an open billing case - Aging: 52,100 is under 30 days, 9,800 is over 90 days Want the full ranked list?
Microsoft Dynamics 365 Sales
Sample figures. Your results come from your own account.
microsoft-dynamics-365-sales-get-invoices
microsoft-dynamics-365-sales-get-accounts
microsoft-dynamics-365-sales-get-incidents
microsoft-dynamics-365-sales-get-activitypointers

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Sales

Microsoft Dynamics 365 Sales
Run it on your own Microsoft Dynamics 365 Sales data.

Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Age

It finds unpaid invoices past due and sorts them into 30-day buckets.

microsoft-dynamics-365-sales-get-invoices

03

Rank

It ranks customers by amount overdue and notes credit limit breaches.

microsoft-dynamics-365-sales-get-accounts

04

Report

You get the list with contacts, last contact and open cases for the top five.

Your AI tool

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.

get-data

microsoft-dynamics-365-sales-get-invoices

Returns Dynamics 365 Sales invoices. Filter by name, customer, invoice ID, created date, total amount, status reason and due date, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-accounts

Returns Dynamics 365 Sales accounts. Filter by city, annual revenue, status, industry, account number, email, account name and state, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-incidents

Returns Dynamics 365 Sales cases. Filter by case title, status, customer, priority, owner, case type, created date and case number, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-activitypointers

Returns Dynamics 365 Sales activities. Filter by activity type, owner, due date, subject, regarding record, priority and activity status, and cap how many records come back.
Read only.Nothing in Microsoft Dynamics 365 Sales 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

A ranked collections list with call context

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