/
/
Focus inventory sign-off on the gaps worth real money
For operations teams who want Dynamics GP items and quantities compared with Business Central after migration, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
A wall of small differences hides the costly gaps
Checking inventory arrived in Business Central from Dynamics GP means comparing descriptions, units, costs, types and quantities for every item. Types are named differently, GP splits quantities by site, and small differences hide the gaps worth real money.
Without PopdockAI
- Export items from both systems
- Total GP quantities across sites
- Translate item types between the two systems
- Scroll a long list of rounding differences
With PopdockAI
- GP quantities are totalled across sites and item types mapped
- Discontinued items are left out but counted
- Cost differences over one percent are flagged
- Quantity gaps are ranked by value, costliest first
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Confirm that Dynamics GP inventory items were migrated to Business Central with matching setup and quantity on hand, for item `{item-number}` or, if that is empty, every GP item that is not discontinued.
**Step 1: Read the GP items**
Call `dynamics-gp-get-iv-item`, with `item-number` set to `{item-number}` when it is given, and a `max-records` large enough for the item list. Leave out items whose item-type is Discontinued; they are commonly left behind on purpose, so count them but do not report them as missing.
**Step 2: Read the GP quantities**
Call `dynamics-gp-get-iv-item-quantity` with the same `item-number` filter. Use the item-total row for each item (the one whose record-type is the overall item record, not a site). If only site rows come back, add up quantity-on-hand per item-number across sites.
**Step 3: Read the BC items**
Call `business-central-get-item`, with `item-number` set to `{item-number}` when it is given. Match GP `item-number` to BC `item-number`, trimmed and case-insensitive.
**Step 4: Compare each matched pair**
* item-description vs description
* base-u-of-m vs base-unit-of-measure
* current-cost vs unit-cost, and standard-cost vs standard-cost (flag a difference over 1 percent)
* quantity-on-hand vs inventory
* item-type vs type: GP Sales Inventory maps to BC Inventory, GP Services and Flat Fee map to BC Service, GP Misc Charges maps to BC Non-Inventory
**Step 5: Report**
Counts first: matched clean, matched with differences, missing from BC, discontinued and skipped. Then a table of quantity differences (item, GP on hand, BC inventory, difference), sorted by the absolute difference times current-cost so the largest value gaps come first. Then a table of the other differences.
**Rules & Guidelines:**
* `dynamics-gp-get-iv-item` and `dynamics-gp-get-iv-item-quantity` are on the dynamics-gp server. `business-central-get-item` is on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-item`, `business-central-update-item`, `dynamics-gp-iv-item-add` or `dynamics-gp-iv-item-update`.
* If either system has more than one company, ask the user which GP company and which BC company to use before the first call, and pass them as `company`.
**Validation:**
* If BC has the item but inventory is 0 for every item, report that opening quantities have not been posted in BC yet, instead of listing every item as a quantity difference.
* If GP and BC were not read at the same moment, quantities can drift on a live system. Say so when the GP company is still posting transactions.Who it's for
One answer, three teams that use it
Inventory managers
Check the costliest gaps first
Quantity gaps ranked by value let you count and fix the items that move the balance sheet first.
Compare Dynamics GP item quantities with Business Central and show the 20 biggest gaps by value.
Migration leads
Know if opening quantities were posted
If Business Central shows zero everywhere, it tells you opening quantities have not been posted yet.
Did our opening inventory quantities make it into Business Central from Dynamics GP?
ERP administrators
Check item setup carried over
Descriptions, units of measure and item types are compared, so setup differences are fixed before go-live.
Does item LP-10 have the same unit, type and cost in Dynamics GP and Business Central?
How it works
What PopdockAI does when you ask
You name one item or check all, and your AI assistant compares Dynamics GP items with Business Central and ranks the gaps by value. Both systems are only read.
01
Ask
You name one item or check all of them.
02
Read
It reads GP items, totals quantities across sites and maps item types.
03
Compare
It compares each item with Business Central and flags cost gaps over 1 percent.
04
Report
You get quantity gaps ranked by value, costliest first.
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.
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-quantity
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
Sign-off focused on the gaps that matter
Related use cases
More ways to put this data to work
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.

.webp)
