Connectors

/

BigCommerce

/

BigCommerce and Dynamics GP customer receivables profile
Report
Cross-Connector

See BigCommerce orders next to Dynamics GP receivables

For finance teams who want a customer's store orders and Dynamics GP balance in one view, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
BigCommerce and Dynamics GP customer receivables profile
Show Northwind Traders orders from BigCommerce next to their Dynamics GP balance. Contact is dana@northwindtraders.com.
Dana Whitfield has 6 orders in the last 365 days totalling 1,840.00, with 120.00 refunded. - Dynamics GP match: Northwind Traders (name match, email agrees) - Balance: 2,310.00 against a credit limit of 2,000.00 - Hold: no - Open documents: 3 invoices, oldest from 2026-06-14 Flag: balance is over the credit limit. Want the invoice list?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
bigcommerce-get-order
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx

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

No shared customer id between the store and the ledger

Checking what an online customer ordered against what they owe means logging into BigCommerce and Dynamics GP separately. The two share no customer id, so someone has to guess which GP customer is the same company.

Without PopdockAI

  • Total orders and refunds in BigCommerce by hand
  • Search Dynamics GP by company name
  • Guess which of several similar customers is right
  • Read balance and open documents on another screen

With PopdockAI

  • Orders, refunds and unpaid orders are totalled from BigCommerce
  • Dynamics GP is searched by name, preferring a matching email
  • You choose when several GP customers match
  • Name-only matches are labelled, 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:** Build a combined sales and accounts-receivable profile for the BigCommerce customer with email `{email}`, looking at orders from the last `{lookback-days}` days (default 365).

**Step 1: Find the customer in BigCommerce**

Call `bigcommerce-get-customer` (bigcommerce server) with `email` set to `{email}`. If nothing matches, report that the customer is not in BigCommerce and stop. Keep `id`, `name`, `company` and `email`.

**Step 2: Get their orders**

Call `bigcommerce-get-order` (bigcommerce server) with `customer-id` set to the customer id and `date-created.from` set to the start of the lookback window. Total the order count and `total-including-tax`, total `refunded-amount`, and note the latest `date-created` and any `payment-status` that is not paid.

**Step 3: Find the customer in Dynamics GP**

The two systems share no id, so match on name. Call `dynamics-gp-get-rm-customer` (dynamics-gp server) with `customer-name.contains` set to the BigCommerce `company` (or `name` when company is empty). If more than one customer matches, list them (`customer-id`, `customer-name`, `city`, `main-email-address`), prefer the one whose `main-email-address` equals `{email}`, and if still ambiguous stop and ask. If none match, report the customer as present in BigCommerce and absent from Dynamics GP and skip to Step 5. Keep `customer-id`, `customer-balance`, `credit-limit-amount`, `hold`, `inactive` and `payment-terms-id`.

**Step 4: Get open receivables**

Call `dynamics-gp-get-rm-trx` (dynamics-gp server) with `customer-id` set to the GP customer id. Total `document-amount` by `document-type` and list the oldest documents.

**Step 5: Report**

One block per system: BigCommerce (customer, order count, revenue, refunds, last order) and Dynamics GP (customer id, balance, credit limit, hold flag, open documents). Close with flags: customer on hold in GP but still ordering, balance above credit limit, unpaid BigCommerce orders against a GP balance of zero.

**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 in the window, say so and still report the GP side.
* If the GP match was made on name alone, say it was a name match and not an id match.

Who it's for

One answer, three teams that use it

Credit controllers

See orders and balance before extending credit

Balance, credit limit and hold flag sit beside recent orders, so a credit call takes one question.

Show Contoso orders in BigCommerce and their Dynamics GP balance and credit limit. Email is ap@contoso.com.

Collections specialists

Prepare for a collection call

Open receivable documents and unpaid store orders appear together, so you know what to ask about.

What does lee@fabrikam.com owe in Dynamics GP, and which of their BigCommerce orders are unpaid?

Customer service leads

Spot customers on hold who keep ordering

Flags such as on hold but still ordering are raised so the team can act before shipping.

Is Northwind Traders on hold in Dynamics GP while still ordering on BigCommerce? Contact is dana@northwindtraders.com.

How it works

What PopdockAI does when you ask

You give a customer email and your AI assistant puts their BigCommerce orders beside their Dynamics GP receivables. It asks you to pick when the GP match is not clear.

01

Ask

You give the customer email and an optional lookback.

Your AI tool

02

Orders

It totals BigCommerce orders, refunds and unpaid orders for the customer.

bigcommerce-get-customer
bigcommerce-get-order

03

Match

It searches Dynamics GP by name and asks you if several customers match.

microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx

04

Report

You get both blocks and flags such as on hold but still ordering.

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-customer

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

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-trx

Returns receivables transactions such as invoices, payments and credit memos from Dynamics GP Receivables Management, including customer, dates, amounts and outstanding balances. Filter by customer ID, document type, customer name, document date, document amount, document number, batch number and void status, 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

Credit questions answered from the right account

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