Connectors

/

BigCommerce

/

Check BigCommerce refunds against Dynamics 365 Business Central credit memos
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check BigCommerce refunds against Dynamics 365 Business Central credit memos
Check BigCommerce refunds since 1 March against Business Central credit memos.
9 refunded orders since 1 March: 6 matched, 1 amount differs, 1 missing, 1 never invoiced. - Missing credit memo: order 1042, refunded 120.00 - Amount differs: order 1051, refunded 60.00, credit memo 55.00 - Never invoiced: order 1060, no credit memo needed - Refunded value with no credit memo: 120.00 Want the full table of all 9 orders?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Read

It lists BigCommerce orders with a refund since that date.

bigcommerce-get-order

03

Match

It looks for a posted credit memo for each, and checks whether the sale was invoiced.

No items found.

04

Report

It shows a status per order, counts and the refunded value with no credit memo.

Your AI tool

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.

get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
Read only.Nothing in BigCommerce 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

Refunds with no credit memo 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