Understanding Ledger, Journal, and Financial Information Inquiries

PeopleSoft General Ledger provides a series of inquiries that enable you to review ledger summary and detail ledger information based on selected ChartField combinations. These inquiries use several successive views that take you down to journal line details. The ledger inquiry also enables you to drill down across products from account balances in General Ledger to specific transaction entries in other PeopleSoft Financials and Distribution products.

The following terms are used in this topic:

Term

Definition

Regular Balance

View a regular balance when you inquire on the balance of a ledger and you do not include any adjustment entries, balance forward entries, or closing entries. This balance only includes transactions posted during the specified period.

Cumulative Balance

View a cumulative ledger balance when you inquire on the balance of a ledger by including balance forward entries, adjustment entries and closing entries. Each balance is added to the next balance to provide a cumulative ledger balance.

Base Amount

The transaction amount converted to the base currency indicated for the transactions business unit.

Posted Total Base Amount

The total ledger amount expressed in the base currency.

Transaction Amount

The amount of the transaction entered in a currency that is different from the base currency or is the same currency as the base currency.

Posted Total Transaction Amount

Amounts in the transaction currency for all ledger balances including those in the base currency.

Posted Total Amount

Total amount of the transactions in the transaction currency for all ledger balances except those in the base currency.

Note: Many of the following inquiry pages operate in deferred processing mode. Most fields are not updated or validated until you save the page or refresh it by clicking a button, link, or tab. This delayed processing has various implications for the field values on the page—for example, if a field contains a default value, any value you enter before the system updates the page overrides the default. Another implication is that the system updates quantity balances or totals only when you save or otherwise refresh the page.

These inquiries are accessible in General Ledger:

  • Journal Inquiry

    Enables you to review a specific journal or multiple journals within a ledger for a business unit and accounting period. You can use a document sequence number as part of your search criteria to review journal data.

  • Ledger Inquiry

    Select a ledger to view based on selected ChartField values, including book codes, or ChartField value sets, which consist of a predefined set of selection criteria for a given ChartField. A ChartField value set can be obtained from a tree, a series of detail ChartField ranges, or a series of detail ChartField values. There are also various methods for displaying both summary and detail ledger information.

  • Ledger Group Inquiry

    Review all the journals within a ledger group along with their journal line details. Compare the posted transaction amount, posted base amount, or posted total amount balances between ledger periods.

  • Ledger Comparisons

    Compare one ledger by periods or compare one ledger with another within one or more ledger periods. Customize your comparison by selecting specific ChartFields or ChartField value sets. You can display comparisons for all thirteen periods or for selected periods, with or without adjustments.

  • Analytic Charts

    Display analytic bar charts of the comparison across ledgers amounts.

  • Imported Accounting Entries Inquiries

    Import PeopleSoft Payroll, Student Financial, Enterprise Learning Management, Contributor Relations and Global Consolidations transactions, as well as generic accounting line data into General Ledger and review this imported data before and after you run Journal Generator.

  • Entry Event Budget and GL Adjustment Accounting Inquiries

    Drill down to the accounting line detail for Budget and GL adjustment transactions that use entry events.

  • Subsystem Reconciliation Inquiry

    Drill back to the Payables and Receivables subsystems and review vital status fields for documents that have not been processed and posted to the general ledger.