Connectors

/

Akeneo

/

Find enabled Akeneo products with no Dynamics GP stock
Report
Cross-Connector

Find enabled Akeneo products with no stock in Dynamics GP

For operations teams who want unfulfillable products found by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find enabled Akeneo products with no Dynamics GP stock
Which enabled products in the apparel family have no stock or no price in Dynamics GP?
Of 40 enabled apparel products, 6 have no stock and 3 of those have nothing on order. - No stock, nothing on order, priced: TS-1042, TS-1077 - No stock, nothing on order, not priced: TS-1090 - Not in Dynamics GP: TS-3001 - With stock: 34 products Want the full table sorted by what is on order?
Akeneo
Sample figures. Your results come from your own account.
akeneo-get-product
microsoft-dynamics-gp-get-iv-item-quantity
microsoft-dynamics-gp-get-iv-item-price

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Akeneo

Akeneo
Run it on your own Akeneo data.

Connect Akeneo, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Customers ordering what cannot ship

Enabled products stay in the catalog after Dynamics GP has run out of stock or never received a price, so customers order what cannot ship. Finding them means looking up stock and prices in GP one SKU at a time.

Without PopdockAI

  • List enabled products in a family
  • Look up stock across GP sites for each
  • Check the price list for items with no stock
  • Miss the SKU that is not in GP at all

With PopdockAI

  • Up to 40 enabled products read for a family
  • Stock on hand and on order read from Dynamics GP
  • Price list checked for items with no stock
  • No GP record reported as not in the ERP, not zero

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 enabled Akeneo products in the family {family} that cannot be fulfilled from Dynamics GP because the item has no stock on hand or no price list entry, for the company {company}. Default to 40 products.

**Step 1: List catalog products (akeneo)**

Call `akeneo-get-product` with enabled set to true, family set to {family}, and max-records 40. If {family} is empty, leave the filter off. Keep identifier, product-name and brand.

**Step 2: Check stock (dynamics-gp)**

For each identifier, call `dynamics-gp-get-iv-item-quantity` with item-number set to it (company when given). Sum quantity-on-hand across the sites returned and note quantity-on-order.

**Step 3: Check price (dynamics-gp)**

For each product whose stock is zero or missing, call `dynamics-gp-get-iv-item-price` with item-number set to the identifier. Note whether any price level has a list-price above zero.

**Step 4: Report**

A table of SKU, product name, brand, total on hand, on order, and priced yes or no. Sort with no stock and nothing on order first. Give counts of products checked, with stock, and without.

**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 SKU with no Dynamics GP quantity record at all is reported as not in the ERP, not as zero stock.
* If the catalog returns nothing for the family, say so and stop.

Who it's for

One answer, three teams that use it

Operations managers

Find live products you cannot ship

See enabled products with no stock and nothing on order.

Which enabled footwear products have no stock in Dynamics GP?

Purchasing coordinators

See what is already on order

Quantity on order is shown next to stock so you know what to buy.

For enabled outdoor products with no GP stock, what is on order?

Pricing analysts

Catch items with no price

Items with no stock are also checked for a price above zero.

Which enabled kitchen products have no price list entry in Dynamics GP company TWO?

How it works

What PopdockAI does when you ask

You name a family and your AI assistant checks each enabled product's stock and price in Dynamics GP. Products with no stock and nothing on order come first.

01

Ask

You name a family and, if needed, a company.

Your AI tool

02

List

It reads enabled products in that family from Akeneo.

akeneo-get-product

03

Check

It reads stock across sites and the price list in Dynamics GP.

microsoft-dynamics-gp-get-iv-item-quantity
microsoft-dynamics-gp-get-iv-item-price

04

Report

It lists products with no stock, nothing on order or no price.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Akeneo and one secure connection to your AI tool. No code, no exports.

get-data

akeneo-get-product

Returns products from Akeneo PIM with their family, categories, enabled status, completeness and update dates. Filter by family, category, enabled status or update date.
get-data

microsoft-dynamics-gp-get-iv-item-quantity

Returns item quantity records by site from Dynamics GP Inventory, including quantities on hand, allocated, on order and back ordered. Filter by quantity on hand, item description, location code from item master, item class code, item type, record type and item number, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-iv-item-price

Returns item price list records from Dynamics GP Inventory, including price level, unit of measure, quantity breaks and pricing method. Filter by price level, price method, unit of measure, item number, currency ID, item description and item type, and pick the company and the maximum number of records.
Read only.Nothing in Akeneo 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

Unfulfillable products listed for action

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