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.

  1. Access Total Names (RW70.1).
    Note: When you define a total name, you must not create a new total name for each fiscal year. You can use the system to store 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 use in a compute statement. Specify this information:
    Year

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

    Total Name

    Specify or select a total name.

    Description
    Provide a description for the total name.
  3. On the Main tab, define the basic total name parameters. Specify this information:
    Folder

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

    Type
    Specify or select how totals are accumulated. These types are available:
    • Amounts
    • Units
    • Currency
    • Budget Amounts
    • Budget Units
    • Reporting Currency
    Currency

    Specify or select a currency code in which you calculate the total name.

    Budget

    If you are calculating a total of budget information, then 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. Optionally, select Calculate to open Total Value (RW70.2) on the Main tab. Use this form to calculate and inquire total name values for each period and year, and review them for accuracy.
  5. On the Single Ranges tab, define a total name that includes a single range of companies and up to four accounting units.
  6. On the Accounting Units tab, 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.
  7. On the Accounts tab, 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.
  8. Alternatively, click the Multiple Ranges tab and 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