Contents of the Apply Weighted Average Rates To Timesheets Screen

Use the fields and options to configure the Apply Weighted Average Rates to Timesheets 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

Use this group box to select the timesheet cycle or cycles you want to recompute.

Field Description
Option

From the drop-down list, to select the range of timesheet cycles you want to process. Valid options are:

  • All: Select this option to process all timesheet cycles and timesheet periods with unposted timesheets. Selecting this option disables the Timesheet Period and Weighted Average group boxes.
  • One: Select this options to process one timesheet cycle.
Start

If you did not select All timesheet cycles, you must enter, or click to select, a timesheet cycle here. Entering a value here enables the Timesheet Period and Weighted Average group boxes.

Only employees whose pay class and FLSA exempt status match one of the selected pay class/FLSA exempt status combinations from the Configure Weighted Average Overtime Settings screen are selected for processing.

Timesheet Period

If the Timesheet Cycle you entered has a Period Type of Timesheet Period on the Weighted Average Overtime Setup screen, you must use this group box to enter the start date and end date of the timesheet period you want to process. displays the start dates and end dates of all valid timesheet periods.

Field Description
Option

This field always displays Range.

Start

Enter, or click to select, the start date of the timesheet period you want to process. After you select the date, the application automatically enters the end date in the End field for this timesheet period.

End

Enter, or click to select, the end of the timesheet period you want to process. If you did not enter a date in the Start field but enter an end date here, the application automatically inserts the start date for this timesheet period in the Start field.

Weighted Average

If the Timesheet Cycle you entered has a Period Type of Weighted Average Period on the Weighted Average Overtime Setup screen, you must use this group box to enter the start date and end date of the timesheet period you want to process. displays the start dates and end dates of all valid timesheet periods.

Field Description
Option

This field always displays Range.

Start

Enter, or click to select, the start date of the timesheet period you want to process. After you select the date, the application automatically enters the date in the End field for this timesheet period.

End

Enter, or click to select, the end of the timesheet period you want to process. If you did not enter a date in the Start field but enter an end date here, the application automatically inserts the start date for this timesheet period.

If the Period Type assigned to the Timesheet Cycle is Weighted Average Period on the Weighed Average Overtime Setup screen and weighted average is processed for a period, the weighted average period’s Processed flag in the Weighed Average Periods table is set to Y (Yes).

Transaction Currency

You can only use the following fields if Multi-Currency functionality is enabled 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 want to recompute. If you enter a transaction currency, then timesheets will be processed for only the employees that have a currency (as of the screen Timesheet Date) that is equal to the transaction currency specified on this screen.

Sort By

Field Description
1st Sort

This field always displays Employee ID.

Process

Click and select Apply Weighted Average Rates to begin the recomputing process. You must have already printed the report (while still in this screen) to enable this option.

Process/Print

Click and select Print/Apply Weighted Average Rates to print the report and then continue immediately into the recomputing process.

Special Hints

There are several important timing and processing considerations when using this program:

  • Run this screen after entering regular timesheets but before processing or posting them in any way, or before exporting them to your outside payroll service.
  • This program recomputes only R (Regular), D (Replacement), and L (Labor Only) timesheets; it does not recompute other timesheet types (Correction, Bonus, and so on), and each timesheet is recomputed by itself, even if several are included in the selected time range.
  • If an employee's hourly rate is changed on the Manage Employee Salary Information screen after the timesheets are entered but before this program is run, the weighted average hourly rate is not correct.
  • All overtime pay types are recomputed even if you selected the Recalculate option in the Weighted Average Rate group box on the Manage Pay Types screen.
  • Back up the Timesheet file before beginning this process so that you can return to the original files if necessary.