Contents of the Create Retroactive Timesheet Adjustments Screen

Use the fields and options to configure the Create Retroactive Timesheet Adjustments screen.

Identification

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Timesheet Cycle

Field Description
Option

This field always displays One.

Start

Enter, or click to select, the timesheet cycle to be processed.

Timesheet Date

Field Description
Option

This field always displays Range.

Start

Enter, or click to select, the timesheet date from which to start. This entry indicates the beginning timesheet date.

End

Enter, or click to select, the timesheet date from which to end. This entry indicates the ending timesheet date.

Employees

Use these fields to select the range of employees to include for processing.

Field Description
Option

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.
Start

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

End

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.

Non-Contiguous

Select this check box to process a series of non-contiguous employee IDs. Selecting this check box enables the Employee Non-Contiguous Ranges subtask.

Transaction Currency

Note:

You can only view these fields if Enable Multicurrency Functionality is selected on the Configure Labor Settings screen.

Field Description
Option

From the drop-down list, select whether All or One of the transaction currencies will be part of the selection criteria.

Start

Enter, or click to select, the transaction currency of timesheets that you will generate. If you enter a transaction currency, then timesheets will only be created for employees that have a currency (as of the screen Timesheet Date) that is equal to the transaction currency specified on this screen.

Options

Warning:

Do not select the Apply Wage Determination check box if you are using the auto-adjust feature for hourly employees. If you use the Create Retroactive Pay Timesheets process in this circumstance, the timesheets created do not reflect the wage determination rates.

Field Description
Auto-Adjust Salaried Employees

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.

Auto-Adjust Hourly Employees

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.

Auto-Adjust % Source

Use this drop-down box to specify the source of the Auto-Adjust % which will be used on the selected, eligible timesheets. This drop-down list will only be available if the Auto-Adjust Salaried Employees and/or Auto-Adjust Hourly Employees check boxes are selected. If neither checkbox is selected, the drop-down box will be disabled and set to Not Applicable.

The options for this drop-down are as follows:

  • Manage Timesheet Periods: If you select this option, the Auto-Adjust % assigned to the timesheet period in which the original timesheet falls will be used. The Auto-Adjust % is assigned to timesheet periods in the Timesheet Period Details table in the Manage Timesheet Periods screen. If retroactive pay is being calculated based on a D-type.
  • Original Timesheet: If you select this option, the Auto-Adjust % from the original timesheet (the timesheet being processed) will be used.
  • Override Auto-Adjust %: If you select this option, the Auto-Adjust % from the Create Retroactive Timesheet Adjustments screen will be used.
  • Not Applicable: This option displays if the Auto-Adjust Salaried Employees and/or Auto-Adjust Hourly Employees check boxes are not selected.
Override Auto-Adjust %

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.

This field will only be available if the Auto-Adjust % Source is Override Auto-Adjust %.

Apply Wage Determination

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.

Apply Weighted Average Rates

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.

Apply to Unposted Timesheets

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.

Print Warning Messages

Select this check box to print warning messages on the error report.

Print Unchanged Lines

Select this check box to print unchanged lines for timesheets with other changes.

Retroactive Timesheet Data

Use the fields in this group box to enter the dates of the timesheets for which you want to generate retroactive pay timesheets.

Field Description
Timesheet Date

Enter, or click to select, the retroactive timesheet date.

Pay Type

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.

Fiscal Year

Enter, or click to select, the fiscal year.

Period

Enter, or click to select, the retroactive timesheet period.

Subperiod

Enter, or click to select, the retroactive timesheet subperiod.

Subtask

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.