Connectors

/

Microsoft Dynamics 365 Business Central

/

Compare job title rates with Business Central resource costs
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Compare job title rates with Business Central resource costs
Compare the hourly rates on our Resource Management job titles with the unit costs of Business Central resources, and flag anything more than 15 percent apart.
Of 14 job titles, 3 have a rate more than 15 percent from the average resource cost in Business Central. - Site Engineer: rate $68.00, average cost $54.10, 26 percent gap - Foreman: rate $52.00, average cost $61.30, 15 percent under cost - No resources in Business Central: Safety Officer, Apprentice - Approximate match: Project Coordinator, matched to Coordinator Want the full table of all 14 job titles?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-workforce-planning-job-titles

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

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.

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

Your AI tool

Read

It reads the job title rates and the unit costs of Business Central resources, ignoring blocked ones.

procore-get-workforce-planning-job-titles

Match

It groups resources by job title and matches each rate to the same title, saying when a match is approximate.

No items found.

Report

You get each title's rate, average cost, gap percent and flag, then titles with no match on either side.

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-job-titles

Returns the job titles defined in Procore Resource Management.
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

Rate drift found before it costs margin

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