The Timesheet vs Function Line Exception Report generates a listing of employee's function line information and timesheets for those employees that do not have timesheet hours equal to half of the function line hours. This report is intended for a Biweekly payroll to determine when an employee has not been paid the usual working hours of half the function line hours.
Enter Starting Pay Period
-
Enter the starting pay period for a range of periods to select timesheets. The default is the current pay period.
Enter Ending Pay Period
-
Enter the ending pay period for a range of period to select timesheets.
When the Starting and Ending Pay Periods Equal and Biweekly, the Following Prompt Displays:
The pay period date range is deemed to be biweekly when the starting date is Sunday and the end date is the following Saturday.
Select Week Number
-
Enter 'B' to select both weeks.
-
Enter '1' to select the first week date range.
-
Enter '2' to select the second week date range.
The dates from this selection will display as the defaults for the following date prompts.
Enter Starting Date Range
-
Enter a starting date to select timesheets for a given date range.
Enter Ending Date Range
-
Enter the ending date to select timesheets for a given date range.
Select Employee Statuses To Be Reported
-
Enter 'N' to select none
-
Enter 'T' to select Terminated
-
Enter 'L' to select On Leave
-
Enter 'B' to select Both
-
Enter 'A' to select ALL
When Human Resources and SNS is active:
Select by Employee or SNS User Code
-
Enter 'E' to select by employee.
-
Enter 'U' to define the selection based on a SNS User Code.
When selection by 'E'mployee was chosen:
Report All or Selected Employees
When selection by SNS 'U'ser code was chosen:
Enter SNS User Code for Selection
Use the look-up for valid SNS User codes.
-
Enter a valid SNS User Code to define the selection criteria. Refer to Human Resources for details on SNS User Codes.
Sort by Employee Number, Name or Salary Grid
-
Enter 'E' to generate the report in employee number sequence.
-
Enter 'N' to generate the report in employee name sequence.
-
Enter 'G' to generate the report in employee name within salary grid sequence.
Enter Pay Codes for Timesheet Selection
By default, all pay codes from Posted Earning Codes (from DTE Code Maintenance) will be displayed.
-
Enter a list of pay codes to define the timesheet hours to be included and reported.
-
Enter Salary Grids for Employee Exclusions
-
Enter one or up to 22 salary grid codes to be used to exclude employees from the report. Salary grid codes may be entered using the wild card character '?'. An employee will be excluded from the report when the employee's salary grid from the Master for first function line (only) matches on of the salary grids from this list.
The report displays the following:
-
Employee number and name
-
Location code
-
Function line order
-
Pay cycle
-
Pay type
-
Pay code
-
Pay rate and hours
-
Occupation code
-
Employee type code
-
Salary grid
-
Percentage employed
-
Cost center
-
Default Earnings GL Account
Each time sheet detail will include the following:
-
Cost center code
-
Occupation code
-
Batch code
-
Shift code
-
Pay code and description
-
Input rate per hour
-
Timesheet Card number
-
Date
-
Hours input
-
Earnings (less premiums)
-
Premiums (include shift and occupation premiums)
-
Gross earnings (total earnings and premiums)