Connectors

/

Microsoft Dynamics 365 Business Central

/

Check Resource Management assignments against Business Central timesheets
Report
Cross-Connector

Compare scheduled time with booked timesheets

For payroll and project accountants who want Resource Management assignments checked against Business Central timesheets, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check Resource Management assignments against Business Central timesheets
For employee E0042, compare the time scheduled in Resource Management with the Business Central timesheets for October.
Employee E0042 was scheduled for 152 hours in October and booked 138 hours, 14 short. - Riverside Tower: scheduled 96 hours, booked 80, 2 lines unapproved - Northwind Plaza: scheduled 56 hours, booked 58, 1 line unposted - Booked with no assignment: 0 hours on job J00188 - Unit used: hours, checked against a sample row Want the same check for another employee?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-workforce-planning-reports-assignment-history
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

Scheduled time and booked time are never compared

Resource Management holds who was scheduled where, and Business Central holds the hours actually booked. Compared by hand, under-booked weeks and time on the wrong job go unnoticed until close.

Without PopdockAI

  • Export a person's assignments from Resource Management
  • Find their timesheet lines in Business Central
  • Match project numbers to job numbers by hand
  • Total scheduled and booked time project by project

With PopdockAI

  • Assignments and timesheet lines read together
  • Project numbers carried across as job numbers
  • Duration unit checked before comparing
  • Unapproved and unposted lines counted per project

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For employee {employee-number}, compare the time scheduled on projects in Resource Management between {date-from} and {date-to} with the time booked on Business Central timesheets for the same dates, per project, and report the gaps. If {date-to} is empty use today.

**Step 1: Read the scheduled assignments (procore-resource-management server)**

Call `procore-get-workforce-planning-reports-assignment-history` with `employee-number` set to {employee-number} and `max-records` of 500. Keep project-id, project-name, start-day, end-day, duration, job-title and cost-code-name. Keep only assignments that overlap the dates given. Then call `procore-get-workforce-planning-projects` and, for each project-name in the result, keep project-number.

**Step 2: Find the person in Business Central (business-central server)**

Call `business-central-get-resource` with `resource-number` set to {employee-number}. If nothing is found, call `business-central-get-employee` with the same `employee-number`, then `business-central-get-resource` with `name.contains` set to the surname you find. If more than one resource matches, list them and stop. Keep resource-number and use-time-sheet.

**Step 3: Read the booked time**

Call `business-central-get-timesheet` with `resource-number` from Step 2, `date.from` set to {date-from} and `date.to` set to {date-to}. Pass `max-records` of 500. Keep job-number, date, quantity, status, posted and approved-by. Carry the project across by matching the project-number from Step 1 to job-number here.

**Step 4: Report**

A table per project: scheduled duration, hours booked, difference, and how many of the booked lines are unapproved or unposted. Then list time booked on a job that has no scheduled assignment, and scheduled projects with no booked time at all.

**Rules & Guidelines:**

* `procore-get-workforce-planning-reports-assignment-history` and `procore-get-workforce-planning-projects` are on the procore-resource-management server. `business-central-get-resource`, `business-central-get-employee` and `business-central-get-timesheet` are 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` or `business-central-update-employee`.
* Duration in Resource Management may be in minutes or hours; check a sample row against its start and end time before comparing, and say which unit you used.

**Validation:**

* If no assignments overlap the dates, say so and stop.
* If the person has no Business Central resource, report that and show the scheduled time only.
* If the resource does not use timesheets (use-time-sheet is false), say so and stop rather than reporting zero hours booked.

Who it's for

One answer, three teams that use it

Payroll accountants

Find under-booked weeks

See where a person booked fewer hours than they were scheduled, project by project, before pay is processed.

For employee E0042, compare October assignments in Resource Management with Business Central timesheets.

Project accountants

Catch time on the wrong job

Find hours booked to a job that had no scheduled assignment, and scheduled projects with no time booked.

Did employee E0117 book time to any job they were not scheduled on in September?

Resource managers

Check bookings against the plan

See how closely booked hours follow the schedule, with unapproved lines counted.

Compare employee E0058 scheduled hours with booked hours for the last two weeks.

How it works

What PopdockAI does when you ask

You give the employee and the period and your AI assistant reads both systems. It only reads, and it stops rather than guess when the person is ambiguous or does not use timesheets.

Ask

You give the employee number and a date range.

Your AI tool

Read

It reads the person's scheduled assignments and finds them in Business Central, listing candidates if several match.

procore-get-workforce-planning-reports-assignment-history
procore-get-workforce-planning-projects

Compare

It checks the duration unit and matches each project number to a job number on the timesheet lines.

No items found.

Report

You get scheduled time, hours booked, the difference and unapproved or unposted lines for each project.

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-reports-assignment-history

Returns a project's workforce assignment history from Procore Resource Management: who was assigned, the project, start and end days and duration. Filter by employee number.
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

Booked time checked against the schedule

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