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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How are actual hours calculated?

(0) ShareShare
ReportReport
Posted on by 1,942

Dear all,

On project form we have two section for actuals and estimated hours.

I would like to know how these two values are calculated.

I have the same question (0)
  • Pankaj_Kumar Profile Picture
    70 on at
    RE: How are actual hours calculated?

    Hi Vighnesh,

    Below are the details of hours calculation description for PAS:

    Effort Hours â€“ this column reflects the original estimate.

    Effort Hours â€“ this column reflects the original estimate.

    Remaining Hours â€“ reflects the time left on the task. The remaining hours will be automatically reduced as actual hours are booked against the task. Meaning it will default to the difference between the estimated hours and actual hours. But you will also find that it will be quite common to adjust this figure during project delivery.

    Progress % â€“ This is calculated as (actual hours / EAC) *100. The percentage reflects the progression on the task.

    Actual Hours â€“ As time is approved from time sheets that actual hours field will increase.

    Refer article : neilparkhurst.com/.../ for details.

    Regards,

    Pankaj Kumar

  • Vighnesh Profile Picture
    1,942 on at
    RE: How are actual hours calculated?

    I saw this already. Does it mean the actuals are totaled at the project tasks from time entries?

  • Pankaj_Kumar Profile Picture
    70 on at
    RE: How are actual hours calculated?

    Yes, Actuals hours is getting calculate with Approve Time entries and you will able to view in Actuals as below:

     pastedimage1580976510122v5.png

    Regards,

    Pankaj Kumar

  • Suggested answer
    Vighnesh Profile Picture
    1,942 on at
    RE: How are actual hours calculated?

    I contacted Microsoft support and no one gave a specific answer and all my tickets are kept open. So I thought of troubleshooting this my way

    Below is flow given by Microsoft- Dynamics learning portal (source)

    Time-entry-flow.jpg

    Time entry : Project Approval = 1:N

    Project Approval : Journal Line = 1: N

    Fact entity, I have no idea on how it is related to others and where it is used  

    Important points to observe:

    1. When a time entry is created, no action on related entities.

    2. When a time entry is submitted, 2 journal lines (un-billed sales and cost) & a project approval records are created. 

    3. When a time entry is approved, the journal lines from previous step are updated and 2 actual records are created.

    4. Cost record from Actual entity are calculated from the journal line at the time of approval action.

    5. Un-billed sales record from Actual entity are calculated from the project approval (Billable hours field) at the time of approval action.

    6. So, the actual hours on project entity is calculated from actual records that are created during approval action, technically from journal lines

    During Approval action I think the calculation logic is done inside the code and not stored in CRM. I verified this by editing the values on project approval, journal line & actual records before and after the approval action.  

  • Verified answer
    Matthew Lazowski Profile Picture
    3,163 on at
    RE: How are actual hours calculated?

    Yes, a PSA plugin updates Actual Hours (msdyn_actualhours) on Project Task (msdyn_projecttask) based on user input in Billable Hours (msdyn_salesquantity) on Project Approval (msdyn_projectapproval). So if you want to update Actual Hours, you need to update Billable Hours on Project Approval and approve it.

    docs.microsoft.com/.../msdyn_projecttask

    docs.microsoft.com/.../msdyn_projectapproval

    Please remember, that your project needs to be linked to a contract via a contract line. Otherwise no actuals get created.

    You could add a couple of rollup fields on project task if you wanted to calculate actual hours yourself. You could have custom fields that calculate these values based on related time entries. You could have 1 field for all recorded hours, all submitted hours, all approved hours, all rejected hours etc.

    Fact entity:

    docs.microsoft.com/.../msdyn_fact

  • zica Profile Picture
    on at
    RE: How are actual hours calculated?

    Hi Vighnesh, can you please provide the link to the information source on Microsoft- Dynamics learning portal?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans