/
/
See which overdue Dynamics GP customers have been called
For collections teams who want Contivio call history next to overdue Dynamics GP invoices, just by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Some overdue customers get repeat calls, others none
Collections teams cannot tell which overdue customers have already been called. Without checking the call log customer by customer, calls are repeated for some and never made for others.
Without PopdockAI
- Work out which customers are overdue in Dynamics GP
- Note each balance and phone number
- Search the Contivio call log customer by customer
- Compare to see who was called and who was missed
With PopdockAI
- Overdue customers and invoices are found for you
- Contivio is checked by customer id, then by phone number
- Calls in the window and the last result are shown
- Capped at 20 customers, with any left out counted
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find customers whose Dynamics GP invoices were due before `{as-of-date}` (default: today) with balance above `{min-balance}` (default 1000), and check whether anyone has called them in the last `{lookback-days}` days (default 14).
**Step 1: Candidates (Dynamics GP)**
Call `dynamics-gp-get-rm-customer` with `customer-balance.min` set to `{min-balance}` and `inactive` set to false; keep `customer-id`, `customer-name`, `customer-balance`, `phone-1` and `main-email-address`. Then call `dynamics-gp-get-rm-trx` with `document-date.to` set to `{as-of-date}` and keep invoices whose `due-date` is before `{as-of-date}` and whose `current-transaction-amount` is above zero. Keep only customers that appear in both results.
**Step 2: Contact (Contivio)**
For each remaining customer (at most 20, highest balance first), call `contivio-get-call` with `customer-id` set to that customer and `start-time.from` set to the start of the lookback window. If nothing comes back, retry without `customer-id` and match `from` or `to` to `phone-1`.
**Step 3: Report**
A table: customer, balance, overdue amount, oldest `due-date`, calls in the window, last call date and `result`. Sort uncontacted customers first, then say how many customers had no contact.
**Rules & Guidelines:**
* `contivio-get-call` is on the Contivio server; `dynamics-gp-get-rm-customer` and `dynamics-gp-get-rm-trx` are on the Dynamics GP server.
* Never call any `dynamics-gp-*-add`, `dynamics-gp-*-update` or `dynamics-gp-*-note` tool; this prompt is read-only.
**Validation:**
* If more than 20 customers qualify, say how many were left out.
* If no customer is overdue, report that and stop without calling Contivio.Who it's for
One answer, three teams that use it
Collections specialists
Pick up where the last call left off
See last call date and result for each overdue customer, so you call the ones nobody has spoken to.
Show overdue Dynamics GP customers over 1,000 and when Contivio last called each.
Credit managers
Review collection effort
Check that customers with the largest overdue balances have been contacted within the window you expect.
Of Dynamics GP customers overdue as of 31 October, who has had no call in 14 days?
Contact center supervisors
Prevent repeat calls
See which overdue customers were recently called, so the team does not ring the same account twice.
Which overdue Dynamics GP customers over 5,000 had a Contivio call this week?
How it works
What PopdockAI does when you ask
You set the date, balance and window, or use the defaults. Your AI assistant reads Dynamics GP and Contivio and compares them. It only reads, so nothing is written.
Ask
You give an as-of date, a minimum balance and how many days of calls to check, or use the defaults.
Find
It finds Dynamics GP customers with overdue invoices and a balance above the minimum.
Match
It checks Contivio for calls to each of up to 20 customers, highest balance first.
Report
You get a table with uncontacted customers first, and how many were left out.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics GP and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx
contivio-get-call
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 overdue customer missed, none called twice
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)
