Connectors

/

Stripe

/

Reconcile Stripe customers with Dynamics GP
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Stripe customers with Dynamics GP
Reconcile our Dynamics GP customers in class WHOLESALE with Stripe and compare balances.
Of 64 WHOLESALE customers in Dynamics GP, 52 match a Stripe customer. - Matched by email: 47, matched by name only: 5 - GP only: 10 customers, including Contoso - Ambiguous: Fabrikam matches 2 Stripe customers - Balances differ: 6, of which 2 are under 1.00 Want the balance differences listed by customer?
Stripe
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
stripe-get-customer
stripe-get-invoice

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Match

It looks up each active GP customer in Stripe by email, then by name.

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

03

Compare

It totals open Stripe invoices against the GP balance.

stripe-get-invoice

04

Report

You get one-sided, ambiguous and out-of-balance customers.

Your AI tool

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.

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

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
Read only.Nothing in Stripe 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-sided and out-of-balance customers in view

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