Creating compute and bypass source balance

  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 with Compute and Bypass Source Balance in the From Post Option field or the To Post Option field.
  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, click the Compute button.
  9. Specify this information:
    Field Name
    Specify a field name. The name must begin with an upper case character and cannot contain spaces.
    Default Label
    Specify default text for the field. To add translated labels, click the globe icon and define local translations.
    Field Type
    Select the field type.
    Size
    Optionally, specify the field size.
    Decimals
    Optionally, specify the number of decimals for the field.
    Definition
    Create the compute statement for the allocation calculation.

    This list shows the tools and shortcuts that are available:

    • Add fields from the list
    • Select operators to insert into the compute statement
    • Reference a custom total to read business totals from the GeneralLedgerTotal business class for the calculation.

      See Custom totals.

    • Select built-in functions for working with dates, fields, and one-to-many fields. The 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 processing 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 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.

  10. On the Parameters tab, select the Allocation Currency When Source Balance Is Bypassed field.
  11. Select the transaction currency to use. The transaction currency must match the currency of the computed value.
  12. Click Save.
  13. Return to the allocation line.
  14. On the allocation line, assign the custom compute statement.