Contents of the Print Timesheet Information Report by Account Screen

Use the fields and options to configure the Print Timesheet Information Report by Account screen.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

User ID

Field Description
Option

From the drop-down list, select the range of user IDs to include on this report. Valid options are:

  • All: Select this option to include all user IDs on the report.
  • One: Select this option to include only one user ID on the report. Enter the user ID in the Start field.
Start

Enter, or click to select, the starting user ID for the range you want to include in the report. If you select All in the Option field, this field is inactive.

End

Enter, or click to select, the ending user ID for the range you want to include in the report. If you select All in the Option field, this field is inactive.

TS Cycle

Field Description
Option

This field always displays One.

Start

Enter, or click to select, the timesheet cycle. The timesheet cycle must already exist on the Manage Timesheet Periods screen.

Timesheet Date

Field Description
Option

From the drop-down list, select the range of timesheets, by date, to include on this report. Valid options are:

  • All: Select this option to include all timesheet dates on the report.
  • One: Select this option to include only one timesheet date on the report. Enter the timesheet date in the Start field.
  • Range: Select this option to include a range of timesheet dates on the report. The range begins with the timesheet date entered in the Start field and ends with the timesheet date entered in the End field.
  • From Beginning: Select this option to include the first timesheet date record up to the timesheet date entered in the End field.
  • To End: Select this option to include the timesheet date entered in the Start field up to the last timesheet date record.
Start

Enter, or click 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 Option field, this field is inactive.

End

Enter, or click 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 Option field, this field is inactive.

Accounting Period

Field Description
Option

From the drop-down list, select the range of accounting periods for the report. Valid options are:

  • All: Select this option to include all accounting period on the report.
  • Range: Select this option to include a range of accounting periods on the report. The range starts with the accounting period entered in the Start field and ends with the accounting period in the End field.
Fiscal Year

Enter, or click to select, the fiscal year for the reporting period.

Period

Enter, or click to select, the period for the appropriate period.

Subpd

Enter, or click to select, the starting subperiod for the reporting period.

End Subpd

Enter, or click to select, the ending subperiod for the reporting period.

Home Organizations

Use these fields to select the range of home organizations to include on the report.

Field Description
Option

From the drop-down list, select the range of organizations to include on this report. Valid options are:

  • All: Select this option to include all home organizations on the report.
  • One: Select this option to include only one home organization on the report. Enter the home organization in the Start field.
  • Range: Select this option to include a range of home organizations on the report. The range begins with the home organization entered in the Start field and ends with the home organization entered in the End field.
  • From Beginning: Select this option to include the first home organization record up to the home organization entered in the End field.
  • To End: Select this option to include the home organization entered in the Start field up to the last home organization record.
Start

Enter, or click 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 Option field, this field is inactive.

End

Enter, or click 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 Option field, this field is inactive.

Accounts

Field Description
Option

From the drop-down list, select the range of accounts to include on this report. Valid options are:

  • All: Select this option to include all accounts on the report.
  • One: Select this option to include only one account on the report. Enter the account in the Start field.
  • Range: Select this option to include a range of accounts on the report. The range begins with the account entered in the Start field and ends with the account entered in the End field.
  • From Beginning: Select this option to include the first account record up to the account entered in the End field.
  • To End: Select this option to include the account entered in the Start field up to the last account record.
Start

Enter, or click to select, the starting account for the range you want to include in the report. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending account for the range you want to include in the report. If you select All, One, or To End in the Option field, this field is inactive.

Transaction Currency

You can only use the following fields if Multi-Currency functionality is enabled in the Configure Labor Settings screen.

Field Description
Option

From the drop-down list, select whether All or One of the transaction currencies will be part of the selection criteria.

Start

Enter, or click to select, the transaction currency to be reported. If you enter a transaction currency, then timesheets will be processed for only the employees that have a currency (as of the screen Timesheet Date) that is equal to the transaction currency specified on this screen.

Sort By

Use the options in this group box to sort the report.

Field Description
1st Sort

From the drop-down list, select the sort order of the report. Valid options are:

  • Employee Name: Select this option to sort the report by the employee's displayed name, which appears on the report and was originally set up on the Manage Employee Information screen.
  • Employee ID: Select this option to sort the report by employee ID. Both the employee's name and ID display on the report.
  • General Labor Category: Select this option to sort the report by the employee's general labor category.
  • Transaction Currency: Select this option to sort the report by the employee's transaction currency.
Page Break On Account

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

Options

Show

Field Description
Exception Edits

Select this check box to print a code on the report when certain conditions exist that must be brought to your attention. 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 was used.
  • E: Employee has exceeded budgeted hours for the project.
Pay Type Totals

Select this check box 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 check box to view the subtotal for each labor category. This check box is enabled if you have chosen to sort by General Labor Category.

Include

Field Description
Previously Posted to the General Ledger

Select this check box to include timesheets that have already been posted to the GL. This occurs on the Post Timesheets screen.

Part-Time Employees

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

Temporary Employees

Select this check box to include temporary employees in the report.