Connectors

/

Procore

/

Match Procore projects to Dynamics 365 Business Central jobs
Report
Cross-Connector

Keep every live Procore project tied to a working job

For project managers who want Procore projects checked against Business Central jobs, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Procore projects to Dynamics 365 Business Central jobs
Check that every active Procore project with Tower in the name has a job in Business Central, and tell me where the two disagree.
Of 9 active Procore projects, 6 match cleanly, 2 have no job and 1 matches on number with a different name. - No job: P-2041 Harbour Tower Annex, in the construction stage - Name differs: P-2017 is Riverside Tower in Procore and Riverside Twr Phase 2 in Business Central - Blocked: job P-2030 is blocked while its Procore project is active - Job with no project: 1 Business Central job has no active Procore project Want the full list of the 9 projects?
Procore
Sample figures. Your results come from your own account.
procore-get-projects

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

Project and job records drift apart

Project numbers and names are typed into Procore and Business Central separately. Over time a live project has no job, a different name, or a closed job, and the gap shows up when costs will not post.

Without PopdockAI

  • Export the active projects from Procore
  • Look each number up in the Business Central job list
  • Compare names and statuses by eye
  • Find the closed job when costs are rejected

With PopdockAI

  • Active projects are read from Procore for you
  • Jobs are matched by number first, then name, with weak matches marked
  • Missing, renamed, blocked and complete jobs are listed
  • Nothing is created or edited in either system

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Check that each active Procore project whose name contains `{project-name}` (default: all projects) has a Business Central job, and report mismatches in name or status.

**Step 1: Read the projects in Procore**

Call `procore-get-projects` (procore-core) with `project-name.contains` set to `{project-name}` when given and `max-records` of {max-records} (default 100). Keep projects where `active` is true. Note `number`, `project-name`, `stage` and `project-id`.

**Step 2: Read the jobs in Business Central**

Call `business-central-get-job` (Business Central) with `description.contains` set to `{project-name}` when given. Match first on `job-number` equal to the Procore `number`, then on `description` equal to `project-name` ignoring case. Note `status`, `blocked`, `complete` and `person-responsible-name`.

**Step 3: Report**

* Active Procore projects with no Business Central job: `number`, `project-name`, `stage`.
* Matched on number but different name: show both names.
* Matched but the job is `blocked` or `complete` while the Procore project is active.
* Business Central jobs with no active Procore project.

End with the count of clean matches.
**Rules & Guidelines:**

* `procore-*` tools belong to the procore-core server; `business-central-*` tools belong to the Business Central server. Both servers must be connected.
* Only use filters the tools have. Pass `company` only when the user gave one.
* This prompt is read-only. Do not call any `business-central-create-*` or `business-central-update-*` tool.
**Validation:**

* If either side returns nothing, report the other side as entirely unmatched and stop.
* A Procore project with an empty `number` can only be matched by name; mark those as weak matches.

Who it's for

One answer, three teams that use it

Project managers

Confirm your projects can take costs

Check each of your live projects has an open job in Business Central so time and invoices post without rejection.

Do my active Procore projects each have an open Business Central job? Start with the ones with Warehouse in the name.

Finance controllers

Catch name and status drift

Find jobs that are blocked or complete while the Procore project is live, and projects renamed on one side only.

List Procore projects whose Business Central job is blocked or complete while the project is still active.

Systems administrators

Audit the number scheme between systems

See projects with no number and jobs with no project so the numbering stays consistent across both systems.

Which active Procore projects have no project number, and which Business Central jobs have no active Procore project?

How it works

What PopdockAI does when you ask

You ask in plain words and your AI assistant reads both systems and pairs the records. It only reads, and it tells you which matches are weak.

Ask

You name a project or part of a name, or leave it blank for all active projects.

Your AI tool

Read

It reads the active Procore projects and the matching Business Central jobs.

procore-get-projects

Match

It pairs them by number first, then by name, and marks weak matches.

No items found.

Report

You get the projects with no job, name mismatches, blocked or complete jobs and the clean match count.

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-projects

Returns the projects in Procore, with project number, name, stage, active flag and dates. Filter by name, number or status.
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 live project backed by a working job

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