and search for timesheet types that begin with R, Costpoint retrieves and displays timesheet records with a D timesheet type; these timesheets have a sequence number between 1 and 9.Use this screen to correct posted timesheets. This application represents one of several processes you can use to correct or modify timesheets after they have posted.
All of the timesheet types in this screen appear as D (D-Correcting). "Regular" timesheets are available in this program, but the timesheet type displays as D. If you click and search for timesheet types that begin with R, Costpoint retrieves and displays timesheet records with a D timesheet type; these timesheets have a sequence number between 1 and 9.
If you click and search for timesheet types that begin with D, Costpoint retrieves and displays timesheet records with a D timesheet type; these timesheets have a sequence number that can range from "11" to "99"; it is unlikely, however, that you will ever correct or modify a sequence "99" timesheet.
After you make corrections and save the timesheets, two timesheets are created. Costpoint automatically generates a reversing timesheet for the original. Reversing timesheets are saved as N-Reversing. Correcting timesheets are also created and are saved as D-Correcting. Both timesheet types can be accessed on the Manage Timesheets screen. N-Reversing timesheets are non-editable; however, you can make changes to D-Correcting timesheets before you post them.
This screen has two table windows. After you perform a query, the records that display in the top Table Window represent posted timesheet records from various accounting periods. The corresponding timesheet line detail is available in the bottom Table Window.
Use this table window to edit or view posted timesheets. All of the record information available in this application originates from the Enter Timesheets screen.
Enter, or click 
to select, the timesheet date. You must enter the date in the MM/DD/YYYY format.
You must enter a date within an open timesheet period. You can use the Manage Timesheet Periods screen to open a timesheet cycle.
The timesheet date must fall within an open period in order for you to save the timesheet record.
After you save the corrected timesheet, this date displays in the Reference Date field on the original timesheet available on the Manage Timesheets screen.
This non-editable field displays the original timesheet date.
After you save the corrected timesheet, this date displays in the Reference Date field on the Manage Timesheets screen on the D-Correcting and N-Reversing timesheets.
This non-editable field displays the employee ID.
This non-editable field displays the employee name.
This non-editable field displays the timesheet type.
This non-editable field displays the timesheet sequence number.
The number displayed in this field is based on the data in the Date, Employee, and Type fields. You can create one timesheet for each unique date/employee ID/timesheet type combination, with a maximum of nine sequences.
D-Correcting timesheets begin with a sequence "11," (or one, one). The first "1" represents the sequence and the second "1" denotes the first correction; therefore, "11" represents the first sequence of the D-Correcting timesheet and the first correction of a regular timesheet.
A sequence "21" represents the second sequence of a D-Correcting timesheet and first correction of a regular timesheet. A sequence "99" represents the ninth sequence of the D-Correcting timesheet and the ninth correction of a regular timesheet; it is unlikely, however, that you will ever create a sequence "99" timesheet.
This field displays the regular, non-overtime labor hours. You can enter up to two places to the right of the decimal in this numeric field.
This field displays the overtime hours. You can enter up to two places to the right of the decimal in this numeric field.
This non-editable field displays the sum of the values in the Regular Hours and Other Hours fields.
Enter, or click 
to select, the new open fiscal year for which the D-Correcting and N-Reversing timesheets should be posted.
Enter, or click to select, the new open accounting period for which the D-Correcting and N-Reversing timesheets should be posted.
Enter, or click to select, the new open subperiod for which the D-Correcting and N-Reversing timesheets should be posted.
This field displays the OT state charged on the previous timesheet. You can enter, or click to select, a different overtime state for this timesheet.
This non-editable field displays the employee's Rate Type code from the Manage Employee Salary Information screen. This non-editable field displays the pay class of the employee, based on data you entered on the Employee Salary Information record. Valid values are:
H — Hourly
S — Salaried Fixed
F — Salaried Fluctuating
This non-editable field displays the Fair Labor Standards Act (FLSA) status, based on data you entered on the Manage Employee Salary Information record.
This non-editable field displays the labor group or union, based on data you entered on the Employee Salary Information record.
This non-editable field displays the total number of regular, non-overtime hours.
This non-editable field displays the total number of overtime hours.
This non-editable field displays the sum of the values in the Total Regular Hrs and Total Other Hrs fields.
This non-editable field displays the total labor amount, based on the sum of the values in the Amount field on the timesheet lines.
This field displays the entered date of the original timesheet, in MM/DD/YYYY format, by which to reference this timesheet.
This non-editable field displays the reference sequence number.
This field displays the auto adjust percentage.
This field may populate automatically after you enter data in the Employee field, contingent upon the data you entered in the Default Auto-Adjustment Percent field on the Manage Timesheet Periods screen.
Costpoint uses this percentage to recalculate pay, despite the number of labor hours.
The auto adjust feature synchronizes the timesheet data with the data on the Manage Employee Salary Information record to eliminate any pay variance.
If, for example, a salaried employee works 50.00 hours in a week, 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.
The auto adjust calculation may be performed after you save the record, contingent upon the setup on the Overtime Settings subtask of the Configure Labor Settings screen.
This non-editable field displays the name of the user who entered the timesheet.
This non-editable field displays the system date on which the timesheet was entered.
This non-editable field displays the screen on which the timesheet was entered (or is being entered).
This field displays the Shop Floor Time status
Click this button to perform an automatic calculation of regular and overtime hours.
As you enter each timesheet line, you can keep a running total of the sum of the regular and overtime hours. This amount displays in the Total Hours field.
Click this button to prorate this salaried employee's timesheet. Hourly employees cannot be prorated. If you selected None as your Calculation Method in the Prorate Options group box on the Configure Labor Settings screen, this button is disabled.
Vacation time is handled the same way as work time. Holiday time is not included.
If you use this functionality, you do not have to enter Leave Without Pay timesheet lines for salaried employees.
You cannot use this function on an auto-adjusted timesheet.
The application excludes from the day count any days where the only pay types designated are:
Cost Only
Benefit Reimbursement
Reimbursement – Exclude from Gross Earnings
Leave Without Pay (LWOP)
Leave Without Pay (LWOP) – Negative
Severance
Click this button to create a Fringe Handling line.
All of the timesheet line detail in this table window originates from data you entered on a previous timesheet.
You can enter up to 999 timesheet lines on one timesheet. If more than 999 lines are required, you can use additional sequence numbers for the same date/employee ID/timesheet type combination.
In addition, defaults and validations were added to the withholdings fields to accommodate multi-state withholdings, as determined by the employee's pay cycle. These checks and validations are triggered if the employee's pay cycle is set for multi-state withholdings.
This field displays the timesheet line number. As you add timesheet lines, this number increases sequentially.
Timesheet lines remain in the order in which they are entered. Lines with the same account number are not combined.
You can use the scrollbar to view additional timesheet lines.
This field displays the timesheet line type.
The system-defined line types include:
A — This line type allows you to enter data in all fields on the timesheet line. The default timesheet line type is A.
B — This line type allows you to associate the timesheet line with two leave types: Family Medical Leave Act (FMLA), which deducts hours from FMLA leave hours, and the leave type that is associated with the account number on the timesheet line. With this leave type, hours are deducted and payment of these hours is included in the Compute Payroll process.
C — Costoint automatically generates this line type. You cannot manually enter a C line type. The creation of this line type, which represents cash in lieu of fringe benefits, is based on the previous setup of record data on the Manage Wage Determination Rates screen. The data in the Project, Labor Location, Labor Category, and Labor Group fields on the Manage Wage Determination Rates screen must match the data on the timesheet lines. In addition, you must enter data in the Amount per Hour field, and you must select the Cash option. This line type works in conjunction with the Generate Fringe Line button on the Manage Timesheets screen.
L — This line type allows you to enter timesheet data when no labor costs are involved. If, for example, an employee has no vacation or sick time available yet needs to use FMLA leave, use this line type. FMLA leave hours are deducted from the FMLA leave balance. This line type is commonly referred to as a "Leave Memo" line type.
M — This line type allows you to add a manufacturing order timesheet line and to add or modify data on the Manufacturing Order Timesheet Information subtask. For M type lines, the defaulting account will be based on the Account Default Method that you select in the Manufacturing Order Timesheet Lines group box of the Configure Labor Settings screen.
S — This line type allows you to add a sales order timesheet line and to add or modify data on the Sales Order Timesheet Information subtask.
V — Costpoint automatically generates this line type. You cannot manually enter a V line type. This line type is created when you click the Std Variance button on the Manage Timesheets screen.
1-9 — You can assign default values for the Pay Type, Account, and Organization fields. You associate these defaults with line types 1 through 9 on the Manage Employee Timesheet Line Type Defaults and/or Manage Timesheet Line Type Defaults screens. When line types 1 through 9 are entered on the timesheet, these defaults are used to populate the Pay Type, Account, and/or Organization fields.
Enter, or click to select a project.
There are 10 levels of project-specific timesheet line defaults. Here is a summary of each level:
Level 1: Assign PLC to Employee Work Force subtask of Manage Project Work Force
Use this screen in Project domain to assign a PLC and employee to a specific project. The PLC must have been set up on the Manage Project Labor Categories screen before you can assign it. You must assign the employee to the project on the Manage Project Work Force screen before you can assign him to the PLC and Project. This is the first level of defaults imported when you enter a project on a timesheet line. Only the PLC will default from this screen.
If the employee and project are linked to a PLC, the PLC selected as Default PLC will load in the timesheet line.
Use this screen to set up defaults for a timesheet line based on a project for a specific employee. This is the second level of defaults imported when you enter a project on the timesheet line. If the system finds a default PLC on the Assign PLC to Employee Work Force subtask of Manage Project Work Force, it will use that PLC instead of the data entered here.
Use this screen to set up defaults for a timesheet line based on projects for a specific employee. This is the third level of defaults imported when a project is entered on a timesheet line. If you have entered information in any of the default fields on the Assign PLC to Employee Work Force subtask of Manage Project Work Force or Manage Employee Project Timesheet Defaults screens, that information is used instead of the data entered here.
Use this function to set up defaults for a timesheet line based on a project for a specific labor group/union type within an account group. This is the fourth level of defaults imported when you enter a project on the timesheet line. If you entered information in any of the default fields on the Assign PLC to Employee Work Force subtask of Manage Project Work Force, Manage Employee Project Timesheet Defaults, or Manage Employee Proj-Acct-Group Timesheet Defaults screens, that information is used instead of the data entered here.
Level 5: Manage Project Timesheet Defaults
Use this function to set up defaults for a timesheet line based on a project. This is the fifth level of default imported when you enter a project on a timesheet line. If you have entered information in any of the default fields on the Assign PLC to Employee Work Force subtask of Manage Project Work Force, Manage Employee Project Timesheet Defaults, Manage Employee Proj-Acct-Group Timesheet Defaults, or Manage Labor-Group Proj-Acct-Group Timesheet Defaults screens, that information is used instead of the data entered here.
Level 6: Defaults tab of Manage Employee Information
Use this subtask in Costpoint Employee to set up default-related data concerning the employees processed by Costpoint Labor. The Defaults subtask is the sixth level of default imported when you enter a project on a timesheet line. If you have entered information in any of the default fields on the Assign PLC to Employee Work Force subtask of Manage Project Work Force, Manage Employee Project Timesheet Defaults, Manage Employee Proj-Acct-Group Timesheet Defaults, Manage Labor-Group Proj-Acct-Group Timesheet Defaults, or the Manage Project Timesheet Defaults, that information is used instead of the data entered here.
Level 7: Manage Salary Information
Use this application in Costpoint Employee to establish default PLC and GLC codes. This is the seventh level of default imported when you enter a project on the timesheet line. If you have entered a default PLC or GLC on the Assign PLC to Employee Work Force subtask of Manage Project Work Force, Manage Employee Project Timesheet Defaults, Manage Employee Proj-Acct-Group Timesheet Defaults, Manage Labor-Group Proj-Acct-Group Timesheet Defaults, Manage Project Timesheet Defaults, Link GLC to Project PLC subtask of Link Project Labor Categories to Projects, or Defaults tab of Manage Employee Information screens, they are used instead of the data entered here. Only the PLC or GLC will default from this screen.
Level 8: Link GLC to Project PLC subtask of Link Project Labor Categories to Projects
Use this screen in Costpoint Project Setup to provide the linkage between the General Labor Categories (GLCs) and PLC for a specific project. The PLC must already be assigned to a project on the Assign PLC to Projects screen (in Costpoint Project Setup) before you can link it here. This is the eighth level of default imported when you enter a project on the timesheet line. If you have entered a default PLC on the Assign PLC to Employee Work Force subtask of Manage Project Work Force, Manage Employee Project Timesheet Defaults, Manage Employee Proj-Acct-Group Timesheet Defaults, or Manage Labor-Group Proj-Acct-Group Timesheet Defaults screens, that PLC is used instead of the PLC entered here. Only the PLC will default from this screen.
Level 9: Manage General Labor Categories
Use this screen to establish the General Labor Category (GLC) codes and related descriptions. This is the eighth level of default that is imported when you enter a project on the timesheet line. If you have entered a default GLC on the Link GLC to Project PLC subtask of Link Project Labor Categories to Projects screen, that GLC defaults if the PLC is entered for the timesheet line. Otherwise, the employee's assigned GLC from the Defaults Tab of the Manage Employee Information screen defaults.
Level 10: Defaults group box of Configure Labor Settings
Use this group box to enter a default Timesheet Cycle, Worker's Comp, or a Pay Type. This is the 10th level of defaults imported when you enter a project on the timesheet line. If you have entered information in any of the default fields on the Manage Employee Project Timesheet Defaults, Manage Employee Proj-Acct-Group Timesheet Defaults, Manage Labor-Group Proj-Acct-Group Timesheet Defaults screens, Manage Project Timesheet Defaults, or Defaults Tab of the Manage Employee Information screens, that information is used instead of the data entered here.
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.
This non-editable field displays the project name associated with the data displayed in the Project field on this timesheet line.
Enter, or click to select, the project abbreviation.
If you established the project/abbreviation on the Manage Project User Flow screen and you enter data in this field, its related project defaults in the Project field on the timesheet line.
Enter, or click to select, the project account abbreviation.
If you established project/account abbreviations on the Manage Project User Flow screen and you enter data in this field, its related account number defaults in the Account field on the timesheet line.
Enter, or click to select, the General Ledger account to which the labor costs and labor hours on each timesheet are charged.
This non-editable field displays the account name associated with the data displayed in the Account field.
Enter, or click to select, the organization to charge this timesheet line.
This non-editable field displays the organization name associated with the data displayed in the Organization field on this timesheet line.
Enter, or click to select, the organization abbreviation.
If you established the organization abbreviation on the Manage Organization Elements screen and you enter data in this field, its related organization defaults into the Organization field.
Enter, or click to select, the pay type code for this timesheet line.
This field displays the employee labor hours.
This field displays the labor costs for each timesheet line.
Labor costs are calculated in a number of ways, depending on the system settings in effect.
Based on your setup on the Configure Labor Settings, Manage Wage Determination Rates, Manage Pay Types, and Manage Employee Salary Information screens, various calculations may be performed to calculate this amount.
Labor costs, however, are not displayed if labor suppression is in effect. Labor suppression is established on the Users screen and, if active, prevents display of the Amount field on the timesheet line.
Enter, or click to select, a GLC (general labor category).
The GLC code must display on the General Labor Categories screen.
If you assigned GLC codes to this employee on the Assign GLCs to Employees screen, a warning displays if the GLC charged was not assigned, although you can still save the timesheet record. If no GLC assignments were established for the affected employee, Costpoint does not perform any validation.
If you selected the Allow Edit of GLC check box on the Configure Labor Settings screen, you can change the GLC code for this timesheet line. If you did not select the Allow Edit of GLC check box, you cannot change the GLC. In this case, you must accept the GLC defaults.
Enter, or click to select, a PLC (project labor category).
There are various levels of PLC timesheet defaults.
Enter, or click to select, a bill date.
When you enter a PLC on a timesheet line, the subperiod end date default into this field.
The Fiscal Year, Period, and Subperiod fields in the top table window of this screen, therefore, must contain data in order for the subperiod end date to default into this field.
The effective bill date represents the date on which the PLC billing rates become effective.
Enter, or click to select, 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.
Enter, or click to select, the labor location or local.
If you selected the Require Labor Location check box on the Configure Labor Settings screen, you must enter data in this field.
Enter, or click to select, the state withholding code 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 on the timesheet line based on the matching union, local, and GLC that are assigned to the employee on the Employee Salary Information screen.
Enter, or click to select, the locality withholding code 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 locality withholding code from the Manage Union Profile Setup screen.
The locality withholding code (for the union/project) defaults on the timesheet line based on the matching union, local, and GLC that are assigned to the employee on the Manage Employee Salary Information screen.
Enter, or click to select, the workers' compensation code for this timesheet line.
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.
This non-editable field displays the total number of timesheet hours.
Enter, or click to select, the reference information.
You can modify the reference field heading on the Configure General Ledger Settings screen to better suit the needs of your company.
Enter, or click to select, the reference information.
You can modify the reference field heading on the Configure General Ledger Settings screen to better suit the needs of your company.
Enter more timesheet notes relevant to this record.
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.
This field displays the line number of Fringe timesheet lines.
This non-editable field displays the screen on which the timesheet line was entered (or is being entered).
Click this button to load all employee defaults for the selected line.
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, and click this button to populate the designated fields.
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, and click this button to populate the designated fields.
|
Subtask |
Description |
|
Manufacturing Order Timesheet Information |
Click this link to use the Manufacturing Order Timesheet Information subtask to add or modify manufacturing order timesheet information. To add or modify data in this subtask, you must select a timesheet line that has an M (Manufacturing Order) line type. |
|
Sales Order Timesheet Information |
Click this link to use the Sales Order Timesheet Information subtask to add or modify sales order timesheet information. To add or modify data in this subtask, you must select a timesheet line that has an S (Sales Order) line type. |