/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the Procore purchase order contracts and the Business Central purchase orders.
Match
It pairs them on contract number only and lists title matches as possible.
Report
You get a table with each status and difference, the unmatched orders and counts.
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.
procore-get-purchase-order-contracts
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 commitment accounted for as an order
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)
