Max of approval date

  • 1
  • Problem
  • Updated 2 months ago
  • Acknowledged
Issue:
If we have an approved time sheet re-opened and then re-approved, when we run report (used Project Time Actuals template) we are seeing 2 rows for each of the approved time sheets as we need the approval date/time column. When I contacted customer support team to see if we have a solution to get the latest data, looks like there is no solution.

Solution Idea:
If we can somehow get the max(approval date/time) while creating the report, that should resolve this.

Note: We are integrating this report with another ERP system and approved date/time is important for the audit. Hence we cannot remove that column to not get duplicate rows

Photo of Mukthesh

Mukthesh

  • 13 Posts
  • 0 Reply Likes
  • frustrated

Posted 2 months ago

  • 1
Photo of Vinodh.V

Vinodh.V, Community Moderator

  • 341 Posts
  • 9 Reply Likes
Hello Muktesh,

Thank you for posting your query in Replicon Community.

As I correctly understand you are using " Project time Actuals template" and would like to see the recent approval details in one line.

If the timesheet has 2 approvers, it shows 2 lines.

Sample:



We have assigned this post to our PM team

Regards,

Vinodh.V