/
/
See where owner billing differs between systems
For finance teams who want Procore prime contracts compared with Business Central sales invoices, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Owner billing is tracked in one system and issued in another
Prime contracts live in Procore but the invoices are posted from Business Central. Comparing the totals by hand misses contracts that are under-billed and invoices that reference no contract.
Without PopdockAI
- Export the prime contracts from Procore
- Pull the posted sales invoices for each owner
- Work out which invoice belongs to which contract
- Total and compare each contract by hand
With PopdockAI
- Prime contracts are read from Procore with owner invoices
- Invoices attach to a contract only when they reference it
- Differences and open balances are shown per contract
- Unreferenced invoices are listed separately
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 Procore prime contracts on {project-name} (all projects if empty), compare the total invoiced to the owner with the posted sales invoices for the matching customer in Business Central, and say where billing is missing or different.
**Step 1: Read the prime contracts (procore-construction-financials server)**
Call `procore-get-prime-contracts`. If {project-name} is not empty, pass it as `project-name.contains`. Pass `max-records` of 100. Keep number, title, project-name, owner-client, status, revised-contract-amount, owner-invoices and payments-received.
**Step 2: Read the customer invoices (business-central server)**
For each distinct owner-client, call `business-central-get-posted-sales-invoice` with `sell-to-customer-name.contains` set to the owner-client and `max-records` of 200. If {from-date} is not empty, pass it as `posting-date.from`. Keep invoice-number, external-document-number, your-reference, total-amount, remaining-amount and posting-date. Stop after 20 customers and say how many were left unchecked.
**Step 3: Match across**
Attach an invoice to a prime contract when external-document-number or your-reference contains the prime contract number or the project name. Invoices for the customer that carry neither are Unreferenced; list them but do not assign them to a contract. Add up total-amount per contract and compare it with owner-invoices. If a customer name returns more than one customer in the results, say so rather than combining them.
**Step 4: Report**
Give a table with columns Project, Contract, Owner, Procore owner invoices, Business Central invoiced, Difference, Open balance in Business Central, Procore payments received, Status (Matched, Under-billed in Business Central, Over-billed in Business Central, No customer found). Then the Unreferenced invoices and counts of each status.
**Rules & Guidelines:**
* `procore-get-prime-contracts` is on the procore-construction-financials server; `business-central-get-posted-sales-invoice` 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.
* Owner names rarely match exactly; show the name you matched on.
**Validation:**
* If `procore-get-prime-contracts` returns nothing, say so and stop.
* If a customer search returns nothing, mark the contract No customer found and continue.
* If owner-client is empty on a contract, list it under Cannot match.Who it's for
One answer, three teams that use it
Accounts receivable
Find contracts you have under-billed
See which prime contracts have less invoiced in Business Central than Procore shows, so billing can catch up.
Which Procore prime contracts on Contoso Warehouse are under-billed compared with Business Central sales invoices?
Finance controllers
Review open balances per owner
Check what each owner still owes in Business Central beside the contract value and payments in Procore.
Show owner billing and open balances for all Fabrikam Developments prime contracts since 1 July.
Billing administrators
Clean up unreferenced invoices
List posted invoices that carry no contract number or project name, so they can be corrected at source.
Which posted sales invoices for Northwind Properties in Business Central do not reference a Procore prime contract?
How it works
What PopdockAI does when you ask
You name a project in plain words and your AI assistant reads the prime contracts, then the owner invoices in Business Central. It never assigns an invoice without a reference and only reads.
Ask
You name a project, or leave it blank for all, and optionally a from date.
Read
It reads the Procore prime contracts with owner invoices and payments received.
Match
It finds posted sales invoices per owner and attaches them only when they reference the contract or project.
Report
You get a table with differences and open balances, plus the unreferenced invoices.
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-prime-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
Billing gaps found before the owner finds them
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)
