Defining a total name

Use this procedure to define a total name for use in a compute statement. A total name is a user-defined name that identifies any combination of accounting unit, account, or subaccount balances for a company, company group, level group, accounting unit list, or total range as if they were one amount.

To define a total name, complete these steps:

  1. Access Total Names (RW70.1).
    Note: When you define a total name, you do not need to create a new total name for each fiscal year. The system stores totals by fiscal year. When you use a total name in a new fiscal year, the application automatically creates the total name for that new year and generates a new balance.
  2. Define a total name that you will use in a compute statement. Use these guidelines to specify the field values:
    Year

    Specify the fiscal year in which you are defining a total name.

    Total Name, Description

    Specify or select a name and description that you want to identify as the total name.

  3. On the Main tab, define the basic total name parameters. Use these guidelines to specify the field values:
    Folder

    Specify or select a folder where you want to store the total names. You can define folders in Folder (RW01.1).

    Type

    Specify or select how totals are accumulated. You can select Amounts, Units, Currency, Budget Amounts, Budget Units, or Reporting Currency.

    Currency

    You can specify or select a currency code in which you will calculate the total name in.

    Budget

    If you are calculating a total of budget information, then you can specify or select the budget number.

    Ledger

    If the Total Name applies to one or more ledger companies, select a ledger in this field. You can define the ledger in Ledger Setup (ML10.1) and associate it with any company or companies that you select for the Total Name.

  4. (Optional) On the Main tab, you can select Calculate to open Total Value (RW70.2). Use this form to calculate and inquire total name values for each period and year, and review them for accuracy.
  5. Select the Single Ranges tab.
  6. Use this tab to define a total name that includes a single range of companies and up to four accounting units. Use these guidelines to specify the field values:
    Accounting Units

    Use this tab to define accounting unit information for the total name. Select from these fields:

    • Company

    • Accounting Unit

      – or –

    • Company Group

    • Account Unit List

    • Level Group

      Note: If you select an accounting unit, then leave the Accounting Unit List field blank.
    Accounts

    Use this tab to define additional account information for the total name. Select from these fields:

    • Chart of Account

    • Summary Account

      – or –

    • Account List

    • Major Account Range

    • Account Group

    • Subaccount

    • Subaccount Group

      Note: If you select an account range, then leave the Account Group field blank. If you select a subaccount, then leave the Subaccount Group blank.
  7. Alternatively, you can select the Multiple Ranges tab to define a total name that includes multiple ranges. A total range includes a company group, an accounting unit list, a level group, an account group, subaccount ranges, or a subaccount group.
Related topics