/
/
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.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
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.
**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.
02
Find
It finds the customer in both systems, listing candidates if several match.
03
Gather
It reads the GP balance and documents and Stripe subscriptions and charges.
04
Report
You get both sides and the points where they disagree.
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.
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
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.
The outcome
One account picture before the call
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.

.webp)
