Selective DTE Timesheet Retro Process

The Selective DTE Timesheet Retro Process allows you to select timesheets for a single employee, to be either reversed out and replaced or have retro calculated, based on a new pay rate. Pay rates are taken from the appropriate salary grid point using the DTE rules. Timesheets that have a zero rate difference and the same salary grid will be omitted.

When the retro type processing is selected, occupation and shift code * premiums difference will be calculated and when applicable the premium is paid out under the Pay Code from the occupation or shift code database definition.

All newly generated batches will be automatically balanced and closed.

This process includes the option to maintain multiple sets of stored prompts.

Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.

This option will run in batch only.

Enter Starting Pay Period

Enter the starting pay period for a range of pay periods to be processed. Only timesheets within this range will be processed. This range of pay periods will also be used when costing based on GL history is selected.

Enter Ending Pay Period

Enter the last period to be used for the period range.

Enter Starting Date Range

Enter the starting date for a range of dates for timesheet entry selection.

Enter Ending Date Range

Enter the ending date for a range of dates for timesheet entry selection.

Enter the Number of Employee to be Reported

Enter the employee number to be processed.

Enter Salary Grid to Change to

Enter to have each timesheets use the salary grid from the timesheet for pay rate calculations.
Enter a salary grid to be used for pay rate calculations.

Enter Portion of Hours to Process

Enter to have the full hours be used in the retro and reversal timesheets.
Enter a percentage of hours to be used from selected timesheets.

Enter Location Codes for Selection

Enter to include all location codes.
Enter a list of location codes for timesheet selection.

Include/Exclude Pay Code List

Enter 'I' to include Pay Codes for timesheet selection.
Enter 'E' to exclude pay code for timesheet selection.

Enter Pay Code

Enter pay codes (one by one) to include/exclude.

Create Reversal/Replacement Timesheet Adjustments

Enter 'Y' to process the timesheet reversal/replacement process. This option will reverse out the select timesheets and create new timesheets using the new rate and or salary grid. All GL costing for the new timesheets is taken from the original timesheet.
Enter 'N' to generate the retro type process. The retro process will accumulate the dollar amount of difference and pay that amount out as a money only transaction.

When 'Y' Create Reversal was Selected, the Following Prompt will Display:

EI Allocation to Current Pay Period

Enter 'N' to have the EI allocated to the pay period defined by the entry date.
Enter 'Y' to have all EI allocated to the current pay period, as defined by the Batch Period. When this option is selected, the batches created by this process will be marked with the EI To Current Period flag. The Timesheet Entry and Timesheet Edit will both enforce the EI allocation rule when these batches are accessed.

If 'N' Create reversal was selected above, the following prompt will appear:

Costing by Base FUN/Multiple Function/History

For function line costing (B and M):

When the employee s function line contains a GL code that GL will be used. When no GL code exists on a function line the GL is taken from the cost center for that function line.

Enter 'B' to distribute the retro pay based on the first or master function line.
Enter 'M' to distribute the retro pay over multiple function lines.
Enter 'H' when costing of the retro pay should be costed based on the GL accounts and cost centers taken from the employees GL history for the range of pay periods defined above. A prompt follows that allows you to specify secondary pay codes to exclude from the GL account history selection. The GL history costing is first selected based on the pay code include/exclude list defined for the retro run. The retro amount will be costed to the accumulated history GL accounts on a ratio to the amount of the accumulated monies paid out under each GL and cost center set. For GL history where no cost center is available, the employee s cost center from the master function line will be used. Compressed GL history that will be omitted.

If 'H' selected, the following prompts would appear:

Pay Codes to Exclude for History Costing

Enter any additional pay codes to be excluded from the accumulation of GL history entries for costing based on GL history earnings.

The message Already Accounts for will be followed by the pay code include/exclude list entered above. The History Costing takes this previous pay code list into account.

If 'M' selected, the following prompt will appear:

Pay Codes to Exclude on Function Line Costing

Enter any pay codes to be excluded on function lines from the costing over multiple function lines.

Enter Batch Period

Enter the pay period for the batch. This should be the period the retro is to be paid in. Employees not in cycle for this pay period will be bypassed.

When reversal/replacement processing was selected, the next two prompts will be omitted:

Enter Batch Pay Code

Enter the default pay code to pay the retro under.

Retro should be paid out under a money only pay code.

Batch Pay Code Exceptions allows retro from selective pay codes to be paid out under either the same pay code or another pay code.

Enter the pay code from history followed by the pay code to be used for payment of the retro for those earnings. Use the wild card * to indicate all digits in a series. For example, 7* means all 70 series pay codes.

Report Only or Process

Enter 'R' to generate just a report.
Enter 'P' to generate the reports and generate the retro timesheet entries.

Enter Batch Type

Enter a valid batch type code. The batch type code entered will be used to generate batches of retro transactions. This is validated by the system.

The reports lists the following:

This ######.LST report for Retro Processing lists the following:

The employee number, name.
Date of timesheet to be generated.
Pay code for timesheet to be generated.
Total retro amount per pay code.
Employee costing distribution
GL account and cost center when costing by GL history was selected.
Total entries and moneys to be generated.

The final run will create the payroll batches of transactions. The batch numbers generated will appear in the program log.