Connectors

/

Microsoft Dynamics GP

/

Check Dynamics GP overdue customers for Contivio calls
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Dynamics GP overdue customers for Contivio calls
Which Dynamics GP customers with a balance over 1,000 are overdue as of today, and have they been called in the last 14 days?
14 customers are overdue in Dynamics GP with a balance over 1,000, and 5 have no Contivio call in the last 14 days. - Not contacted: Fabrikam Inc, balance 18,200, overdue 9,400, oldest due 3 Sep - Not contacted: Adventure Works, balance 6,750, overdue 6,750, oldest due 20 Sep - Contacted: Contoso Ltd, overdue 12,300, 2 calls, last on 2 Nov, Promised to pay - All 14 fit within the 20 customer cap, so none were left out Want the full table?
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

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.

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

Your AI tool

Find

It finds Dynamics GP customers with overdue invoices and a balance above the minimum.

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

Match

It checks Contivio for calls to each of up to 20 customers, highest balance first.

No items found.

Report

You get a table with uncontacted customers first, and how many were left out.

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

No overdue customer missed, none called twice

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