Connectors

/

Microsoft Dynamics 365 Business Central

/

Match Resource Management projects to Business Central jobs
Report
Cross-Connector

Plan crews only against projects with an open job

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

Try PopdockAI free
Get a live demo
Match Resource Management projects to Business Central jobs
Check that our active Resource Management projects each have a job in Business Central, and that they agree on whether the work is still open.
Of 12 active Resource Management projects, 9 match a job on number, 1 matches only by name and 2 have no job. - No job: P-3105 Fabrikam Depot Fit-out and P-3112 Contoso Annex - Name match only: Northwind Plaza found as an approximate match - Disagree: P-3071 is complete in Business Central but still planned in Resource Management - Blocked: job P-3088 is blocked while crews are still planned Want the full table of all 12 projects?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-workforce-planning-projects

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Crews planned against jobs that cannot be billed

Workforce projects live in Resource Management while the costing job lives in Business Central. A job that is missing, blocked or closed is found only when time or invoices are rejected.

Without PopdockAI

  • List the projects in Resource Management
  • Look up each number as a job in Business Central
  • Compare open and closed state by eye
  • Learn a job is blocked when time is rejected

With PopdockAI

  • Workforce projects are read from Resource Management for you
  • Each number is looked up as a job, with name fallbacks labelled approximate
  • Open or closed disagreements and blocked jobs are listed
  • Nothing is created 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 Resource Management workforce planning project (status {status}, all if empty) has a Business Central job with the same number, and that the two agree on whether the work is open or closed. If {project-number} is not empty, check only that project.

**Step 1: Read the workforce projects (procore-resource-management server)**

Call `procore-get-workforce-planning-projects`. If {status} is not empty pass it as `status`; if {project-number} is not empty pass it as `project-number`. Pass `max-records` of 200. Keep name, project-number, status, stage, bid-rate and closed-date. List projects with no project-number separately.

**Step 2: Find each job (business-central server)**

For each project number call `business-central-get-job` with it as `job-number`. If nothing is found, call `business-central-get-job` once with the project name as `description.contains`, and treat any hit as an approximate match. Keep job-number, description, status, starting-date, ending-date, blocked, complete and bill-to-customer-number.

**Step 3: Compare**

For each matched pair compare open or closed: a Resource Management project that is closed, or has a closed-date, against a Business Central job that is not complete, and the reverse. Also note a blocked job that Resource Management still plans people on.

**Step 4: Report**

A table with a row per project: Resource Management name, number, status and stage, Business Central job-number, description and status, match quality (exact, approximate, none), and the issue if any. Finish with the lists of projects with no job, jobs found only by name, and blocked or complete jobs still open in Resource Management.

**Rules & Guidelines:**

* `procore-get-workforce-planning-projects` is on the procore-resource-management server. `business-central-get-job` is on the business-central server.
* Do not call any create, update, delete, sync or bulk tool on either server. This prompt only reads and reports. In particular never call `procore-create-workforce-planning-project`.
* Say which matches are exact on number and which are only by name.

**Validation:**

* If Step 1 returns no projects, say so and stop.
* If Business Central returns nothing for every project, say the company may be wrong or the connection empty rather than listing every project as unmatched.
* If more than one job matches a name, list the candidates and do not choose.

Who it's for

One answer, three teams that use it

Project managers

Know your jobs are open before you plan

Check that each project you are staffing has an open job in Business Central so the time you plan can be costed.

Do my active Resource Management projects all have an open job in Business Central?

Resource planners

Stop planning on closed work

Find projects that are complete in Business Central but still have people planned in Resource Management.

Which Business Central jobs are blocked or complete while the Resource Management project is still open?

Finance controllers

See jobs that were never set up

List the workforce projects with no matching job so the job can be created before time is booked.

List Resource Management projects with status Active that have no job in Business Central.

How it works

What PopdockAI does when you ask

You ask in plain words and your AI assistant reads Resource Management, then looks each project up in Business Central. It labels exact and approximate matches and only reads.

Ask

You give a status or a project number, or leave both blank to check every project.

Your AI tool

Read

It reads the workforce planning projects with their numbers, status and closed dates.

procore-get-workforce-planning-projects

Look up

It finds each project number as a Business Central job, with a labelled name search as a fallback.

No items found.

Compare

You get a table with match quality and the projects with no job or a blocked or complete job.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.

get-data

procore-get-workforce-planning-projects

Returns Procore Resource Management (workforce planning) projects with their number, name, status and stage. Filter by name and status.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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

No crew planned against a job that cannot bill

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