/
/
Check BigCommerce refunds against Business Central credit memos
For finance teams who want refunded store orders checked against Business Central credit memos by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Refunds without credit memos overstate revenue
At month end finance compares BigCommerce refunds with Business Central credit memos by hand. A refund with no credit memo overstates revenue, and an order that was never invoiced looks like a gap when it is not.
Without PopdockAI
- Export refunded orders from BigCommerce
- Search Business Central for a credit memo for each
- Check whether the sale was ever invoiced
- Hunt for memos filed under another reference
With PopdockAI
- Refunded orders since your start date are listed
- A posted credit memo is looked for, then the original invoice
- Each order is marked Matched, Amount differs, Missing or Never invoiced
- One cent of rounding is allowed, 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:** Find BigCommerce orders with a refund since `{since-date}` (default: 30 days ago, YYYY-MM-DD) and check that Business Central company `{company}` (omit when the tenant has one company) has a credit memo for each.
**Step 1: List refunded orders**
Call `bigcommerce-get-order` with `refunded-amount.min` = 0.01, `date-modified.from` = `{since-date}` and `max-records` = 100. If nothing returns, say so and stop.
**Step 2: Look for the credit memo**
For each order, call `business-central-get-posted-sales-credit-memo` with `external-document-number` = the order `id`. If nothing returns, call `business-central-get-posted-sales-invoice` with `external-document-number` = the order `id` to see whether the sale was ever invoiced; if it was, `business-central-get-posted-sales-credit-memo` with `sell-to-customer-number` = that invoice's `sell-to-customer-number` and `total-amount-including-tax.min` / `.max` bracketing the refund amount can find a credit memo filed under a different reference.
**Step 3: Report**
A table: order id, refunded-amount, credit memo number and amount (or "none"), difference, and a Status of Matched, Amount differs, Missing credit memo, or Never invoiced. End with the counts and total refunded value with no credit memo.
**Rules & Guidelines:**
* Tools whose names start with bigcommerce- are on the bigcommerce server; tools whose names start with business-central- are on the business-central server. Both must be connected.
* Read-only: do not call any `-add`, `-update`, `-delete`, `-create` tool on either server.
**Validation:**
* Allow a one-cent rounding difference between refunded-amount and the credit memo amount.
* A partial refund can legitimately have a smaller credit memo; show both amounts instead of calling it wrong.
* An order never invoiced in Business Central needs no credit memo; label it, do not count it as missing.Who it's for
One answer, three teams that use it
Accountants
Close the month with refunds accounted for
The refunded value with no credit memo tells you what still needs posting.
Check BigCommerce refunds since 1 September against Business Central credit memos.
Finance controllers
Know how much revenue is overstated
Counts and totals by status give you the size of the gap in one line.
How much in BigCommerce refunds this quarter has no Business Central credit memo?
Accounts receivable
Fix amount differences on memos
Partial refunds show both amounts, so you can correct memos that do not match.
Which BigCommerce refunds since 1 August have a Business Central credit memo for a different amount in company CRONUS?
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant checks each BigCommerce refund against Business Central. Never invoiced orders are kept apart from real gaps.
01
Ask
You give a start date and optionally a company.
02
Read
It lists BigCommerce orders with a refund since that date.
03
Match
It looks for a posted credit memo for each, and checks whether the sale was invoiced.
04
Report
It shows a status per order, counts and the refunded value with no credit memo.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-order
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
Refunds with no credit memo 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)
