Creating actuals allocation lines

The allocation line is used to define the allocation calculation rules, the allocated balances, and the method by which the balances are allocated. Allocation lines also contain the details and the rules for how the journal lines are created.

See Copying allocation lines for steps to copy content from existing allocation lines.

  1. Select Processing > Allocations > Allocation Control.
  2. On the Actuals tab, open an allocation record.
  3. On the Allocations tab, open an allocation record.
  4. On the Lines tab, click Create.
  5. Specify this information:
    Allocation Line
    Specify the name and description of the allocation line.
    Step
    Specify a step number to the allocation line if it is different from the default step..

    Step values are used when a subsequent allocation depends on the results of a previous allocation. For example, if this calculation depends on other allocation calculations, then identify whether this allocation should be calculated first. Otherwise, it is calculated after initial allocations are calculated.

  6. On the Parameters tab, specify this information:
    From Post Option
    Select the from posting option. The posting options control the method by which the journal lines are generated and determine the details of each generated journal line.
    To Post Option
    Select the to posting option. The method by which the journal lines are generated and the details of each generated journal line are controlled by the posting options.

    For information about the from and to post options, see Valid combinations of To and From posting options.

    Source Percentage
    Specify a percentage of the source to allocate. The default value is 100.

    Specify a negative percentage to reverse posted allocation transactions. Reversed transactions are generated when the allocation is rerun. For example, if the allocation was run with a source percentage of 75, then rerun the allocation with a source percentage of -75. The posted allocation transactions are offset.

    Auto Reverse
    Select Default From Allocation to inherit the Auto Reverse setting of the allocation. Select Yes or No to override the value of the allocation.

    If an allocation line is set to auto reverse, then all transactions from the allocation line are reversed when the journal entry for the allocation is posted.

    When the allocation transactions are journalized, you can select the specific date on which the transactions are auto-reversed. If you do not select a date, then the first day of the next period is used. See Journalizing actuals allocations.

    Allocate Year To Date
    Select this check box to allocate period balances up to the current period.
    Allocate Life To Date
    Select this check box to allocate life to date balances up to the current period.
    Allocate Units
    Select this check box to allocate units.
    Process Posting Dimension Balances
    Use this field if the address fields for summary source are specified and you are allocating posting level balances for summaries with large posting elements.

    If you select this field, then all dimensions are processed at the posting level. Balances are read from the GeneralLedgerTotal instead of the analytic cubes. Accounting strings are only processed if they are within the allocation structures and have balances.

    Do not select this field to process summary level balances. If this field is cleared, then the source accounting strings are generated and the balances of each source detail are retrieved from the analytic cubes.

    Allocate All Currency Amounts
    Select this check box to fully allocate each of the currency amounts.

    If this check box is cleared, then the transaction amounts are allocated and the other currency amounts are converted from the allocation transaction amount.

    Allow Negative Weights
    Select this check box to allow negative manual weights and to process credit balances as negative when weight percentages are calculated.
    Use Custom Group in Source Address
    Select this check box to show custom group fields for the dimensions in the Source Address section. If a custom group is specified for a dimension, then a posting or summary dimension cannot be selected.
  7. In the Source Address section, specify this information:
    Ledger
    Specify the source ledger for the allocated balances. The default value is the ledger that is specified in the allocation.
    Source System Code
    Optionally, specify the source system code for the allocation line to override the allocation source system code setting for this allocation line. Only balances that are created from the specified source system are allocated. This field must be blank to allocate balances from all system codes.
  8. In the Source Address section, specify the origin of funds to allocate. Select a value for each of the dimensions. The elements displayed are based on the structures assigned in the Structures tab. The structures provide the hierarchical user interface to select a posting, summary, or node value as a source. Update the Structures tab as necessary. You can specify an existing posting, summary, or node value. Specify this information:
    Process Posting Balances
    This check box is applicable only if a dimension is a summary or a node. This value is ignored if a dimension is a posting element.

    If the dimension is a summary, then select this check box to process source balances for each posting dimension in the selected summary. If the Use Posting Dimensions in Compute check box is selected, then the posting dimensions can be used in a weight compute statement to retrieve weight data.

    If the dimension is a node, then select this check box to process source balances for each of the posting elements. Blank values under the node are included based on the allocation line structures.

    Clear this check box to process source balances at the specified summary or top level node element based on the allocation line structures.

    A node level element is specified when a node is selected or specified. A node level element is specified when the value for the dimension is blank and the Treat blank Dimension as empty check box is cleared.
    Note: The Dimension name in the Treat blank <dimension> as empty field is changed based on the user dimensions that are specified in the enterprise group setup.
    Treat blank Dimension as empty
    This check box only applies to non-required dimensions. Select the check box to only allocate balances for entries where the value for the dimension is blank or empty. Clear the check box to allocate all balances within the assigned structure. This includes balances where the value for the dimension is blank.
  9. Click Save.
  10. Continue with the setup based on the selected posting options.