Creating allocation line source compute statements

  1. Select Processing > Allocations > Allocation Control.
  2. On the Actuals tab or the Budget tab, open an allocation control record.
  3. On the Allocations tab, open an allocation record.
  4. On the Lines tab, open an allocation line that has the From Post Option or the To Post Option set to Compute.
  5. On the Parameters tab, select Compute.
  6. Click Create.
  7. Specify this information:
    Custom Compute
    Specify the name of the custom compute statement.
    Description
    Specify a description for the compute statement.
    Effective Date
    Specify the date the compute statement goes into effect.
    Business Class
    The allocation line compute statement is specified in the AllocationLine business class.
  8. On the Editor tab, select Compute. Specify this information:
    Field Name
    Specify a field name. The field name cannot begin with a lowercase letter nor can it contain spaces.
    Default Label
    Specify the default label for the field. You can add translated labels by clicking the globe icon and defining local translations.
    Field Type, Size, Decimals
    Select the field type, and if applicable, specify the size and number of decimals.
    Definition
    Create the compute statement for the allocation calculation. Several tools and shortcuts are available.
    • You can add fields from the list by dragging them or double-clicking them.
    • You can select a set of operators to insert into the compute statement.
    • You can reference a custom total to read business totals from the GeneralLedgerTotal business class for use in the calculation. See Custom totals.
    • You can select built-in functions for working with dates, fields, and one-to-many fields.
    Any fields in the allocation line can be used in the allocation line compute statement. These variables can also be used in the allocation line compute statement:
    • Source: The generated detailed source of the specified source address. The detailed sources are the posting or summary combination of the source address that is based on the Process Posting Balances field.
    • CurrentValue: The source amount of the detailed source currently being referenced.
    • CurrentCurrency: The currency of the source amount of the detailed source currently being referenced.
    • AllocationPeriod: The allocation processsing and posting date.
    • From: The generated Post From transaction accounting string. This is the posting combination of the From Mapping dimensions after applying the override dimension.
    • To: The generated Post To transaction accounting string. This is the posting combination of the To Mapping dimensions after applying the override dimension.
    Example 1: This example shows a simple math computation.
    (CurrentValue * 2.33)
    Example 2: This example shows the use of the total function.
    (total(GeneralLedgerTotal."SALES", AccountingEntity=AccountingEntity, GeneralLedgerTotal.AccountingUnit=AccountingUnit, GeneralLedgerTotal.EntityYearPeriod=AllocationContext.Period).NetFunctionalAmount)

    See Custom totals.

    See Referencing custom totals in a compute statement.

  9. Click Save.
  10. Return to the allocation line and assign the custom compute statement.