Connectors

/

Microsoft Dynamics 365 Business Central

/

Reconcile Resource Management people with Business Central employees
Report
Cross-Connector

Keep workforce planning and payroll in step

For operations and HR teams who want Resource Management people compared with Business Central employees, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Resource Management people with Business Central employees
Compare our active Resource Management people with Business Central employees. Who is missing or has a different status or hire date?
Of 230 active people, 221 match an employee number, 5 are missing in Business Central and 4 have a conflict. - Missing in Business Central: employee numbers 10482, 10517 and 10533 and 2 others - Status conflict: 10209 is Active in Resource Management and Inactive in Business Central - Hire date differs: 10311 is 3 March in one system and 17 March in the other - No employee number: 6 people were listed separately and not matched Want the full tables for each group?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-workforce-planning-people

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

Two worker lists that drift apart

Workers are kept in Resource Management for planning and in Business Central for payroll. Compared by eye, leavers and new hires drift out of step and nobody sees it until pay or planning is wrong.

Without PopdockAI

  • Export the people from Resource Management
  • Export the employees from Business Central
  • Match employee numbers by eye in a sheet
  • Compare status and hire date one person at a time

With PopdockAI

  • Both lists are read for you with employee numbers
  • The match uses employee number only, never names
  • Missing people and status or hire date differences are listed
  • A mismatch in number schemes stops the check and nothing is changed

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 people in Procore Resource Management workforce planning (status {status}, default Active) against Business Central employees, matching on employee number, and report who is missing from either side or disagrees on status or hire date. If {employee-number} is not empty, check only that person.

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

Call `procore-get-workforce-planning-people`. If {status} is not empty pass it as `status`, otherwise pass Active. Pass `max-records` of 500. Keep employee-number, status, hired-date and hourly-wage. Drop people with no employee-number and list them separately, because there is nothing to match them on.

**Step 2: Read the Business Central employees (business-central server)**

Call `business-central-get-employee`. If {employee-number} is not empty pass it as `employee-number`. Pass `max-records` of 500. Keep employee-number, status, employment-date and job-title. Do not filter by status here, so that a person who is Inactive in Business Central still shows up as a match.

**Step 3: Carry the employee number across and compare**

Match the employee-number from Step 1 to the employee-number in Step 2 after trimming spaces and ignoring case and leading zeros. For each match compare Resource Management status with Business Central status, and hired-date with employment-date. The two systems may word statuses differently, so call a pair a conflict only when one side is clearly active and the other clearly not.

**Step 4: Report**

Give counts first (people checked, matched, conflicts). Then three tables: people in Resource Management with no Business Central employee, Business Central employees with no Resource Management person (only when {employee-number} is empty and {status} is empty or Active), and matched people whose status or hire date differs, showing both values.

**Rules & Guidelines:**

* `procore-get-workforce-planning-people` is on the procore-resource-management server. `business-central-get-employee` 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 `business-central-create-employee`, `business-central-update-employee` or `procore-create-people-belonging-to-a-company`.
* Employee number is the only join. Do not match on names, and do not report two people as the same because their dates agree.

**Validation:**

* If Step 1 returns no people, say so and stop.
* If Step 2 returns no employees, say the Business Central company may be wrong or the connection empty, and do not list every person as missing.
* If the employee numbers on the two sides look like different schemes (for example one numeric and one prefixed), say so, show three samples from each, and stop rather than reporting everything as unmatched.
* Hire dates may differ by timezone; treat a one day difference as a match and note it.

Who it's for

One answer, three teams that use it

HR administrators

Catch leavers and joiners on both sides

See who is active in workforce planning but missing or inactive in payroll, matched on employee number.

Which active Resource Management people have no employee in Business Central, matched on employee number?

Resource planners

Plan only with people who are on payroll

Find people you plan work for who are inactive or gone in Business Central.

List Resource Management people whose status conflicts with their Business Central employee record.

Payroll administrators

Check hire dates agree

Get matched people whose hire date differs between the two systems, shown side by side.

For employee number 10311, compare the status and hire date in Resource Management and Business Central.

How it works

What PopdockAI does when you ask

You ask in plain words and your AI assistant reads both lists and joins them on employee number. It only reads and tells you if the numbers do not look comparable.

Ask

You give a status or a single employee number, or accept active people.

Your AI tool

Read

It reads the workforce people and the Business Central employees with numbers, status and dates.

procore-get-workforce-planning-people

Match

It joins them on employee number only and stops if the number schemes do not line up.

No items found.

Report

You get counts, people missing on either side and status or hire date differences.

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

Returns the Procore Resource Management people roster with employee number, status and hired date.
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

One agreed picture of who works for you

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