Connectors

/

Microsoft Dynamics 365 Business Central

/

Match Resource Management purchase orders to Business Central purchases
Report
Cross-Connector

Compare an order to its purchase document before you pay

For accounts payable teams who want a Resource Management purchase order compared with Business Central, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Resource Management purchase orders to Business Central purchases
Compare Resource Management purchase order PO-0412 on the Riverside Tower project with the matching purchase in Business Central.
PO-0412 matches a Business Central purchase order, with 2 of 6 lines showing a quantity difference. - Vendor: Contoso Building Supplies on both sides - Status: Open in Business Central, partly received in Resource Management - Line 3, 12 mm rebar: ordered 400, received 400 in one system and 320 in the other - Only in Business Central: 1 delivery charge line Want the full line table for all 6 lines?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items

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

Two systems, two views of what was delivered

Site teams record receipts in Resource Management while accounts payable works from the Business Central purchase. Comparing vendor and quantities by hand before payment is slow and easy to get wrong.

Without PopdockAI

  • Open the order and its lines in Resource Management
  • Find the purchase document in Business Central
  • Compare ordered and received quantities line by line
  • Spot a short delivery only after payment

With PopdockAI

  • The order and its lines are read from Resource Management for you
  • The Business Central document is found by number, then by vendor
  • Quantities are compared line by line with approximate matches labelled
  • Nothing is updated on either side

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Take the Resource Management materials purchase order {purchase-order-name} (narrowed to project {project-name} if given) and compare it with the Business Central purchase document it should correspond to: vendor, status, expected receipt date and, line by line, quantity ordered against received.

**Step 1: Read the purchase order (procore-resource-management server)**

Call `procore-get-materials-mgmt-purchase-orders` with `name.contains` set to {purchase-order-name}, and `project-name.contains` set to {project-name} when it is not empty. If more than one matches, list them and stop. Keep name, vendor, status, project-name, estimated-delivery-at and line-items-count. Then call `procore-get-materials-mgmt-purchase-orders-line-items` with `purchase-order-name` set to the exact name and keep line-number, item-name, quantity-ordered, quantity-received, quantity-outstanding and contract-delivery-at.

**Step 2: Find the Business Central document (business-central server)**

Call `business-central-get-purchase-transaction` with `document-number` set to the Resource Management name. If nothing is found, call it again with `buy-from-vendor-name.contains` set to the vendor and look through the results for a vendor-order-number or document-number containing the Resource Management name. Keep document-number, buy-from-vendor-number, buy-from-vendor-name, status, order-date, expected-receipt-date and total-amount. Then call `business-central-get-purchase-transaction-line` with `document-number` and keep number, description, quantity, quantity-received, outstanding-quantity and direct-unit-cost.

**Step 3: Carry the lines across and compare**

Match lines on item description, ignoring case, first by exact text and then by one containing the other, and say which are approximate. For each match compare quantity-ordered with quantity, and quantity-received on each side. Compare the vendors by name.

**Step 4: Report**

A header table: the two sides' vendor, status and delivery date. Then a line table with both quantities and the difference. Finish with lines present only in Resource Management, lines present only in Business Central, and receipts recorded on one side but not the other.

**Rules & Guidelines:**

* `procore-get-materials-mgmt-purchase-orders` and `procore-get-materials-mgmt-purchase-orders-line-items` are on the procore-resource-management server. `business-central-get-purchase-transaction` and `business-central-get-purchase-transaction-line` are 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. In particular never call `business-central-update-purchase-order`, `business-central-update-purchase-order-line` or `procore-update-materials-purchase-order`.
* A Business Central document can be an order, an invoice or a credit memo. Say which document-type you matched.

**Validation:**

* If Step 1 finds no purchase order, say so and stop.
* If no Business Central document is found, report the order as present in Resource Management and absent from Business Central and stop.
* If quantities use different units of measure, say so rather than reporting a difference.

Who it's for

One answer, three teams that use it

Accounts payable

Check receipts before you pay

See whether received quantities agree on both sides before you release payment on a materials order.

Compare Resource Management purchase order PO-0587 for Fabrikam Depot with Business Central and show any quantity differences.

Site administrators

Confirm deliveries reached accounts

Find receipts you recorded in Resource Management that are not yet shown in Business Central.

For purchase order PO-0391 on Contoso Warehouse, which receipts are recorded in Resource Management but not in Business Central?

Procurement managers

Catch vendor and date mismatches

Check the vendor and expected delivery date agree between the order and the purchase document.

Does Resource Management order PO-0620 for Northwind Plaza have the same vendor and delivery date in Business Central?

How it works

What PopdockAI does when you ask

You name the order and your AI assistant reads it in Resource Management, then finds and compares the Business Central document. It stops if the order is ambiguous and never updates anything.

Ask

You name the purchase order and optionally its project.

Your AI tool

Read

It reads the Resource Management order and its lines with ordered and received quantities.

procore-get-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items

Find

It locates the matching Business Central purchase document and reads its lines.

No items found.

Compare

You get a header table, a line table with differences, and lines found on one side only.

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-purchase-orders

Returns Procore Resource Management materials purchase orders with vendor, status, project and contract delivery date. Filter by status and project name.
get-data

procore-get-materials-mgmt-purchase-orders-line-items

Returns the line items of Procore materials purchase orders, with quantities and item details. Filter by purchase order.
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

Pay for what was actually received

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