Use this screen to print detail postings to the General Ledger for all project/ account/org combinations.
This report is a crucial tool for analysis of project activity and balances.
You can run the Project Ledger Detail Report any time after you have posted journals to print all activity posted to a specific project for a specified range of accounting periods. Only the journals that you posted to the General Ledger will print on this report.
In addition, you should print the Project Ledger Detail Report in full at the end of the fiscal year for use by accounting and management personnel.
You can print the entire Detail Project Ledger at any other time during the year. However, due to the voluminous nature of the report, it is more likely that you will want to print the report only for projects you want to review at that time.
|
|
Note: You can apply org security to this function. Use this optional feature to grant or remove rights for individual users to view and/or update specific organizations.
|
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 range of activity posted to a specific project to print on the report.
Projects
Enter, or use the drop-down box to select, the range of projects you want to be include on the Project Ledger Detail Report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."
Enter the starting value for the project(s) you want to include on the report. You can also use Lookup to select the value for this field. This field may be disabled, depending on your Option selection.
Enter the ending value for the project(s) you want to include on the report. You can also use Lookup to select the value for this field. This field may be disabled, depending on your Option selection.
Select this checkbox to insert a page break after each project.
Fiscal Year *
This non-editable field displays a value of "One."
Enter, or use Lookup to select, the fiscal year for which you want to print the Project Ledger Detail.
Accounting Periods
Enter, or use the drop-down box to select, the range of periods you want to include on this report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."
This field may or may not be active, depending on the period Option you select.
To print for "One" period, enter (or use Lookup to select) that period in this field.
To print a "Range" of periods, enter the starting period in this field.
To print periods beginning from a specific period ("To End"), enter or select that period in this field.
This non-editable field displays the ending date for the period you selected.
This field may or may not be active, depending on the period Option you selected.
To print a "Range" of periods, enter both the ending period in this field.
To select periods up to a specific ending period ("From Beginning"), enter that period in this field.
This non-editable field displays the ending date for the period you selected.
Organizations
Enter the starting value for the organization(s) you want to include on the report. You can also use Lookup to select the value for this field. This field may be disabled, depending on your Option selection.
Enter the ending value for the organization(s) you want to include on the report. You can also use Lookup to select the value for this field. This field may be disabled, depending on your Option selection.
Accounts
Enter the starting value for the account(s) you want to include on the report. You can also use Lookup to select the value for this field. This field may be disabled, depending on your Option selection.
Enter the ending value for the account(s) you want to include on the report. You can also use Lookup to select the value for this field. This field may be disabled, depending on your Option selection.
Use this block to select your sorting option.
1st Sort *
Use the drop-down box to sort either by organization or by account.
Use the Level groupbox in this block to choose the level of the organization at which you will print the report.
Use the checkboxes in the Show groupbox of this block to include various types of detail information on this report. You can check, or leave unchecked, any combination of these checkboxes. Of course, if you need to print all detail for all projects, your report may be quite long.
Level
Choose the level of the organization at which you will print the report. For example, if you choose organization 1.02.03 at level 4, all organizations beginning with 1.02.03 will print and roll up to level 4:org1.02.03.01 (including all its subsidiaries), org 1.02.03.02, etc.
Show
Select this checkbox to print transaction level detail for labor postings.
Note that Labor Suppression is in effect in this screen, if the user is subject to it per the Users screen (Administration\Maintain\Users).
Select this checkbox to print transaction level detail for Accounts Payable postings.
Select this checkbox to print document and entry ID detail. Examples of document detail include voucher number, check number, invoice number, etc.
Select this checkbox to print reference numbers on the report.
Select this checkbox to print inactive accounts on the Project Ledger Detail Report.
Unselect this checkbox to prevent inactive accounts from printing on the Project Ledger Detail Report.
This checkbox is selected by default.
* A red asterisk denotes a required field.
This report prints data stored in the GL_POST_SUM (GL Posting Summary) and the GL_DETL (GL Detail) tables.
