Statistical Ledger Detail (Inquiry)

Additional Information

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

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.
  Document Number Enter or select a document instance based on the document number assigned to it.
  Account Enter or select a desired statistical ledger account.
  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 ClosedStatistical Ledger Summary Inquiry Optional Restrictions.

The following optional restrictions are available:

  • Company
  • Document Suffix
  • Employee / Vendor / Client
  • EVC Type
  • Measure
  • Organization
  • Organization Map
  • Organization Map Level
  • Quantity

Results

The inquiry results include the following two levels of information:

  • Statistical Ledger Detail: The first level of the inquiry provides general ledger detail information, which includes Fiscal Period, Document Number, Document Type, Document Date, EVC Type, Account Code, Account Name, Organization Code, Organization Name, Measure Code, Measure Name, and Quantity. The initial view is grouped in ascending order by Fiscal Period and Document Number. ClosedStatistical Ledger Summary Optional Columns.

    The following optional columns of information are available:

    • Company Code
    • Company Name
    • Document Source
    • Document Suffix Code
    • Document Suffix Name
    • Employee / Vendor / Client Code
    • Employee / Vendor / Client Name,
    • Financial Description
    • Line Item Type
    • Organization Map Name Level 2 - 6
    • Posting Period

  • Transaction Details: The second level of the inquiry provides an transaction details, which includes Account Code, Account Name, Organization Code, Organization Name, Measure Code, Measure Name, and Quantity. The initial view is grouped in ascending order by Account Code. ClosedTransaction Details Optional Columns.

    The following optional columns of information are available:

    • Company Code
    • Company Name
    • Document Date
    • Document Number
    • Document Suffix Code
    • Document Suffix Name
    • Document Type
    • Employee / Vendor / Client Code
    • Employee / Vendor / Client Name
    • EVC Type
    • Financial Description
    • Line Item Type
    • Posting Period