Report

Choose a supplier on cost and delivery, not habit

For buyers who want every Dynamics GP vendor for an item compared on cost trend, lead time and on-time delivery, by asking their AI assistant.

Compare Dynamics GP vendors for an item

Compare the vendors for item SD-200 in Dynamics GP over the last 12 months.

SD-200 has 3 active vendors, and the cheapest is not the most reliable. - Contoso Parts: lowest cost at 118, up 4 percent, 71 percent on time - Fabrikam Supply: 124, flat, 96 percent on time - Lead time: Fabrikam averages 9 days against 14 stated by Contoso Recommendation: Fabrikam for urgent orders, Contoso for stock builds. Want the full comparison?

Microsoft Dynamics GP

Sample figures. Your results come from your own account.

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

microsoft-dynamics-gp-get-pm-vendor

microsoft-dynamics-gp-get-iv-purchase-receipt

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

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

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

Suppliers chosen by habit, not by evidence

Choosing a supplier for an item in Dynamics GP usually comes down to whoever was used last. Comparing cost trends, lead times and on time delivery means matching orders to receipts by hand.

Without PopdockAI

List the vendors set up for the item
Pull receipts to build a cost history
Match purchase order lines to receipts for lead time
Pick the last vendor used because comparing takes too long

With PopdockAI

Every vendor for the item is read, setting aside held or inactive ones
Receipts give cost history and trend
Orders are matched to receipts for actual lead time and on time share
A short recommendation names the cost and reliability trade-off

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Compare the vendors that supply item `{item-number}` on cost and delivery over the last `{lookback-days}` days (default 365) and recommend where to buy it.

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 setup**

Call `dynamics-gp-get-iv-vendor-item` by `item-number`: each `vendor-id`, vendor item number, `last-receipt-cost`, `average-lead-time`, `minimum-order-quantity`, `economic-order-quantity`. Call `dynamics-gp-get-pm-vendor` for those vendors and drop any on `hold` or inactive, noting them.

**Step 2: Receipt history**

Call `dynamics-gp-get-iv-purchase-receipt` by `item-number` with `date-received.from` at the lookback. Per vendor: receipts, quantity, average and latest `unit-cost`, and the cost trend from first to last receipt.

**Step 3: Delivery**

Call `dynamics-gp-get-pm-purchase-order-line` by `item-number` and `dynamics-gp-get-pm-receivings-trx-line` by `item-number` over the lookback. Match by `po-number`: actual lead time = receipt date minus PO document date, and on-time = received by `required-date`. Per vendor: average actual lead time and on-time share.

**Step 4: Report**

A table per vendor: vendor, latest cost, average cost, trend, stated lead time, actual lead time, on-time share, minimum order, status. Then a one-paragraph recommendation that names the trade-off (cheapest against most reliable).

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool whose name does not contain `get` (no add, update, note or email tools).

**Validation:**

* If the item has only one vendor, say it is single-sourced and report that vendor's performance only.
* If the item has no vendor records, say so and stop.

Who it's for

One answer, three teams that use it

Buyers

Pick the right vendor for the next order

One row per vendor with cost, stated and actual lead time and on time rate helps you place the next order with confidence.

Which vendor should we buy item LP-10 from? Compare them in Dynamics GP over the last year.

Procurement managers

Find single sourced items

Items with only one active vendor are called out, so you can line up an alternative before there is a supply problem.

Is item CART-12 single sourced in Dynamics GP, and how reliable is that vendor?

Supply chain planners

Plan on real lead times

Actual lead times from orders and receipts replace the stated ones, so reorder points are set on what really happens.

What are the actual lead times for each vendor of item SD-200 in Dynamics GP compared with what they quote?

How it works

What PopdockAI does when you ask

You name the item and a lookback window, and your AI assistant measures each Dynamics GP vendor on cost and delivery. It reports and recommends, and changes nothing.

Ask

You name the item and a lookback window.

Your AI tool

Read

It reads the item's vendors, setting aside those on hold or inactive.

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

microsoft-dynamics-gp-get-pm-vendor

Measure

It reads receipts for cost trend and matches orders to receipts for lead time.

microsoft-dynamics-gp-get-iv-purchase-receipt

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

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

Report

You get one row per vendor and a recommendation on the trade-off.

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

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-iv-purchase-receipt

Returns inventory purchase receipt layers from Dynamics GP Inventory, with item, vendor, purchase order, quantities received and sold, and unit cost. Filter by receipt number, transaction location, purchase order number, date received, vendor ID, item number, purchase receipt type and quantity received, and pick the company and the maximum number of records.

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.

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

Source each item on cost and delivery evidence

Related use cases

More ways to put this data to work

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

Follow up late Dynamics GP purchase orders

Ask your AI which Dynamics GP purchase orders are late and it checks receipts so only real shortfalls remain, then groups them by vendor, worst first.

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

Return items to a vendor in Dynamics GP

Ask your AI to return items to a vendor and it finds the vendor and return address in Dynamics GP, keeps only items they supplied, and creates the return 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

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.