Connectors

/

Microsoft Dynamics 365 Business Central

/

Check Resource Management materials against Business Central items
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Resource Management materials against Business Central items
On the Riverside Tower project, do all the Resource Management materials exist as items in Business Central, and do the quantities line up?
Of 18 materials on Riverside Tower, 14 match a Business Central item, 2 have none and 1 is blocked. - No item: Stainless anchor bolts M12 (no exact or approximate match) - Blocked: Fire collar 110 mm, item 10482 - Several items: Cable tray 300 mm, 3 candidates, left for you to choose - Quantities: Plasterboard 12.5 mm, ordered 400, on purchase order 350 Want the full table of all 18 materials?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-materials

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It reads the materials with available, ordered and left to receive quantities.

procore-get-materials-mgmt-materials

Match

It finds each material as a Business Central item and lists candidates when several match.

No items found.

Compare

You get inventory and quantity on purchase orders for each material, with missing, blocked and ambiguous items listed.

Your AI tool

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.

get-data

procore-get-materials-mgmt-materials

Returns materials management materials from Procore Resource Management, including item numbers and quantities available.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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

Every material checked before the order goes out

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation