Timesheet Options Tab

Use the fields in the Timesheet Options tab to control timesheet entry or import functionality.

Contents

Field Description
Enable Union Functionality

Select this check box to allow the processing of Union Payroll and enable access to the applicable Union tables. It also enables the Manage Union Profile Setup screen, where you establish the union, local, and crew chief information.

Select this check box to access the Crew Assignment, Manage Fringe Codes, and Manage Fringe Modify Codes.

If you select this check box, you cannot use the Manage Wage Determination Fringe Charge Codes and the Manage Wage Determination Rates screens.

If you select his check box, the Require Labor Location check box is automatically selected and the Union Fringe Ceilings by Local option becomes enabled.

Union Fringe Ceilings by Local

Select this check box to apply union fringe pay period and contract ceilings at the local level, rather than at the local/union/GLC level. If you select this check box, you have access to the Manage Union Fringe Ceilings by Local screen. In addition, the Compute Payroll process applies the ceilings set up on the Manage Union Fringe Ceilings by Local screen, rather than the ceilings from the Fringe Table subtask of the Manage Union Profile Setup screen. If this check box is selected and no ceilings are assigned to a local/fringe code on the Manage Union Fringe Ceilings by Local screen, no ceilings are applied to that local/fringe code. However, when you compute payroll, Costpoint prints a warning report, listing which local/fringe code combinations were not set up on the Manage Union Fringe Ceilings by Local screen.

Enable Wage Determination

Select this check box to enable the processing and setup of screens for wage determination project fringe and wage-related amounts. Selecting this check box (along with the Require Labor Location check box) enables the Manage Wage Determination Fringe Charge Codes screen, where you establish the charge settings for handling WD project fringe amounts. It also enables the Manage Wage Determination Rates screen, where you establish base pay rates per hour and an associated handling method, Fringe Amounts per Hour, and a related Fringe Payment Method. Fringe codes are established on the Manage Fringe Codes screen. The Fringe Payment Method enables the automatic generation of a "Fringe" timesheet line, when the timesheet line being charged results in "Fringe" fields being found in the Wage Determination Rates table, and the Wage Determination Rates record has the Fringe Payment Method set to Cash.

For Costpoint Multicurrency (MU) users, if you selected both the Enable Wage Determination check box and the Enable Multicurrency Functionality check box, wage determination will be applied only to timesheets with USD (US Dollar) as transaction currency. This functionality is implemented in the following screens:

  • Manage Timesheets
  • Manage Correcting Timesheets
  • Import Timesheets
  • Import Timesheets from Deltek Time & Expense
  • Create Auto-Pay Timesheets
  • Create Retroactive Timesheet Adjustments
Enable Batch

Select this check box to turn on the feature for calculating "running" control totals for regular hours, other (overtime) hours and total hours, and by timesheet type (regular, other than regular, and total number of timesheets) for a Group (or batch) of timesheets being entered on the Manage Timesheets screen. Select this check box to enable user entry of control totals for the batch before beginning timesheet entry. These control totals are compared to the system-calculated totals and you are alerted to any differences when you exit the timesheet entry screens.

Use Standard Rates

Select this check box to use standard (or effective) hourly rates for calculating labor costs for salaried employees. To use this feature, enter, on the Manage Employee Information screen, the estimated hours to be worked per year by employees. Costpoint calculates the standard (or effective) hourly rate (annual salary divided by the number of estimated hours) and uses this figure to calculate labor cost on the timesheet line.

Standard Variance Account

Use this field to generate a separate timesheet line that shows the difference between total labor cost at the standard rate and the employee's salary amount if the Standard Variance button is clicked on the Manage Timesheets screen during timesheet entry. This field is available and required only if you selected the Enable check box. Enter a General Ledger account or click to select your account.

Use Reference Date in Correcting and Labor-Only Timesheets

Select this check box to use the reference date to determine the rate when entering Correcting or Labor Only timesheets.

Allow edit of timesheet line GLC

Select this check box to allow changes to the General Labor Category (GLC) on each timesheet line. If you do not select this check box, the GLC is still stored on each timesheet line, but is filled in from the Default tab of the Manage Employee Information screen. This check box is selected as the default when you first enter this screen.

Allow edit of timesheet Workers' Compensation Code

Select this check box to allow edit of the workers' compensation code (the WC field) on the timesheet line.

Require Labor Location

Select this check box to require that a labor location be entered for each timesheet line. In order to access the Manage Wage Determination Rates and Manage Wage Determination Fringe Charge Codes screens, you must select both the Enable Wage Determination Feature and Require Labor Location check boxes.

Enable Pay Type Restrictions

Select this check box to enable the Manage Pay Type Restrictions screen, where you establish the pay types that cannot be used for a given project, but can optionally be used for a given location and labor group/union. It also enables the related automatic editing of the timesheet line pay type being charged based upon the entries on the Manage Pay Type Restrictions screen.

Enable Multicurrency Functionality

Select this check box to allow multi-currency functionality in labor and leave transactions. You must be licensed for Multicurrency (MU) to use this check box.

Note:

When you select this check box, the Reconciliation Method on the Configure Leave Settings screen will be automatically set to Employee.

Warning: If your company assigns the DLTKSMB UI profile, to certain Costpoint user/user groups on the Manage User Interface Profiles screen, you must clear the Enable Multicurrency Functionality check box to prevent validation errors when the users access the screens which have multicurrency functionality.
Allow generation of negative LWOP timesheet lines

Selecting this check box to enable the automatic negative LWOP timesheet line generation functionality in the timesheet applications.

When you select this check box, the screen enables the following options, which determine how existing negative LWOP timesheet lines are handled when a user selects to create negative LWOP timesheet lines for a timesheet:

  • Exclude timesheets with existing negative LWOP lines
  • Delete and regenerate existing negative LWOP lines
Exclude timesheets with existing negative LWOP lines Select this option to exclude timesheets with existing negative LWOP lines from the application processing. If a timesheet for an employee has any negative LWOP lines in the input file, the application will not delete the negative LWOP lines and will skip that timesheet when it generates negative LWOP TS lines.
Delete and regenerate existing negative LWOP lines Select this option to delete all existing negative LWOP lines from the file regardless of whether they are linked to a positive LWOP line. The application will then generate new negative LWOP lines for any positive LWOP lines.

Shop Floor Time

Field Description
Correcting Timesheet Date Method

From the drop-down list, select the method for determining the date of correcting timesheets. Valid options are:

  • Date of correction
  • Original timesheet date
  • Last day of current open pay period
  • Last day of next pay period
  • Last day of next timesheet period
  • Not applicable

Effective Bill Date Options

Field Description
Default Effective Bill Date

From the drop-down list, select the method that will be used to default the effective bill date when you enter or import timesheets. Valid options are:

  • Subperiod End Date: Select this option to have the last day of the timesheet's subperiod default as the effective bill date when you enter or import timesheets.
  • Timesheet Date: Select this option to have the timesheet date default as the effective bill date when you enter or import timesheets.
  • Timesheet Line Date: Select this option to use the timesheet line date as the default effective bill date of timesheets that you enter or import. If there is no timesheet line date, timesheet applications will use the timesheet date as the default effective bill date value. If the timesheet type is either D-Correcting or C-Correcting, and the Effective Bill Date Options - Use Reference Date in Correcting Timesheets check box is selected, but there is no timesheet line date; then the applications will use the reference date as the default effective bill date.

The default value for this drop-down list is Subperiod End Date.

Use Reference Date in Correcting Timesheets

Select this check box to use the reference date as the default effective bill date when you enter or import timesheets. When entering or importing C-Correcting or D-Replacement timesheets, if this check box is selected, the Default Effective Bill Date method is set to Timesheet Line Date, and no timesheet line date is provided; the reference date will be used as the default effective bill date.

Validation of Labor-Only Timesheets

Use this group box to select the type of message (error or warning) that displays if you save a labor-only timesheet where the net hours are not equal to zero.

Field Description
Error if Net Hours not equal to zero

Select this option if you want Costpoint to display a warning message when a labor-only timesheet is entered or imported with net hours not equal to zero. This option is the default.

Warning if Net Hours not equal to zero

Select this option if you want Costpoint to display an error message when a labor-only timesheet is entered or imported with net hours not equal to zero.

Timesheet Posting

Field Description
Accrued Salaries Account

Enter, or click to select, the general ledger account number to be used for recording accrued salaries. Costpoint uses this account when posting to the General Ledger. The posting is generated at the Balance Sheet Level designated in the Top Level Org table for each employee's home organization. The description of the account displays in the adjacent field.

Manufacturing Order Timesheet Lines

Field Description
Organization Default Method

From the drop-down list, select the organization that defaults onto an M (manufacturing order) type timesheet line during timesheet entry or import. Valid options are:

  • Employee Home Org: Select this option to have the employee's home organization default when you enter or import an M type timesheet line.
  • MO Org: Select this option to have the manufacturing order's organization default when you enter or import an M type timesheet line. If the timesheet line account is the manufacturing order's WIP labor account, the manufacturing order's WIP labor organization defaults onto the timesheet line. If the timesheet line account is the manufacturing order's WIP misc 1 account, the manufacturing order's WIP misc 1 organization defaults onto the timesheet line. If the timesheet line account is the manufacturing order's WIP misc 2 account, the manufacturing order's WIP misc 2 organization defaults onto the timesheet line. 

The default value for this drop-down list is Employee Home Org.

Account Validation Method

From the drop-down list, select the account validation method for MO timesheet line entry/import. Valid options are:

  • MO's Build Inventory
  • Valid PAG Accounts
Account Default Method

From the drop-down list, select the method to be used for defaulting the account on manufacturing order timesheet lines. Valid options are:

  • MO Direct Labor Account: The WIP labor account defaults from the inventory abbreviation that is assigned to the manufacturing order.
  • Labor Module Defaulting: The application goes through the following levels of default until an account is identified:
    • Employee Project TS Defaults
    • Employee Project-Acct-Grp TS Defaults
    • Labor-Grp Project-Acct-Grp TS Defaults
    • Projct TS Defaults
    • Basic Employee Info Defaults
  • Labor Operation Account: The account assigned to the timesheet line labor operation will default.

Salary Proration

Starting with Costpoint 7, the prorating of salaries is now done through Labor, rather than Payroll. Use this group box to select your calculation method for proration.

Field Description
Prorate Calculation Method

Use these options to select the method to prorate salaried employees.

  • Days Per Cycle: Select this option to prorate based on work days per cycle. If you select this option, you must establish a work schedule in Costpoint or in Deltek Time & Expense.
  • Do Not Prorate: Select this option if you do not want to prorate. This option is the default.
Prorate Hired/Terminated Employees Only

Select this check box to prorate only employees who have been hired or terminated within the timesheet cycle. If you do not select this check box, Costpoint prorates any salaried employee who does not work the full amount of scheduled days in the timesheet cycle. If you select None as your Calculation Method, this field is cleared and disabled and no prorating occurs for any employees.