Connectors

/

Procore

/

Match Procore subcontractor invoices to Dynamics 365 Business Central purchase invoices
Report
Cross-Connector

Find approved invoices that never reached the ledger

For accounts payable teams who want Procore subcontractor invoices checked against Business Central, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Procore subcontractor invoices to Dynamics 365 Business Central purchase invoices
Check the approved subcontractor invoices on Riverside Tower in Procore. Which ones are not posted as purchase invoices in Business Central?
Of 18 approved invoices on Riverside Tower, 14 are matched, 2 are not posted, 1 has a different amount and 1 is a duplicate. - Not posted: Contoso Electrical invoice 7 and Fabrikam Concrete invoice 4 - Amount differs: Northwind Steel claimed 48,200.00, posted 42,800.00 - Duplicate: 2 posted invoices carry the same vendor invoice number - Not posted total: 63,450.00 claimed Want the full table of all 18 invoices?
Procore
Sample figures. Your results come from your own account.
procore-get-requisitions

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

Approved in Procore does not mean posted in the ledger

Approved subcontractor invoices are keyed into Business Central by hand. Without a check, some are never posted, some are posted twice and some carry a different amount from the one claimed.

Without PopdockAI

  • Export the approved invoices from Procore
  • Search Business Central for each vendor invoice number
  • Compare amounts and vendors line by line
  • Find the unposted ones when a subcontractor chases payment

With PopdockAI

  • Approved invoices are read from Procore with their claimed amounts
  • Each is looked up as a posted purchase invoice in Business Central
  • Unposted, duplicate and mismatched invoices are flagged
  • Drafts are never treated as posted and nothing is written

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 Procore invoices (requisitions) with status {invoice-status} (default Approved) on {project-name} (all projects if empty), confirm each one has a posted purchase invoice in Business Central with the same vendor invoice number and amount.

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

Call `procore-get-requisitions` with `status` set to {invoice-status}. If {project-name} is not empty, pass it as `project-name.contains`. Pass `max-records` of 200. Keep invoice-number, vendor-invoice-number, vendor, commitment, project-name, billing-date and total-claimed-amount.

**Step 2: Look each one up (business-central server)**

For each invoice that has a vendor-invoice-number, call `business-central-get-posted-purchase-invoice` with that value as `vendor-invoice-number`. If vendor-invoice-number is empty, call it with the Procore invoice-number as `vendor-invoice-number` instead and mark the row as matched on a weaker key. Keep invoice-number, buy-from-vendor-name, amount, remaining-amount, closed and posting-date. Stop after 50 lookups and say how many invoices were left unchecked.

**Step 3: Compare**

An invoice is Matched when a posted invoice exists and its amount equals total-claimed-amount. It is Amount differs when it exists with a different amount, Not posted when no posted invoice comes back, and Duplicate when more than one comes back. Also compare vendor names loosely and flag Vendor differs when the Business Central vendor does not look like the Procore vendor.

**Step 4: Report**

Give a table with columns Project, Procore invoice, Vendor, Claimed amount, Business Central invoice, Posted amount, Paid (closed), Status. Then counts of each status and the total claimed amount that is Not posted.

**Rules & Guidelines:**

* `procore-get-requisitions` is on the procore-construction-financials server; `business-central-get-posted-purchase-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.
* Never treat an unposted draft purchase invoice as posted.

**Validation:**

* If `procore-get-requisitions` returns nothing, say so and stop.
* If a Business Central lookup returns nothing, record the invoice as Not posted and continue.
* If the two systems use different currencies, report the amounts side by side and do not flag a difference.

Who it's for

One answer, three teams that use it

Accounts payable

Close the gap between approval and posting

Find approved Procore invoices that were never keyed into Business Central so none miss a payment run.

Which approved Procore invoices on the Fabrikam Depot project have no posted purchase invoice in Business Central?

Finance controllers

Catch amount differences before month end

See invoices posted for a different amount than claimed, shown side by side with the Procore figure.

Compare approved Procore invoice amounts with posted purchase invoices in Business Central for Contoso Warehouse and show any that differ.

Construction accountants

Spot duplicate postings

Find vendor invoice numbers posted more than once so a subcontractor is not paid twice.

Check approved Procore invoices across all projects for duplicate posted purchase invoices in Business Central.

How it works

What PopdockAI does when you ask

You say which invoices to check and your AI assistant reads them in Procore, then looks each one up in Business Central. It caps lookups at 50 and tells you what was left unchecked.

Ask

You give an invoice status and optionally a project.

Your AI tool

Read

It reads the matching Procore invoices with their vendor invoice numbers and claimed amounts.

procore-get-requisitions

Look up

It finds each one as a posted purchase invoice in Business Central, up to 50 lookups.

No items found.

Compare

You get a table with each status, counts and the total claimed that is not posted.

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-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
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

No approved invoice left unposted

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