/
/
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.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
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.
**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.
02
Read
It reads successful Stripe refunds and lost disputes.
03
Trace
It follows each to the original invoice and looks for GP credits applied to it.
04
Report
You get missing credits with amounts, and open disputes counted.
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.
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
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
Missing credits found before close
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)
