Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Timesheet report with approval history

(0) ShareShare
ReportReport
Posted on by 308

Hi,

We have received a request from auditors who need a file/report showing that timesheets for employees have been approved by project managers. I know that it is possible to see this by manually opening the workflow history of every line in the timesheet, but I would like to know if it is possible to generate a report that includes this information  

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Timesheet report with approval history

    This one requires customization and need a developer to do such kind of reports.

    Thanks,

    Girish S.

  • Gaute K Profile Picture
    Gaute K 308 on at
    RE: Timesheet report with approval history

    I am not a technical consultant, so unfortunately the link did not help. I appreciate your help so far, but I am still not able to solve this. Can this be solved directly in the browser (e.g Chrome), or does one need developer tools?

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Timesheet report with approval history

    WorkflowTrackingTable will have a field "user" - You need to join UserInfo table to get the name of the worker. You can also DirPersonUser table to get the worker name against user Id in WorkflowTrackingTable.

    In WorkflowTrackingStatus table you will have field named "ContextRecId"  - This field will store the RecId of the TsTimesheetTable or TsTimesheetLine based on the workflow configuration(Line level or header level workflow).

    Refer to the below blog which will help you to understand better.

    http://daxingwitheshant.blogspot.com/2019/05/x-code-to-return-workflow-approver-name.html

    Thanks,

    Girish S.

  • Gaute K Profile Picture
    Gaute K 308 on at
    RE: Timesheet report with approval history

    Exactly how do I make this report? In the WorkflowTrackingStatusTable I see all timesheet lines, but there is no information about the person who approved the lines. In the WorkflowTrackingTable I can filter for "Approval" as you suggested, but I don't see how I can identify which timesheet line the approval refers to. We need a report where you can see the timesheet submitter and timesheet approver on the same line. Is this possible?

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Timesheet report with approval history

    All the workflow details are available in above mentioned table. User who approved the workflow will be available in the above tables also.

    There is a standard report to show the timesheet details like employees, project, timesheet hours. On the "All timesheets" form - On the action pane - Timesheet - Print - Print timesheet - That report contains basic details - You can refer to the report. But it doesn't include the user who approved the timesheet - You need to add the code from the above mentioned tables.

    Thanks,

    Girish S.

  • Gaute K Profile Picture
    Gaute K 308 on at
    RE: Timesheet report with approval history

    Thanks, but this does not seem to include all details. We need a report where you can see the timesheets and the name of the project manager(s) who have approved the lines in the timesheets. Is it possible to generate such a report?

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Timesheet report with approval history

    Hi Gaute,

    Yes its possible. Workflow related details will be stored in WorkflowTrackingStatusTable and WorkflowTrackingTable.

    To get the Approved you can add a range on TackingType to Approval.

    WorkflowTrackingStatusTable will have field named ContextRecid - that field will store the RecId of Timesheet tables.

    Thanks,

    Girish S.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans