/
/
Trace a BigCommerce order into PowerGP Online sales
For finance teams who want to confirm a web order reached Dynamics GP by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Hoping the PO field holds the order number
To confirm a BigCommerce order reached GP, finance searches sales documents by customer and date and hopes the PO field holds the order number. Totals and statuses are compared by eye, and nobody is sure whether it was invoiced or paid.
Without PopdockAI
- Open the order in BigCommerce
- Search GP sales documents by customer and date
- Compare totals and status by eye
- Check receivables for payment separately
With PopdockAI
- The order status, payment, total and lines are read
- GP sales documents are searched for a customer PO equal to the order number
- Amount, status and invoice state are compared
- Close candidates are labelled unconfirmed, 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:** For BigCommerce order `{order-id}`, find the matching sales document in GP company `{company}` and compare totals and status.
**Step 1: Read the store order (bigcommerce server)**
Call `bigcommerce-get-order` with `id` set to `{order-id}`. Keep `date-created`, `status`, `payment-status`, `total-including-tax`, `billing-last-name`, `billing-email`. Call `bigcommerce-get-order-product` with `order-id` for the lines (`sku`, `quantity`).
**Step 2: Find the GP document (powergp-online-ai server)**
Call `powergp-online-get-salesdocuments` with `company` set to `{company}`, `document-date.from` set to the order date minus 7 days, and `customer-name.contains` set to the billing last name. Look in the results for a `customer-po` equal to the order id. If none matches by `customer-po`, say that the order id is not recorded in GP and offer the closest candidates by date and amount, labelled as unconfirmed.
**Step 3: Compare**
For the matched document read `document-amount`, `sop-document-status`, `document-number`. Then call `powergp-online-get-receivablestransactions` with the `customer-number` from the document to show whether an invoice exists and whether it is paid.
**Step 4: Report**
Side by side: store order (status, payment, total, lines) and GP document (type, status, amount, invoice state). State the difference in total and whether the statuses are consistent.
**Rules & Guidelines:**
* `powergp-online-*` tools belong to the powergp-online-ai server (Dynamics GP). `bigcommerce-*` tools belong to the bigcommerce server (online store). Both servers and this prompt server must be connected.
* This prompt is read-only. Call only `get` tools. Never call any `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tool.
* Query only the GP company given in `{company}`; never mix companies.
* Show at most 25 rows per table and say how many more there are.
**Validation:**
* Order not found in the store: stop.
* Never present an unconfirmed candidate as a match.Who it's for
One answer, three teams that use it
Accountants
Confirm an order reached GP
The matching sales document and its total difference answer the question directly.
Was BigCommerce order 22014 entered in GP company TWO?
Accounts receivable
Check invoice and payment state
Receivables show whether the order was invoiced and whether it is paid.
Has BigCommerce order 21877 been invoiced and paid in GP company TWO?
Order operations
Investigate an order that went missing
When the order number is not in GP, close candidates are offered for you to check.
I cannot find BigCommerce order 22530 in GP company TWO. What are the closest candidates?
How it works
What PopdockAI does when you ask
You give an order number and the GP company, and your AI assistant traces the BigCommerce order into PowerGP Online. It never treats a candidate as a match.
01
Ask
You give the BigCommerce order number and the GP company.
02
Read
It reads the order status, payment, total and lines.
03
Match
It searches PowerGP Online sales documents for a customer PO equal to the order number.
04
Report
You see both side by side, with the total difference and invoice state.
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
powergp-online-get-salesdocuments
powergp-online-get-receivablestransactions
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
Entered, invoiced and paid in GP, or not
Related use cases
More ways to put this data to work
Check BigCommerce demand against PowerGP Online supply
Ask your AI to rank recent BigCommerce sales by SKU and check each against PowerGP Online stock and open purchase orders, flagging low cover without changing anything.
Learn More
Profile a customer across BigCommerce and PowerGP Online
Ask your AI for a customer profile and it combines BigCommerce orders with the PowerGP Online balance and overdue items. Name matches are labelled unconfirmed.
Learn More
Check BigCommerce web price margin against PowerGP Online cost
Ask your AI to compare BigCommerce prices with PowerGP Online current cost and list prices, and it lists products under your margin threshold. Nothing is changed.
Learn More
Compare BigCommerce stock with PowerGP Online
Ask your AI to compare BigCommerce inventory levels with PowerGP Online quantity on hand per SKU. Differences are ranked and nothing is changed in either system.
Learn More
Reconcile BigCommerce catalog to PowerGP Online items
Ask your AI to match BigCommerce SKUs to PowerGP Online item numbers and it lists items missing on either side and prices below cost. Nothing is changed.
Learn More
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.