Connectors

/

Microsoft Dynamics GP

/

Check whether a bill was already paid in Dynamics GP
Read
Cross-Connector

Stop paying an invoice twice across a system cutover

For payables teams moving from Dynamics GP to Sage Intacct who want to know if a late invoice was already entered or paid, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check whether a bill was already paid in Dynamics GP
Was Fabrikam Supply invoice INV-1042 for 4,860 already paid in Dynamics GP or Intacct?
Verdict: paid in Dynamics GP. Do not enter it in Sage Intacct. - Dynamics GP: INV-1042 entered 18 August for 4,860 - Payment: check 20517 applied in full on 15 September - Sage Intacct: no matching bill or payment - Near match: an Intacct bill for 4,860 numbered INV1024, not counted Want the full payment details?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-pm-payables-trx
microsoft-dynamics-gp-get-pm-payables-apply
sage-intacct-get-bill
sage-intacct-get-vendor
sage-intacct-get-ap-payment

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

Invoices get paid twice across a system cutover

During a move from Dynamics GP to Sage Intacct, a vendor invoice can arrive after cutover that was already entered or paid in the old system. Checking means searching both systems, and invoice numbers rarely match exactly.

Without PopdockAI

  • Search Dynamics GP payables by invoice number or amount
  • Check which payments were applied to each match
  • Search Sage Intacct bills and payments separately
  • Miss a match because the invoice number is formatted differently

With PopdockAI

  • Dynamics GP payables are searched, including voided documents
  • Sage Intacct bills and payments are searched, matching the vendor by name
  • Invoice numbers are compared ignoring case, spaces, dashes and leading zeros
  • One verdict comes first, with evidence and 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:** Tell the user whether vendor `{vendor-id}`'s invoice `{invoice-number}` (or, when no number is given, an invoice for `{amount}`) is safe to enter and pay in Intacct, or was already handled in Dynamics GP.

**Step 1: Look in GP**

Call `dynamics-gp-get-pm-payables-trx` with `vendor-id` = `{vendor-id}`, and `document-number` = `{invoice-number}` when given; otherwise `document-amount.min` and `document-amount.max` both = `{amount}`. Include voided documents and note them. If nothing matches, retry without the number filter and compare numbers yourself, ignoring case, spaces, dashes and leading zeros.

For every match, call `dynamics-gp-get-pm-payables-apply` with `apply-to-document-number` = its `document-number` to find payments applied to it (payment `document-number`, `payment-date`, `applied-amount`).

**Step 2: Look in Intacct**

Call `intacct-get-bill` with `vendor-id` = `{vendor-id}` and `bill-number` = `{invoice-number}` (or the amount filters), then with `vendor-id` alone if needed, comparing the same way. If the vendor id is not found in Intacct, look it up with `intacct-get-vendor` by the GP `vendor-name`. For bills found, check `total-paid` and call `intacct-get-ap-payment` for the vendor around the bill's dates.

**Step 3: Verdict**

Give one verdict first, then the evidence:
* **SAFE**: not in GP, not in Intacct.
* **PAID IN GP**: recorded and paid in GP. Do not pay again. Show the payment number, date and amount.
* **OPEN IN GP**: recorded in GP, not paid. It should have migrated as an open bill; check it is in Intacct once only.
* **ALREADY IN INTACCT**: already entered in Intacct. Show state and amount paid.
* **IN BOTH, CHECK FOR DUPLICATE**: paid in GP and open in Intacct, or open in both.

**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.
* Read only. Do NOT call `dynamics-gp-pm-payables-trx-add`, `intacct-create-recurring-bill`, `intacct-create-charge-card-transaction` or `intacct-update-vendor`.

**Validation:**

* If neither `{invoice-number}` nor `{amount}` is given, ask for one before searching.
* A near match (same amount, different number, within 30 days) is worth showing as "possible match", but never as the verdict on its own.

Who it's for

One answer, three teams that use it

Accounts payable

Check an invoice before you pay it

One answer tells you whether a bill is safe to pay or already paid in GP or Intacct, with the payment that settled it.

Was Contoso Ltd invoice 000877 already paid in Dynamics GP or Sage Intacct?

Migration leads

Clear duplicate risk during cutover

Invoices that turn up after go live are checked against both systems, so the cutover does not cause double payments.

Check whether a 12,400 invoice from Northwind Traders dated August exists in GP or Intacct.

Finance controllers

Back each payment decision with evidence

Each verdict comes with the matching documents and payments, so you can approve or stop a payment with confidence.

Has Fabrikam Supply invoice INV-2290 been entered or paid in either Dynamics GP or Intacct?

How it works

What PopdockAI does when you ask

You give the vendor and the invoice number or amount, and your AI assistant searches both systems for the bill and its payments. You get one verdict and the evidence behind it.

01

Ask

You give the vendor and the invoice number or amount.

Your AI tool

02

GP

It searches Dynamics GP payables, including voided ones, and the payments applied.

microsoft-dynamics-gp-get-pm-payables-trx
microsoft-dynamics-gp-get-pm-payables-apply

03

Intacct

It searches Sage Intacct bills and payments, matching numbers loosely.

sage-intacct-get-bill
sage-intacct-get-vendor
sage-intacct-get-ap-payment

04

Verdict

You get one verdict first, then the evidence, with nothing changed.

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-pm-payables-trx

Returns payables transactions such as invoices, credit memos and payments from Dynamics GP Payables Management, with the vendor, dates, document and outstanding amounts. Filter by batch number, voucher number, vendor name, document amount, purchase order number, document number, document type and document date, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-pm-payables-apply

Returns payment applications from Dynamics GP Payables Management, showing which payments and credits were applied to which vendor documents and for how much. Filter by vendor ID, apply to document number, apply to voucher number, document number, vendor name, apply to document type, payment date and voucher number, and pick the company and the maximum number of records.
get-data

sage-intacct-get-bill

Returns bills from Sage Intacct. The record-number links to the Get bill lines tool.
get-data

sage-intacct-get-vendor

Returns vendors from Sage Intacct.
get-data

sage-intacct-get-ap-payment

Returns AP payment from Sage Intacct. The record-number links to the Get AP payment details 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

No invoice paid twice across the cutover

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