/
/
Find where a BigCommerce order landed in Dynamics GP
For finance teams who want a web order compared with its Dynamics GP sales document, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
A web order keyed with a changed line goes unnoticed
Finding where a BigCommerce order landed in Dynamics GP, and whether totals and lines agree, is a manual hunt across two systems. The order may have been keyed with another reference, or with a changed quantity or price.
Without PopdockAI
- Open the order and lines in BigCommerce
- Search GP sales documents by customer PO
- Compare totals and tax by hand
- Check every line for quantity and price
With PopdockAI
- The order and lines are read from BigCommerce
- The GP sales document is found by customer PO, using the closest amount if several match
- Totals, tax and lines are compared by SKU and item number
- A verdict closes the report, 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:** Trace BigCommerce order `{order-id}` into Dynamics GP and report whether the sales document exists and agrees with the order.
**Step 1: Read the order**
Call `bigcommerce-get-order` (bigcommerce server) with `id` set to `{order-id}`. If nothing matches, report that and stop. Keep `customer-id`, `total-including-tax`, `total-tax`, `date-created`, `billing-email` and `status`.
**Step 2: Read the order lines**
Call `bigcommerce-get-order-product` (bigcommerce server) with `order-id` set to `{order-id}`. Keep `sku`, `quantity` and `price-excluding-tax` per line.
**Step 3: Find the sales document in Dynamics GP**
The convention is that the GP customer PO number holds the BigCommerce order id. Call `dynamics-gp-get-rm-sales-trx` (dynamics-gp server) with `customer-po-number` set to `{order-id}`. If nothing comes back, report the order as present in BigCommerce and absent from Dynamics GP and stop. If several come back, list them and use the one whose `document-amount` is closest to the order total. Keep `sop-number`, `sop-type`, `customer-id`, `document-amount`, `tax-amount` and `posting-status`.
**Step 4: Read the GP lines**
Call `dynamics-gp-get-rm-sales-line-item` (dynamics-gp server) with `sop-number` and `sop-type` from Step 3. Keep `item-number`, `quantity` and `unit-price`.
**Step 5: Report**
Header comparison (total, tax) with the difference. Line comparison matching BigCommerce `sku` to GP `item-number`: lines only in BigCommerce, lines only in GP, and lines whose quantity or price differs. End with one verdict: In step, Differs, or Not in Dynamics GP.
**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 there is no PO number match, say the order may have been keyed with a different reference.
* Amounts within 0.01 are equal.
Who it's for
One answer, three teams that use it
Accountants
Confirm totals and tax agree
Header totals and tax compared side by side tell you whether the order was keyed right.
Does Dynamics GP agree with BigCommerce order 18820 on total and tax?
Order entry clerks
Find lines that changed
Lines with a different quantity or price, or on one side only, are listed for correction.
Which lines differ between BigCommerce order 19305 and its Dynamics GP sales document?
Finance managers
Check an order before month end
A verdict of in step, differs or not in GP gives a quick answer for close.
Trace BigCommerce order 20117 into Dynamics GP company TWO and give me a verdict.
How it works
What PopdockAI does when you ask
You give an order id and your AI assistant traces it into Dynamics GP line by line. It stops when either record is missing.
01
Ask
You give the BigCommerce order id and optionally the GP company.
02
Read
It reads the order and its lines from BigCommerce.
03
Find
It finds the GP sales document by customer PO number and reads its lines.
04
Report
You get header and line comparisons and a verdict.
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
bigcommerce-get-order-product
microsoft-dynamics-gp-get-rm-sales-trx
microsoft-dynamics-gp-get-rm-sales-line-item
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
A clear verdict on every web order in 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)
