Email: support@essaywriterpros.com
Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Reviewing Balances in an Account Inquiry

Reviewing Balances in an Account Inquiry

When you perform an inquiry on a summary account, you can drill down to the detail balances that make up the summary balance. When you perform an account inquiry on a detail account, you can review the journal entries that affect your account balances during the period you specify. You can also see the summary accounts the detail account rolls up into.

For any account inquiry, you can view account balances in their entered currency as well as converted to their ledger currency.

Note: You cannot use ledger sets for summary account inquiry.

Data Access Sets

To view summary accounts, your data access set must provide read access to the ledger and parent accounts used in the summary account. For example, you must have read access to the T account.

Folder Tools

Most inquiry windows are folders. You can customize folders to show the account or journal information you need by Ledger, Ledger Currency, and other information. The following table lists the fields available.

FieldDescription
AccountThe accounting flexfield.
Account DescriptionThe description of the accounting flexfield.
Converted Debit/CreditThe foreign entered debit or credit amounts that have been converted to the ledger currency
Debit/CreditThe debit or credit amounts entered in a specific currency.
CurrencyThe currency for a specific balance.
LedgerThe ledger name.
Ledger CurrencyThe currency of the ledger.
If you use reporting currencies, then this is the currency of the reporting currency.
PeriodThe Period name.
PJTD, PTD, QTD, YTDIf querying on the Currency Type Total, the total cumulative amounts for the ledger currency for the given amount type. This includes balances that were entered using the ledger currency, as well as any foreign entered balances that were converted to the ledger currency.
If you use reporting currencies (journal or subledger level), then querying on the Currency Type Total displays the total cumulative amounts for the reporting currency for the given amount type. This includes balances that were entered using the currency of the reporting currency, as well as any foreign entered balances that were converted to the reporting currency.
If querying on Currency Type Entered, the amounts entered using a specific currency for the given amount type.
PJTD, PTD, QTD, YTD ConvertedThe foreign entered amounts that were converted to the ledger currency for a given amount type.
If you use reporting currencies (journal or subledger level), then this displays the foreign entered amounts that were converted to the currency of the reporting currency for a given amount type.

Note: All of the Converted fields will be null for Budget and Encumbrance balances because those balance types are not converted to the ledger currency or reporting currency.

For information on modifying and saving folders, see the Oracle E-Business Suite User’s Guide.

Prerequisites

  • Enter your account inquiry criteria. For a summary account inquiry, make sure you specify a summary template and select a summary account for the inquiry. For a detail account inquiry, do not specify a summary template-simply select a detail account.