Defining activity total names

An activity total name can be 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. Use this optional procedure to define total names that you want to use in a compute statement.

Procedure flow: Defining activity total names
  1. Access Activity Total Names (AC35.1).
  2. Specify a name and description for the total name.
  3. On the Main tab, define the main characteristics of the total name. Use these guidelines to specify the field values:
    Year

    When you use a total name in a compute statement, you can select the year for which you want 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 you want to retrieve.

    Type

    Select how totals should be generated from one of these options:

    • Select Amount to total activity amounts

    • Select Unit to total activity units

    • Select Currency to total amounts using activity currency instead of base currency

    • Select AC/GL Acct Unit Amount to total amount balances by activity, account category, company, and accounting unit (only if you maintain accounting unit balances)

    • Select AC/GL Acct Unit Units to 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 Yes to accumulate totals from activity budgets.

    Budget Number

    If you selected 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 you want to associate with the total name. Consider these tabs under the Single Ranges tab.
    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

    • 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 Name. For example, if you want to retrieve data from three different lists of activities you can define three sequences of AC Parameters in a total range.

    Note: Total ranges let you associate multiple sets of data with the total name.
    1. Select Define in the Total Range field to access Activity Total Range (AC36.1).
    2. Specify a name and 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. Select the Add form action 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.