/
/
Check project materials exist as Business Central items
For operations teams who want Resource Management materials matched to Business Central items and stock, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
The problem
Material gaps are found when an order is rejected
Stock and orders are tracked per project in Resource Management while items are bought and costed in Business Central. A material with no item, or a blocked one, shows up only when the order fails.
Without PopdockAI
- List the materials on the project in Resource Management
- Search Business Central for each as an item
- Check blocked flags, stock and purchase orders
- Compare quantities by hand across the two systems
With PopdockAI
- Materials and quantities read from Resource Management
- Each matched to an item, with exact and approximate matches said
- Several matching items listed, never chosen
- Missing and blocked items flagged, none created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the materials on Resource Management project {project-name} (names containing {material-name}, all if empty), check that each exists as an item in Business Central, is not blocked, and compare the quantity ordered and available in Resource Management with Business Central stock and quantity on purchase orders.
**Step 1: Read the materials (procore-resource-management server)**
Call `procore-get-materials-mgmt-materials` with `project-name.contains` set to {project-name} and, if {material-name} is not empty, `name.contains` set to it. Pass `max-records` of 200. Keep name, project-name, availability-available, availability-ordered, availability-left-to-receive and availability-damaged.
**Step 2: Find each item (business-central server)**
For each distinct material name call `business-central-get-item` with the name as `description.contains`. If nothing is found try the first two words. If one item matches keep item-number, description, blocked, inventory, quantity-on-purchase-order, base-unit-of-measure and last-direct-cost. If several match, list them and do not choose.
**Step 3: Compare**
Compare availability-ordered with Business Central quantity-on-purchase-order, and note availability-available against inventory. Differences are expected when materials are held on several projects, so present them as figures, not errors.
**Step 4: Report**
A table with a row per material: Resource Management name, available, ordered and left to receive, Business Central item-number and description, inventory, on purchase order, blocked. Then list materials with no Business Central item, materials that match a blocked item, and materials that match several items.
**Rules & Guidelines:**
* `procore-get-materials-mgmt-materials` is on the procore-resource-management server. `business-central-get-item` is on the business-central server.
* Do not call any create, update, delete, sync or bulk tool on either server. This prompt only reads and reports. Never call `business-central-create-item` to fill a gap.
* Material names are free text. Say which matches are exact and which are approximate.
**Validation:**
* If Step 1 returns no materials, say so and stop.
* If Business Central returns nothing for every material, say the company may be wrong or the connection empty rather than listing every material as missing.
* If units of measure differ, say so and do not compare quantities.Who it's for
One answer, three teams that use it
Materials managers
Find items that will block an order
See materials with no Business Central item or a blocked one before purchasing starts.
On Riverside Tower, which materials have no item or a blocked item in Business Central?
Purchasing teams
Compare orders with what is on purchase orders
Check quantity ordered against quantity on purchase orders, so differences are looked at before receipt.
Compare ordered quantities for plasterboard on Northwind Plaza with Business Central purchase orders.
Project managers
Know materials are ready to buy
Get a one-reply view of which project materials are set up and in stock in the accounting system.
Check all materials on Contoso Warehouse against Business Central items and stock.
How it works
What PopdockAI does when you ask
You name the project and your AI assistant matches materials to items. It only reads, and it never creates the missing items.
Ask
You name the Resource Management project and optionally a material.
Read
It reads the materials with available, ordered and left to receive quantities.
Match
It finds each material as a Business Central item and lists candidates when several match.
Compare
You get inventory and quantity on purchase orders for each material, with missing, blocked and ambiguous items listed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.
procore-get-materials-mgmt-materials
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
Every material checked before the order goes out
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)
