General Ledger Summary (Inquiry)

Additional Information

The General Ledger Summary Inquiry allows you to view a summary of general and allocation ledger transactions posted to accounts. The inquiry provides three levels of information, which include the general ledger summary, an account summary, and associated general ledger transactions.

Restrictions

The inquiry includes the following default restrictions:

Restriction Description
Fiscal Calendar Enter or select a fiscal calendar. This is the definition of the fiscal years and posting periods for a specified fiscal year. This field defaults to the default fiscal calendar.
From Fiscal Period

Enter or select a fiscal period. This is the first date in the date range to include items. This field defaults to the current fiscal period.
To Fiscal Period Enter or select a fiscal period. This is the last date in the date range to include open items. This field defaults to the current fiscal period.
Currency Type Enter or select the type of currency to display on the inquiry. his field defaults to Document Currency, but available options include Base Currency, Company Currency, and Document Currency.
  Include General Ledger Select to include items from the general ledger. The default is true.
  Include Allocations Select to include items from the allocation ledger. The default is false.

For a list of the optional restrictions, see ClosedGeneral Ledger Summary Inquiry Optional Restrictions.

The following optional restrictions are available:

  • Account
  • Account Map
  • Account Map Level
  • Company
  • Currency
  • Organization
  • Organization Map
  • Organization Map Level
  • Transaction Type

Results

The inquiry results include the following three levels of information:

  • General Ledger Summary: The first level of the inquiry provides general ledger summary information, which includes Account Code, Account Name, Organization Code, Organization Name, Balance Forward, Debit, Credit, Net Amount, and Balance. The initial view is grouped by Account Name. ClosedGeneral Ledger Summary Optional Columns.

    The following optional columns of information are available:

    • Account Map Level 2 - 6 Name
    • Account Subsidiary Type
    • Account Type
    • Allocation Ledger
    • Company Code
    • Company Name
    • Currency Code
    • Currency Name
    • General Ledger
    • Organization Manager Code
    • Organization Manager Name
    • Organization Map Level 2 - 6 Name
    • Transaction Type

  • Account Summary: The second level of the inquiry provides an account summary, which includes Fiscal Period, Debit, Credit, and Net Amount. ClosedAccount Summary Optional Columns.

    The following optional columns of information are available:

    • Balance
    • Balance Forward
    • Budget Category Code
    • Budget Category Name
    • Posting Period
    • Posting Period Name
    • Posting Period Quarter

  • General Ledger Transactions: The third level of the inquiry provides general ledger transaction detail information, which includes EVC Type, Employee / Vendor / Client Code, Employee / Vendor / Client Name, Document Type, Document Number, Document Date, Debit, and Credit. Closed General Ledger Transaction Optional Columns.

    The following optional columns of information are available:

    • Allocation Ledger
    • Client Parent Code
    • Client Parent Name
    • Document Source
    • Document Suffix Code
    • Document Suffix Name
    • External Reference Date
    • External Reference Number
    • Financial Description
    • Internal Reference Number
    • Labor / Expense
    • Posting Date
    • Project Code
    • Project Name
    • Source Company Code
    • Source Company Name
    • Task Code
    • Task Hierarchy Code
    • Task Name
    • Vendor Parent Code
    • Vendor Parent Name