Defining a computed allocation

A computed allocation allocates amounts or units using a compute statement. Use computed allocations when allocation percentages are dependent on a system calculated percentage. This procedure describes the process of defining a computed allocation.

You must define at least one allocation pool and an allocation header before defining an allocation. See Allocations overview and setup. Use the previous procedures in this chapter to define the compute statement you will use as the driver for the allocation.

  1. Access Multiple Pool Allocation (AC30.2).
  2. Define the computed allocation. Use these guidelines to specify the field values:
    Allocation

    Select the name of the allocation you are defining. You name the allocation when defining the allocation header. See Defining an allocation header.

    Line

    Specify the allocation line number. Each line identifies the pool, driver information, and the activities to which allocation transactions will be posted.

    Post To Activity

    Select the activity and account category to which the allocation will be posted.

    Pool

    Select the pool from which you want to allocate amounts or units. You can specify a different pool for each allocation line, or you can use the same pool. See Defining an allocation pool.

    Compute

    Select a compute statement for the allocation driver.

    Param (Compute Parameter)

    Select a compute parameter to use with the compute statement.

    Post Opt (Posting Option)

    Select one of these posting options to determine the level of detail for the allocation transactions:

    • The Consolidate option creates one allocation transaction for each Post to Activity. The transaction is posted to the post-to activity and account category defined on the allocation line. The Consolidate option defaults, and must be used with General Ledger based pools.

    • The Pool option creates multiple allocation transactions for each Post to Activity. Transactions are created based on the pool's account categories. Transactions are posted to the Post to Activity defined on the allocation line, but the account category is overridden with the original account categories defined for the pool. This option can only be used with an activity based pool.

    • The Detail option creates multiple allocation transactions for each Post to Activity. The calculation creates the same detailed transactions as the Pool option, but transactions are posted to the Post to Activity and account category defined on the allocation line.

      Examples are available elsewhere in this user guide. See Account category posting options.

    Auto Rvs (Auto Reverse)

    Select Yes to automatically create a reversing entry for the allocation when you create allocation transactions. When you run Allocation Update (AC131), you specify the date you want to assign to the reversing entry. This option is normally used for allocations based on year-to-date or life-to-date data. This overrides the default you defined in the Automatic Reverse field on New Allocation (AC30.4).

  3. To override allocation header or pool information for the post-to activity in the allocation line, or to define a unit of measure if you are allocating units that will impact Units of Production billing, click More to access Activity Allocation (AC30.6). Use these guidelines to specify the field values:
    Post From Activity, Post From Acct Category, and Post From Account

    You can override offset transaction defaults defined on New Allocation (AC30.4) in these three fields.

    Type

    Select Amount or Units to override the type of data allocated from the pool.

    Unit Of Measure

    If you are allocating units that you want to bill using the Units of Production billing method in the Billing and Revenue Management application, then select a unit of measure. See Defining units of measure (AC/BR).

    Description

    The description in the allocation header is used in transactions created for the post-to activity in the allocation line. Specify a description to override the description defined in the allocation header.

    Post To Account

    The allocation header contains the post-to company, accounting unit, account, and subaccount that will be used in the allocation transaction. Select a different company, accounting unit, account, and subaccount if you do not want to use the allocation header's information in the transactions created for the post-to activity in the allocation line.