/
/
See net supply and demand for an Akeneo product in Business Central
For operations teams who want one product's position by asking their AI assistant.
On this page
Connector
Connect Akeneo, pick your AI tool and paste the prompt.
The problem
Net position worked out across five screens
To answer whether a product can be sold, someone checks Akeneo, then the Business Central item, vendors and open purchase and sales orders. The net position is worked out by hand, and numbers do not always agree.
Without PopdockAI
- Check the product in Akeneo
- Open the Business Central item card
- Read vendors and open orders separately
- Work out the net position by hand
With PopdockAI
- Product confirmed in Akeneo
- Inventory, committed sales and incoming purchases read
- Net position, vendors and soonest receipt shown
- Disagreements shown, none found never read as zero
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a supply and demand picture for the product `{product-identifier}`, looking back `{lookback-days}` days for sales lines (default 90).
**Step 1: Confirm the product in Akeneo**
Call `akeneo-get-product` (Akeneo server) with `identifier` set to `{product-identifier}`. Keep `product-name`, `brand`, `family` and `enabled`. If nothing matches, stop.
**Step 2: Find the item and its vendor in Business Central**
Call `business-central-get-item` (Business Central server) with `item-number` set to `{product-identifier}`. Keep `inventory`, `quantity-on-sales-order`, `quantity-on-purchase-order`, `vendor-number` and `vendor-name`. Then call `business-central-get-vendor-item` with `item-number` set to the same value to list every vendor that supplies it with `vendor-item-number`. If there is no item, report the product as absent from Business Central and stop.
**Step 3: Pull the open lines**
Call `business-central-get-purchase-transaction-line` with `number` set to the item number and `document-type` Order, and `business-central-get-sales-transaction-line` with `number` set to the item number, `document-type` Order, and `shipment-date.from` set to today minus `{lookback-days}` days. Use only `document-number`, `quantity`, `outstanding-quantity`, `expected-receipt-date` and `shipment-date` from them.
**Step 4: Report**
Product summary from Akeneo, then inventory, committed sales quantity, incoming purchase quantity and the net position, then the vendor list and the soonest expected receipt.
**Rules & Guidelines:**
* Akeneo tool: `akeneo-get-product`. Business Central tools: `business-central-get-item`, `business-central-get-vendor-item`, `business-central-get-purchase-transaction-line`, `business-central-get-sales-transaction-line`.
* Read-only. Do not call `business-central-update-item` or `akeneo-update-product`.
**Validation:**
* If a line list is empty, say none found; do not infer zero demand from a failed call.
* If line totals disagree with `quantity-on-sales-order` or `quantity-on-purchase-order`, show both numbers.Who it's for
One answer, three teams that use it
Operations managers
Know if you can sell a product
The net position combines stock, commitments and incoming supply.
Can we sell more of product HB-2201? Check Business Central supply and demand.
Buyers
See vendors and the next receipt
Vendors and the soonest expected receipt show when stock arrives.
When is the next receipt for product KT-330 in Business Central, and from which vendor?
Sales managers
Check committed demand
Committed sales quantity shows how much stock is already promised.
How much of product TS-2050 is already committed to sales orders in Business Central?
How it works
What PopdockAI does when you ask
You give a product identifier and a look back period, and your AI assistant works out net supply and demand. It stops if the product or item is missing.
01
Ask
You give a product identifier and a look-back period.
02
Confirm
It checks the product in Akeneo and finds the Business Central item.
03
Pull
It reads the vendors and the open purchase and sales lines.
04
Report
It shows the net position, vendors and the soonest receipt.
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.
akeneo-get-product
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
Net supply and demand in one answer
Related use cases
More ways to put this data to work
.webp){kind=logo}
Check Akeneo product readiness in Dynamics 365 Business Central
Ask your AI if a product is ready to sell. It compares the Akeneo record with the Business Central item and reports Ready, Needs attention or Not in ERP with each check.
Learn More
Find enabled Akeneo products blocked in Dynamics 365 Business Central
Ask your AI which enabled Akeneo products are blocked or out of stock in Business Central. It lists them by brand, with stock and vendor, and shows products missing from the ERP.
Learn More
Reconcile Akeneo products to Dynamics 365 Business Central items
Ask your AI to match enabled Akeneo products to Business Central items by SKU. It lists confirmed matches, possible matches and products with no item, and changes nothing.
Learn More
Audit Akeneo attribute setup
Ask your AI to audit Akeneo attributes and groups. It lists attributes with missing groups, empty groups and conflicting flags, with a suggested fix for each. Nothing is changed.
Learn More
Audit Akeneo select attribute options
Name a select attribute and your AI lists its Akeneo options, flagging missing labels, near duplicate codes and repeated sort orders, with a suggested clean-up. Nothing is changed.
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.