Connectors

/

Microsoft Dynamics GP

/

Review a customer's history across Dynamics GP and Intacct
Report
Cross-Connector

See a customer's full history across GP and Intacct

For account managers who want a customer's Dynamics GP and Sage Intacct history in one timeline, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review a customer's history across Dynamics GP and Intacct
Show me Northwind Traders' history across Dynamics GP and Sage Intacct for the last 12 months.
Northwind Traders buys steadily but pays more slowly since cutover. - Settings: credit limit 50,000 in GP, not set in Intacct - Sales: 96,000 over 12 months, 38,000 of it in Intacct - Open balance: 14,200 in Intacct - Not migrated: 1 GP invoice of 1,150 Want the monthly totals by system?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
sage-intacct-get-customer
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-sales-trx
sage-intacct-get-invoice
sage-intacct-get-ar-payment
sage-intacct-get-order-entry-document

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

Old sales in GP, new invoices in Intacct

After a cutover, a customer's older sales and receivables live in Dynamics GP and newer invoices in Sage Intacct. Seeing the whole picture means two lookups and care not to count migrated invoices twice.

Without PopdockAI

  • Look the customer up in both systems
  • Compare terms, limit and status by eye
  • Pull history from each and remove migrated invoices
  • Miss a GP document that never migrated

With PopdockAI

  • The customer is found in both systems and differing settings listed
  • GP and Intacct histories are split at cutover
  • Migrated invoices are shown once
  • Monthly totals, open balance and recent documents, reading only

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 history for customer `{customer-id}` covering the last `{months-back}` months (default 12), with GP activity before cutover and Intacct activity after, and flag settings that did not carry across.

**Step 1: The customer in both systems**

Call `dynamics-gp-get-rm-customer` with `customer-id` = `{customer-id}` and `intacct-get-customer` with the same `customer-id`. If Intacct has no match, try `customer-name` from GP; if still none, say the customer was not migrated and continue with GP only.

Compare payment terms (`payment-terms-id` vs `term`), credit limit (`credit-limit-amount` vs `credit-limit`), status, email and city. List every difference.

**Step 2: GP history**

Call `dynamics-gp-get-rm-trx` and `dynamics-gp-get-rm-sales-trx` for the customer, `document-date.from` = `{months-back}` months ago. Keep document number, type, date, amount and open amount.

**Step 3: Intacct history**

Call `intacct-get-invoice`, `intacct-get-ar-payment` and `intacct-get-order-entry-document` for the customer over the same period.

**Step 4: Merge**

Use `{cutover-date}` to split the timeline. If it is empty, take the day after the latest GP document date and say it was inferred. Open invoices migrated at cutover appear in both systems: match GP `document-number` to Intacct `invoice-number` or `reference-number` and show each once, tagged "migrated".

**Step 5: Report**

1. Customer header, and the setting differences from Step 1.
2. Monthly totals, sales and payments, tagged GP or Intacct per month.
3. Current open balance (Intacct), and any open GP document that did not migrate.
4. The last 10 documents with their source.
5. A one-line read: is the customer buying more, less or the same since cutover, and are they paying on time.

**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. Do NOT call `intacct-update-customer`, `intacct-create-order-entry-document`, `dynamics-gp-rm-customer-update` or `dynamics-gp-rm-sales-trx-add`.

**Validation:**

* If the customer is not in GP, say so and report Intacct only; they may be a new customer.
* Never add a migrated invoice to both sides of a monthly total.

Who it's for

One answer, three teams that use it

Account managers

Prepare for a customer call

Monthly totals by system, the open balance and a read on buying and paying give you the full story.

Show me Contoso's history across Dynamics GP and Sage Intacct for the last 24 months.

Credit controllers

Check settings carried across

Differences in terms, credit limit or status are listed, so you can fix what the migration missed.

Do Fabrikam's terms and credit limit match between Dynamics GP and Sage Intacct?

Accounts receivable

Find documents that did not migrate

Any GP document missing from Intacct is flagged, so the open balance is right.

Is there anything open for Northwind Traders in GP that did not come across to Intacct?

How it works

What PopdockAI does when you ask

You give the customer ID and a lookback, and your AI assistant merges the Dynamics GP and Sage Intacct histories at cutover. It only reads.

01

Ask

You give the customer ID and how many months to look back.

Your AI tool

02

Compare

It finds the customer in both systems and lists differing settings.

microsoft-dynamics-gp-get-rm-customer
sage-intacct-get-customer

03

Merge

It reads both histories and splits the timeline at cutover.

microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-sales-trx
sage-intacct-get-invoice
sage-intacct-get-ar-payment
sage-intacct-get-order-entry-document

04

Report

You get monthly totals by system, the open balance and recent documents.

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

sage-intacct-get-customer

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

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

Returns AR payments from Sage Intacct.
get-data

sage-intacct-get-order-entry-document

Returns order entry documents from Sage Intacct. Sales documents such as quotes, orders and invoices. The document-id links to the Get order entry document lines tool.
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

A customer's full history in one view

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