Setting up multiple overrides in an allocation line

Use this procedure for both actuals and budget allocation lines.

  • If the From Post Option is set to Split, then specify the fields in the Multiple Overrides section of the From Mapping tab to specify a dimension. Specify the accounting strings to which the source amounts are being split and the weight value for the split.
  • If the To Post Option field is Split, then specify the fields in the Multiple Overrides section of the To Mapping tab to specify a dimension. Specify the accounting strings to which the source amounts are being split to and the weight value for the split.
  1. Select Processing > Allocations > Allocation Control.
  2. On the Actuals tab or on the Budget tab, open an allocation control record.
  3. On the Allocations tab, open an allocation.
  4. On the Lines tab, open an allocation line.
  5. Select the From Mapping or To Mapping tab to set up multiple overrides.
  6. In the Multiple Override section, specify this information:
    Override Option
    Select One Dimension to split the amount into multiple elements for only a single dimension. The value of the other dimensions in the allocation transaction is from the single override or from the source detail.
    Select Two Dimensions to split the amount into multiple elements for two dimensions. The value of the other dimensions in the allocation transaction is from the single override or from the source detail.
    Select Multiple Dimensions to split the amount to multiple unique accounting strings. You can allocate amounts to multiple accounts and different accounting units or projects.
  7. If the Override Option is One Dimension, then follow these steps:
    1. Specify a value in the One Dimension Override field. For example, to allocate expenses to multiple posting accounts, select Account for the One Dimension Override field. In the allocation transaction, the value of the other dimensions is from the single override or the source detail.
    2. Click Save.
    3. Select one of these options to specify the list of posting elements to which to allocate the source amount:
      • Select Add Manual Overrides to manually specify the list of posting elements and the weight value associated to a posting element.
      • In the Summary Override field, select a parent or summary value to allocate the amount to all active posting elements under the summary.
      • In the Group Override field, select a custom group to determine the list of posting elements. Only active elements are included.

        See Creating custom group overrides.

    4. Click Save.
    5. If Summary Override or Group Override is selected, then specify a Summary/Group Weight Compute.

      The amount or unit balances are dynamically retrieved by the compute statement and assigned as a weight value for each posting element in the override. The compute statement must reference a custom total to get the balances.

      If a compute statement is not assigned, then amounts are allocated equally among the posting elements.

      See Allocation line weight compute setup
    6. If the compute statement is set up to retrieve weight values for the posting dimensions in a source address, select the Use Posting Dimensions in Compute check box.
      The dimensions in the source address with the Process Posting Balances check box selected are available and can be selected to be used by the compute statement.
    7. Click Save.
  8. If the Override Option is Two Dimensions, then follow these steps:
    1. Specify a value in the One Dimension Override field and the Two Dimension Override field. For example, to allocate expenses to each posting element of the Project and the Fund dimensions, select Project and Fund. In the allocation transaction, the value of the other dimensions is from the single override or the source detail.
    2. Click Save.
    3. In the Summary <One Dimension> Override field, select a parent or summary value to allocate the amount to all active posting elements under the summary.
    4. In the Summary <Two Dimension> Override field, select a parent or summary value to allocate the amount to all active posting elements under the summary.
    5. Click Save.
    6. Specify a Summary/Group Weight Compute.

      The amount or unit balances are dynamically retrieved by the compute statement and assigned as a weight value for each posting element in the override. The compute statement must reference a custom total to get the balances.

      If a compute statement is not assigned, then amounts are allocated equally among the posting elements.

      See Allocation line weight compute setup
    7. If the compute statement is set up to retrieve weight values for the posting dimensions in a source address, select the Use Posting Dimensions in Compute check box.
      The dimensions in the source address with the Process Posting Balances check box selected are available and can be selected to be used by the compute statement.
    8. Click Save.
  9. If the Override Option is Multiple Dimensions, then follow these steps:
    1. Click Save.
    2. In the Override Type field, select one of these options:
      • Select Manual Override to manually specify the list of overrides to which to allocate the source amount.
      • Select Group Override List to use a predefined list of overrides to which to allocate the source amount. Weight values are assigned to each override through the compute statements.
    3. Click Save.
    4. If the Override Type is Manual Override, then click Add Manual Overrides to define the list of accounting strings to which to allocate. You can manually specify the weight values or assign a weight compute.
    5. If the Override Type is Group Override List, then specify a value for Line Override Group List to use a predefined list of accounting strings to which to allocate.
      See Creating line override groups.
    6. Specify the Manual Override Weight Compute or the Group Override Weight Compute.
      The amount or unit balances are dynamically retrieved by the compute statement and assigned as a weight value for each posting element in the override. The compute statement must reference a custom total to get the balances.
      If a compute statement is not assigned, then amounts are allocated based on the manual weight or equally among the overrides.
      See Allocation line weight compute setup
    7. If the compute statement is set up to retrieve weight values for the posting dimensions in a source address, select the Use Posting Dimensions in Compute check box.
      The dimensions in the source address with the Process Posting Balances check box selected are available and can be selected to be used by the compute statement.
    8. Click Save.