/
/
See a customer's balance and recent calls together
For support and collections staff who want a Dynamics GP account position beside Contivio call history, just by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
The balance and the calls are checked in different places
You look up the balance and open items in Dynamics GP, then search the contact center for calls to the same customer. One side is often missed, so contact does not match the account's position.
Without PopdockAI
- Look up the customer's balance in Dynamics GP
- List open receivables by hand
- Search the contact center for recent calls
- Miss a number saved in a different format
With PopdockAI
- Balance, credit limit and hold status are read together
- Receivables are listed with due dates and amounts
- Calls are found by customer id, then phone number if needed
- The matching method used is stated
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Dynamics GP customer `{customer-id}`, show the account position and the recent phone contact together, looking back `{lookback-days}` days (default 30).
**Step 1: Find the customer (Dynamics GP)**
Call `dynamics-gp-get-rm-customer` with `customer-id` set to `{customer-id}`. If nothing is returned, stop and say the customer does not exist in Dynamics GP. Keep `customer-name`, `customer-balance`, `credit-limit-amount`, `hold`, `phone-1` and `main-email-address`.
**Step 2: Open receivables (Dynamics GP)**
Call `dynamics-gp-get-rm-trx` with `customer-id` set to `{customer-id}` and `document-date.from` set to the start of the lookback window. List each `document-number`, `document-type`, `document-date`, `due-date`, `document-amount` and `current-transaction-amount`.
**Step 3: Calls (Contivio)**
Call `contivio-get-call` with `customer-id` set to `{customer-id}` and `start-time.from` set to the start of the lookback window. If it returns nothing, call `contivio-get-call` again without `customer-id`, and keep only calls whose `from` or `to` matches `phone-1` after stripping spaces, dashes and country code. State which matching method found the calls.
**Step 4: Report**
Give: customer name, balance versus credit limit and hold status; the receivables table; the calls table (`start-time`, `direction`, `agent`, `queue`, `result`, `talk-duration-seconds`, `ai-short-summary`); then 2 or 3 sentences on whether contact has followed the account position.
**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 Contivio returns no calls by either method, report the customer as having no recorded calls and still give the GP section.
* If a phone number is in a different format in the two systems, normalise to digits only before comparing and say so.Who it's for
One answer, three teams that use it
Support agents
Answer a balance query with context
See what the customer owes and how recently they were spoken to, before replying to a question about their account.
Show the balance and open receivables for Dynamics GP customer FABRIKAM001 with their calls from the last 14 days.
Credit controllers
Check contact before chasing
See whether an overdue account has been called recently, so you do not repeat a call or miss a gap.
For customer NORTHWIND01, has contact in Contivio followed their overdue receivables in the last 30 days?
Account managers
Prepare for a customer review
Balance against credit limit with the recent calls gives you the facts to bring to a review conversation.
Review CONTOSO001 in Dynamics GP and Contivio for the last 60 days, including balance against credit limit.
How it works
What PopdockAI does when you ask
You give a customer id and your AI assistant reads Dynamics GP and Contivio. It only reads data and never writes to Dynamics GP.
Ask
You give the customer id and how far back to look.
Read
It reads the Dynamics GP customer, their balance, credit limit and hold status.
Match
It lists receivables and finds Contivio calls by customer id, or by phone number if none are found.
Report
You get the account, receivables, calls and a short view of whether contact followed the balance.
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
Account position and contact in one view
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)
