/
/
Check direct cost vendors exist in Business Central
For finance teams who want vendors on recent Procore direct costs checked against Business Central, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Direct cost vendors fail checks late, at payment time
Procore direct costs name vendors the accounting system may not know, or has blocked. The mismatch is found when a payment run fails, and then someone searches name by name to see what went wrong.
Without PopdockAI
- List the vendors on recent Procore direct costs
- Search Business Central for each name
- Check each record for a block and a balance
- Total the Procore spend by vendor in a spreadsheet
With PopdockAI
- Direct costs grouped by vendor with totals and projects
- Each vendor marked Found, Blocked, Possible match or Not in Business Central
- Several matching vendors listed, never chosen for you
- Lookups capped at 40, with the unchecked count stated
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Take the vendors on Procore direct costs dated on or after {from-date} (default 90 days ago) and check each one exists in Business Central, is not blocked, and see what it is owed.
**Step 1: Read the direct costs (procore-construction-financials server)**
Call `procore-get-direct-costs` with `date.from` set to {from-date}. If {project-name} is not empty, pass it as `project-name.contains`. Pass `max-records` of 200. Group by vendor and keep the number of costs, the total of grand-total, the projects and the latest invoice-number for each.
**Step 2: Look each vendor up (business-central server)**
For each distinct vendor, call `business-central-get-vendor` with `name.contains` set to the vendor name. Keep vendor-number, name, blocked, balance, balance-due and payment-terms-code. Stop after 40 vendors and say how many were left unchecked.
**Step 3: Classify**
Mark each vendor Found, Blocked (blocked is not empty), Possible match (the name is similar but not equal; say how it differs), Several matches (list them) or Not in Business Central.
**Step 4: Report**
Give a table with columns Procore vendor, Direct costs, Total, Business Central vendor, Number, Status, Balance due. Put Blocked and Not in Business Central first and give the total Procore spend with each.
**Rules & Guidelines:**
* `procore-get-direct-costs` is on the procore-construction-financials server; `business-central-get-vendor` 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. To create missing vendors use the add-missing-direct-cost-vendors-to-bc prompt instead.
* Never choose between several matching vendors yourself.
**Validation:**
* If `procore-get-direct-costs` returns nothing, say so and stop.
* If a direct cost has an empty vendor, count it under No vendor named and continue.
* If a vendor search returns nothing, mark it Not in Business Central.Who it's for
One answer, three teams that use it
Accounts payable
Fix vendors before paying invoices
See which direct cost vendors are missing or blocked, with their balance due, so the run does not stall.
Which vendors on Procore direct costs since July are blocked or missing in Business Central?
Procurement teams
Check who you have been coding costs to
Find vendors that appear on direct costs but have no accounting record, with the spend for each.
Show direct cost vendors on Riverside Tower that are not in Business Central, with their total spend.
Finance controllers
Review vendor hygiene
Get a table of found, blocked and ambiguous vendors with total Procore spend, ready for review.
Check all Procore direct cost vendors for the last 90 days and put the blocked ones first.
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant reads the vendors and looks each up. It only reads, and it never picks between vendors with similar names.
Ask
You give a start date, or leave it at the last 90 days, and optionally a project.
Group
It groups the Procore direct costs by vendor with counts, totals, projects and latest invoice.
Look up
It checks each vendor in Business Central, up to 40, and keeps the balance due and block status.
Report
You get a table with Blocked and Not in Business Central first, and the total Procore spend with each.
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-direct-costs
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
Vendor problems found before the payment run
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)
