How You Inquire on Detail Balances

You can run account inquiries using the Inquire on Detail Balances page. To get to the page, select the Inquire on Detail Balances task in the Period Close work area.

You can also drill through to the page from Financial Reporting or Smart View.

Search Criteria

Here are some points to consider when entering search criteria.

Your data access set assignments determine the ledgers and ledger sets you can search on.
You can search only on accounting periods, not on years or quarters.
You can search any account hierarchy level in the chart of account fields, as long as the account hierarchies (tree versions) are published to the balances cube. If the search times out before returning results, set parent values for the chart of account dimensions to lower levels.
You can search for segment values by description.

Saved Search

If you search often using the same criteria, create a saved search.

Enter your search criteria.
Click Save.
Enter a name for the search.
Optionally, make the saved search the default search. When you land on the Inquire on Detail Balances page, the default saved search criteria is populated automatically.
Click OK.

Search Results

Here are a few things that you can do with the search results.

Drill to journal lines for actual balances and then drill to the journal entry or subledger transactions.

Note: The drill to journal lines displays attributes such as entered and accounted amounts, accounting date, and journal line description.

Note: Drilling on budget data isn't supported.
Export the balances to Excel.
Hide, show, and manage the columns using the View > Columns and View > Columns > Manage Columns menus. For example, descriptions for chart of accounts dimensions are hidden by default. You might decide to display descriptions for the company, cost center, and account dimensions.

Note: If you select Entered or Converted in the Currency Type search field, the search results appear in two rows. The first row shows the entered currency. The second row shows the ledger currency.

Drill Through from Financial Reporting and Smart View

If you're getting to the Inquire on Detail Balances page by drilling through from Financial Reporting or Smart View, consider these points.

Your data access set assignments determine whether you can drill through to the page.
Best practice is to set the point of view settings for chart of account dimensions to the lowest possible parent or detail value to avoid a timeout.
If you're drilling into a year or quarter Accounting Period dimension, the accounting periods are converted to the applicable range of accounting periods on the Inquire on Detail Balances page.
Your selections for rows, columns, page, and point of view display in the page search fields. You can refine the search criteria as needed and rerun the search.
From the inquiry page, you can drill to journal lines (for actual balances) and then drill to the journal entry or subledger transactions.

Note: Drilling through on budget data isn't supported.