Contents of the Manage Timesheets Screen
Use the fields and options to configure the Manage Timesheets screen.
Identification
Use the fields in this group box to enter the timesheet date, timesheet type, timesheet sequence number, and the employee ID.
Field | Description |
---|---|
Date |
Enter, or click to select, the ending date for the timesheet's period. This date can represent a period of time, such as a week, or it can represent a single day. Enter the date in MM/DD/YYYY format. You can enter only those timesheets with a timesheet date falling in an open timesheet period. To enter a timesheet with a date in a closed timesheet period, you must first open that timesheet period (select the Open check box) on the Manage Timesheet Periods screen. |
Employee |
Enter, or click to select, the employee ID that uniquely identifies the employee. |
Type |
From the drop-down list to select the type of timesheet being entered or displayed. Valid options are:
|
Sequence |
Enter the sequence number in this numeric field. Use this field to provide a unique identification for the combination of employee ID, timesheet date, and timesheet type. You can have a maximum of 99 separate sequence numbers for any combination of the employee ID, timesheet date, and correcting (C) timesheet type. You can have a maximum of nine separate sequence numbers for any combination of the employee ID, timesheet date, and non-correcting timesheet type. |
Timesheet Lines |
Click to initialize this table. Enter up to 999 timesheet lines on any one timesheet. If more than 999 lines are required, additional sequence numbers can be used for the same employee ID, timesheet date, and type. Click the Default Line button to refresh the entire line, using the values on the Default tab of the Manage Employee Information screen. You can also set up several other screens so that certain projects can be associated with different defaults. (See the documentation for the Project column for more information.) |
Line Type |
Enter, or click to select, an alphanumeric character type code for the timesheet line. This is a required field. When entering timesheets, valid system-defined options for this field are A, L, B, M, and S. You can also assign default values to Line Types 1-9 on the Manage Employee Timesheet Line Type Defaults and/or Manage Timesheet Line Type Default screens. If you set up default values, you can enter that line type number in this column. The default is the A (Account/Org) type and allows entry of all the fields discussed above. The L (Leave Memo) pertains to making entries that have no labor cost associated, but that have data related to tracking leave hours used. This type is useful when tracking Family Medical Leave Act leave usage. This timesheet line type is processed to the Leave files, but is not processed by the Labor Distribution Posting. The B (Account/Org/Leave Acct) type pertains to making entries for employees who have accrued leave but have a current Status of Family Medical Leave on the Manage Employee Information screen. This type is also used to track Family Medical Leave. The M represents a manufacturing order timesheet line. If you select M, a dialog box appears, requiring you to enter a manufacturing order number; you can click to select the appropriate choice for this manufacturing order number. The S is used for Sales Order. If you select S, a dialog box appears, requiring you to enter a sales order, release, and sales order line number. The system creates a C type (Cash in Lieu of Fringe Benefit) when a fringe line is created while using the Wage Determination Rates feature. Costpoint creates a V type (Standard Variance) when calculating and applying variance to the timesheet line. Both C and V types cannot be manually changed. You can assign default values to Line Types 1-9 on the Manage Employee Timesheet Line Type Defaults and/or Manage Timesheet Line Type Default screens. If you have set up default values, you can enter that line type number in this column. A line type of V represents a standard variance timesheet line. You can generate a V type line only by clicking the Std Var button. (You cannot manually enter a line type of V). After you enter the line type, Costpoint imports from two levels of defaults (from two screens) associated with the line type.
|
Line Number |
This non-editable field displays the sequential number of each timesheet line. The screen you see accepts the first four timesheet detail lines. If employees have more charges on their timesheets, you can scroll down (or up) using the arrow keys on the right side of the screen. Timesheet lines remain in the order in which they are entered, and lines with the same account number are not combined. |
Line Date |
Enter the work date for the entered hours. This date must be in the timesheet cycle. This field is required if you selected Days per Cycle as your Calculation Method in the Prorate Options group box on the Configure Labor Settings screen. |
Project |
Enter, or click to select a project. After you enter the project, or tab through the Project field, you will be given the option of importing timesheet line data from 10 levels of defaults (from 10 screens) associated with the project and/or employee.
A project number is required for a specific account if you select the Project Required check box for that account on the Manage Accounts screen. The edits performed on the project are listed below (see the Manage Project User Flow).
In addition, one of two combination edits is required depending on the setting of the Validate Project Charging by Organizations check box on the Configure Project Settings screen. If you selected the check box, the combination of account, organization, and project number must be set up on Account/Org Links subtask of the Manage Project User Flow. If you did not select the check box, only the account and organization combination must be set up. In both combination edits above, the Active column for the Account/Org must be Y on the Link Accounts/Organizations screen. |
Project Name |
This field displays the project name. |
Account |
Enter, or click to select the General Ledger account to which the time and labor cost on each timesheet line is charged. In order to charge time to a given account, it must already be set up in the General Ledger Chart of Accounts. You can charge labor to a labor-related account type on the timesheet line, but any account is accepted, provided the following conditions are met:
|
Account Name |
This non-editable field displays the account name associated with the Account number entered on this timesheet line. |
Organization |
Enter, or click to select, the organization to charge this timesheet line. This is a required field and the combination of account and organization must be valid. The edits performed on the organization are:
Costpoint determines the default organization for timesheet entry based on the following order—from the 1st level to the 6th level.
For example, if an organization exists in both 1st and 3rd levels, Costpoint uses the organization in the 1st level as the default for timesheet entry. |
Organization Name |
This field displays the organization name. |
Pay Type |
Enter, or click to change, the pay type code for this timesheet line. |
Hours |
Enter the hours that the employee worked for this timesheet line, if appropriate. Any hours entered in this field also update the Entered Hours column. If a cost-only pay type is charged, this field (Hours) is zeroed out after entry. However, the Entered Hours field retains these hours. Hours can be entered at zero if dollars and not hours are to be charged (hourly rate corrections, for example). |
Trans Amount |
Enter the labor cost for the transaction currency in which the hours were worked. You can use this field if have a license for Costpoint Multicurrency (MU) and Multicurrency Functionality is enabled in the Configure Labor Settings screen. |
Amount |
Costpoint automatically computes the amount (labor cost) for each timesheet line. Labor cost is not displayed if labor suppression is in effect. Labor cost is calculated in a variety of ways, depending on the system settings in effect. Costpoint determines the hourly rate (pay rate) to use for the employee by checking certain settings. If the Configure Labor Settings screen has the Enable check box selected for using standard rates, Employee Salary Information can have an effective rate. This is used in place of the employee's hourly rate. Standard rates are used only for Salaried Fixed employees (see the documentation for the Manage Employee Salary Information screen). It is an alternative method of handling salaried employee's uncompensated overtime. The timesheet date is also compared to the Effective Date on the Manage Employee Salary Information screen, so that the correct line on the Employee Salary Information table is used to determine labor costs. If you selected the Enable Wage Determination check box on the Configure Labor Settings screen and the employee is charging to a project number that has a Wage Determination (WD) record established (see the documentation for the Manage Wage Determination Rates screen) for the appropriate GLC, location, labor group/union, and effective date, the rate for that WD record can be used. The WD record relates to the fields defined for the unique combination of project, location, labor category, and for labor group/union and effective date. The project, location, labor category, and timesheet date (used to access the effective date) are part of the timesheet, and the labor group/union is assigned to each employee on the Manage Employee Salary Information screen. Depending on the setting of the Hourly Rate Method on the Manage Wage Determination Rates screen, Costpoint can use this rate per hour to calculate the timesheet line labor cost. If you have selected the Override method in the WD record (Manage Wage Determination Rates screen), the associated Rate per Hour overrides all other rates to calculate the labor cost on the timesheet (that is, hours on the timesheet are multiplied by the Rate per Hour from the override record (and as adjusted by the pay type parameters)). If the Use if Higher method has been set in the WD record (Manage Wage Determination Rates screen), the Hourly rate on the Manage Employee Salary Information screen for the employee (employee's rate) is first compared to Rate per Hour in the override record. If the override record Rate per Hour is higher than the employee's rate, the override rate is used. If not, the employee's rate is used to calculate labor cost: Hours on the timesheet are multiplied by the greater of:
The WD table is not referenced for employees classified as Salaried Fixed or Salaried Fluctuating Hours. It applies only to hourly, non-exempt from the Fair Labor Standards Act, type employees (see the documentation for the Manage Employee Salary Information screen). Therefore, the WD table does not conflict with standard rates. The WD table is also not referenced for timesheets with a Transaction Currency that is not USD (US Dollar) if the Enable Multicurrency Functionality check box is selected on the Configure Labor Settings screen. Once the hourly rate has been determined, the pay type code parameters must be taken into account. There are several parameters related to each pay type:
If you selected the Enable Union Functionality check box on the Configure Labor Settings screen, the Labor Cost is determined by multiplying the charge hours by the GLC Hourly Rate listed for that union and local set up on the Manage Union Profile Setup screen. Another parameter that you can enter into the labor cost calculation is the Salaried and Overtime check boxes on the Manage Pay Types screen. If you selected both of these check boxes, timesheet lines containing this pay type are skipped by the Auto-Adjust calculation. In addition, cost-only timesheet lines, if combined with lines containing hours, are zeroed out by the Auto-Adjust function. Timesheets containing all cost-only (Pay Types) timesheet lines cannot be auto-adjusted. This is a required field. |
GLC |
If you selected the Allow Edit on GLC check box on the Configure Labor Settings screen, you can change the General Labor Category (GLC) code for this line. If you enter a GLC, the code must be present in the General Labor Category table. If you did not select the Allow Edit on GLC check box, you cannot change the GLC. If you established authorized general labor categories (see the Assign GLCs to Employees screen) for this employee, a warning is issued at timesheet entry if the general labor category charged is not found (not authorized). If no authorized general labor categories are found for the affected employee, no validation is performed. This feature is similar to the Deltek System1 Skill Codes. Costpoint determines the default GLC for timesheet entry based on the following order—from the 1st level to the 6th level.
For example, if a GLC exists in both 1st and 3rd levels, Costpoint uses the GLC in the 1st level as the default for timesheet entry. |
PLC |
Enter the Project Labor Category (PLC) code to be used for billing purposes. This field can default from one of eight different tables: Costpoint first uses the transaction project's setup to determine which project is used to default the PLC. If the transaction project has the Use Top Level Work Force check box selected on the Basic Info tab of the Manage Project User Flow, the transaction project's top level is used. If the transaction project's Use Top Level Work Force check box is not selected, Costpoint then determines whether a source project is assigned to the transaction project. If a source project exists in the first row of the Define Rate Sequence table, that source project is used to determine the PLC default value. If you did not select the Use Top Level Work Force check box and no source project exists for the transaction project, Costpoint uses the transaction project to determine the PLC default value.
The PLC field validation goes through the following steps (PLCs are required only for timesheet lines containing a project number):
|
Bill Date |
If you enter a C Type (Correcting) timesheet and the Use Reference Date in Correcting Timesheets check box is selected in the Effective Bill Date Options group box on the Configure Labor Settings screen, the ref date defaults when you enter a valid PLC. If you do not select that check box, or if you enter an R Type (Regular) or B Type (Bonus) timesheet, the Effective Bill Date Options Default Method on the Configure Labor Settings screen is used to determine the effective bill date default. If the Effective Bill Date Options Default Method is Subperiod End Date, the last day of the timesheet header subperiod defaults when you enter a valid PLC. Otherwise, if the Effective Bill Date Options Default Method is Timesheet Date, the timesheet date defaults when you enter a valid PLC. You can edit the date, but it is not validated. This field is required if a PLC is specified on the timesheet line. |
Labor Location |
Enter, or click to select, the Labor Location or Local code applicable to the work location. If you selected the Require Labor Location check box on the Configure Labor Settings screen, this is a required field. The default is provided by the Defaults tab of the Manage Employee User Flow. If you are using the Auto-OT feature, Costpoint uses this field to access the Overtime Rules by Location table. It is also a key field for the Wage Determination feature. |
W/H State |
Enter, or click to select, the state withholding code that this timesheet line represents. This field is applicable only to union employees. If you selected the Enable Union Functionality check box on the Configure Labor Settings screen and the Union Employee check box is selected for the employee on the Manage Employee Information screen, this field automatically defaults with the indicated project's withholding state from the Manage Union Profile Setup screen. The withholding state (for the union/project) defaults for the timesheet line based on the matching Union, Local code, and GLC that are assigned to the employee on the Manage Employee Salary Information screen. This is an optional field. If you are a multi-state Payroll user (the Enable Multi-State Tax Withholding check box is selected on the Manage Pay Periods screen), Costpoint obtains the default withholding state using the following levels of default for the associated project:
|
W/H Locality |
Enter, or click to select, the locality withholding code that this timesheet line represents. This field is applicable only to union employees. If you selected the Enable Union Functionality check box on the Configure Labor Settings screen and the Union Employee check box is selected for the employee on the Basic Info tab of the Manage Project User Flow, this field automatically defaults with the indicated project's locality withholding code from the Manage Union Profile Setup screen. The locality withholding code (for the union/project) defaults for the timesheet line based on the matching Union, Local code, and GLC that are assigned to the employee on the Manage Employee Salary Information screen. This is an optional field. Note:
If the employee is a union employee and you enter a project that exists for and matches the employee's union, local code, and GLC (on the Project Information subtask of the Manage Union Profile Setup screen), the W/H State and W/H Locality codes default for that project. The Timesheet Date must be within the project's Start Date and End Date on the Manage Union Profile Setup screen. |
Workers' Compensation |
If you are using workers' compensation codes, enter, or click to select, the workers' compensation code for this timesheet line. It is edited to determine that the code is in the Worker's Comp table. |
Project Abbrev |
Enter, or click to select, the project abbreviation. If you have already entered a project ID for the timesheet line, this field displays the project's project abbreviation from the Manage Project User Flow. |
Proj/Acct Abbrev |
Enter, or click to select, the project account abbreviation. If you have already entered a project ID for the timesheet line, entering a project account abbreviation automatically defaults with the account ID. |
Org Abbrev |
Enter, or click to select, the organization abbreviation. |
Ref 1 |
Enter, or click to select, the reference number for the Reference 1 table. The field is edited to determine that the number is in the table. The column heading for this field can be adjusted to suit the needs of your company on the Configure General Ledger Settings screen. |
Ref 2 |
Enter, or click to select, the reference number for the Reference 2 table. The field is edited to determine that the number is in the table. The column heading for this field can be adjusted to suit the needs of your company on the Configure General Ledger Settings screen. |
Union Fringe Code |
Enter, or click to select, the fringe code to be used for this timesheet. This field does not display if you did not select the Enable Union Functionality check box on the Configure Labor Settings screen. |
Notes |
Enter and update additional notes or text data related to an individual timesheet line. |
Line Source |
This field displays the application ID used to enter the line. |
Line Source Name |
This field displays the application name used to enter the line. |
Entered Hours |
This non-editable field displays the hours entered on the timesheet line. If a cost-only pay type was charged, the Hours field is zeroed out. This field is updated by entries to the Hours field, but retains the original value entered. |
Fringe Line Number |
This field displays the timesheet line number that the fringe is referring to. |
Transaction ID |
This field displays the timesheet line's transaction ID from Shop Floor Time. |
Default Line |
Click this button to refresh or load all the field values that were set up for this employee on the Default tab of the Manage Employee Information screen for a given timesheet line. All the values are loaded at the same time. To use this feature you must be at the start of the timesheet line (or have focus on the timesheet line if you are using a mouse) and then click the button. |
Load MO Data |
Click this button to populate fields related to a manufacturing order timesheet line. You must select the M timesheet line type, enter data on the Manufacturing Order Timesheet Information subtask, then click this button to populate the designated fields. |
Load SO Data |
Click this button to populate fields related to a sales order timesheet line. You must select the S timesheet line type, enter data on the Sales Order Timesheet Information subtask, then click this button to populate the designated fields. |
Subtasks
Subtask | Description |
---|---|
Exchange Rates | Click this link to add, edit, and/or view exchange rate information. |
Manufacturing Order Timesheet Information | Click this link to open the Manufacturing Order Timesheet Information subtask. This is enabled only if you have entered a timesheet line type of M in the Type column. You must enter a manufacturing order number; you can also enter an activity code, an operation sequence number, a step number, and a work center. To go back to this subtask later and change the data, click this link to reopen the subtask. |
Sales Order Timesheet Information | Click this link to open the Sales Order Timesheet Information subtask. This is enabled only if you have entered a timesheet line type of S in the Type column. You must enter a sales order, release, and sales order line number. To go back to this subtask later and change the data, click this link to reopen the subtask. |