Connectors

/

Microsoft Dynamics GP

/

Reconcile open Dynamics GP purchase orders with Dynamics 365 Business Central
Report
Cross-Connector

Know which open orders to re-enter before goods arrive

For buyers who want open Dynamics GP purchase orders checked in Business Central after go-live, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile open Dynamics GP purchase orders with Dynamics 365 Business Central
Which open Dynamics GP purchase orders are missing from Business Central?
94 open GP purchase orders were checked, and 6 are missing. - First to arrive: PO 2210 from Fabrikam Supply, expected 10 October - Probable matches: 3 found by vendor and amount, marked probable - Differences: 2 remaining amounts differ beyond tax Want the re-entry list?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-pm-purchase-order

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

Goods arrive with no order to receive against

Purchase orders open in Dynamics GP at go-live need to exist in Business Central, or goods arrive with nothing to receive against. Checking means matching renumbered orders and comparing vendors, amounts and dates with tax handled differently.

Without PopdockAI

  • Export open orders from both systems
  • Match orders that may have been renumbered
  • Compare amounts with tax included on one side only
  • Find the missing order when the truck arrives

With PopdockAI

  • Open GP orders are read, including those on hold
  • Each is found by number, vendor order number, or vendor and amount
  • Vendor, remaining amount, expected date and currency are compared
  • Missing orders are listed soonest receipt first, with nothing 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:** Confirm that purchase orders still open in Dynamics GP exist as open purchase orders in Business Central, for vendor `{vendor-id}` or, if that is empty, every vendor.

**Step 1: Read the open GP purchase orders**

Call `dynamics-gp-get-pm-purchase-order` with `vendor-id` set to `{vendor-id}` when it is given and `remaining-subtotal.min` set to 0.01. Keep orders whose po-status is New, Released or Change Order.

**Step 2: Read the BC purchase orders**

Call `business-central-get-purchase-transaction` with `document-type` set to Order, and `buy-from-vendor-number` set to `{vendor-id}` when it is given.

Match GP po-number to BC document-number. If BC renumbered the orders, match GP po-number to BC vendor-order-number instead. If that also fails, match on the same vendor with a remaining amount within 1 percent, and mark those matches as probable.

**Step 3: Compare each matched pair**

* vendor-id vs buy-from-vendor-number
* remaining-subtotal vs total-outstanding-amount (BC's figure can include tax; flag a difference only when it is larger than the GP tax-amount)
* promised-date, or required-date when that is empty, vs expected-receipt-date
* currency-id vs currency-code

**Step 4: Report**

Counts first: open in GP, matched, probable matches, missing from BC, open in BC with no GP order. Then the missing orders (PO number, vendor, remaining subtotal, promised date), sorted by promised date so the soonest receipts come first, then the differences on matched orders.

**Rules & Guidelines:**

* `dynamics-gp-get-pm-purchase-order` is on the dynamics-gp server. `business-central-get-purchase-transaction` is on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-purchase-order`, `business-central-create-purchase-order-line`, `business-central-update-purchase-order`, `dynamics-gp-pm-purchase-order-add` or `dynamics-gp-pm-purchase-order-update`.
* If either system has more than one company, ask the user which GP company and which BC company to use before the first call, and pass them as `company`.

**Validation:**

* If GP has no open purchase orders, say so and stop.
* If BC has no purchase orders at all, report that open purchase orders were not migrated and list the GP orders a buyer would need to re-enter.
* A GP order on hold (hold = true) is still open; include it and mark it as on hold.

Who it's for

One answer, three teams that use it

Buyers

Re-enter what will arrive first

Missing orders are sorted by expected receipt, so the most urgent ones are entered first.

Which open Dynamics GP purchase orders missing from Business Central are due this week?

Receiving supervisors

Have an order for every delivery

Knowing which orders exist in Business Central means receiving can book deliveries from day one.

Are all open Fabrikam Supply purchase orders from Dynamics GP in Business Central?

Migration leads

Prove open orders came across

Matched, probable and missing orders give a clear picture of the purchasing cutover.

Reconcile all open Dynamics GP purchase orders with Business Central and summarize.

How it works

What PopdockAI does when you ask

You name a vendor or check all, and your AI assistant finds each open Dynamics GP order in Business Central. It reports what to re-enter and writes to neither system.

01

Ask

You name a vendor or check every vendor.

Your AI tool

02

Read

It reads open Dynamics GP purchase orders, including those on hold.

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

03

Match

It finds each in Business Central by number, vendor order number or amount.

No items found.

04

Report

You get differences and missing orders, soonest receipt first.

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

Re-enter missing orders before the goods arrive

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