Connectors

/

BigCommerce

/

Trace a BigCommerce order to its Dynamics GP sales document
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Trace a BigCommerce order to its Dynamics GP sales document
Trace BigCommerce order 10482 into Dynamics GP and tell me if the sales document agrees with it.
Differs. Order 10482 is in Dynamics GP as sales document SOP-30045, but one line is off. - Total: BigCommerce 1,245.00, GP 1,245.00, tax 99.60 in both - Line NW-TEA-250: quantity 6 in BigCommerce, 5 in GP - Line only in BigCommerce: none - Line only in GP: none Want the unit price comparison for each line?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
bigcommerce-get-order-product
microsoft-dynamics-gp-get-rm-sales-trx
microsoft-dynamics-gp-get-rm-sales-line-item

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

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.

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

Your AI tool

02

Read

It reads the order and its lines from BigCommerce.

bigcommerce-get-order
bigcommerce-get-order-product

03

Find

It finds the GP sales document by customer PO number and reads its lines.

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

04

Report

You get header and line comparisons and a verdict.

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.
get-data

bigcommerce-get-order-product

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

microsoft-dynamics-gp-get-rm-sales-line-item

Returns sales document lines from Dynamics GP Sales Order Processing, with the customer, item, quantity, prices and costs of each line. Filter by location code, SOP type, item number, SOP number, customer name, customer ID, item description and extended price, and pick the company and the maximum number of records.
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

A clear verdict on every web order in 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