/
/
Check every company on site is a known vendor
For operations and accounts payable teams who want Procore daily log companies checked against Business Central vendors, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Vendors on site that accounting has never heard of
Daily logs name the companies working on site, but the vendor list sits in Business Central. Nobody compares them, so a missing or blocked vendor is found only when its invoice stalls.
Without PopdockAI
- Pull the company names from manpower and equipment logs
- Search Business Central for each one
- Judge near matches by eye
- Find a blocked vendor when its invoice stalls
With PopdockAI
- Companies are collected from both log types for the period
- Names are matched after dropping punctuation and suffixes
- Near matches are listed as possible, never forced
- Nothing is reported missing if either side returns no data
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Check that every company logged on site in Procore project {project-id} from {date-from} (default the last 30 days) has a Business Central vendor that is not blocked.
**Step 1: Collect the companies from Procore (procore-project-management server)**
Call `procore-get-manpower-logs` with `project-id` {project-id}, `date.from` {date-from} and `max-records` of 200. Then call `procore-get-equipment-logs` with the same filters. Keep the distinct vendor-name values from both, and for each remember which log it came from and the most recent date.
**Step 2: Find each company in Business Central (business-central server)**
For each distinct vendor-name call `business-central-get-vendor` with `name.contains` set to the most distinctive word of the name (drop Inc, LLC, Ltd, Co and punctuation) and `max-records` of 10. Keep vendor-number, name, blocked, balance-due, email and phone-number.
**Step 3: Match across**
A match is a vendor whose name equals the Procore vendor-name after lower-casing and removing punctuation and company suffixes. If the only candidates are looser than that, list them as Possible match with the reason; do not pick one. If there is no candidate, the status is Missing in Business Central.
**Step 4: Report**
Give a table with columns Procore company, Seen on (manpower, equipment or both), Last logged, Business Central vendor number, Business Central name, Blocked, Balance due, Status (Matched, Blocked, Possible match, Missing in Business Central). Finish with counts of each status.
**Rules & Guidelines:**
* `procore-get-manpower-logs` and `procore-get-equipment-logs` are on the procore-project-management server; `business-central-get-vendor` is on the business-central server.
* This is read-only. Do not call any `procore-create-*`, `procore-update-*`, `procore-delete-*` or `procore-send-*` tool on the procore-project-management server, and do not call any `business-central-create-*` or `business-central-update-*` tool on the business-central server.
* Treat a blank vendor-name as unnamed and list the log count separately instead of looking it up.
**Validation:**
* If both Procore log tools return nothing, say so and stop.
* If `business-central-get-vendor` returns nothing for every company, say the Business Central server may be pointed at the wrong company and do not report them all as missing.
* If {project-id} is not a whole number, ask for it before calling anything.Who it's for
One answer, three teams that use it
Site operations managers
Know who is on site and payable
See which companies working on your site are not set up as vendors, before they send an invoice.
Which companies on the Fabrikam Depot daily logs since 1 October are missing as vendors in Business Central?
Accounts payable
Set up vendors ahead of time
Get the list of logged companies missing or blocked in Business Central so you can act before invoices arrive.
Check the Contoso Warehouse manpower and equipment logs from the last 30 days against Business Central vendors and list the blocked ones.
Project controls
Spot name variants across systems
Find companies whose logged name is close to but not the same as the vendor name, so one supplier is not set up twice.
Show possible name matches between companies on Northwind Plaza logs and Business Central vendors since last month.
How it works
What PopdockAI does when you ask
You give the project and period in plain words and your AI assistant reads the logs in Procore, then checks each company in Business Central. It only reads.
Ask
You give the Procore project and a start date, or accept the last 30 days.
Collect
It gathers the distinct companies on the manpower and equipment logs for the period.
Match
It finds each company in Business Central by normalised name and lists near matches as possible.
Report
You get a table with each status, balance due 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-manpower-logs
procore-get-equipment-logs
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
Known vendors before the first invoice arrives
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)
