/
/
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.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the workforce planning projects with their numbers, status and closed dates.
Look up
It finds each project number as a Business Central job, with a labelled name search as a fallback.
Compare
You get a table with match quality and the projects with no job or a blocked or complete job.
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.
procore-get-workforce-planning-projects
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
No crew planned against a job that cannot bill
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)
