/
/
Add missing direct cost vendors to Business Central
For finance and operations teams who want vendors from Procore direct costs added to Business Central without retyping, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Direct cost vendors get retyped one at a time
Someone reads the vendor names off Procore direct costs, searches Business Central for each and keys in the missing ones. A name that is close but not identical gets duplicated, and the rest are found only when a payment run fails.
Without PopdockAI
- List the vendors on recent Procore direct costs
- Search Business Central for each name
- Retype the missing vendors one by one
- Clean up duplicates when a similar name slipped through
With PopdockAI
- Direct cost vendors and their spend read from Procore
- Each vendor checked in Business Central, possible matches skipped
- You confirm the list before anything is created
- Vendors created one at a time, stopping at the first error
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find the vendors on Procore direct costs dated on or after {from-date} (default 90 days ago) that have no vendor in Business Central, and, only after the user confirms, create them in Business Central.
**Step 1: Read the direct costs (procore-construction-financials server)**
Call `procore-get-direct-costs` with `date.from` set to {from-date} and `max-records` of 200. Collect the distinct, non-empty vendor names and the total of grand-total for each.
**Step 2: Check each vendor (business-central server)**
For each vendor, call `business-central-get-vendor` with `name.contains` set to the vendor name. A vendor is Missing only when nothing comes back. If something similar comes back, list it as Possible match and do not treat the vendor as missing. Stop after 40 vendors.
**Step 3: Confirm**
Show a table of the Missing vendors with the Procore spend for each, and the Possible matches you are skipping. Ask the user which vendors to create, limited to {max-create} (default 10). Do not continue until they answer. If none are Missing, say so and stop.
**Step 4: Create (business-central server)**
For each confirmed vendor, call `business-central-create-vendor` with the vendor name as `display-name` and no other fields, because Procore direct costs carry no address. Create one vendor at a time and stop at the first error.
**Step 5: Report**
List each vendor created with its Business Central number and id, each vendor that failed with the error, and each vendor skipped. Remind the user that address, tax registration and payment terms still need completing in Business Central.
**Rules & Guidelines:**
* `procore-get-direct-costs` is on the procore-construction-financials server; `business-central-get-vendor` and `business-central-create-vendor` are on the business-central server.
* `business-central-create-vendor` is the only write tool this prompt may call. Do not call any `procore-create-*`, `procore-update-*` or `procore-delete-*` tool, and do not call any `business-central-update-*` tool.
* The create tool is built Inactive and has not been run end to end; if it is unavailable, report the list and stop.
* Never create a vendor the user has not confirmed, and never create a vendor that already has a possible match.
**Validation:**
* If `procore-get-direct-costs` returns nothing, say so and stop.
* If a lookup fails, leave that vendor out and say so rather than creating it.
* If the user declines, create nothing and report the list only.Who it's for
One answer, three teams that use it
Accounts payable
Set up vendors before the payment run
Find vendors that direct costs depend on and create them in Business Central so invoices are not held up.
Which vendors on Procore direct costs in the last 60 days are missing from Business Central?
Finance controllers
Keep the vendor list free of near duplicates
Possible matches are listed and skipped, so a similar name is reviewed by a person rather than created twice.
Check Procore direct costs since July and show me the missing vendors and the possible matches before creating any.
Construction accountants
See spend before you set up a vendor
Each missing vendor comes with its Procore direct cost total, so you can create the biggest spenders first.
Show missing direct cost vendors with their spend, then create only Contoso Scaffolding.
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant compares the vendors in both systems. It creates nothing until you have seen the list and chosen the vendors.
Ask
You give a start date, or leave it at the last 90 days.
Check
It reads the vendors on Procore direct costs and looks each one up in Business Central.
Confirm
You see the Missing vendors with spend and the possible matches skipped, and pick which to create.
Create
It creates the confirmed vendors one at a time and reports each number, failure and skip.
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
Every direct cost vendor set up once, with no duplicates
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)
