Creating reusable settings for account analysis

Account analysis settings are a set of reusable reporting parameters that are saved for quick analysis.

  1. Select Account Analysis.
  2. Select Actions > Create.
  3. 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.
  4. Click Save.

    To open the analysis using the saved settings, Click Analyze Accounts or Analyze Budget or Trial Balance.