Connectors

/

Procore

/

Check Procore direct cost vendors in Dynamics 365 Business Central
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Procore direct cost vendors in Dynamics 365 Business Central
Check the vendors on Procore direct costs since 1 August against Business Central. Which are missing or blocked?
Of 27 direct cost vendors, 2 are blocked and 3 are not in Business Central. - Blocked: Contoso Scaffolding, 6 costs, $41,300, balance due $8,200 - Not in Business Central: Fabrikam Traffic Control, 2 costs, $6,250 - Several matches: Northwind Traders, 3 vendors, left for you to choose - Unchecked: none, all 27 were looked up Want the full table of all 27 vendors?
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 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.

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

Your AI tool

Group

It groups the Procore direct costs by vendor with counts, totals, projects and latest invoice.

procore-get-direct-costs

Look up

It checks each vendor in Business Central, up to 40, and keeps the balance due and block status.

No items found.

Report

You get a table with Blocked and Not in Business Central first, and the total Procore spend with each.

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

Vendor problems found before the payment run

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