to execute this process, which evaluates only timesheets that have been posted to Costpoint Labor.Use this screen to create retroactive pay timesheets.
If you have not posted timesheets, use the Manage Timesheets program to perform pay rate modifications; however, if you have posted timesheets, you must use this process to generate retroactive pay timesheets for the records in question.
The system generates new timesheets by comparing the hourly rate on the Manage Employee Salary Information record originally used for timesheet entry against the hourly rate on the new Employee Salary Information record. If there is a difference, the system uses this hourly rate differential to calculate the new labor cost. The monetary difference between the original labor cost and new labor cost generates on a new timesheet.
Regular, Correcting, D-Correcting, Labor Only, and N-Reversing timesheet types are used for the comparison. The system evaluates each timesheet line. Any labor cost differences result in a new timesheet line on the timesheet generated by this program.
You can use this application to determine the retroactive rate for posted timesheet lines that have been recasted. It applies the percent of increase between the original hourly rate and the new hourly rate to the recasted overtime premium.
You can also have this application determine the retroactive rate for posted timesheet lines that have been recalculated using a weighted average rate.
Overtime premium recast refers to the ability to reassign the premium portion of overtime charges to a specific recast project, account, and/or pay type that is different from the charge accounts noted on the original timesheets.
This application populates permanent reporting tables that you can use as sources for the timesheet adjustments made in this screen.
You can compute and report multi-state withholding taxes, based on the regulations specific to each state.
You can cancel this process at any time; however, if you are satisfied with your record specifications, you must click to execute this process, which evaluates only timesheets that have been posted to Costpoint Labor.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
This field always displays Range.
Enter, or click 
to select, the timesheet date from which to start. This entry indicates the beginning timesheet date.
Enter, or click to select, the timesheet date from which to end. This entry indicates the ending timesheet date.
This field always displays One.
Enter, or click to select, the timesheet cycle to be processed.
Use these fields to select the range of employees to include for processing.
From the drop-down list, select the range of employee IDs to include in the back-out process. Valid options are:
All — Select this option to include all employees IDs in the process.
One — Select this option to include only one employee ID in the process. Enter the employee ID in the Start field.
Range — Select this option to include a range of employees IDs in the process. This range begins with the employee ID in the Start field and ends with the employee id in the End field.
From Beginning — Select this option to include the first employee ID up to the employee ID in the End field.
To End — Select this option to include the employee ID in the Start field up to the last employee ID.
Enter, or click to select, the starting employee ID or name for the range to include in the back-out process. If you select All or From Beginning in the Option field, this field is inactive
Enter, or click to select, the ending employee ID or name for the range you want to include in the back-out process. If you select All, One, or To End in the Option field, this field is inactive.
Select this check box to process a series of non-contiguous employee IDs. Selecting this check box enables the Employee Non-Contiguous Ranges subtask.
Select this check box to apply wage determination to hourly/non-exempt employee timesheets. The wage determination rates are based on a combination of the selected timesheets' timesheet date, project, labor location, labor category, and labor group. The application evaluates all timesheets for the employees and date range specified. This check box is enabled only if you selected the Enable Wage Determination Feature check box on the Configure Labor Settings screen.
Select this check box to calculate and apply weighted average rates using the rules assigned to the Timesheet Cycle on the Configure Weighted Average Overtime Settings screen. A weighted average rate is calculated by adding the labor amount from several timesheet lines and dividing that sum by the total number of hours from those timesheet lines. This concept is important for those employees who perform contract work, where they receive a different pay rate for each project.
Select this check box to calculate and apply weighted average rates to unposted timesheets within the date range specified on the screen. This check box is enabled only if the timesheet cycle's Timesheet Processing Method is All Timesheets in the Period on the Configure Weighted Average Overtime Settings screen.
Select this check box to base salaried employees' retroactive pay on an adjusted labor cost. This check box is checked and disabled if the Enable for Salaried Employees check box is selected in the Automatic Auto-Adjust group box on the Overtime Settings subtask of the Configure Labor Settings screen. This field is enabled if the Enable for Salaried Employees check box is selected in the Selective Auto-Adjust group box on the Overtime Settings subtask of the Configure Labor Settings screen. If neither check box is selected for salaried employees, this check box is cleared and disabled. The application uses the employee's Rate Type value on the Manage Employee Salary Information screen as of the original timesheet date.
You cannot use auto-adjust if the original timesheet was prorated.
Select this check box to base hourly employees' retroactive pay on an adjusted labor cost. This field is checked and disabled if the Enable for Hourly Employees check box is selected in the Automatic Auto-Adjust group box on the Overtime Settings subtask of the Configure Labor Settings screen. This field is enabled if the Enable for Hourly Employees check box is selected in the Selective Auto-Adjust group box on the Overtime Settings subtask of the Configure Labor Settings screen. If neither check box is selected for hourly employees, this check box is cleared and disabled. The application uses the employee's Rate Type value on the Manage Employee Salary Information screen as of the original timesheet date.
You cannot use auto-adjust if the original timesheet was prorated.
Enter the auto-adjust percentage to be applied.
The auto-adjust feature synchronizes the timesheet information with the data on the Manage Employee Salary Information screen to eliminate any pay variance.
If, for example, a salaried employee works 50.00 hours in a week, you enter 100% in this field if the employee is to be paid his regular pay based on data on the Manage Employee Salary Information screen.
In this circumstance, adjust the pay at 100%, and the employee is paid his regular base pay for the week. Therefore, this employee is paid for 40.00 hours, even though he worked 50.00.
Select this check box to print warning messages on the error report.
Use the fields in this group box to enter the dates of the timesheets for which you want to generate retroactive pay timesheets.
Enter, or click to select, the retroactive timesheet date.
Enter, or click to select, the pay type to be used for the generated timesheets. This pay type should have a Factor of 1.0 on the Manage Pay Types screen with the Overtime, Cost Only, Salaried, Exempt, and Non-Exempt check boxes selected.
Select this check box to print unchanged lines for timesheets with other changes.
Enter, or click to select, the fiscal year.
Enter, or click to select, the retroactive timesheet period.
Enter, or click to select, the retroactive timesheet subperiod.
|
Subtask |
Description |
|
Employee Non-Contiguous Ranges |
Click on this link to open the Employee Non-Contiguous Ranges subtask, where you can enter non-contiguous employee records that require retroactive pay activity. If you are not entering non-contiguous records, use of this subtask is not required. |