web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Day to Day Dynamics 365 / Dynamics 365 Project Servic...

Dynamics 365 Project Service Automation: A simple fix to correct Assigned Hours when adjusting resource booking durations via the Schedule Board

apa Profile Picture apa 8,284 Moderator

Tested on:
Dynamics 365 version 8.2

I recently came across an odd feature using the Schedule Board. I had hard booked resources from the Project Team Member Associated View and had a need to change the dates and lengths of the bookings. I wanted to use the Schedule Board for this and adjusted the dates and durations of the bookings only to find out that on the Project Team Member Associated View the Booked Hours and Assigned Hours were not aligned post change. I noticed that when a task on the WBS has a duration of 1 day, PSA aligns the Assigned and Booked Hours when the respective resource is reselected from the Resources box on the WBS. When the task has a duration of more than 1, i.e. the task spans multiple days, adjusting a resource's booking duration misaligned the Booked Hours and Assigned Hours.

PTMAV_2D00_unaligned_5F00_hours_5F00_.PNG

This seemed like an odd feature so I contacted Microsoft about it in the form of a short video describing the problem. They suggested I create a workflow which adjusts the Assigned Hours to match the Booked Hours. The solution proved to be quite simple:

The Bookable Resource Booking entity has a field Duration. When this field changes, the Booked Hours field seen on the Project Team Members Associated View captures the changes. To transmit the hours on the Assigned Hours field, a simple background workflow needs to be created. The workflow needs to fire off when the value on the Bookable Resource Booking entity’s Duration field changes. As an action, the Assigned Hours of the Project Team Member entity are to be updated with the dynamic value Booked Hours of the Project Team Member entity.

WF.PNG

WF_2D00_dynamic_5F00_values.PNG
After activating the workflow I adjusted the booking dates and durations via the Schedule Board and the workflow ran as intended and fixed the problem. Big thanks to Microsoft for the suggestion!

 PTMAV_2D00_aligned_5F00_hours_2D00_2_5F00_.PNG



Disclaimer:
All my blog posts reflect my personal opinions and findings unless otherwise stated.

Comments

*This post is locked for comments