Connectors

/

Microsoft Dynamics GP

/

Compare Dynamics GP service calls with Contivio calls
Report
Cross-Connector

Find phone calls that never became Dynamics GP service calls

For service operations teams who ask their AI assistant whether a customer's Contivio calls were logged as Dynamics GP service calls.

Try PopdockAI free
Get a live demo
Compare Dynamics GP service calls with Contivio calls
For Dynamics GP customer ADVANCED0001, compare service calls with Contivio phone calls since 1 September.
Of 9 Contivio calls from ADVANCED0001, 5 match a service call and 4 have no service call. - Matched: 5 service calls each with a phone call on the same day or the day before - Service calls with no phone call: 1 - Phone calls with no service call: 4, for example an inbound call on 14 Sept about a pump fault, agent Maria There may be problems reported by phone that were never logged. Dates can differ by time zone, so a one-day gap was treated as a match. Want the four calls in full?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-srv-service-call
contivio-get-call
microsoft-dynamics-gp-get-rm-customer

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

Problems reported by phone go unlogged

Nobody checks whether customer calls became service calls. Comparing the two lists by hand is slow, and date and time zone differences make real matches look like gaps.

Without PopdockAI

  • List the customer's service calls in Dynamics GP
  • List their phone calls in Contivio
  • Look up the customer's phone number when calls are not keyed to the id
  • Pair calls and service calls by date by hand

With PopdockAI

  • Service calls and phone calls are read in one request
  • The customer's phone number is used when calls are not keyed to the id
  • A one-day date difference counts as a match and is mentioned
  • Three lists show matches, unlogged calls and service calls with no call

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 customer `{customer-id}`, reconcile Dynamics GP field service calls entered since `{since-date}` (default: 60 days ago) against Contivio phone calls in the same period.

**Step 1: Service calls (Dynamics GP)**

Call `dynamics-gp-get-srv-service-call` with `customer-id` set to `{customer-id}` and `entry-date.from` set to `{since-date}`. Keep `service-call-number`, `entry-date`, `service-call-status`, `priority-level` and `service-description`.

**Step 2: Phone calls (Contivio)**

Call `contivio-get-call` with `customer-id` set to `{customer-id}` and `start-time.from` set to `{since-date}`. If that returns nothing, call `dynamics-gp-get-rm-customer` with `customer-id` for `phone-1`, then call `contivio-get-call` without `customer-id`, keeping calls whose `from` or `to` matches that phone number.

**Step 3: Match**

Pair each service call with Contivio calls made on the same day as its `entry-date` or the day before. Produce three lists: service calls with a matching phone call, service calls with no phone call, and phone calls with no service call (include `ai-short-summary` and `agent`).

**Step 4: Report**

Show the three lists and one line on the likely gap, for example inbound calls about a problem that never became a service call.

**Rules & Guidelines:**

* `contivio-get-call` is on the Contivio server; `dynamics-gp-get-srv-service-call` and `dynamics-gp-get-rm-customer` 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 either side returns nothing, say so and still list the other side.
* Dates may differ by time zone; treat a one-day difference as a match and mention it.

Who it's for

One answer, three teams that use it

Service managers

Check that phoned problems get logged

See which customer calls never became a service call, so field work is not missed.

Which Contivio calls from customer ADVANCED0001 in the last 60 days have no Dynamics GP service call?

Dispatchers

Confirm a service call has a customer call behind it

Find service calls with no matching phone call, to see where records were entered without a call.

For customer FABRIKAM01, which service calls since 1 October have no Contivio call on the same day?

Customer service leads

Spot a gap in call handling

Read the agent and call summary on unlogged calls to coach the team on logging service requests.

List the unlogged Contivio calls for customer CONTOSO01 since 1 September, with agent and summary.

How it works

What PopdockAI does when you ask

You give the customer id and a start date, and your AI assistant reads Dynamics GP and Contivio. It only reads, and it still lists one side when the other returns nothing.

Ask

You give the customer id and a start date, or leave it at 60 days.

Your AI tool

Service calls

It reads the customer's service calls in Dynamics GP.

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

Phone calls

It reads their Contivio calls, using the customer's phone number if none are keyed to the id.

No items found.

Match

It pairs calls within a day and shows matches, service calls with no phone call and phone calls with no service call.

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-srv-service-call

Returns service call records from Dynamics GP Field Service, including customer, service type, status, technician, priority and totals. Filter by total, service type, customer ID, office ID, service call status, name, priority level and service call number, 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.
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.
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

Catch reported problems that were never logged

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