/
/
Find Dynamics GP customers missing or out of balance in Stripe
For receivables teams who want Dynamics GP customers matched to Stripe and balances compared by asking their AI assistant.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
The problem
Customers and balances drift between GP and Stripe
Keeping customer records in step between Dynamics GP and Stripe means searching Stripe for each GP customer, deciding whether a name match is the same company and comparing balances by hand. Missing customers and drifting balances go unnoticed for months.
Without PopdockAI
- Search Stripe for each GP customer
- Decide whether a name match is the same company
- Total open Stripe invoices by hand
- Compare them with GP balances
With PopdockAI
- Each active GP customer is looked up in Stripe by email, then name
- Names matching several customers are listed as ambiguous
- Open Stripe invoices are totalled against the GP balance
- Differences under 1.00 are noted, 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.
**Objective:** Match Dynamics GP customers in company `{company}` (empty means the default company), limited to customer class `{customer-class}` when given, to Stripe customers, and report who is in one system only and whose balances disagree.
**Step 1: Read the GP customers**
Call `dynamics-gp-get-rm-customer` with `inactive` = false, `company` = `{company}` and, when given, `customer-class` = `{customer-class}`. Keep `customer-id`, `customer-name`, `main-email-address`, `customer-balance` and `hold`.
**Step 2: Find each one in Stripe**
For each GP customer with a `main-email-address`, call `stripe-get-customer` with `email` = that address. If nothing comes back, or the GP customer has no email, call `stripe-get-customer` with `name` = the GP `customer-name`. Compare emails without regard to case or surrounding spaces. If a name search returns more than one Stripe customer, list them all as ambiguous rather than choosing one.
**Step 3: Compare balances**
For each matched customer, call `stripe-get-invoice` with `customer-id` = the Stripe `customer-id` and `status` = `open`, and add up `amount-remaining`. Compare that with the GP `customer-balance`.
**Step 4: Report**
A summary first: GP customers read, matched by email, matched by name only, ambiguous, not in Stripe. Then a table of matches with GP customer ID, name, email, GP balance, Stripe open amount, Stripe `delinquent`, and a Note on any difference. Then a list of GP customers not found in Stripe. Note that Stripe customers who are not in GP are not covered here; use `backfill-stripe-customers` for that direction.
**Rules & Guidelines:**
* `dynamics-gp-get-rm-customer` is on the dynamics-gp server. `stripe-get-customer` and `stripe-get-invoice` are on the stripe server.
* This prompt is read-only. Do not call `dynamics-gp-rm-customer-add`, `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-.
* An email match wins over a name match. Never treat a match on name alone as certain.
**Validation:**
* If GP returns no customers, say so and stop.
* If GP returns more than 200 customers, work through the first 200, say how many were left out, and suggest narrowing by customer class.
* A small balance difference can be timing. Report differences of any size, but say which are under 1.00.Who it's for
One answer, three teams that use it
Accounts receivable
Find balances that disagree
Open Stripe invoices against GP balances show where one system is wrong.
Reconcile our Dynamics GP customers in class RETAIL with Stripe and compare balances.
Master data analysts
Find customers in one system only
Customers missing from either side are listed, ready to set up or retire.
Which active Dynamics GP customers have no Stripe customer?
Controllers
Separate real matches from guesses
Email matches are kept apart from name matches, so you know which comparisons to trust.
Show GP customers that matched Stripe only by name, with their balances.
How it works
What PopdockAI does when you ask
You name the GP company, and your AI assistant matches each customer to Stripe and compares balances. It only reads and keeps email matches separate from guesses.
01
Ask
You name the GP company, and optionally a customer class.
02
Match
It looks up each active GP customer in Stripe by email, then by name.
03
Compare
It totals open Stripe invoices against the GP balance.
04
Report
You get one-sided, ambiguous and out-of-balance customers.
What PopdockAI provides
The tools behind the answer
Ready made tools for Stripe and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-gp-get-rm-customer
stripe-get-customer
stripe-get-invoice
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-sided and out-of-balance customers in view
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)
