Creating allocation line source compute statements
- Select Processing > Allocations > Allocation Control.
- On the Actuals tab or the Budget tab, open an allocation control record.
- On the Allocations tab, open an allocation record.
- On the Lines tab, open an allocation line that has the From Post Option or the To Post Option set to Compute.
- On the Parameters tab, select Compute.
- Click Create.
-
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.
-
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.
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.
(CurrentValue * 2.33)
total
function.(total(GeneralLedgerTotal."SALES", AccountingEntity=AccountingEntity, GeneralLedgerTotal.AccountingUnit=AccountingUnit, GeneralLedgerTotal.EntityYearPeriod=AllocationContext.Period).NetFunctionalAmount)
See Custom totals.
- Click Save.
- Return to the allocation line and assign the custom compute statement.