/
/
See who supplies an Akeneo product in Dynamics GP
For buyers and operations teams who want sourcing for a SKU by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Finding who supplies a product takes several screens
Buyers look up a product in Akeneo, then hunt through Dynamics GP vendor items and records to see who supplies it. Lead times, last cost and vendor holds are spread across several screens.
Without PopdockAI
- Look the product up in Akeneo
- Search Dynamics GP vendor items for the SKU
- Open each vendor to check status and hold
- Collect lead times and last costs by hand
With PopdockAI
- The product is read from Akeneo and its vendor items from Dynamics GP
- Each vendor's status, hold and terms are checked
- One row per vendor shows lead time, minimum order and last cost
- Held, inactive and broken vendor links are flagged, reading only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Show who supplies the product with SKU {sku}, combining its Akeneo catalog record with its Dynamics GP vendor items and vendor details, for the company {company}.
**Step 1: Read the catalog record (akeneo)**
Call `akeneo-get-product` with identifier set to {sku}. Keep product-name, brand, family and enabled. If it returns nothing, report the SKU as absent from Akeneo and continue.
**Step 2: Find the vendor items (dynamics-gp)**
Call `dynamics-gp-get-iv-vendor-item` with item-number set to the SKU (company when given). Keep vendor-id, vendor-item-number, average-lead-time, minimum-order-quantity, last-receipt-date, last-receipt-cost and quantity-on-order. If nothing comes back, report that no vendor is set up for the item and stop after the report.
**Step 3: Read each vendor (dynamics-gp)**
For each vendor-id, call `dynamics-gp-get-pm-vendor` with vendor-id set to it. Keep vendor-name, vendor-status, hold, payment-terms-id and current-balance.
**Step 4: Report**
The product line first, then one row per vendor: vendor, status and hold, vendor item number, lead time, minimum order, last receipt date and cost, on order. Flag vendors on hold or inactive. Note if the Akeneo brand matches a vendor name, without assuming they are the same company.
**Rules & Guidelines:**
* Tools starting keneo- are on the akeneo server (the product catalog, PIM). Tools starting dynamics-gp- are on the dynamics-gp server (the ERP). Both servers must be connected.
* The join key is the Akeneo product identifier (the SKU) and the Dynamics GP item number. Compare them exactly first, then trimmed and case-insensitive; report any record that only matches that loose way as a format mismatch rather than a match.
* Dynamics GP tools take an optional company; pass {company} when it is given, and say which company the answer is for.
* This prompt is read-only. Do not call any write tool on either server.
**Validation:**
* A vendor-id with no vendor record is reported as a broken link.
* Costs are in the item's own currency; do not convert.Who it's for
One answer, three teams that use it
Buyers
Pick a vendor for the next order
Lead times, minimum orders and last costs for every vendor of the product, side by side.
Who supplies SKU HD-3300 in Dynamics GP, and what did we last pay each vendor?
Product managers
Check supply before a launch
See how many vendors can supply a catalog product and whether any are on hold.
Is the Akeneo product TS-2210 single sourced in Dynamics GP?
Catalog managers
Find broken supplier links
Vendor ids that point at no record are flagged, so product and supplier data can be fixed.
Check the Dynamics GP vendors for SKU KB-0450 and flag any that are inactive or missing.
How it works
What PopdockAI does when you ask
You give a SKU, and your AI assistant links the Akeneo product to its Dynamics GP vendors. It only reads and does not convert costs.
01
Ask
You give a SKU and, if needed, a company.
02
Read
It reads the product from Akeneo and its vendor items from Dynamics GP.
03
Check
It reads each vendor's status, hold and terms.
04
Report
It shows one row per vendor and flags any on hold or inactive.
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.
akeneo-get-product
microsoft-dynamics-gp-get-iv-vendor-item
microsoft-dynamics-gp-get-pm-vendor
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
Who supplies a product, in one answer
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
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
Add Dynamics GP item buyers to a Constant Contact list
Ask your AI to add an item's buyers to a Constant Contact list and it totals each customer's purchases in Dynamics GP, checks them in Constant Contact and adds the missing ones after you confirm.
Learn More
Add missing Dynamics GP customers to a Constant Contact list
Ask your AI to add missing Dynamics GP customers to a Constant Contact list and it checks every email, then creates only the missing contacts after you confirm.
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.