PRINT PROJECT LEDGER DETAIL 

Use this screen to print detail postings to the General Ledger for all project/ account/organization 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 journals posted to the General Ledger are printed 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. You can also limit your report selections by selecting an account or organization.

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. In order to do so, you must first set up the necessary org security screens in Costpoint System Administration. You can then activate org security through the use of the Maintain Users and System Settings screens. For more information about org security and how to apply it, see System Administration Special Topic SA - 5, "Organizational Security" and the documentation for the Organizational Security menu in Costpoint System Administration.

Select Projects

Range Option

Enter, or use the drop-down box to select, the range of projects to be included on the Project Ledger Detail Report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."

From/To

Enter the starting and/or ending value for the Project(s) you want to include on the report. You can also use Lookup to select the values for these fields. One or both of these fields may be disabled, depending on your Range Option selection.

Level

Identify the highest project level you want printed on this report. Projects below the specified level will be summed and shown as a summary total.

Page Break

Select this checkbox if you want a page break after each project.

Select Periods

Range Option

Enter, or use the drop-down box to select, the range of periods to be included on this report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."

Fiscal Year

Enter, or select from the drop-down box, the fiscal year for which you want to print Project Ledger Detail.

Period Starting and Ending

These fields may or may not be active, depending on the period Range Option you selected. If you print for "One" period, enter (or select from the drop-down box) that period in the Starting field. If you selected a "Range" of periods, enter both the starting and ending periods in their respective fields. If you selected periods beginning from a specific period ("To End"), enter or select that period in the Starting field. If you selected periods up to a specific ending period ("From Beginning"), enter that period in the Ending field.

The ending dates for the periods selected display in the non-editable fields to the right.

Select Organizations

Range Option

Enter, or use the drop-down box to select, the range of organization(s) to be included on the Project Ledger Detail report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."

From/To

Enter the starting and/or ending value for the organization(s) you want to include on the report. You can also use Lookup to select the values for these fields. One or both of these fields may be disabled, depending on your Range Option selection.

Page Break

Select this checkbox if you want a page break after each organization.

Select Accounts

Range Option

Enter, or use the drop-down box to select, the range of accounts to be included on the Project Ledger Detail report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."

From/To

Enter the starting and/or ending value for the accounts you want to include on the report. You can also use Lookup to select the values for these fields. One or both of these fields may be disabled, depending on your Range Option selection.

Page Break

Select this checkbox if you want a page break after each account.

Sort By

Select the appropriate radio button to sort either by Account  or by Organization.

Show

Use this group box 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.

Labor Detail

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 Maintain Users screen in Costpoint System Administration.

Accounts Payable Detail

Select this checkbox to print transaction level detail for Accounts Payable postings.

Document and Entry ID Detail

Select this checkbox to print document and entry ID detail. Examples of document detail include voucher number, check number, invoice number, etc.

Reference Numbers

Select this checkbox to print reference numbers on the report.

Inactive Accounts

Select this checkbox to print inactive accounts on the Project Ledger Detail report.

Unselect this checkbox to prevent inactive accounts from printing on the report.

This checkbox is selected by default.

Hint: You can save the specified report parameters for future use. To save the selected report parameters, select the Save button on the toolbar after you have entered your report selections. Enter an appropriate ID and description for the report, and then select the OK to save. Stored report parameters are especially useful if reports are to be run through Process Manager.

Table Information

This report prints data stored in the GL_POST_SUM and GL_DETL tables.