BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

Resource reservation analysis - Resource

An inquiry that compares each resource's capacity with its reserved hours over a date range: hard-booked, hard-assigned, hard-reserved and soft-reserved hours, unscheduled hours and utilization percentages.

Used by
Project manager, Resource manager
Business process
Plan projects
Menu item
PSAResAssignAnalysis_Employee
Main table
PSATmpResourceAssignmentAnalysis
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry that compares each resource's capacity with its reserved hours over a date range: hard-booked, hard-assigned, hard-reserved and soft-reserved hours, unscheduled hours and utilization percentages.
What you do hereUse it to answer 'who is over- or under-booked in this period?' so the resource manager can move work or free people for new projects.
ExampleFor November the BEAT resource manager sees R-0105 with 160.00 hours capacity and 176.00 hours hard-reserved, 110.00 percent utilization, while R-0118 has 160.00 hours capacity and only 64.00 hours reserved.
Resource reservation analysis - Resource page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processPlan projects
Menu pathProject management and accounting › Inquiries and reports › Resource scheduling inquiries › Resource reservation analysis - Resource
Set up firstSynchronize resource calendars capacity across all companies Microsoft Learn
Used next byResource fulfillment Microsoft Learn
Related pagesResource reservation analysis - Project Microsoft Learn Resource reservation analysis - Role Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Find over-booked resources

Compare each resource's capacity with its reservations for a period.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Resource scheduling inquiries > Resource reservation analysis - Resource.
  2. Enter the Start date and End date of the staffing period, and select a Resource or leave it blank for all.
  3. Sort on Utilization to find resources above 100 percent first.
  4. Select the resource row, then Reservation details to see which projects make up the hours, and move or cancel bookings there.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
CapacityThe hours the resource can work in the period, from its calendar.Microsoft Learn 160.00
Hard-reservedHours committed through hard bookings and assignments.Microsoft Learn 176.00
Soft-reservedTentative hours that don't yet commit the resource.Microsoft Learn 24.00
UtilizationReserved hours as a percentage of capacity for the period.Checked in Dynamics 365110.00

Common errors and fixes

MessageWhat to do
Capacity shows 0.00 for a resource.Capacity comes from the calendar synchronization; run Synchronize resource calendars capacity across all companies for the period. Microsoft Learn

Test checklist

  1. Give R-0105 a calendar with 8.00 hours a day.
  2. Hard-book R-0105 for 40.00 hours in one week.
  3. Run the analysis for that week.
  4. Check capacity 40.00, hard-reserved 40.00 and utilization 100.00.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Find over-booked resourcesEnter the period and sort on Utilization; check capacity before reading percentages.Utilization is reserved hours over calendar capacity; a missing capacity makes every percentage wrong.How often is calendar capacity synchronized?Trusting utilization after a calendar change without rerunning the capacity synchronization.Test: Capacity and utilization

Feature management and licence

Licence or add-inOn the live system, Resource manager maintains this page and Project manager views it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company for the projects, but capacity comes from resource calendars that the capacity batch job fills across all companies, so a resource lent by another legal entity can show here. Microsoft Learn
Can it be undoneReversible: The inquiry changes no data. Microsoft Learn
If you change it laterThe page recalculates from bookings, assignments and calendar capacity each time you search; after a calendar change, run the capacity synchronization again or capacity stays at the old value. Microsoft Learn
Technical architect

6Technical

Menu itemPSAResAssignAnalysis_Employee Checked in Dynamics 365
FormPSAResourceAssignmentAnalysis Checked in Dynamics 365
TablePSATmpResourceAssignmentAnalysisShown as “Hold information for resource assignment analysis” in Record infoChecked in Dynamics 365
Who can open itPrivilegesResource manager ProjResourceManagerMaintain project schedules ProjSchedulingMaintainMaintain project schedules ProjSchedulingViewDutiesInquire into project schedule master ProjProjectScheduleMasterInquireMaintain project schedule master ProjProjectScheduleMasterMaintainResource manager ProjResourceManager
2 security rolesProject manager ProjProjectManagerResource manager ProjResourceManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itResource manager ProjResourceManagerTo use itProject manager ProjProjectManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PSAResAssignAnalysis_Employee
Data migrationLoad order: Resource reservation analysis - Resource has no data entity in Data management: it fills a temporary table when you search. Reservations come from bookings and assignments on project teams (ResBooking and ResAssignment), created by staffing projects; capacity comes from the calendar synchronization job.Microsoft Learn
Everyone

8Sources