General Ledger Detail (Inquiry)

The General Ledger Detail Inquiry allows you to view a detail of general and allocation ledger transactions posted to accounts. This inquiry provides two levels of information, which includes a general ledger detail and transaction details for a specific document.

Additional Information

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. This 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.
  Document Number Enter or select a document instance based on the document number assigned to it.
  From Document Date

Enter or select a document date. This is the first date in the date range to include items.
  To Document Date Enter or select a document date. This is the last date in the date range to include items.

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
  • Allocation
  • Client
  • Client Parent
  • Company
  • Credit Amount
  • Currency
  • Debit Amount
  • Document Source
  • Document Suffix
  • Document Type
  • Employee
  • EVC Type
  • External Reference Number
  • Organization
  • Organization Map
  • Organization Map Level
  • Project
  • Project Manager
  • Project Organization
  • Transaction Type
  • Vendor
  • Vendor Parent

Results

The inquiry results include the following two levels of information:

  • General Ledger Detail: The first level of the inquiry provides general ledger detail information, which includes Fiscal Period, Posting Date, Document Number, Document Type, Document Date, EVC Type, Employee / Vendor / Client Name, Account Code, Account Name, Organization Code, Organization Name, Debit Amount, Credit Amount, Currency Code, and Net Amount. The initial view is grouped in ascending order by Fiscal Period, Posting Date, and Document Number. ClosedGeneral Ledger Summary Optional Columns.

    The following optional columns of information are available:

    • Account Map Level 2 - 6 Name
    • Account Type
    • Allocation Code
    • Allocation Ledger
    • Allocation Name
    • Budget Category Code
    • Budget Category Name
    • Client Parent Code
    • Client Parent Name
    • Client Parent Type
    • Client Type
    • Company Code
    • Company Name
    • Document Source
    • Document Suffix Code
    • Document Suffix Name
    • Employee / Vendor / Client Code
    • Employee Type
    • Expense Category Code
    • Expense Category Name
    • Expense Category Type
    • External Reference Date
    • External Reference Number
    • Financial Description
    • General Ledger
    • Internal Reference Number
    • Line Item Type
    • Organization Map Level 2 - 6 Name
    • Posting Period
    • Project Code
    • Project Description
    • Project Director Code
    • Project Director Name
    • Project Manager Code
    • Project Manager Name
    • Project Name
    • Reconciled
    • Source Company Code
    • Source Company Name
    • Task Code
    • Task Hierarchy Code
    • Task Name
    • Transaction Type
    • Vendor Parent Code
    • Vendor Parent Name
    • Vendor Parent Type
    • Vendor Type

  • Transaction Details: The second level of the inquiry provides an transaction details, which includes Account Code, Account Name, Organization Code, Organization Name, External Reference Number, Currency Code, Debit Amount, and Credit Amount. The initial view is grouped in ascending order by Account Code. ClosedTransaction Details Optional Columns.

    The following optional columns of information are available:

    • Account Type
    • Budget Category Code
    • Budget Category Name
    • Client Parent Code
    • Client Parent Name
    • Company Code
    • Company Name
    • Document Date
    • Document Number
    • Document Source
    • Document Suffix Code
    • Document Suffix Name
    • Document Type
    • Employee / Vendor / Client Code
    • Employee / Vendor / Client Name
    • EVC Type
    • External Reference Date
    • Financial Description
    • Internal Reference Number
    • Line Item Type
    • Posting Date
    • Posting Period
    • Project Code
    • Project Description
    • Project Name
    • Source Company Code
    • Source Company Name
    • Task Code
    • Task Hierarchy Code
    • Task Name
    • Vendor Parent Code
    • Vendor Parent Name