Connectors

/

Microsoft Dynamics GP

/

Trace a customer across Dynamics GP and Stripe
Report
Cross-Connector

Get one account picture across GP and Stripe

For finance teams who want a customer's Dynamics GP balance and Stripe billing side by side before a call, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Trace a customer across Dynamics GP and Stripe
Trace Northwind Traders across Dynamics GP and Stripe before I call them.
Northwind Traders is on hold in Dynamics GP while Stripe keeps billing. - Dynamics GP: 8,400 balance, on credit hold, limit 10,000 - Stripe: 1 active subscription, 1 open invoice of 499 - Failed charges: 2 in the last 90 days - Disputes: none Want the full account picture?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
stripe-get-customer
microsoft-dynamics-gp-get-rm-trx
stripe-get-subscription
stripe-get-invoice
stripe-get-charge
stripe-get-dispute

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

GP has them on hold while Stripe keeps billing

When a customer calls about their account, the answer is split between Dynamics GP and Stripe. You switch screens for balances, subscriptions and failed charges, and miss that GP has them on hold while Stripe keeps billing.

Without PopdockAI

  • Check the GP balance, limit and hold status
  • Search Stripe for the same customer
  • Review subscriptions, open invoices and failed charges
  • Miss where the two systems disagree

With PopdockAI

  • The customer is found in both, with candidates listed if several match
  • GP balance and documents sit beside Stripe subscriptions and charges
  • Failed charges from 90 days and disputes are included
  • Disagreements are listed, and nothing is written

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build one view of customer `{customer}` (a GP customer ID, an email address or a name) across Dynamics GP company `{company}` (empty means the default company) and Stripe, and report where the two systems agree and where they do not.

**Step 1: Find the customer in GP**

If `{customer}` looks like an email address, skip to Step 2 and come back here with the name Stripe gives you. Otherwise call `dynamics-gp-get-rm-customer` with `customer-id` = `{customer}`, and if that returns nothing, with `customer-name.contains` = `{customer}`. If more than one GP customer matches, list them and stop. Keep `customer-id`, `customer-name`, `main-email-address`, `customer-balance`, `credit-limit-amount`, `hold` and `payment-terms-id`.

**Step 2: Find the customer in Stripe**

Call `stripe-get-customer` with `email` = the GP `main-email-address`, or with `{customer}` itself when it is an email. If that returns nothing, call it with `name` = the GP `customer-name`. If more than one Stripe customer matches, list them and stop. Keep the Stripe `customer-id`, `email`, `balance` and `delinquent`.

**Step 3: Gather both sides**

From Dynamics GP: call `dynamics-gp-get-rm-trx` with `customer-id` = the GP customer ID, for documents with a `current-transaction-amount` above zero. From Stripe, each filtered by the Stripe `customer-id`: `stripe-get-subscription`, `stripe-get-invoice` with `status` = `open`, `stripe-get-charge` with `status` = `failed` over the last 90 days, and `stripe-get-dispute`.

**Step 4: Report**

A header naming the customer in both systems with both IDs. Then: GP balance and credit limit next to the total of Stripe open invoices; active subscriptions with their renewal dates; failed charges with their `failure-message`; open disputes with `details-due-by`; and GP open documents with their due dates. Finish with a short list of things that disagree (for example, GP on hold while Stripe keeps billing, or GP owed nothing while Stripe shows open invoices).

**Rules & Guidelines:**

* `dynamics-gp-get-rm-customer` and `dynamics-gp-get-rm-trx` are on the dynamics-gp server. The stripe-get tools are on the stripe server.
* This prompt is read-only. Do not call `dynamics-gp-rm-customer-update`, `dynamics-gp-rm-customer-note` or any other dynamics-gp tool whose name does not start with dynamics-gp-get-.

**Validation:**

* If the customer is in only one system, report that side in full and say plainly that there is no match on the other.
* If Stripe needs a customer ID for a call and you do not have one, skip that call and say so.

Who it's for

One answer, three teams that use it

Accounts receivable

Answer a billing call with both sides

GP balances and Stripe charges together mean you answer the customer without putting them on hold.

Trace customer billing@contoso.com across Dynamics GP and Stripe.

Credit controllers

Spot conflicting account states

A GP hold with an active Stripe subscription is called out, so the two can be aligned.

Is Fabrikam on hold in Dynamics GP while still being charged in Stripe?

Customer success managers

Check for failed charges and disputes

Failed charges and disputes from Stripe are shown with the GP balance before a renewal call.

Any failed charges or disputes for Northwind Traders in Stripe, and what do they owe in GP?

How it works

What PopdockAI does when you ask

You give a customer ID, email or name, and your AI assistant builds one account picture across Dynamics GP and Stripe. It reads both and writes nothing.

01

Ask

You give a GP customer ID, an email or a name.

Your AI tool

02

Find

It finds the customer in both systems, listing candidates if several match.

microsoft-dynamics-gp-get-rm-customer
stripe-get-customer

03

Gather

It reads the GP balance and documents and Stripe subscriptions and charges.

microsoft-dynamics-gp-get-rm-trx
stripe-get-subscription
stripe-get-invoice
stripe-get-charge
stripe-get-dispute

04

Report

You get both sides and the points where they disagree.

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

stripe-get-customer

Returns customer records (name, email, balance, delinquency, address) from Stripe.
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

stripe-get-subscription

Returns subscriptions (customer, status, billing period, cancellation, trial) from Stripe.
get-data

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
get-data

stripe-get-charge

Returns charges (amount, status, refunds, customer, card used) from Stripe.
get-data

stripe-get-dispute

Returns disputes (charge, amount, reason, status, evidence due date) from Stripe.
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

One account picture before the call

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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