Defining list allocations

This procedure describes the process for defining list allocations in Project Accounting. A list allocation uses activity lists to identify the activities to which allocations is posted. Use this procedure to define a list allocation.

You must define an allocation pool and an allocation header before defining an allocation. See Allocations overview and setup.

Procedure flow: Defining list allocations
  1. Access List (MX10.1) to define the activity list that will identify the post-to activities for the list allocation. See Using Attribute Matrix attributes.
  2. Access Allocation Pool (AC32.1) to define the pool containing the amounts or units that you want to allocate. If you will be using the pool activity posting option for the list allocation, ensure that the pool's list must is the same as the post to list you select in the allocation. See Allocations overview and setup.
  3. Access Activity Total Names (AC35.1) to define any total names you want to use in the compute statement for the list allocation. If you are using a total name in the compute statement's numerator, and you want the system to calculate the pro rata share of each activity in the list to total activities in the list, then leave the activity-related parameters blank. See Defining computed allocations.
  4. Access Compute Statement (RW50.1) to define the compute statement you will use as the list allocation's driver. See Defining computed allocations.
  5. Access Compute Parameters (AC34.1) to define any compute parameters you need to associate with data dictionary names in the compute statement. If are using a data dictionary name in the compute statements numerator, and you want the system to calculate the pro rata share of each activity in the list to total activities in the list, then leave the activity-related parameters blank. See Defining computed allocations.
  6. Access List Allocation (AC30.3) to define the list 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.

    Pool

    Select the pool from which you want to allocate amounts or units. If you will be using the pool activity post option, then the pool must select activities using the same activity list that you use in the Post To List field. See Defining an allocation pool.

    Post To List

    Select the list of activities that represents the post-to activities for this allocation. If you select Pool in the Activity Post Option, then ensure that the list you select in this field is the same as the list you select in the Pool field.

    Activity Post Option

    Select the activity posting option to use to determine how the allocation will be calculated:

    • If you select Consolidate, the application applies the compute statement to the entire pool balance. Allocation transactions are created for each post-to activity in the list. The default setting is Consolidate.

    • If you select Pool, then the application treats each activity in the pool's list separately. The driver is applied to each activity, and the allocation is posted back to the same activity. The pool must be defined using a list of activities, and the post-to activities must be identified using the same list.

    Acct Cat Post 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 activity in the post to list. The transaction is posted to the account category defined in the Post to Account Cat field. The Consolidate option defaults, and must be used with General Ledger based pools.

    • The Pool option creates multiple allocation transactions for each activity in the post to list. Transactions are posted using the account categories identified in the allocation pool. This option can only be used with an activity based pool.

    • The Detail option creates multiple allocation transactions for each activity in the post to list. The system creates the same detailed transactions as the Pool option, but transactions are posted to the account category defined in the Post to Account Cat field.

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

    Post To Acct Cat

    Select the account category to which the allocation transactions should be posted. This field is required if you select Detail or Consolidate in the Acct Cat Post Option field.

    Automatic 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).

    Compute Name

    Select a compute statement in the Compute Name field to use as the driver for this allocation.

    Parameter Name

    Select a compute parameter in the Parameter Name field to use with the compute statement.

  7. To override parameters defined in the allocation header, or to define a unit of measure to allocate 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 intend 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 each post-to activity in the post to list. 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.