Connectors

/

Microsoft Dynamics GP

/

Review a customer's history across Dynamics GP and Dynamics 365 Business Central
Report
Cross-Connector

See one honest sales trend across GP and Business Central

For account managers who want a customer's history from Dynamics GP and Business Central joined without double counting, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review a customer's history across Dynamics GP and Dynamics 365 Business Central
Show Contoso's sales trend across Dynamics GP and Business Central. We went live on 1 July.
Contoso is buying more since go-live. - Before: 412,000 in the 12 months to 30 June in Dynamics GP - After: 148,000 in 3 months in Business Central, up 9 percent a month - Open: 2 orders and 1 invoice of 12,400 due 20 October - Changed at go-live: payment terms from Net 30 to 30 Days Want the month-by-month table?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-sales-trx
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

Microsoft Dynamics GP

Microsoft Dynamics GP
Run it on your own Microsoft Dynamics GP data.

Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

A customer's history split in two at go-live

After moving from Dynamics GP to Business Central, a customer's history is split in two. Seeing the trend means pulling sales from both by month, and migrated opening entries make it easy to count invoices twice.

Without PopdockAI

  • Pull GP sales by month up to go-live
  • Pull Business Central sales since go-live
  • Remove migrated opening entries by hand
  • Miss settings that changed at go-live

With PopdockAI

  • GP history up to go-live and Business Central since are read
  • Migrated opening entries are left out
  • Monthly sales run straight across go-live
  • Changed salesperson, terms or limit are shown, with nothing 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:** Give a single view of customer `{customer-id}` across both systems: the Dynamics GP history up to go-live on `{cutover-date}` and the Business Central activity since, starting from `{from-date}` (default 24 months before today).

**Step 1: Confirm the customer in both systems**

Call `dynamics-gp-get-rm-customer` with `customer-id` set to `{customer-id}`, and `business-central-get-customer` with `customer-number` set to `{customer-id}`. If one side has the customer and the other does not, say which, and continue with the side that has it. If neither has it, stop.

If `{cutover-date}` is empty, ask the user for the go-live date before continuing.

**Step 2: Read the GP history**

* Call `dynamics-gp-get-rm-sales-trx` with `customer-id`, `document-date.from` set to the start date and `document-date.to` set to `{cutover-date}`.
* Call `dynamics-gp-get-rm-trx` with `customer-id` and the same dates, leaving out voided documents, for invoices, credit memos and payments.

**Step 3: Read the BC activity**

* Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` and `posting-date.from` set to the day after `{cutover-date}`.
* Call `business-central-get-sales-transaction` with `sell-to-customer-number` for open orders and quotes.
* Call `business-central-get-detailed-customer-ledger` with `customer-number` and `posting-date.from` set to the day after `{cutover-date}`, for payments and credits.

BC entries posted on or before `{cutover-date}` whose document numbers match GP documents are the migrated opening balances, not new sales. Do not count them as BC activity.

**Step 4: Report**

* A header: customer name, GP salesperson, BC salesperson code, BC balance, BC credit limit.
* Sales by month, one line per month, each marked GP or BC, so the trend runs straight across go-live.
* Totals: GP sales before go-live, BC sales since, and the change in average monthly sales.
* Open BC orders and quotes, and open BC invoices with their due dates.
* Anything that changed at go-live: a different salesperson, payment terms or credit limit between the two systems.

**Rules & Guidelines:**

* `dynamics-gp-get-rm-customer`, `dynamics-gp-get-rm-sales-trx` and `dynamics-gp-get-rm-trx` are on the dynamics-gp server. `business-central-get-customer`, `business-central-get-posted-sales-invoice`, `business-central-get-sales-transaction` and `business-central-get-detailed-customer-ledger` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-update-customer`, `business-central-create-sales-order`, `business-central-create-sales-invoice` or `dynamics-gp-rm-customer-update`.
* If either system has more than one company, ask the user which GP company and which BC company to use before the first call, and pass them as `company`.

**Validation:**

* If GP has sales after `{cutover-date}`, report them separately as posted in GP after go-live; they may be missing from BC.
* If one side returns nothing for the period, report that side as having no activity rather than stopping.

Who it's for

One answer, three teams that use it

Account managers

See if a customer is buying more or less

One monthly trend across go-live shows the real direction, without double counted invoices.

Is Fabrikam buying more or less since we moved to Business Central on 1 April? Use Dynamics GP for before.

Sales managers

Review an account before a QBR

Totals before and after go-live, open orders and quotes give you the account picture for a review.

Show Northwind Traders' sales by month across Dynamics GP and Business Central for the last 18 months.

Credit controllers

Check terms and limits after go-live

Anything that changed at go-live, like terms or credit limit, is called out for you to confirm.

Did Contoso's terms or credit limit change when we moved from Dynamics GP to Business Central?

How it works

What PopdockAI does when you ask

You name the customer and the go-live date, and your AI assistant builds one trend across Dynamics GP and Business Central. It asks if the date is missing, and only reads.

01

Ask

You name the customer and the go-live date.

Your AI tool

02

Read

It reads Dynamics GP history up to go-live and Business Central activity since.

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

03

Merge

It leaves out migrated opening entries so nothing is counted twice.

No items found.

04

Report

You get monthly sales across go-live, open items and changed settings.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics GP and one secure connection to your AI tool. No code, no exports.

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-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-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 Microsoft Dynamics GP 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

One honest sales trend across both systems

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