/
/
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.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the person's scheduled assignments and finds them in Business Central, listing candidates if several match.
Compare
It checks the duration unit and matches each project number to a job number on the timesheet lines.
Report
You get scheduled time, hours booked, the difference and unapproved or unposted lines for each project.
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-reports-assignment-history
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
Booked time checked against the schedule
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)
