/
/
Find job title rates that have drifted from cost
For finance teams who want Resource Management job title rates compared with Business Central resource costs, 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
Rates and costs drift apart until margin goes
Estimators set rates on job titles in Resource Management while finance holds the costs in Business Central. Nobody compares them, so the gap grows until a job loses margin.
Without PopdockAI
- Export job title rates from Resource Management
- Export resource unit costs from Business Central
- Match titles by hand and average the costs
- Work out which gaps are big enough to matter
With PopdockAI
- Rates and resource costs read together
- Resources grouped by job title with low, average and high cost
- Approximate matches said to be approximate
- Gaps beyond tolerance flagged, with titles missing on either side listed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare the hourly rate on each Resource Management job title (names containing {job-title}, all if empty) with the unit cost of Business Central resources holding the same job title, and flag rates that differ by more than {tolerance-percent} percent (default 10).
**Step 1: Read the job titles (procore-resource-management server)**
Call `procore-get-workforce-planning-job-titles`. If {job-title} is not empty pass it as `name.contains`. Pass `max-records` of 200. Keep name, type and hourly-rate. List job titles with no hourly-rate separately.
**Step 2: Read the Business Central resources (business-central server)**
Call `business-central-get-resource` with `max-records` of 500. Keep resource-number, name, job-title, unit-cost, unit-price, type and blocked. Ignore blocked resources, and keep only person resources, not machines, when type shows the difference.
**Step 3: Carry the job title across and compare**
Group the Business Central resources by job-title, ignoring case and surrounding spaces. For each Resource Management job title, take the group with the same name. If there is none, try a group whose name contains the title or is contained by it and say the match is approximate. For each match show the Resource Management hourly-rate, the lowest, average and highest unit-cost in the group, and the percentage gap between the rate and the average cost.
**Step 4: Report**
One table with a row per job title: title, Resource Management hourly-rate, number of Business Central resources, average unit-cost, gap percent, and a flag when the gap is larger than {tolerance-percent} percent (10 when empty). Then list the job titles with no Business Central resources and the Business Central job titles that do not exist in Resource Management.
**Rules & Guidelines:**
* `procore-get-workforce-planning-job-titles` is on the procore-resource-management server. `business-central-get-resource` 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-update-a-job-title` or `procore-create-job-title`.
* A rate and a cost are not the same thing (cost excludes margin and burden). Report the gap as a prompt to look, not as an error.
**Validation:**
* If Step 1 returns no job titles, say so and stop.
* If no Business Central resource has a job-title value, say the field is unused in that company and stop after listing the Resource Management rates.
* Do not add or compare amounts across currencies; show the currency where one is returned.Who it's for
One answer, three teams that use it
Finance managers
Spot rates that no longer cover cost
See which job titles are priced well above or below what their resources cost.
Which Resource Management job title rates are more than 10 percent from Business Central resource costs?
Estimators
Check the rates you price with
See where your hourly rates sit against actual unit costs before you build the next estimate.
How do the rates for Site Engineer and Foreman compare with Business Central resource costs?
Resource managers
Tidy job titles across systems
Find titles in one system that do not exist in the other, so naming can be aligned.
List Business Central job titles that do not exist in Resource Management.
How it works
What PopdockAI does when you ask
You give a tolerance and your AI assistant matches rates to costs by job title. It only reads, and it treats the gap as a prompt to look, not as an error.
Ask
You give an optional job title filter and a tolerance in percent.
Read
It reads the job title rates and the unit costs of Business Central resources, ignoring blocked ones.
Match
It groups resources by job title and matches each rate to the same title, saying when a match is approximate.
Report
You get each title's rate, average cost, gap percent and flag, then titles with no match on either side.
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-job-titles
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
Rate drift found before it costs margin
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)
