Timesheets Not Posting or Showing as Posted

book

Article ID: 4146

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

One or more of the following occur:
-Timesheets that were submitted are not getting posted. They are still in the 'Approved' status.
-Reports actual hours/units show deficient/missing.

Cause

The Post Timesheets job checks the conditions of the below before it can set a timesheet status from 'Approved' to 'Posted'. 
  • timesheet
  • resource
  • investment 

Resolution

A. The following criteria must be fulfilled:

  • The timesheet has been in the 'Approved' status for at least 5 minutes before running the Post Timesheets job
  • The time period is not closed

  • The resource is 'Open For Time Entry'
  • The resource track mode is set to 'Clarity PPM'

  • The investment is "Open For Time Entry"
  • The investment track mode is set.
  • The investment team entry is 'Open for Time Entry'

  • Is setting in Administration, Project Settings: "Allow posting of future timesheets" checkmarked?
    If not, the current time period has not yet ended, therefore the timesheet will not post.

   

B. Check if the Post Timesheets job has been completing.

Use the following query before, during, and after the Post Timesheets job run to check how many timesheets remain to be posted:

select count(1)
from PRTIMESHEET
where prstatus = 3 --approved

C. If there is a custom timesheet process, make sure the conditions are met.

Additional Information

Clarity PPM: Timesheets not being approved