/
/
Find Shopify refunds missing from Dynamics GP
For finance teams who want Shopify refunds matched to Dynamics GP credit memos and returns, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Shopify refunds and GP credits are never checked together
Refunds issued in Shopify should show up in Dynamics GP as credit memos or returns, but the two are rarely checked against each other. A missed refund overstates revenue and receivables, and finding it means matching order names by hand.
Without PopdockAI
- Export Shopify refunds with lines and tax
- Export GP credit memos and returns
- Match order names in the customer PO field
- Add up refunds split across documents by hand
With PopdockAI
- Shopify refunds are totalled from their lines and tax
- GP credit memos and returns are matched by order name
- Refunds split across documents are summed
- Missing credits, mismatches and unmatched GP credits are listed, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Shopify refunds created in the last `{lookback-days}` days (default 14), find the matching Dynamics GP credit memo or return, and report the refunds that are missing from GP or whose amounts differ.
**Step 1: Read the Shopify refunds**
Call `shopify-get-refund` (Shopify server) with `created-at.from` = today minus `{lookback-days}` days. Keep `refund-id`, `order-name`, `customer-email`, `created-at` and `order-id`. For each refund call `shopify-get-refund-line` (Shopify server) with `order-refund-id` = the `refund-id`, and total `subtotal` plus `total-tax` to get the refunded amount. Keep each line's `sku` and `quantity`.
**Step 2: Read Dynamics GP credit documents**
Call `dynamics-gp-get-rm-trx` (Dynamics GP server) with `document-date.from` = the same start date and `document-type` = credit memo, passing `company` = `{gp-company}` when it is given. Also call `dynamics-gp-get-rm-sales-trx` (Dynamics GP server) with the same date range and `sop-type` = return. Neither tool filters on the PO number, so match locally: a GP document matches a refund when its `customer-po-number` equals the refund's `order-name` (with or without the leading #).
**Step 3: Report**
1. Refunds with no GP credit: order name, refund date, amount, customer email, and the SKUs refunded.
2. Amount mismatches: order name, Shopify refunded amount, GP `document-amount`, difference, GP `document-number` or `sop-number`.
3. GP credit documents in the range whose PO number looks like a Shopify order name but matched no refund.
4. The count of refunds that matched cleanly.
**Rules & Guidelines:**
* Tools whose names start with shopify are on the Shopify server; tools whose names start with dynamics-gp are on the Dynamics GP server.
* This is read-only. Do NOT call `dynamics-gp-rm-trx-add`, `dynamics-gp-rm-sales-trx-add` or `dynamics-gp-srv-rma-add`.
**Validation:**
* If Shopify returns no refunds, say so and stop.
* A refund may be split across several GP documents; if two or more GP documents share the order name, compare their sum.
* If GP returns more documents than the default page, raise `max-records` rather than reporting refunds as missing.Who it's for
One answer, three teams that use it
Accounts receivable
Find refunds GP never recorded
Refunds with no GP credit are listed with the SKUs involved, ready to enter.
Which Shopify refunds from the last 14 days have no credit memo or return in Dynamics GP?
Controllers
Close with accurate receivables
Mismatches and missing credits are found before period end, so revenue is not overstated.
Match last month's Shopify refunds to Dynamics GP credits and list any amount mismatches.
Returns coordinators
See GP credits with no refund
Credits in GP that matched no Shopify refund are listed too, so you can check returns entered in error.
Are there Dynamics GP credit memos from October that match no Shopify refund?
How it works
What PopdockAI does when you ask
You set a lookback window, and your AI assistant matches each Shopify refund to Dynamics GP credits. It only reads and counts the clean matches too.
01
Ask
You set a lookback window.
02
Read
It reads Shopify refunds and totals each one's lines and tax.
03
Match
It matches GP credit memos and returns by order name in the customer PO.
04
Report
You get missing credits, mismatches, unmatched GP credits and clean matches.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-refund
shopify-get-refund-line
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-sales-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
Every refund accounted for in Dynamics GP
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)
