/
/
Find BigCommerce orders missing from Dynamics GP
For finance teams who want web orders and the ERP to agree, by asking their AI assistant to compare them.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Web orders missing from GP surface when the books fail to tie
BigCommerce orders that never reached Dynamics GP are found only when a customer complains or the books fail to tie. Checking by hand means searching GP for each order number and comparing amounts on both sides.
Without PopdockAI
- Export orders from BigCommerce
- Search Dynamics GP by customer PO for each one
- Compare document amounts with order totals
- Find the gap when the books do not tie
With PopdockAI
- Orders since your start date are listed, up to your limit
- Each order number is looked up in GP by customer PO number
- Missing orders and amount differences over a cent are flagged
- A warning appears if GP seems to use another numbering, 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 created on or after `{since-date}` (YYYY-MM-DD) with status `{order-status}` (default: any) that have no sales document in Dynamics GP, checking at most `{max-orders}` orders (default 50).
**Step 1: List the orders**
Call `bigcommerce-get-order` (bigcommerce server) with `date-created.from` set to `{since-date}`, `max-records` set to the order limit and, when `{order-status}` is given, `status` set to it. Keep `id`, `date-created`, `total-including-tax`, `customer-id`, `billing-email` and `payment-status`.
**Step 2: Check each order in Dynamics GP**
For each order call `dynamics-gp-get-rm-sales-trx` (dynamics-gp server) with `customer-po-number` set to the order id. Record the order as found (with `sop-number` and `document-amount`) or missing.
**Step 3: Report**
Missing orders: id, date, total, billing email, payment status, oldest first. Found orders whose `document-amount` differs from `total-including-tax` by more than 0.01: id, both amounts. Counts: checked, found, missing, amount mismatches.
**Rules & Guidelines:**
* `bigcommerce-*` tools run on the bigcommerce server and `dynamics-gp-*` tools on the dynamics-gp server. Both servers must be connected.
* Where a GP tool takes `company`, pass `{gp-company}` when it is given; if it is empty, omit `company`.
* This prompt is read-only. Never call any `bigcommerce-*-add`, `-update` or `-delete` tool, and never call any `dynamics-gp-*-add`, `-update` or `-note` tool.
**Validation:**
* If BigCommerce returns no orders, say so and stop.
* Matching relies on the GP customer PO number holding the BigCommerce order id; if almost every order shows as missing, say the GP side probably uses another convention.
Who it's for
One answer, three teams that use it
Accountants
Tie the store to the books
Orders with no GP document are listed before they throw out month end.
Which BigCommerce orders since 1 September have no Dynamics GP sales document?
Order operations
Fix amounts that changed
Found orders whose GP amount differs from the store total are flagged for review.
Show BigCommerce orders from the last 14 days whose Dynamics GP amount does not match.
Integration specialists
Check the numbering convention
If almost every order looks missing, the warning points to a reference problem rather than lost orders.
Check 30 Shipped BigCommerce orders from last week against Dynamics GP.
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant checks each BigCommerce order for a Dynamics GP sales document. It only reads both systems.
01
Ask
You give a start date and optionally an order status and a limit.
02
List
It reads matching BigCommerce orders.
03
Check
It looks each order number up in Dynamics GP and compares the document amount with the order total.
04
Report
It lists missing orders, amount mismatches and counts of checked, found and missing.
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
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
Missing web orders and amount mismatches, found early
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)
