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.
Use the previous procedures in this chapter to define the compute statement that you can use as the driver for the allocation.
- Access Multiple Pool Allocation (AC30.2).
- Define the computed allocation. Specify this information:
- Allocation
-
Select the name of the allocation you are defining. You name the allocation when defining the allocation header.
- Line
-
Specify the allocation line number. Each line identifies the pool, driver information, and the activities to which allocation transactions are posted.
- Post To Activity
-
Select the activity and account category to which the allocation is posted.
- Pool
-
Select the pool to allocate amounts or units. You can specify a different pool for each allocation line, or you can use the same 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:
- C - Consolidate: Create 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. By default, this option is selected and it is used with General Ledger based pools.
- P - Pool: Create 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. You can only use this option with an activity based pool.
- D - Detail: Create multiple allocation transactions for each Post to Activity. The calculation creates the same detailed transactions as the P - Pool option, but transactions are posted to the Post to Activity and account category defined on the allocation line.
- Auto Rvs (Auto Reverse)
-
Select Y - 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 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).
- 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 affects Units of Production billing, click More to access Activity Allocation (AC30.6). Specify this information:
- 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 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.
- Description
-
The description in the allocation header is used in transactions created for the post-to activity in the allocation line. Provide 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 is 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.