Connectors

/

Procore

/

Reconcile Procore purchase orders with Dynamics 365 Business Central purchase orders
Report
Cross-Connector

Find commitments that never became purchase orders

For finance teams who want Procore purchase order contracts reconciled with Business Central, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore purchase orders with Dynamics 365 Business Central purchase orders
Reconcile the Procore purchase order contracts on Riverside Tower with the purchase orders in Business Central, with a tolerance of 5.
Of 14 purchase order contracts on Riverside Tower, 10 match, 2 differ in amount, 1 is a possible match and 1 is missing in Business Central. - Missing: contract PO-0311 for Fabrikam Glazing, 38,000.00 revised - Amount differs: PO-0275 is 120,500.00 in Procore and 112,500.00 in Business Central - Possible match: PO-0290 title matches an order with a different number - No contract: 2 Business Central orders have no Procore contract Want the full table of all 14 contracts?
Procore
Sample figures. Your results come from your own account.
procore-get-purchase-order-contracts

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Commitments in Procore, orders in accounting, matched by eye

Purchase order contracts sit in Procore while the orders sit in Business Central. Matching them from two exports means commitments with no order and amounts that drifted after change orders are missed.

Without PopdockAI

  • Export the contracts from Procore and the orders from Business Central
  • Match contract numbers by eye across two sheets
  • Compare each revised amount by hand
  • Miss orders that no contract points to

With PopdockAI

  • Both sides are read for you
  • Matching uses the contract number only, never the title alone
  • Amount differences beyond your tolerance are flagged
  • Orders with no contract are listed too

The prompt

Use this prompt

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

Prompt
**Objective:** Reconcile the Procore purchase order contracts for {project-name} (all projects if empty) against the Business Central purchase orders, so finance can see which commitments were never set up as purchase orders and where the amounts disagree. Treat amounts as different when they differ by more than {tolerance} (default 1.00).

**Step 1: Read the commitments (procore-construction-financials server)**

Call `procore-get-purchase-order-contracts`. If {project-name} is not empty, pass it as `project-name.contains`. Pass `max-records` of 200. Keep number, title, project-name, status, original-contract-amount, revised-contract-amount, invoiced and payments-issued.

**Step 2: Read the purchase orders (business-central server)**

Call `business-central-get-purchase-transaction` with `document-type` Order and `max-records` of 200. Keep document-number, vendor-order-number, buy-from-vendor-name, total-amount, total-outstanding-amount and status.

**Step 3: Match across**

For each contract, look for a purchase order whose document-number or vendor-order-number equals the Procore contract number, ignoring case, spaces and leading zeros. If there is no such match, say the contract is Missing in Business Central; do not guess from the title alone, but you may list a title match as a Possible match and say why. Compare revised-contract-amount with total-amount. List every purchase order that no contract matched as Missing in Procore.

**Step 4: Report**

Give a table with columns Project, Contract number, Title, Procore revised amount, Business Central order, Business Central amount, Difference, Status (Matched, Amount differs, Possible match, Missing in Business Central). Then the unmatched purchase orders, then counts of each status and the total difference.

**Rules & Guidelines:**

* `procore-get-purchase-order-contracts` is on the procore-construction-financials server; `business-central-get-purchase-transaction` is on the business-central server.
* This is read-only. Do not call any `procore-create-*`, `procore-update-*` or `procore-delete-*` tool, and do not call any `business-central-create-*` or `business-central-update-*` tool.
* Procore amounts and Business Central amounts may be in different currencies; if currency-code on the order is not the Procore currency, say so and do not report a difference.

**Validation:**

* If `procore-get-purchase-order-contracts` returns nothing, say so and stop.
* If `business-central-get-purchase-transaction` returns nothing, report every contract as Missing in Business Central and note the Business Central server may not be connected to the right company.
* If a contract number is empty, list it under Cannot match instead of forcing a match.

Who it's for

One answer, three teams that use it

Accounts payable

Find commitments with no order

See which Procore purchase order contracts have no purchase order in Business Central so none are paid outside the ledger.

Which Procore purchase order contracts on Contoso Warehouse have no purchase order in Business Central?

Cost accountants

Catch amount drift after change orders

Compare the revised contract amount with the order total so changes made in Procore reach the ledger.

Compare revised purchase order contract amounts with Business Central order totals for Fabrikam Depot, tolerance 10.

Finance controllers

Find orders with no contract

List Business Central orders that no Procore contract matches, so spend raised outside the project is visible.

List the Business Central purchase orders that no Northwind Plaza purchase order contract in Procore matches.

How it works

What PopdockAI does when you ask

You name a project in plain words and your AI assistant reads both systems and matches on contract number. It only reads, and it calls title matches possible.

Ask

You name a project, or leave it blank for all, and optionally a tolerance.

Your AI tool

Read

It reads the Procore purchase order contracts and the Business Central purchase orders.

procore-get-purchase-order-contracts

Match

It pairs them on contract number only and lists title matches as possible.

No items found.

Report

You get a table with each status and difference, the unmatched orders and counts.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.

get-data

procore-get-purchase-order-contracts

Returns Procore purchase order contracts with number, vendor, status and amounts.
Read only.Nothing in Procore 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 commitment accounted for as an order

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