Defining an allocation pool

Use this procedure to define a pool for an allocation. A pool identifies the amount or units to be allocated. Pools are either activity-based or General Ledger-based. Activity pools consist of posted monetary amounts or statistical units found in activities and account categories. General Ledger pools consist of unit or amount balances for companies, accounting units, accounts, and subaccounts.

Follow these steps to define an allocation pool:

  1. Access Allocation Pool (AC32.1).
  2. On the Activity Management tab, define an activity based pool.

    Use these guidelines to specify the field values:

    Type

    Select either amounts or units to be the basis of the pool.

    Calculate Compute Value

    Select whether or not to calculate the amount in the allocation pool. The compute value is valid for Year-to-date, Life-to-date, and compute statements for AC allocation pools only.

    Note:  Period-to-date allocation pools cannot be calculated because they depend on the allocation date entered on Allocation Calculation (AC130).
    Activity Selection

    To define a pool comprised of a single activity, select Activity.

    To define a pool comprised of multiple activities, select Activity List.

    Activity or Activity List

    Based on your choice in the Activity Selection field, select an activity or activity list. The name of this field is dynamic and changes to reflect your choice in the Activity Selection field.

    Note: If you select an activity list, remember that balances from posting activities roll up to summary activities. If members of your list include posting activities and their higher level summary activities, then your pool can be overstated.
    Account Category Selection

    Select Account Category Range or Account Category Group as the basis for the account categories in the allocation pool.

    Acct Cat Range or Acct Cat Group

    Based on your choice in the Account Category Selection field, select an account category range or account category group in this field. The name of this field is dynamic and changes to reflect your choice in the Account Category Selection field.

    Cumulative Basis

    Select whether you want life-to-date, year-to-date, or period-to-date balances for the activities and account categories.

    Compute

    Use a compute statement to identify the cumulative basis for the allocation pool. For example, specify the compute statement YTDACA(,12)*.70 to specify the pool basis as 70% of current year-to-date activity amounts through period 12.

    Alternatively, you can go to the General Ledger tab and define a general ledger based pool. Use these guidelines to specify the field values:

    Type

    Select either amounts or units to be the basis of the pool.

    Compute

    Select a compute statement to identify the type of General Ledger data you want in the pool. For example, the compute statement CPAMT*1 defines General Ledger current period amount balances, and CYAMT*1 defined General Ledger current year-to-date amount balances. You define compute statements using Compute Statement (RW50.1).

    Company

    Select the company to define the data you want in the pool.

    Accounting Unit

    Select the accounting unit to define the data you want in the pool. You can select a posting or summary accounting unit.

    Note: To define a pool for General Ledger balances in multiple companies or accounting units, use General Ledger total names in the Compute statement you define for the pool.
    Accounts

    Select a range of accounts to define the data you want in the pool.

    Subaccounts

    Select a range of subaccounts to define the data you want in the pool.