Time Entry has 2 fields to enter time:
- Actual Time
- Hours To Bill
“Hours To Bill” is automatically updated with “Actual Time” when “Billable” is checked. However you can update this field (“Hours To Bill”) independently too.
Please note that if you uncheck “Billable” field in time-entry record then the value of “Hours To Bill” is updated to 0.
We have added the below rollups to Case:
Total Time: This is the total of “Actual” time with status as “approved”. This includes both “billable” as well as “non-billable” time.
Billable Time: This is the total of “Actual” time with “billable” checked and “status” as “approved”.
Non-Billable Time: This is a calculated field. This is the difference between “Total Time” and “Billable Time”.
Hours To Bill Time: This is the total of “Hours to Bill” field where time-entry status is “approved”.
Unapproved Time: This is the total of “actual time” with time-entry “status” not equals “approved”.
Now lets see how the Rollups: values are calculated for Case using an example:
Total Time = 60 mins (Total of “Actual Time” with status = “Approved” entered for that particular case)
Billable Time = 45 mins (Total of “Actual Time” with “Billable” = “Yes” and status = “Approved” entered for that particular case)
Hours To Bill = 30 min (Total of “Hours To Bill” with status = “Approved” entered for that particular case)
Unapproved Time = 20 min (Total of “Actual Time” with status Not Equal “Approved” entered for that particular case)
These are rollup fields… so dynamics 365 automatically totals these values at regular intervals.
