Timesheets submitted by an employee should always be visible to their current manager, even if the submission occurred while a different manager was assigned.
If a current manager cannot see the submitted timesheet, please carry out the following checks.
Check if the timesheet workflow completed successfully
Use the Workflow Log to confirm whether the submission process completed without error.
Ask the employee to confirm the date they submitted the timesheet.
Open the Workflow Log and filter by that date.
Locate the workflow triggered by the employee’s user account for the Timesheet Submission.
Open the workflow and ensure it completed without error.
Check which post and manager the timesheet was submitted under
If the employee has more than one appointment record, they may have more than one assigned manager. When submitting a timesheet, the employee is asked to select which Post to log hours against, and this determines which manager receives the timesheet for approval.
We recommend the following:
Ask both managers to check their timesheet listings, as it will have been sent to the one associated with the selected post.
Run a data export to confirm which manager received the submission.
Data export to see who a timesheet has been sent to
Log in to the SelectHR Administrator Tool.
Click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectHR and log in.
Copy and paste the SQL below:
SELECT
p.[Person Number],
p.[First Name],
p.Surname,
p.[Manager Person Number],
p.[Manager Post Name],
p.[Manager Name],
t.[Timesheet Number],
td.[Start Date],
td.Hours,
td.[Unit Number]
FROM Person.Snapshot p
INNER JOIN Time.Timesheets t
ON p.[Person Number] = t.[Person Number]
INNER JOIN Time.[Timesheet Details] td
ON t.[Timesheet Number] = td.[Timesheet Number]
WHERE p.[First Name] = 'REPLACE WITH FIRST NAME'
AND p.Surname = 'REPLACE WITH SURNAME'
ORDER BY t.[Timesheet Number] DESC;
In the export window, click Options and select Paste SQL from clipboard.
Update the First Name and Surname in the query to match the impacted employee.
Click Data to view results.
The exported data will show:
The Managers currently assigned to the employee.
The Unit Numbers associated with each submitted timesheet.
If the unit numbers differ, it means the timesheet was submitted for a different post.
As a result, it may have been sent to a different manager than expected.