Connectors

/

Shopify

/

Match Shopify refunds to Dynamics GP credit memos
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match Shopify refunds to Dynamics GP credit memos
Match the last 30 days of Shopify refunds to credit memos in Dynamics GP.
36 refunds checked, and 5 need attention. - No GP credit: 3 refunds, SKUs WT-GRY-01 and MUG-SGE-02 - Mismatch: #1042 refunded 89.00, GP credit 79.00 - Unmatched GP credit: RTN100233 - Clean matches: 31 Want the detail for each gap?
Shopify
Sample figures. Your results come from your own account.
shopify-get-refund
shopify-get-refund-line
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-sales-trx

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Read

It reads Shopify refunds and totals each one's lines and tax.

shopify-get-refund
shopify-get-refund-line

03

Match

It matches GP credit memos and returns by order name in the customer PO.

microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-sales-trx

04

Report

You get missing credits, mismatches, unmatched GP credits and clean matches.

Your AI tool

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.

get-data

shopify-get-refund

Returns Shopify refunds with their order and total adjustments. Filter by order, customer, customer email, refund and created date.
get-data

shopify-get-refund-line

Returns the line items on Shopify refunds, with the subtotal and how each was restocked. Filter by refund, order, SKU, name and restock type.
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.
get-data

microsoft-dynamics-gp-get-rm-sales-trx

Returns Sales Order Processing documents such as quotes, orders and invoices from Dynamics GP Sales, with the customer, dates, salesperson and document totals. Filter by batch number, customer ID, SOP type, SOP number, salesperson ID, document amount, customer name and document date, and pick the company and the maximum number of records.
Read only.Nothing in Shopify 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

Every refund accounted for in Dynamics GP

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