Why Are Timesheets Not Posting?

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

Issue:

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

 

 

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:

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.
-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 process involving the timesheet, make sure the conditions are met.