Performing an Account Inquiry
An account inquiry shows you actual, budget, and encumbrance account balances for summary and detail accounts. You can perform variance calculations for both summary and detail accounts. You can also drill down to see the activity that comprises your detail account balances, including activity from Oracle Payables and Oracle Receivables, if these products are installed on your server and you have set up the drilldown. For more information, see After Running AutoPatch, Oracle Applications Installation Manual for Windows Clients, Release 10SC.
When you perform an inquiry, note that the button on the left of most inquiry windows allows you to drill down to more detailed information, and the button on the right allows you to see higher level information.
To perform an account inquiry:
1. Navigate to the Account Inquiry window.
2. Enter the range of Accounting Periods to include in your inquiry.
3. Specify the currency to include in the inquiry:
- Select All Currencies to see account information in all currencies.
- Select Single Currency and enter a Currency to see only balances entered in or translated to that currency.
4. Choose to see balances from transactions Entered in the inquiry currency, or balances Translated to that currency. You must choose Entered balances if the inquiry currency is your functional currency or STAT.
5. From the poplist, choose Primary Balance Type.
6. Specify whether you want to see Actual, Budget, or Encumbrance balances.
- If you choose to show budget balances, specify the Budget to use.
- If you choose to show encumbrance balances, enter an Encumbrance Type.
7. Choose a display and precision Factor:
Units: Full precision; rounds to two decimal places.
Thousands: Divides balances by 1,000; rounds to three decimal places
Millions: Divides balances by 1,000,000; rounds to three decimal places
Billions: Divides balances by 1,000,000,000; rounds to three decimal places.
8. Enter an optional Summary Template name to restrict your inquiry to only those summary accounts associated with that template.
9. Query the summary or detail Account(s) you want to review. If you entered a summary template, you can only query summary accounts associated with that template.
10. Choose the button that applies to the account information you want to see:
- Choose Show Balances to review balances for the current account based on your inquiry criteria.
- Choose Show Journal Details to see the journal entry activity for the current account based on your inquiry criteria. This button is not available if you choose to inquire on translated balances.
- Choose Show Variance to see a variance calculation between the primary balance type you defined for the inquiry and a secondary balance type. This button is not available if you choose to inquire on all currencies.
To include variances in your inquiry:
- You can compare any two balance types in a variance calculation. To inquire on variances, choose Secondary Balance Type from the alternative region poplist, and enter another balance type. Variances are calculated as follows:
Variance = Primary Balance Type - Secondary Balance Type
For example, to see how much you've budgeted but not spent, enter a Budget primary balance type and an Actual secondary type.
Note: You cannot include variances in your Account Inquiry if you choose to inquire on all currencies.
See Also
Reviewing Balances in a Summary Account Inquiry
Reviewing Balances in a Detail Account Inquiry
Drilling Down to Journal Detail
Reviewing Variances Between Balance Types
Drilling Down to Oracle Payables Detail
Drilling Down to Oracle Receivables Detail