PRINT GENERAL LEDGER DETAIL 

Use this screen to print detail postings to the General Ledger for all account/org combinations. This report is a crucial tool for analysis of General Ledger activity and balances.

Run the General Ledger Detail Report any time after posting journals to print all activity posted to a specific account/org for a specific range of periods. Only journals posted to the General Ledger are printed on this report. You should print this report in full at the end of the fiscal year for use by accounting and management personnel, as well as independent and government auditors. You can print the entire General Ledger Detail at any other time during the year. However, due to the voluminous nature of the report, it is likely that you will want to print the G/L detail only for accounts you need 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. 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.

This report is considered  part of the system audit trail. You should retain the reports printed at fiscal year end.

Select Accounts

Range Option

Enter, or use the drop-down box to select, the range of accounts that you want to include on the report. The system-defined options are "All," "One," "Range," "From Beginning," and "To End."

From/To

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

Level

Include Level __ and Below

Identify the highest account level you want printed on this report, based on the levels established in the G/L Settings screen. Accounts 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 account, or leave this checkbox unchecked to enable printing of more than one account per page.

Select Grouping

Select By

From the drop-down box, select the appropriate option for the grouping of your report. The system-defined options are "Organization," "Ref 1," "Ref 2," or "Alternate Reporting." The names you assigned to the two reference numbers in G/L Settings will be used here, instead of "Ref 1" and "Ref 2."

Range Option

Enter, or use the drop-down box to select, the range of Organizations, Ref 1s, Ref 2s, or Alternate Reporting structures to be included on the G/L Detail. The system-defined options are "All," "One," "Range," "From Beginning," and "To End." 

From/To

Enter the starting and/or ending Organization, Ref 1, Ref 2, or Alternate Reporting structure ID for the Organization(s), etc., 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

Include Level __ and Below

Identify the highest Organization (or Ref 1, Ref 2, or Alternate Reporting structure) level you want printed on this report. Balances on the report will be rolled up to the specified level.

Page Break

Select this checkbox if you want a page break after each group specified in the Select By field. Leave this checkbox unchecked if you do not require page breaks after each Organization, Ref 1, Ref 2, or Alternate Reporting structure.

Sort

Select the appropriate radio button to sort the report either by Account or by the selected alternate reporting option (Organization, Ref 1, Ref 2, or Alternate Reporting structure). The alternate reporting option depends on your selection in the Select Grouping group box.

Select Active Periods

Range Option

Enter, or use the drop-down box to select, the range of active 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 G/L Detail.

Period Starting and Ending

These fields may or may not be active, depending on the period Range Option you selected. If you elected to 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.

Show

Use this group box to include 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 accounts, 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 Suppress Labor checkbox has been selected in the table window of the Maintain Users screen in Costpoint System Administration, you will not be able to see the labor cost detail.

Accounts Payable Detail

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

Document Detail

Select this checkbox to print document 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 General 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 button to save. Stored report parameters are especially useful if reports are to be run through Process Manager.

Table Information

This screen reads the following tables: