Creating reusable settings for account analysis
Account analysis settings are a set of reusable reporting parameters that are saved for quick analysis.
- Select Account Analysis.
- Select Actions > Create.
- Specify this information:
- Account Analysis Settings
- Provide the name and description of the account analysis settings.
- Reporting Basis
- Select the reporting basis to determine the chart and structure to be used for the account analysis.
- Scenario
- Select the scenario for the account analysis, for example, actuals, encumbrances, commitments, or budget. If you select a budget scenario, then the Analyze Budget button is available when the account analysis is saved.
- Account
- Select the chart account level for the account analysis. When you select a summary level account, the account and any child accounts are displayed. If this field is blank, then the top level of the structure that is assigned to the selected reporting basis is used.
- System
- Select a system to return records for a single system. If this field is blank, then all system codes are displayed.
- Year
- Optionally, select the year for the account analysis. Selecting the year limits the periods returned for the period filters.
- Period
- Select a reporting period, including year and month or year and quarter.
- Thru Period
- Select a through period. Use this field when the period range is not available as an existing calendar group. We recommend that a through period is used when the same results can be achieved by selecting a quarter period or a year period. For example, Period 1 through Period 3 should be Quarter 1.
- Use LTD Beginning Balance
- Select this check box to include life-to-date beginning balance to calculate life-to-date totals.
- Accounting Entity
- Select an accounting entity to filter the totals that are displayed. If this field is blank, then all accounting entities that are assigned to the basis are displayed.
- User Dimensions
- Additional user dimensions that are defined in the finance enterprise group are displayed as separate fields. Select a value for each of the dimensions to filter the totals that are displayed. If this field is blank, then the top level of the structure that is assigned to the selected reporting basis is used.
- Reporting Currency
- Select a reporting currency for the account analysis. All amounts are displayed in the report currency. If Functional, Alternate, Alternate 2 or Alternate 3 is selected, then a warning is displayed when Accounting Entity is blank.
- Suppress Zero Rows
- Select this check box to exclude posting accounts with zero amounts.
-
Click Save.
To open the analysis using the saved settings, Click Analyze Accounts or Analyze Budget or Trial Balance.