PRINT TS EDIT BY ACCT RPT 

Use this screen to print timesheet data for the timesheet cycle and dates selected. You can sort by employee or labor category within the account. Use this report to provide data to department or project managers.

Print this report after entering all timesheets for the cycle.

Sort

Use the radio buttons in this group box to sort the report.

Employee Name

Select this radio button to sort the report by the employee's displayed name, which appears on the report and was originally set up in the Basic Employee Info screen in Costpoint Employee.

Employee ID

Select this radio button to sort the report by employee ID. Both the employee's name and ID appear on the report.

General Labor Category

Select this radio button to sort the report by the employee's general labor category.

Show

Exception Edits

Select this checkbox to print a code on the report when certain conditions exist that need to be brought to your attention. The codes are as follows:

Pay Type Totals

Select this checkbox to view the total hours charged and labor cost for each individual pay type. These totals appear on the final page of the report.

Subtotals by GLC

Select the checkbox to view the subtotal for each labor category. This checkbox is enabled if you have chosen to sort by General Labor Category.

Include

Previously Posted to GL

Select this checkbox to include timesheets that have already been posted to the GL; this occurs in the Post Labor Distribution screen.

Part-Time Employees

Select this checkbox to include part-time employees in the report.

Temporary Employees

Select this checkbox to include temporary employees in the report.

Page Break

Page Break On Account

Select this checkbox if you want a new page to be started for each account.

Select

Use items in this group box to indicate the home organization, timesheet cycle, and the dates within that timesheet cycle that should be included in the report. You can include this data either for a specific user or for all users who have entered timesheets.

User ID

To select timesheets entered by a specific user, enter the user ID in this field. To select all timesheets entered by all user IDs, leave this field blank.

TS Cycle

Enter, or use Lookup to select, the timesheet cycle. The timesheet cycle must already exist in the Timesheet Periods screen.

Timesheet Date

Range Option

Use this drop-down box to select the range of timesheets, by date, to include on this report. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."

From

Enter, or use Lookup to select, the starting timesheet date for the range you want to include in the report. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

To

Enter, or use Lookup to select, the ending timesheet date for the range you want to include in the report. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

Home Organizations

Use the fields in this group box to select the range of home organizations to include on the report.

Range Option

Use this drop-down box to select the range of organizations to include on this report. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."

From

Enter, or use Lookup to select, the starting home organization for the range you want to include in the report. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

To

Enter, or use Lookup to select, the ending home organization for the range you want to include in the report. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

Accounting Periods

All Accounting Periods

Select this checkbox to include all of the accounting periods on the report.

Fiscal Year

Use the drop-down box to make a selection, choosing the fiscal year for the reporting period.

Period

Use the drop-down box to make a selection, choosing the period for the appropriate period.

Subperiod

From

Enter the starting subperiod for the reporting period.

To

Enter the ending subperiod for the reporting period.

Accounts

Range Option

Use the drop-down box to make a selection, choosing the account range to be reported.

From

Enter the account number from which to start.

To

Enter the account number from which to end.

Table Information

Changes to this screen update the Print TS Edit by Acct table.

Report Columns

Column Heading

Screen

Table Name

Account/Timesheet Organization/Project

 

Enter Timesheets

Employees shown in this report have timesheets that have been entered in the Enter Timesheets application, but that have not been posted to Labor Distribution. However, if the Previously Posted to GL checkbox is selected, those employees with timesheets that have been posted to Labor Distribution will be included.

TS_HDR

TS_LN

Employee Name/ Employee ID/Post Info

Enter Timesheets

TS_HDR

TS_LN

GLC/ WC/ PLC

Enter Timesheets

TS_HDR

TS_LN

Home Organization/ Reference Numbers

Enter Timesheets

TS_HDR

TS_LN

TS Date/Type Seq/Post FL

Enter Timesheets

TS_HDR

TS_LN

W/H State/Local

Enter Timesheets

TS_HDR

TS_LN

Lab Loc

Enter Timesheets

TS_HDR

TS_LN

Pay Type

Enter Timesheets

TS_HDR

TS_LN

Hours Charged/Entered

Enter Timesheets

TS_HDR

TS_LN

Labor Cost/User ID/ Flags/Ln Type

Enter Timesheets

Flag information appears on this report when you select the Exception Edits checkbox. The codes are as follows:

"A" - The labor cost does not equal the hours times the hourly rate.

"B" - The timesheet date is after the contract end date.

"C" - The account is not a labor account.
 

"D" - Wage determination rate (SCA value) was used.

"E" - Employee has exceeded budgeted hours for the project.

TS_HDR

TS_LN