Use this screen to print a report that details non-labor amounts incurred by project. It provides cost detail sorted by account or by organization, using either the project's home organization or the performing organization. Please note that if you have not recently run the Compute Burden Cost screen (Projects\Process\Project) and the Update Project Status Report Table screen (Projects\Process\Project), you may see differences between this report and your Project Status Report. This occurs because the Print Non-Labor Detail Report obtains its information from the General Ledger, and the Project Status Report screen (Projects\Review\Project) obtains its information from the PROJ_SUM table, which is updated by the Compute Burden Cost screen.
This screen consists of four blocks and one subtask. They can be used, as follows:
Use the Identification block to enter the parameter ID and description.
Use the Selection Ranges block to enter range options for projects, performing organizations, accounts, project managers, and accounting periods. You can also select the option for non-contiguous project ranges.
Use the Sort By block to enter the primary sort for the report.
Use the Options block to enter project, organization, and account roll-up levels, organizational grouping options, and an option to show the transaction description on the report.
Use the Project Non-Contiguous Ranges subtask to enter the detail of the non-contiguous ranges.
Transactions will appear on this report after they have been posted. Data for this report is drawn primarily from the GL_DETL table, which is updated with the source document postings.
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.
|
|
Note: Use the Change Period Report Parameters toolkit in the Miscellaneous Toolkits screen to change only the fiscal year, period, and subperiod for a saved report parameter. |
Use the fields in this block to select range options for projects, organizations, project managers, and accounting periods.
Use the drop-down box to choose whether to run the report by "Project," "Project Abbreviation," or "Alternate Project."
The selection made in this field will determine what values to enter in the Start and End fields.
Use this drop-down box to select the range option for your report. The values entered in the Start and End fields will depend on the selection made in the Select By drop-down box. 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, a starting value for the range that you want to include on the report. The value entered in this field is dependent on the selection made in the Select By field.
If you select "One," "Range," or "To End," in the Option field, you must enter a value in this field.
If you select "All" or "From Beginning" in the Option field, this field will be inactive.
Enter, or use Lookup to select, a value for the range that you want to include on the report. The value entered in this field is dependent on the selection made in the Select By field.
If you select "All," "Range," or "From Beginning" in the Option field, you must enter a value in this field.
If you select "One" or "To End" in the Option field, this field will be inactive.
Select this checkbox to enable Project Non-Contiguous Ranges subtask. Use the Project Non-Contiguous Ranges subtask to create a customized list of projects to print on the report.
Performing Organization
Use this drop-down box to select the range of performing organizations that you want to include in the report. The following options are available:
All - Select this option to include all available performing organizations. The Start and End fields are disabled for this option.
One - Select this option to include only one performing organization. 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 performing organizations. 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 performing organizations from the beginning of the available performing organizations to a specific performing organization 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 performing organizations from a specific performing organization to the end of all the available performing organizations. 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, a starting performing organization for the range that you want to include on the report.
If you select "One," "Range," or "To End," in the Performing Organization Option field, you must enter a performing organization in this field.
If you select "All" or "From Beginning" in the Performing Organization Option field, this field will be inactive.
Enter, or use Lookup to select, an ending performing organization that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Performing Organization Option field, you must enter a performing orgainzation in this field.
If you select "One" or "To End" in the Performing Organization Option field, this field will be inactive.
Select this checkbox to place a page break after each performing organization.
Account *
Use this drop-down box to select the range of accounts that you want to include on the report. The following options are available:
All - Select this option to include all available accounts. The Start and End fields are disabled for this option.
One - Select this option to include only one account. 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 accounts. 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 accounts from the beginning of the available accounts to a specific account 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 accounts from a specific account to the end of all the available accounts. 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, a starting account number for the range that you want to include on the report.
If you select "One," "Range," or "To End," in the Account Option field, you must enter a account number in this field.
If you select "All" or "From Beginning" in the Account Option field, this field will be inactive.
Enter, or use Lookup to select, an ending account number that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Account Option field, you must enter a performing orgainzation in this field.
If you select "One" or "To End" in the Account Option field, this field will be inactive.
Project Manager
Use this drop-down box to select the range of project managers that you want to include on the report. The following options are available:
All - Select this option to include all available project managers. The Start and End fields are disabled for this option.
One - Select this option to include only one project manager. 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 project managers. 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 project managers from the beginning of the available project managers to a specific project manager 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 project managers from a specific project manager to the end of all the available project managers. 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, a starting project manager for the range that you want to include on the report.
If you select "One," "Range," or "To End," in the Project Manager Option field, you must enter a project manager in this field.
If you select "All" or "From Beginning" in the Project Manager Option field, this field will be inactive.
Enter, or use Lookup to select, an ending project manager that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Project Manager Option field, you must enter a project manager in this field.
If you select "One" or "To End" in the Project Manager Option field, this field will be inactive.
Accounting Period *
Use this drop-down box to select the range of accounting periods that you want to include in the report. The following options are available:
All - Select this option to include all available accounting periods. The Start and End fields are disabled for this option.
One - Select this option to include only one accounting period. 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 accounting periods. 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 accounting periods from the beginning of the available accounting periods to a specific accounting period 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 accounting periods from a specific accounting period to the end of all the available accounting periods. 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, a starting fiscal year for the range that you want to include on the report.
If you select "One," "Range," or "To End," in the Accounting Period Option field, you must enter a fiscal year in this field.
If you select "All" or "From Beginning" in the Accounting Period Option field, this field will be inactive.
Enter, or use Lookup to select, a starting period number for the range that you want to include on the report.
If you select "One," "Range," or "To End," in the Accounting Period Option field, you must enter a period number in this field.
If you select "All" or "From Beginning" in the Accounting Period Option field, this field will be inactive.
Enter, or use Lookup to select, a starting subperiod number for the range that you want to include on the report.
If you select "One," "Range," or "To End," in the Accounting Period Option field, you must enter a subperiod number in this field.
If you select "All" or "From Beginning" in the Accounting Period Option field, this field will be inactive.
The unlabeled field to the right displays the ending date for the subperiod entered in this field.
Enter, or use Lookup to select, an ending fiscal year that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Accounting Period Option field, you must enter a fiscal year in this field.
If you select "One" or "To End" in the Accounting Period Option field, this field will be inactive.
Enter, or use Lookup to select, an ending period that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Accounting Period Option field, you must enter a period in this field.
If you select "One" or "To End" in the Accounting Period Option field, this field will be inactive.
Enter, or use Lookup to select, an ending subperiod that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Accounting Period Option field, you must enter a subperiod in this field.
If you select "One" or "To End" in the Accounting Period Option field, this field will be inactive.
The unlabeled field to the right displays the ending date for the subperiod entered in this field.
Use the fields in this block to select an option for sorting the report.
1st Sort *
Use this drop-down box to select a sorting option for the report.
Organization - Select this option to sort the report by organization.
Account - Select this option to sort the report by account.
If you print information for the performing organization by selecting the Performing Org radio button in the Group Organizations group box, "Account" will be automatically selected.
Fiscal Year, Period, Subperiod
Select this radio button to sort the transactions in descending fiscal year, period, and subperiod order. This radio button is the default.
Select this radio button to sort the transactions in ascending journal entry number/voucher number order.
Select this radio button to sort the transactions in ascending name order.
Use the fields in this group box to select the roll-up levels for project, organization, and account.
Project/Alternate Project Level __ and below
Identify the highest project level that you want printed on the report.
Performing Organization Level __ and below
Identify the highest performing organization level that you want printed on the report.
Identify the highest account level that you want printed on the report.
Use this group box to select report groupings by performing organization or project.
Select this radio button to print the report using the project's home organizations.
Select this radio button to print the report using the performing organizations.
Select the option in this group box to print transaction descriptions on the report.
Select this checkbox to print transaction descriptions on the report. If you do not select this checkbox, the purchase order will print instead.
* A red asterisk denotes a required field.
Select this subtask link to open the Project Non-Contiguous Ranges subtask, where you can enter the detail of the non-contiguous ranges.
Data for this report is obtained from the GL_DETL (General Ledger Detail) report.
