Defining activity total names

An activity total name is used with total data dictionary names in a compute statement. You can use these total data dictionary names with total names instead of other data dictionary names with compute parameters. This diagram shows how to define total names that you use in a compute statement:

Procedure flow: Defining activity total names
  1. Access Activity Total Names (AC35.1).
  2. Specify a name and provide a description for the total name.
  3. On the Main tab, define the main characteristics of the total name. Specify this information:
    Year

    When you use a total name in a compute statement, you can select the year to retrieve data in the total name or as an optional parameter for the data dictionary name. To identify the year as part of the total name, specify the year for the data to retrieve.

    Type

    Select how totals are generated from one of these options:

    • A - Amount: Total activity amounts.
    • U - Unit: Total activity units.
    • C - Currency: Total amounts using activity currency instead of base currency.
    • G - AC/GL Acct Unit Amount: Total amount balances by activity, account category, company, and accounting unit, only if you maintain accounting unit balances.
    • H - AC/GL Acct Unit Units: Total unit balances by activity, account category, company, and accounting unit, only if you maintain accounting unit balances.
    Budget

    If you selected Amount or Unit for the Type, then you can select Y - Yes to accumulate totals from activity budgets.

    Budget Number

    If you selected Y - Yes in the Budget field, then select the budget number to use for accumulating totals.

  4. Select the Single Ranges tab to define one set of data to associate with the total name. Consider these tabs.
    AC Parameters

    If you selected Amount, Unit or Currency in the Type field on the Main tab, then you can select a combination of activities and account categories as if they were one amount. Select one of these options:

    • An activity or activity list
    • A range of account categories or an account category group
    GL Parameters

    If you selected AC/GL Accounting Unit Amounts or AC/GL Accounting Units in the Type field on the Main tab, then consolidate those balances by identifying a combination of companies and accounting units. Select one of these options:

    • A company and accounting unit
    • A company group and accounting unit
    • An accounting unit list
      Note: The GL Parameters fields relate to accounting unit balances you maintain in Project Accounting. To maintain these balances, you must select Yes in the Accounting Unit Balance field on Activity Group (AC00.1) and run AC191 to update these balances or run Activity Posting (AC190) with the Post Acct Unit Balances field set to Yes.

    Alternatively, you can select the Multiple Ranges tab to associate multiple sets of data with the Total Range. For example, if you retrieve data from three different lists of activities you can define three sequences of AC Parameters in a total range.

    Note: You can associate multiple sets of data with the total name using Total ranges.
    1. Select Define in the Total Range field to access Activity Total Range (AC36.1).
    2. Specify a name and provide a description for the total range.
    3. Complete fields on the AC Parameters or GL Parameters tabs as you would on AC35.1 to define the sets of data you want to associate with the total name.
    4. Click Add after each set of data you define. The total range name remains the same for each set of data and the application automatically assigns a sequence number to each set of data to uniquely identify it.
Related topics