Use this screen to print timesheet reports based on the timesheet cycle and timesheet dates you specify in this application. This report is sorted by account number.
The purpose of this screen is to allow you to review timesheet information before you process this data. After you print timesheet reports, for example, you can validate the report content by comparing it to the original timesheet information. If you identify erroneous data or inconsistencies, you can correct these timesheets before you post them.
There are several sort options available, allowing you to group the report output by "Employee Name," "Employee ID," and "General Labor Category." However, despite your sort selection, this report is always first sorted by account. It is then sorted by the option you specify in the 1st Sort field.
The report output reveals the number of hours charged to various projects. It also displays the accounts and the employees who have charged them. This information may be useful to the managerial staff. This application allows you to print timesheet data for the cycle and dates you select. You should print this report after entering timesheets in order to compare this data to the original documents.
You can click the Preview Default Report icon to print the report output to your screen, or you can click the Print Default Report icon to send the report to a printer.
Use this screen after you enter timesheets using the Enter Timesheets program (People\Transactions\Timesheets). You should print this report after entering all timesheets for a given cycle.
You can print this report for previously posted timesheets.
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to specify the user ID, timesheet cycle, home organization, and timesheet dates that will be included in the report. You can include this data for a specific user or for all users who have entered timesheets.
Use the drop-down box to make a selection. Your choices are "All" or "One."
All - Select this option to include all available records. The Start field is disabled for this option.
One - Select this option to include only one record. You must enter data in the Start field.
Enter, or use Lookup to select, the user ID.
This option includes only one record. This field is non-editable.
Enter, or use Lookup to select, up to four alphanumeric characters to identify the timesheet cycle.
Use this drop-down box to select the range option for your report. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting timesheet date for the range you want to include in the report.
Enter, or use Lookup to select, the ending timesheet date for the range you want to include in the report.
Use the drop-down box to make a selection. Your choices are "All" or "One."
All - Select this option to include all available records. The Start field is disabled for this option.
Range - Select this option to include a record range.
Enter, or use Lookup to select, the fiscal year from which to start.
Enter, or use Lookup to select, the period from which to start.
Enter, or use Lookup to select, the subperiod from which to start.
Enter, or use Lookup to select, the subperiod from which to end.
Use this drop-down box to select the range option for your report. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting home organization for the range you want to include in the report.
Enter, or use Lookup to select, the ending home organization for the range you want to include in the report.
Use this drop-down box to select the range option for your report. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the account from which to start.
Enter, or use Lookup to select, the account from which to end.
Use the fields in this block to determine the layout and format of the report output.
1st Sort *
Use the options in this drop-down box to make a selection. Your choices "Employee Name," "Employee ID," and "General Labor Category."
Employee Name - Select this option to sort the report by the employee name, as entered in the Employee User Flow screen.
Employee ID - Select this option to sort the report by employee ID. Both the employee name and ID will appear on the report.
General Labor Category - Select this option to sort the report by labor category.
Select this checkbox if you want a page break after each account.
Use the fields in this block to include and display additional report data.
Use the fields in this group box to specify the display of additional report detail.
Select this checkbox to print a code on the report that will alert you to potential issues.
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.
The codes will display in a specific column within the body of the report. An explanation of these codes will display at the end of the report.
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.
Select the checkbox to view the subtotal for each labor category.
This checkbox is enabled if the 1st Sort field displays "General Labor Category."
Use the fields in this group box to include posted data, part-time employees, and temporary employees in the report output.
Previously Posted to General Ledger
Select this checkbox to include timesheets that have already been posted.
Select this checkbox to include part-time employees in the report.
Select this checkbox to include temporary employees in the report.
* A red asterisk denotes a required field.
The TS_HDR (Timesheet Header) and TS_LN (Timesheet Line) are source tables whose data is evaluated after you enter your selection criteria.