Connectors

/

Stripe

/

Reconcile Stripe refunds and disputes with Dynamics GP
Report
Cross-Connector

Find Stripe refunds and lost disputes missing from Dynamics GP

For receivables teams who want every Stripe refund and lost dispute checked for a Dynamics GP credit by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Stripe refunds and disputes with Dynamics GP
Check that Stripe refunds and lost disputes from September have credit memos in Dynamics GP.
21 of 24 Stripe refunds and lost disputes from September have a credit in Dynamics GP. - Missing: refund of 480.00 on INV-1042 for Contoso - Missing: lost dispute of 1,150.00 on INV-1051 - By customer: 1 refund with no invoice link, matched on customer, date and amount - Open disputes: 3, counted but not chased Want the missing items listed for credit memos?
Stripe
Sample figures. Your results come from your own account.
stripe-get-refund
stripe-get-dispute
stripe-get-charge
stripe-get-invoice
microsoft-dynamics-gp-get-rm-trx-apply
microsoft-dynamics-gp-get-rm-trx

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

Refunds and lost disputes missing from GP

Every Stripe refund and lost dispute should have a credit memo or return in Dynamics GP, but they are recorded by different people at different times. Checking means tracing each refund to its invoice and searching GP for the credit, and a missed one overstates receivables.

Without PopdockAI

  • List Stripe refunds and lost disputes
  • Trace each through its charge to the invoice
  • Search GP for credits applied to that invoice
  • Compare partial refunds against the right amount

With PopdockAI

  • Successful refunds and lost disputes are read for the range
  • Each is traced through its charge to the original invoice
  • GP credits applied to that invoice are found, with a stated fallback
  • Partial refunds compare to the refund amount, 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:** Check that every successful Stripe refund, and every lost Stripe dispute, created from `{start-date}` to `{end-date}` has a matching credit memo or return in Dynamics GP company `{company}` (empty means the default company).

**Step 1: Read Stripe refunds and disputes**

Call `stripe-get-refund` with `status` = `succeeded`, `created-date.from` = `{start-date}` and `created-date.to` = the day after `{end-date}`. Call `stripe-get-dispute` over the same range and keep only disputes with status `lost`. Drop anything created after `{end-date}`. For each, keep the amount, currency, reason, `charge-id` and the customer name and email.

**Step 2: Find the original invoice**

For each refund or dispute, call `stripe-get-charge` with `charge-id`, and read its `invoice-id`. When there is one, call `stripe-get-invoice` with `invoice-id` to get the invoice `number`.

**Step 3: Look in GP**

If you have an invoice number, call `dynamics-gp-get-rm-trx-apply` with `applied-to-document-number` = that number to see credits and returns applied to it. Otherwise, or if nothing is applied, call `dynamics-gp-get-rm-trx` with `customer-name.contains` = the Stripe customer name, `document-date.from` / `document-date.to` set to the refund or dispute date plus or minus 7 days, and `document-amount.min` / `document-amount.max` both equal to the Stripe amount. Keep only credit memo and return document types.

**Step 4: Report**

A summary first: refunds read, lost disputes read, matched in GP, not found in GP, and the total amount not found. Then a table: Stripe ID (refund or dispute), date, customer, amount, reason, Stripe invoice number, GP document number and type (or blank), Note. List the ones not found in GP last.

**Rules & Guidelines:**

* `stripe-get-refund`, `stripe-get-dispute`, `stripe-get-charge` and `stripe-get-invoice` are on the stripe server. `dynamics-gp-get-rm-trx-apply` and `dynamics-gp-get-rm-trx` are on the dynamics-gp server.
* This prompt is read-only. Do not call `dynamics-gp-rm-trx-add` or any other dynamics-gp tool whose name does not start with dynamics-gp-get-.
* Open disputes (not yet won or lost) are not a GP problem yet. Count them in the summary, but do not look them up.

**Validation:**

* If Stripe returns no refunds and no lost disputes, say so and stop.
* A partial refund may be matched by a GP credit memo for the same amount rather than the invoice total. Compare with the refund amount, never the invoice total.
* If a charge has no invoice, say that the match relied on customer, date and amount.

Who it's for

One answer, three teams that use it

Accounts receivable

Enter the credits GP is missing

Missing credits come with amounts and the invoice they belong to.

Check that Stripe refunds and lost disputes from October have credit memos in Dynamics GP.

Controllers

Keep receivables accurate at close

Refunds and lost disputes missing from GP are found before they overstate the balance.

What Stripe refunds last month are missing from Dynamics GP, and how much do they total?

Billing specialists

Handle partial refunds correctly

Partial refunds are compared to the refund amount, never the full invoice, so matches are right.

Match this quarter's partial Stripe refunds to credits in Dynamics GP.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant traces each Stripe refund and lost dispute to Dynamics GP. It only reads and counts open disputes without chasing them.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads successful Stripe refunds and lost disputes.

stripe-get-refund
stripe-get-dispute

03

Trace

It follows each to the original invoice and looks for GP credits applied to it.

stripe-get-charge
stripe-get-invoice
microsoft-dynamics-gp-get-rm-trx-apply
microsoft-dynamics-gp-get-rm-trx

04

Report

You get missing credits with amounts, and open disputes counted.

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

stripe-get-refund

Returns refunds (charge, customer, amount, reason, status) from Stripe.
get-data

stripe-get-dispute

Returns disputes (charge, amount, reason, status, evidence due date) from Stripe.
get-data

stripe-get-charge

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

stripe-get-invoice

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

microsoft-dynamics-gp-get-rm-trx-apply

Returns receivables apply records from Dynamics GP Receivables/Sales, showing which payments and credits were applied to which invoices and for how much. Filter by customer name, document date, amount applied, document number, document type, applied to document type, customer ID and applied to document number, and pick the company and the maximum number of records.
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.
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

Missing credits found before close

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