Connectors

/

Microsoft Dynamics GP

/

Review a Dynamics GP customer's balance and Contivio calls
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review a Dynamics GP customer's balance and Contivio calls
Show me the Dynamics GP balance and receivables for customer CONTOSO001 with their Contivio calls from the last 30 days.
Contoso Ltd owes 18,450.00 against a credit limit of 25,000.00 and is not on hold. Contact has been light. - Receivables: INV-1042 due 12 Oct, 9,800.00 open; INV-1077 due 28 Oct, 8,650.00 open - Calls: 2 in 30 days, last on 2 Nov outbound with Sam Patel, result no answer - Matching method: calls found by phone number because the customer id returned none Want the older receivables as well?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx
contivio-get-call

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics GP

Microsoft Dynamics GP
Run it on your own Microsoft Dynamics GP data.

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

Try PopdockAI free

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.

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

Your AI tool

Read

It reads the Dynamics GP customer, their balance, credit limit and hold status.

microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx
contivio-get-call

Match

It lists receivables and finds Contivio calls by customer id, or by phone number if none are found.

No items found.

Report

You get the account, receivables, calls and a short view of whether contact followed the balance.

Your AI tool

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.

get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-trx

Returns receivables transactions such as invoices, payments and credit memos from Dynamics GP Receivables Management, including customer, dates, amounts and outstanding balances. Filter by customer ID, document type, customer name, document date, document amount, document number, batch number and void status, and pick the company and the maximum number of records.
get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
Read only.Nothing in Microsoft Dynamics GP 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

Account position and contact in one view

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation