Financial Report Account Inquiry

Menu Path: General Ledger $Images\bluerarw.gif$ Report Writer $Images\bluerarw.gif$ Financial Report Account Inquiry

Purpose

View accounts used or not used in financial reports.

Overview

Use Financial Report Account Inquiry to display general ledger accounts that are included in financial reports or accounts that are not included in financial reports (to see if accounts are missing from the report). You can also use the inquiry to view a list of financial reports that include a specific account.

Using the Inquiry

To use Financial Report Account Inquiry:

In the Filter Options section, select criteria for the accounts for which to display information.
In the Display Options section, select whether or not to include accounts on the report(s) or all accounts, then select a period range for the account information you want to display.
Click the Show Data button in the ribbon. The Results tab displays account information based on the criteria selected in steps 1 and 2. You can double-click an account to display detailed information for it.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Financial Report Account Inquiry window.
Show Data	Click this button to display account information on the Results tab, based on the criteria selected on the Select tab.

Select Tab Fields and Buttons

Field or Button	Description
Ledger ID	Enter a ledger ID for which to display accounts, or click the Lookup button to select a ledger ID. This defaults to your default ledger ID. If you do not have a default ledger ID, this defaults to the functional ledger of the current system ID.
All Financial Reports	Select this check box to display accounts for all financial reports. This check box is selected by default.
Report Name	Enter a financial report name for which to display accounts, or click the Lookup button to select a report name. This field is only enabled if you clear the All Financial Reports check box.
List (Reports)	Click this button to display Financial Report List, which allows you to select specific financial report names for which to display accounts. This button is only enabled if you clear the All Financial Reports check box. If you click this button and select financial report names, the check box to the right of the button is selected.
All Account Types	Select this check box to display accounts for all account types. This check box is selected by default.
Type	Click the Lookup button to select an account type for which to display accounts. This field is only enabled if you clear the All Account Types check box.
List (Types)	Click this button to display Account Type List, which allows you to select specific account types for which to display accounts. This button is only enabled if you clear the All Account Types check box. If you click this button and select account types, the check box to the right of the button is selected.
All G/L Accounts	Select this check box to display all general ledger accounts. This check box is cleared by default.
From (General Ledger Account)	Enter a general ledger account for which to display information, or click the Lookup button to select an account. If you want to display account information for a range of accounts, enter the first account in the range of accounts. This field is only enabled if the All G/L Accounts check box is cleared.
To (General Ledger Account)	Enter the last account in a range of accounts for which to display information, or click the Lookup button to select an account. If you only want to display information for a single account, you can leave this field blank. This field is only enabled if the All G/L Accounts check box is cleared.
All Account Elements 1-10	Select these check boxes to display accounts for all of each account element. These check boxes are selected by default. The number of check boxes available depends on how many account elements are set up in Ledger Maintenance.
From Account Element 1-10	Enter an account element for which to display account information, or click the Lookup button to select an account element. If you want to display account information for a range of account elements, enter the first account element in the range. These fields are only enabled if you clear the associated check boxes to the left of these fields. The number of fields available depends on how many account elements are set up in Ledger Maintenance.
To Account Element 1-10	Enter the last account element in a range of account elements for which to display account information, or click the Lookup button to select an account element. If you only want to display account information for a single account element, you can leave these fields blank. These fields are only enabled if you clear the associated check boxes to the left of these fields. The number of fields available depends on how many account elements are set up in Ledger Maintenance.
Account Display Options	Select whether to display accounts included on the financial report(s), accounts not included on the financial report(s), or all accounts.
From Period	Click the Lookup button to select the first period for which to display account information.
To Period	Click the Lookup button to select the last period for which to display account information.
From Year	Click the Lookup button to select the first year for which to display account information.
To Year	Click the Lookup button to select the last year for which to display account information.

Results Tab Fields and Buttons

Field or Button

Description

Accounts

This grid displays account information after you click the Show Data button in the ribbon, based on the criteria selected on the Select tab. Double-click an account to display Account Detail Inquiry, which allows you to view detailed activity for the account. This grid includes the following columns:

G/L Account - This column displays account numbers for each account.
Account Description - This column displays the account description for each account.
Active - The check box is selected in this column for each active account. Accounts are marked as active in Account Maintenance.
Account Type - This column displays the account type for each account.
Element 1-10 - These columns display each of the account elements for each account.
Sequence - This column displays the sequence for each account in the report displayed in the Financial Report column (if the account has multiple occurrences in the report).
Occurrence - This column displays the number of occurrences of each account in the report displayed in the Financial Report column.
Financial Report - This column displays the financial report each account appears or does not appear in.
Included On Financial Report - The check box in this column is selected for each account that is included in the report displayed in the Financial Report column.
Reporting Account - This column displays the reporting account that includes each account (if applicable).
Reporting Account Description - This column displays the reporting account description for the reporting account that includes each account (if applicable).
Ending Balance - This column displays the ending balance for each account as of the last period in the selected period range.
Balance CR/DR - This column displays CR if the account ending balance is a credit or DR if the account ending balance is a debit.
Total Posted - This column displays the total posted amount for each account in the selected period range.
Total Posted CR/DR - This column displays CR if the total posted amount is a credit or DR if the total posted amount is a debit.