Clarity PPM: Why Are Timesheets Not Posting or Posted?

Document ID : KB000004146
Last Modified Date : 16/04/2018
Show Technical Document Details
Issue:

Timesheets that were submitted are not getting posted. The timesheets are stuck in the 'Approved' status.
Why are approved timesheets not being posted?

 

 

Cause:

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

Resolution:

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". srm_resources
-The resource track mode is set to 'PPM'
-The investment is "Open For Time Entry"
-The investment track mode is set.
-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.

User-added image
-Check if the Post Timesheets job has failed or completed.
-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

-Check the bg-ca.logs if the job is erroring out with a specific error. 

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


 

 

Additional Information:
https://comm.support.ca.com/kb/resource-manager-and-project-manager-timesheet-approval-rights/kb000027004