Connectors

/

Microsoft Dynamics GP

/

Reconcile open Dynamics GP receivables with Intacct at cutover
Report
Cross-Connector

Start Intacct aging and dunning from the right numbers

For finance teams who want open Dynamics GP receivables at cutover tied to Sage Intacct invoices, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile open Dynamics GP receivables with Intacct at cutover
Reconcile open receivables from Dynamics GP with Sage Intacct at our 30 June cutover.
At 30 June, 498 customers had open receivables, and 7 do not tie. - Missing from Intacct: 5 invoices worth 9,860, listed for import - Unapplied GP payments: 2, still counted as open items - Mismatches: 3 due dates differ - Totals: GP 1.21 million, Intacct 1.20 million Want the customers that do not tie?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-trx-apply
sage-intacct-get-invoice
sage-intacct-get-ar-adjustment
sage-intacct-get-customer

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

Aging in Intacct starts from the wrong numbers

After moving to Sage Intacct, finance must prove every customer balance open in Dynamics GP at cutover arrived as an open invoice. Later payments in GP, changed due dates and drifting IDs make it harder than comparing totals.

Without PopdockAI

  • Rebuild each customer's open GP items at cutover
  • Add back payments applied after cutover
  • Match customers and invoices across changed IDs
  • Start aging and dunning on unproven balances

With PopdockAI

  • Open GP receivables are rebuilt at cutover, adding back later applications
  • Customers match by ID, then by name
  • Documents match by invoice or reference number
  • Unapplied payments count as open items, and missing invoices are listed for import

The prompt

Use this prompt

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

Prompt
**Objective:** Confirm the open receivables in Dynamics GP at `{cutover-date}` match the open invoices in Intacct, for customer `{customer-id}` or for every customer when it is empty.

**Step 1: Open GP receivables at cutover**

Call `dynamics-gp-get-rm-trx` with `document-date.to` = `{cutover-date}` (and `customer-id` = `{customer-id}` when given). Drop voided documents (`void-status`). `current-transaction-amount` is what is still open today; keep documents where it is not zero. Treat document types that reduce the balance (credit memos, returns, payments) as negative, using the codes the tool lists for `document-type`.

If GP was used after cutover, add back what was applied since: call `dynamics-gp-get-rm-trx-apply` with `document-date.from` = the day after `{cutover-date}` and add each `amount-applied` back to its `applied-to-document-number`.

**Step 2: Open Intacct invoices**

Call `intacct-get-invoice` with `total-due.min` = 0.01 (and `customer-id` when given), and `intacct-get-ar-adjustment` for migrated credit memos with an open `total-due`.

**Step 3: Match**

Match customers on `customer-id`, exactly first, then ignoring case and leading zeros. For GP customers still unmatched, look them up by name with `intacct-get-customer` and label the result "matched by name".

Within a customer, match GP `document-number` to Intacct `invoice-number`, then to `reference-number`. Compare the open amount and the due date.

**Step 4: Report**

1. Customer summary: customer, GP open at cutover, Intacct open, difference. Put only customers with a difference in the table and give the count that tie.
2. GP documents missing from Intacct: customer, document number, type, date, open amount.
3. Intacct invoices with no GP document.
4. Amount or due date mismatches (a due date change moves the invoice in the aging and in dunning).
5. Grand totals on both sides.

**Rules & Guidelines:**

* Tools prefixed dynamics-gp- are on the dynamics-gp MCP server. Tools prefixed intacct- are on the intacct MCP server. Both servers must be connected; if a tool from either is missing, say which server is not connected and stop.
* Pass `{gp-company}` as `company` on every dynamics-gp- call (empty means the default GP company). Use the default Intacct company; if the Intacct side holds several entities and it is not clear which one received this GP company, ask before starting.
* Set `max-records` high (5000) on every list read. If a read returns exactly that many rows, say the result may be truncated and narrow the filter (per account, per vendor, per customer or per item) instead of reporting totals from it.
* Read only. Intacct has no invoice-creation tool here, so report missing invoices for import. Do NOT call `dynamics-gp-rm-trx-add`, `dynamics-gp-rm-sales-trx-add`, `intacct-create-order-entry-document` or `intacct-update-customer`.

**Validation:**

* If `{customer-id}` is given and not found in GP, say so and stop. If it is in GP but not in Intacct, report the customer as not migrated.
* Amounts within 0.01 tie. An unapplied GP payment or credit is still an open item; it must appear in Intacct too.

Who it's for

One answer, three teams that use it

AR managers

Trust the opening AR in Intacct

Customers that do not tie and missing invoices are listed, so collections start from correct balances.

Reconcile open receivables from Dynamics GP with Sage Intacct at our 31 December cutover.

Migration accountants

Get a list of invoices to import

GP documents missing from Intacct are listed with amounts and due dates, ready for import.

Which customer invoices open in GP at cutover are not in Intacct?

Credit controllers

Check due dates came across

Due date mismatches are flagged, so dunning letters do not go out early or late.

Are there due date differences between GP and Intacct for Fabrikam's open invoices at cutover?

How it works

What PopdockAI does when you ask

You give the cutover date, and your AI assistant rebuilds what customers owed in Dynamics GP and matches it to Sage Intacct. It only reads.

01

Ask

You give the cutover date, and optionally a customer.

Your AI tool

02

Rebuild

It works out each customer's open GP receivables at cutover.

microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-trx-apply

03

Match

It matches customers by ID or name and documents by invoice or reference.

sage-intacct-get-invoice
sage-intacct-get-ar-adjustment
sage-intacct-get-customer

04

Report

You get customers that do not tie and invoices to import.

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

microsoft-dynamics-gp-get-rm-trx-apply

Returns receivables apply records from Dynamics GP Receivables/Sales, showing which payments and credits were applied to which invoices and for how much. Filter by customer name, document date, amount applied, document number, document type, applied to document type, customer ID and applied to document number, and pick the company and the maximum number of records.
get-data

sage-intacct-get-invoice

Returns invoices from Sage Intacct. The record-number links to the Get invoice entries tool.
get-data

sage-intacct-get-ar-adjustment

Returns AR adjustments from Sage Intacct. The record-number links to the Get AR adjustment lines tool.
get-data

sage-intacct-get-customer

Returns customers from Sage Intacct.
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

Aging and dunning from proven balances

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