Connectors

/

Microsoft Dynamics GP

/

Enter a Dynamics GP vendor invoice
Write

Enter vendor invoices once and stop duplicate payments

For payables teams who want vendor invoices entered in Dynamics GP with duplicate and amount checks, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Enter a Dynamics GP vendor invoice
Enter invoice INV-1042 from Fabrikam Supply in Dynamics GP for 4,860, including 360 freight, against PO 2210.
Fabrikam Supply is active, and INV-1042 is not on file. - Amount: 4,500 purchases plus 360 freight, totals 4,860 - PO 2210: total 4,500, matches the purchases - Same amount: no invoice for 4,860 in the last 60 days - Due date: 30 days from the invoice date Shall I enter the invoice?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-pm-vendor
microsoft-dynamics-gp-get-pm-payables-trx
microsoft-dynamics-gp-get-pm-purchase-order
microsoft-dynamics-gp-pm-payables-trx-add

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

Duplicate payments start with a duplicate invoice

Paying the same vendor invoice twice often starts with keying an invoice into Dynamics GP that was already entered. Checking the vendor's status, the purchase order and the amount split takes time nobody has at month end.

Without PopdockAI

  • Search payables for the invoice number before keying it
  • Check the vendor is not on hold or inactive
  • Compare the total with the purchase order by hand
  • Add up purchases, tax and freight with a calculator

With PopdockAI

  • Vendor hold and status are checked first
  • A duplicate invoice number stops the entry
  • Same amount invoices from the last 60 days are flagged
  • Purchases, tax and freight must add up before anything is 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:** Enter invoice `{invoice-number}` from `{vendor-name}` for `{amount}` as a payables transaction, after checking it is not a duplicate and the user has confirmed.

Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.

**Step 1: Vendor**

Call `dynamics-gp-get-pm-vendor` with `vendor-name.contains` (or `vendor-id`). If several match, list them and stop. Note `hold`, `vendor-status` and `payment-terms-id`. If the vendor is on hold or inactive, warn the user before continuing.

**Step 2: Duplicate check**

Call `dynamics-gp-get-pm-payables-trx` by `vendor-id` and `document-number` set to `{invoice-number}`. If a non-voided document exists, stop and show it. Also read the vendor's documents from the last 60 days and warn about any with the same amount.

**Step 3: PO match (optional)**

If the user mentions a purchase order, call `dynamics-gp-get-pm-purchase-order` by `po-number` and compare `{amount}` with its subtotal plus tax and freight; report the difference.

**Step 4: Confirm**

Ask the user for the invoice date, the voucher number, the batch number, and the split of `{amount}` into purchases, tax and freight (default all purchases). Show the user exactly what will be written, field by field, and ask for explicit confirmation. Do nothing further without a clear yes. Show vendor, document type invoice, document number, voucher number, dates, amounts, terms, PO number and batch.

**Step 5: Write, once**

Call `dynamics-gp-pm-payables-trx-add` once with `vendor-id`, `document-type` (invoice), `document-number`, `voucher-number`, `document-date`, `document-amount`, `purchases-amount`, `tax-amount`, `freight-amount`, `batch-number`, and `purchase-order-number` and `payment-terms-id` when known. Do not retry a failed write automatically. Report the error exactly as returned.

**Step 6: Verify**

Call `dynamics-gp-get-pm-payables-trx` by `voucher-number` and report what was stored, including the due date.

**Rules & Guidelines:**

* `dynamics-gp-pm-payables-trx-add` is the only write tool this prompt may call, once, after Step 4.
* The amounts must add up: purchases plus tax plus freight equals `{amount}`. Refuse to write if they do not.

**Validation:**

* If `{amount}` is not a positive number, stop and ask for it again.

Who it's for

One answer, three teams that use it

Accounts payable clerks

Key invoices without the duplicate search

The invoice number and recent amounts are checked for you, so a resent invoice is caught before it is entered.

Enter Contoso Parts invoice 88231 in Dynamics GP for 2,140 including 140 tax.

AP managers

Stop duplicate payments at entry

Duplicate numbers are refused and same amount invoices are flagged, so the payment run never pays twice.

Northwind Supply sent invoice NS-5512 for 9,300. Has it been entered in Dynamics GP? If not, enter it against PO 3301.

Purchasing

Match invoices to the PO total

Naming a PO compares its total with the invoice, so price differences are raised before the bill is approved.

Enter Fabrikam Supply invoice F-7781 for 12,500 against PO 2290 in Dynamics GP and tell me if it differs from the PO.

How it works

What PopdockAI does when you ask

You give the vendor, invoice number and amount, and your AI assistant runs the duplicate and amount checks in Dynamics GP. The invoice is entered once, only after you confirm every field.

01

Ask

You give the vendor, invoice number and amount.

Your AI tool

02

Check

It checks the vendor's hold and status and stops on a duplicate invoice number.

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

03

Match

It warns on same-amount invoices and compares a named PO total.

microsoft-dynamics-gp-get-pm-payables-trx
microsoft-dynamics-gp-get-pm-purchase-order

04

Confirm

You approve every field, and it enters the invoice once and reads it back.

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

Returns vendor records from Dynamics GP Payables Management, including contact details, payment terms, status and current balance. Filter by vendor name, hold, vendor class ID, vendor status, state, current balance, city and vendor ID, and pick the company and the maximum number of records.
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-purchase-order

Returns purchase order headers from Dynamics GP Purchasing, including vendor, dates, status, buyer and order amounts. Filter by hold, vendor ID, remaining subtotal, document date, vendor name, PO status, PO number and buyer ID, and pick the company and the maximum number of records.
run-action

microsoft-dynamics-gp-pm-payables-trx-add

Adds a payables transaction in Dynamics GP through eConnect; GP defaults any field not listed. Requires document amount, voucher number, vendor ID, document date, document type, document number and batch number. Optional: payment terms ID, freight amount, tax amount, posting date, due date and transaction description. Writes to the live Dynamics GP company database.
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

Each vendor invoice entered once

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