/
/
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.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
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.
**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.
02
Compare
It finds the customer in both systems and lists differing settings.
03
Merge
It reads both histories and splits the timeline at cutover.
04
Report
You get monthly totals by system, the open balance and recent documents.
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.
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
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.
The outcome
A customer's full history in one view
Related use cases
More ways to put this data to work
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.

.webp)
