Inquiries

Subledger Accounting Inquiries Overview

Use the accounting events drill-down and inquiries features to:

Accounting Events Inquiry

Accounting Events Inquiry Process Flow Diagram

The figure below shows the process flow for accounting events inquiry from a subledger application responsibility and is described in Accounting Events Inquiry Process Steps.

the picture is described in the document text

Accounting Events Inquiry Process Steps

  1. In the subledger application responsibility for any application using Subledger Accounting, navigate to the Accounting Events inquiry page.

  2. Execute a search for specific accounting events.

  3. View accounting events.

  4. View subledger journal header information for a selected accounting event by clicking View Journal Headers.

    Note: The View Subledger Journal Entry Headers page is displayed only if there is more than one subledger journal entry created for an accounting event. If there is only one subledger journal entry for an accounting event, the View Subledger Journal Entry page is displayed.

  5. View detailed entry information about the subledger journal entry header by clicking the ledger link.

    Note: The following conditions exist:

    • If the balance type is Actual, the reference date is displayed.

    • If the balance type is Budget, the Budget Version field is displayed.

    • If the balance type is Encumbrance, the Encumbrance Type field is displayed.

    • If the entry is for public sector and funds approval is required, the Funds Status field is displayed.

  6. View journal entry information in a t-account format by clicking View T-Account in the Header region of the View Subledger Journal Entry page.

  7. If viewing an accrual reversal journal entry in the View Subledger Journal Entry page, the View Accrual Entry button is displayed to view the accrual journal entry details. If viewing an accrual journal entry, the View Reversing Entry button is displayed to view the accrual reversal journal entry details.

  8. View multiperiod lines associated with the accrual journal entry by clicking the Multiperiod icon in the Lines region.

  9. Compare subledger journal entry header and line information for two selected journals by clicking Compare in the View Subledger Journal Entry Headers page.

  10. View the transaction associated with the accounting event by clicking View Transaction in the View Subledger Journal Entry Headers page.

    Note: This button appears only if the drilldown procedure is registered for the subledger application.

  11. View supporting references at the header or line level for the subledger journal entry by clicking the Supporting References icon.

Subledger Journal Entry Headers Inquiry

Journal Entry Headers Inquiry Process Flow Diagram

The figure below shows the process flow for subledger journal entry headers inquiry and is described in Journal Entry Headers Inquiry Process Steps.

See: Subledger Journal Entry Definition Overview

the picture is described in the document text

Journal Entry Headers Inquiry Process Steps

  1. In the subledger application responsibility for any application using Subledger accounting, navigate to the Subledger Journal Entry Headers inquiry page.

  2. Execute a search.

  3. View subledger journal entry headers in the results region.

  4. Delete, update, duplicate, reverse, or complete subledger journal entries.

    See: Creating Manual Subledger Journal Entries

  5. View detailed header and line information by selecting the ledger link.

  6. View journal entry information in a t-account format by clicking View T-account in the View Subledger Journal Entry page.

  7. If viewing an accrual reversal journal entry in the View Subledger Journal Entry page, the View Accrual Entry button is displayed to view the accrual journal entry. If viewing an accrual journal entry, the View Reversing Entry button is displayed to view the accrual reversal journal entry.

  8. View multiperiod lines associated with the accrual journal entry by clicking the Multiperiod icon in the Lines region.

  9. Create journal entries page by clicking Create Journal Entry in the Subledger Journal Entries page.

  10. Compare subledger journal entries by clicking Compare in the Subledger Journal Entries page.

Subledger Journal Entry Lines Inquiry

View subledger journal entry lines for a number of different documents or transactions by selecting the Subledger Journal Entry Lines menu option in the subledger accounting responsibility. Use the Search region in the Subledger Journal Entry Lines page to execute an inquiry for specific events based on selected criteria.

Journal Entry Lines Inquiry Process Flow Diagram

The figure below shows the process flow for journal entry lines inquiry from a subledger application and is described in Journal Entry Lines Inquiry Process Steps.

the picture is described in the document text

Journal Entry Lines Inquiry Process Steps

  1. In the subledger application responsibility for any application using Subledger Accounting, navigate to the Subledger Journal Entry Lines page.

  2. Execute a search.

  3. View subledger journal entry lines in the results region.

  4. View subledger journal entry lines and header for a selected journal entry line by clicking View Journal Entry.

  5. View journal line information in t-account format by clicking View T-account in the View Subledger Journal Entry page.

  6. Click View Supporting References to view the supporting references associated with the subledger journal line.

  7. If viewing an accrual reversal journal entry in the View Subledger Journal Entry page, the View Accrual Entry button is displayed to view the accrual journal entry details. If viewing an accrual journal entry, the View Reversing Entry button is displayed to view the accrual reversal journal entry details.

  8. View multiperiod lines associated with the accrual journal entry line by clicking the Multiperiod icon in the Lines region.

  9. View the transaction associated with the subledger journal entry by clicking View Transaction in the Subledger Journal Entry Lines page.

    Note: This button appears only if the drilldown procedure is registered for the subledger application.

Drilldown from General Ledger

The figure below shows the drilldown from GL journal lines inquiry to subledger journal entry lines in Subledger Accounting. From here, users can navigate to the subledger journal entries or drill down to the subledger transaction.

the picture is described in the document text

Viewing Supporting Reference Balances

Use the Supporting Reference Balances page to inquire on account balances for a particular supporting reference, then drill-down to the journal lines that contribute to the balances.

To view account balances for one or more supporting references:

  1. Navigate to the Supporting Reference Balances page.

  2. Enter required information: ledger, period range, and supporting reference name. Optionally, enter an account and supporting reference detail values.

  3. Click Go.

  4. Click on the appropriate period activity to view the journal entry lines.

  5. On the View Journal Entry Lines page, click View Journal Entry to drill-down to the Subledger Journal Entry page and view the journal entry to which the line belongs or click View Transaction to drill-down to the subledger transaction that originates the journal entry.

  6. Click the Supporting References icon to open the View Supporting References page.

  7. On the Supporting Reference Balances page, click Export to download the balances to a spreadsheet.