Calculation/Logic in Resource Availability report?

[Dhiren Aghera]

I am exploring the Resource Management module in my personal instance for providing a solution to my organisation. I am struggling to understand the Resource availability report within Resource management. I have two dummy resource created with the same properties, however, when I run the Resource availability report it shows different weekly hours. Can someone please help me understand what I am missing to understand here and how are the hours calculated.

Screenshot 1 - Project Manager 1 USI

Screenshot 2 - Project Manager 2 USI

[Dhiren Aghera]

Any help on the above query will be really appreciated. I am stuck to proceed without getting clarification on the query. Let me know if you need any additional information.

[abhinaykumar]

Hi @Dhiren Aghera 

Can you check schedule attached to users in schedule field of user and in user_has_schedule table.

Based on availability hours it is evident that projectManager1 has 9hours per day schedule and projectManager2 has 8hours per day schedule.

If same schedule is attached to both users then click on hours for projectManager2, you can see list of allocation daily records which reduced projectManager2 availability.

Thanks,

Abhinay kumar nandagiri.

[Dhiren Aghera]

Hi Abhinay,

As suggested I checked and there is no schedule attached to the users

I don't see any allocations for these users as well.

Please help in why both the users have different availability. Not able to figure it out.

[abhinaykumar · Accepted solution]

Hi @Dhiren Aghera 

Have you checked user_has_schedule table entries for these 2users?

If there are no entries in above table then OOTB 'Resource Management Schedule' will be applied for every user(8hours per day). This will be derived from 'com.snc.resource_management.default_schedule' property.

Ideally when aggregates are generated for new user then considering this schedule(40hours per week will be generated).

So, In your instance there is a change in schedule for Project Manager 1 USI before generating aggregates Or change in hours in default schedule.

Find default schedule and figure out the scheduled hours per day by checking schedule entries in 'cmn_schedule' table of that record. 

Then click on 'Update Resource Capacity' link available in user record in Resource Manager View for both users. It will update the aggregates and makes in sync with schedule.

If my answer was able to solve your query please mark it as Helpful & Correct.

Thanks,

abhinay kumar nandagiri.