Connectors

/

Procore

/

Add missing Procore direct cost vendors to Dynamics 365 Business Central
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Add missing Procore direct cost vendors to Dynamics 365 Business Central
Which vendors on Procore direct costs since 1 September have no vendor in Business Central? Show me the list before you create anything.
4 vendors on Procore direct costs are missing from Business Central, and 2 more have a possible match so they are skipped. - Missing: Contoso Scaffolding, $18,400 of direct costs - Missing: Fabrikam Traffic Control, $6,250 - Possible match: Northwind Traders Ltd, similar to Northwind Traders - Limit: up to 10 vendors will be created in this run Which of the missing vendors should I create?
Procore
Sample figures. Your results come from your own account.
procore-get-direct-costs

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

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.

Prompt
**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.

Your AI tool

Check

It reads the vendors on Procore direct costs and looks each one up in Business Central.

procore-get-direct-costs

Confirm

You see the Missing vendors with spend and the possible matches skipped, and pick which to create.

No items found.

Create

It creates the confirmed vendors one at a time and reports each number, failure and skip.

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-direct-costs

Returns Procore direct costs, with vendor, date, status and amount. Filter by project or date.
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

Every direct cost vendor set up once, with no duplicates

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