Report

Chase each vendor once with everything that is late

For buyers who want late Dynamics GP purchase order lines grouped by vendor with receipts checked, by asking their AI assistant.

Follow up late Dynamics GP purchase orders

Which Dynamics GP purchase orders are more than 7 days late? Group them by vendor.

14 lines across 5 vendors are more than 7 days late, worth 38,900 outstanding. - Worst: Fabrikam Supply, 6 lines, 21,400, average lead time 18 days - Stale status: 2 lines show open but were received in full - Unrealistic: 3 required dates were shorter than the vendor's lead time Want the follow-up list for each vendor?

Microsoft Dynamics GP

Sample figures. Your results come from your own account.

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

microsoft-dynamics-gp-get-pm-receivings-trx-line

microsoft-dynamics-gp-get-iv-vendor-item

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics GP

Run it on your own Microsoft Dynamics GP data.

Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.

The problem

Late orders slip and vendors get called three times

Late purchase orders in Dynamics GP are easy to lose track of, and some lines say open when the goods arrived weeks ago. Chasing means checking receipts against every line and phoning the same vendor about several orders.

Without PopdockAI

Filter open PO lines past their required date
Check receipts to see what really arrived
Miss lines received but never updated
Phone the same vendor about each order separately

With PopdockAI

Open lines past their required date are read
Receipts are checked so only real shortfalls remain
Lines received but not updated are noted
One block per vendor, worst first, with 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:** List purchase order lines for `{vendor-name}` (default all vendors) that are at least `{days-late}` days (default 1) past their required date and not fully received, so a buyer can chase each vendor once.

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: Open PO lines**

Call `dynamics-gp-get-pm-purchase-order-line`, with `vendor-name.contains` when `{vendor-name}` is given. Keep lines whose `po-line-status` is still open (not received, closed or cancelled) and whose `required-date` is at least the threshold before today.

**Step 2: What has arrived**

For each distinct `po-number` kept, call `dynamics-gp-get-pm-receivings-trx-line` filtered by `po-number`. Sum `quantity-shipped` per `item-number`. Outstanding = `quantity-ordered` minus received. Drop lines with nothing outstanding and note them as "received, status not updated".

**Step 3: Lead time context**

For vendors with late lines, call `dynamics-gp-get-iv-vendor-item` filtered by `vendor-id` and note the `average-lead-time` per item, so the report can say whether the required date was realistic.

**Step 4: Report**

One block per vendor, worst first by outstanding value (outstanding quantity times `unit-cost`):

* vendor name and id, number of late lines, outstanding value
* a table: PO number, item, description, ordered, received, outstanding, required date, days late, average lead time
* one suggested follow-up line (chase, expedite, or check whether the status is stale)

**Rules & Guidelines:**

* Read-only. Do not call `dynamics-gp-pm-purchase-order-update`, `dynamics-gp-pm-purchase-order-note`, `dynamics-gp-pm-receivings-trx-add`, `dynamics-gp-pm-receivings-trx-line-add` or any tool whose name does not contain `get`.

**Validation:**

* If no lines are late, say so and give the count of open lines due in the next 14 days instead.

Who it's for

One answer, three teams that use it

Buyers

Chase each vendor once

Every late line for a vendor is in one block, so a single call covers all their outstanding orders.

Which Dynamics GP purchase orders from Fabrikam Supply are more than 5 days late?

Purchasing managers

Focus on the late value that matters

Vendors are sorted by outstanding value, so the team chases the shortfalls that affect the business most.

List late Dynamics GP purchase orders over 14 days by vendor, biggest outstanding value first.

Receiving supervisors

Spot stale line statuses

Lines that were received but still show open are noted, so the PO status can be cleaned up.

Are any Dynamics GP PO lines showing open even though the goods were received?

How it works

What PopdockAI does when you ask

You name a vendor, or all of them, and how late counts, and your AI assistant checks Dynamics GP orders against receipts. You get a follow-up list per vendor, and nothing is changed.

Ask

You name a vendor, or all, and how many days late counts.

Your AI tool

Read

It reads open purchase order lines past their required date.

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

Check

It checks receipts for what is still outstanding and spots stale line statuses.

microsoft-dynamics-gp-get-pm-receivings-trx-line

Report

You get one block per vendor with lead time context and a follow-up.

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

Returns purchase order lines from Dynamics GP Purchasing, including the vendor, item, site, quantities, costs, line status and required dates. Filter by item description, document date, vendor name, PO line status, extended cost, PO number, item number and vendor ID, and pick the company and the maximum number of records.

get-data

microsoft-dynamics-gp-get-pm-receivings-trx-line

Returns receipt lines from Dynamics GP Purchasing, with the vendor, purchase order, item, quantities shipped and invoiced, and costs. Filter by vendor ID, extended cost, item description, receipt date, POP receipt number, vendor name, item number and POP type, and pick the company and the maximum number of records.

get-data

microsoft-dynamics-gp-get-iv-vendor-item

Returns vendor item records from Dynamics GP Inventory, linking items to the vendors who supply them with order quantities, lead times and last receipt details. Filter by vendor ID, last receipt date, vendor item description, quantity on order, vendor item number and item number, 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.

The outcome

One call per vendor, covering everything late

Related use cases

More ways to put this data to work

Compare Dynamics GP vendors for an item

Ask your AI to compare vendors for an item and it measures each Dynamics GP vendor's cost history, actual lead time and on-time rate, then names the trade-off.

Learn More

Create a Dynamics GP reorder purchase order

Ask your AI to build a reorder purchase order and it projects stock for every item a Dynamics GP vendor supplies, suggests quantities and creates the PO after you confirm.

Learn More

Receive a Dynamics GP purchase order

Ask your AI to receive a Dynamics GP purchase order and it works out what is outstanding, rejects extras and over-receipts, and creates the receipt at PO cost after you confirm.

Learn More

Profile a Dynamics GP item

Ask your AI to profile a Dynamics GP item and it brings setup, stock by site, prices, vendors, open orders, sales and adjustments into one page with observations.

Learn More

Review Dynamics GP inventory to reorder

Ask your AI which Dynamics GP items need reordering and it compares stock cover with demand and lead time, then suggests quantities by vendor.

Learn More

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.