Connectors

/

Microsoft Dynamics GP

/

Reconcile open Dynamics GP receivables with Dynamics 365 Business Central
Report
Cross-Connector

Prove customer balances carried over, document by document

For finance teams who want open Dynamics GP receivables tied to Business Central with differences traced, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile open Dynamics GP receivables with Dynamics 365 Business Central
Reconcile open receivables between Dynamics GP and Business Central at go-live.
544 customers with a balance were compared, and 8 do not tie. - Contoso: out by 2,150, payment PMT-881 missing in Business Central - Different: 3 invoices have different amounts - Summary migration: 5 customers migrated as one balance, counted as tied - Unexplained: 40 remains on Fabrikam Want the document detail?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
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

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

Days spent proving customer balances carried over

Proving customer balances carried from Dynamics GP into Business Central means comparing every customer, then tracing each difference to documents. Payment signs differ between the systems and later activity muddies balances.

Without PopdockAI

  • Compare every customer balance across both systems
  • Flip signs on payments, credits and returns by hand
  • Line up open documents for each difference
  • Spend days explaining small gaps

With PopdockAI

  • Each customer balance is compared, optionally as of go-live
  • Open documents are lined up with signs flipped where needed
  • Summary-level migrations count as in balance
  • Unexplained remainders are reported, not guessed, with nothing written

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Prove that open receivables carried over from Dynamics GP to Business Central, for customer `{customer-id}` or, if that is empty, every GP customer with a balance. Compare balances as of `{cutover-date}` (if that is empty, compare current balances and say so).

**Step 1: Read the GP balances**

Call `dynamics-gp-get-rm-customer` with `customer-id` set to `{customer-id}` when it is given. Keep customers whose customer-balance is not zero.

**Step 2: Read the BC balances**

Call `business-central-get-customer` for the same customers and match GP `customer-id` to BC `customer-number`, trimmed and case-insensitive. When `{cutover-date}` is empty, use BC balance. When it is given, BC balance also includes activity after go-live, so for any customer whose balance differs, call `business-central-get-detailed-customer-ledger` with `customer-number` and `posting-date.to` set to `{cutover-date}`, and use the sum of amount instead.

**Step 3: Find the documents behind each difference**

For each customer whose GP and BC balances differ by more than 0.01:

1. Call `dynamics-gp-get-rm-trx` with `customer-id`, leaving out voided documents. Keep documents whose current-transaction-amount is not zero.
2. Call `business-central-get-detailed-customer-ledger` with `customer-number`. Group its rows by customer-ledger-entry-number and add up amount to get each entry's remaining amount.
3. Match GP document-number to BC document-number. The GP migration usually keeps the GP document number on the opening entry.

GP stores payments, credit memos and returns as positive amounts; BC stores them as negative. Flip the sign of those GP document types before comparing.

**Step 4: Report**

A summary line: customers compared, customers in balance, customers out of balance, total GP open AR, total BC open AR, net difference. Then, per out-of-balance customer: GP balance, BC balance, difference, and the documents that explain it (open in GP but missing from BC, in BC but not open in GP, or open in both with different remaining amounts).

**Rules & Guidelines:**

* `dynamics-gp-get-rm-customer` and `dynamics-gp-get-rm-trx` are on the dynamics-gp server. `business-central-get-customer` and `business-central-get-detailed-customer-ledger` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-journal-line`, `business-central-create-sales-invoice`, `business-central-create-sales-credit-memo` or `dynamics-gp-rm-trx-add`.
* 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 a GP customer with a balance has no BC customer, report it as a missing customer with its full balance and do not look for documents.
* If the balances differ but no single document explains it, report the unexplained remainder rather than guessing.
* Some migrations bring AR over as one summary entry per customer. If BC has one entry per customer whose amount equals the GP balance, report the customer as in balance at summary level.

Who it's for

One answer, three teams that use it

AR managers

Start collections from the right balances

Each customer ties or comes with the documents that explain why, so dunning starts on correct numbers.

Reconcile open receivables for all customers between Dynamics GP and Business Central at go-live.

Migration leads

Sign off the receivables carryover

Missing, extra and different documents per customer give you the evidence for sign-off.

Which customers do not tie between Dynamics GP and Business Central, and why?

Collections specialists

Answer a customer's balance query

Trace one customer's balance across both systems before you call them about what they owe.

Contoso says their balance is wrong in Business Central. Compare it with Dynamics GP.

How it works

What PopdockAI does when you ask

You name a customer or check all with a balance, and your AI assistant compares and traces receivables between Dynamics GP and Business Central. It writes to neither system.

01

Ask

You name a customer or check all, optionally as of go-live.

Your AI tool

02

Compare

It compares each customer balance in both systems.

microsoft-dynamics-gp-get-rm-customer

03

Trace

For any difference, it lines up open documents, flipping signs where needed.

microsoft-dynamics-gp-get-rm-trx

04

Report

You get missing, extra and different documents per customer.

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

Receivables proven, customer by customer

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