Connectors

/

Microsoft Dynamics GP

/

Find Dynamics GP customers without recent Contivio calls
Report
Cross-Connector

Find active customers who have gone quiet on the phone

For account managers who want to see which Dynamics GP customers had no Contivio calls recently, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Dynamics GP customers without recent Contivio calls
Which active Dynamics GP customers in the Wholesale class have had no Contivio calls in the last 90 days?
7 of 42 Wholesale customers have had no calls in 90 days, and 3 cannot be matched by phone. - Northwind Traders: balance 18,400.00, salesperson SP-04 - Contoso: balance 11,250.00, salesperson SP-02 - Fabrikam: balance 6,900.00, salesperson SP-04 - Cannot match by phone: 3 customers with no phone number Want the full list of all 7 customers?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
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

Quiet accounts are invisible in two systems

Dynamics GP knows who your active customers are and Contivio knows who you called, but neither shows who has gone quiet. Matching phone numbers across both is slow, so quiet accounts go unnoticed.

Without PopdockAI

  • Export active customers from Dynamics GP
  • Export the call log from Contivio
  • Match phone numbers in different formats
  • Rank by balance in a spreadsheet

With PopdockAI

  • Active customers and calls are read for you
  • Customers are matched to calls by phone digits
  • Results are ranked by balance with the salesperson
  • Customers without a phone are flagged 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:** List active Dynamics GP customers in class `{customer-class}` (default: all classes) with no Contivio call in the last `{lookback-days}` days (default 90).

**Step 1: Customers (Dynamics GP)**

Call `dynamics-gp-get-rm-customer` with `inactive` set to false and `customer-class` set to `{customer-class}` when one is given. Keep `customer-id`, `customer-name`, `phone-1`, `customer-balance` and `salesperson-id`. Limit to 50 customers and say if the list was cut.

**Step 2: Calls (Contivio)**

Call `contivio-get-call` once with `start-time.from` set to the start of the lookback window and a large `max-records`. Match each call to a customer by `from` or `to` against `phone-1` (digits only). For any customer not matched, you may call `contivio-get-call` with `customer-id` for that customer.

**Step 3: Report**

Show customers with no calls, sorted by `customer-balance` descending, with `salesperson-id`, then the count of customers that did have calls.

**Rules & Guidelines:**

* `contivio-get-call` is on the Contivio server; `dynamics-gp-get-rm-customer` is 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 a customer has no `phone-1`, list it as "cannot match by phone" instead of "no calls".
* If Contivio returns nothing at all, say the call data may be empty and do not report every customer as uncontacted.

Who it's for

One answer, three teams that use it

Account managers

Find customers to call first

See which of your active customers have had no calls lately, with the biggest balances at the top.

Which of my Dynamics GP customers have had no Contivio calls in the last 60 days?

Sales managers

Check outreach by class

Review a whole customer class to see where outreach has dropped off and which salesperson owns the account.

List Retail class customers in Dynamics GP with no calls in Contivio over 90 days, with salesperson.

Finance and credit teams

Spot unattended balances

See customers carrying a balance who have not been contacted, which helps plan credit conversations.

Show active customers with a balance and no Contivio call in the last 45 days, largest balance first.

How it works

What PopdockAI does when you ask

You choose a customer class and a look-back period, and your AI assistant compares Dynamics GP with Contivio. It only reads and will not call every customer uncontacted if Contivio returns nothing.

Ask

You give an optional customer class and how many days to look back, which defaults to 90.

Your AI tool

Read

It reads active Dynamics GP customers, up to 50, with phone, balance and salesperson.

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

Match

It matches Contivio calls to customers by the digits of the phone number.

No items found.

Report

You get customers with no calls, largest balance first, and a count of those called.

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

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

Know which valuable customers to call next

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