Menu Path: None
To use Reporting Account Maintenance, click Reporting Account in Financial Report Format Maintenance.
Note This button is only available if you select the G/L Account radio button.
Enter reporting account filter criteria for financial reports.
Use Reporting Account Maintenance to set up filter criteria for reporting accounts on financial reports.
NOTE If you edit a reporting account definition, and it is used in multiple reports, it will change in every report in which it is used.
To create a reporting account:
Enter a description of the reporting account in the Description field.
Select whether the account defaults to credits or debits.
In the Include Accounts Where section, enter a filter criterion. Select the AND or OR radio button to specify whether the relationship of the criterion with the next criterion will be inclusive or exclusive. If it is the last criterion, select the Blank radio button.
Click the Enter button.
Repeat steps 3 to 4 for any additional filter criteria.
Click the Show Accounts button to verify that the correct accounts are included in the reporting account.
Click the OK button in the ribbon. The reporting account is created.
Button |
Description |
Exit |
Click this button to close the Reporting Account Maintenance window. |
OK |
Click this button to accept the filter criteria and close the Reporting Account Maintenance window. |
Field or Button |
Description |
Enter the reporting account number, or click the Lookup button to select an account number. |
|
This field displays the description of the selected reporting account number. |
|
Select whether to default to a credit or debit. |
|
Select a filtering method, and then click the Lookup buttons to select filter criteria for accounts to include on the financial report. The first and last Lookup button allow you to enter parenthesis around the criterion. This is useful if you are creating a complex set of conditions. The three other Lookup buttons allow you to select the following:
Example If you want to only report on cost center ID 10, you could select Cost Center EQ 10 using the middle three Lookup buttons. |
|
Select one of the following options:
|
|
Click this button to enter the selected criterion in the Selection Criteria grid. |
|
Click this button to clear the Include Accounts Where fields. |
|
Click this button to update a selected filter criterion in the Selection Criteria grid. |
|
Click this button to delete a selected filter criterion in the Selection Criteria grid. |
|
This grid displays selected filter criteria for the financial report line. |
|
This grid displays accounts that match filter criteria in the Selection Criteria grid after you click the Show Accounts button. |
|
Click this button to display accounts in the Selected Accounts grid that match the filter criteria in the Selection Criteria grid. |