Entering MassAllocation Formula Lines
All MassAllocation formulas use the following equation to determine allocation amounts:
COST POOL * (USAGE FACTOR / TOTAL USAGE)
General Ledger uses the following format to represent the equation. Each factor in this equation relates to a separate formula line.
A * B / C
You can enter any combination of fixed amounts and accounts in formula lines A, B, or C.
To enter an account in a MassAllocation formula line:
1. Enter the account for the A, B, or C line of your formula. Enter accounts with parent segment values to create a formula that references accounts with the corresponding child segment values.
When you enter an account, General Ledger ensures that segment values are valid and enabled.
2. Assign a segment Type for each account segment. The combination of parent/child segment values and types tells General Ledger which related accounts are affected or used by that portion of the formula.
You can assign one the following segment types to each segment:
Looping (L): Assign this type to a parent segment value to include each child value assigned to the parent value in the formula. The allocation program runs each formula once for each corresponding child segment value. You can loop only on parent values.
Summing (S): Assign this type to a parent segment value to sum the account balances of all the child segment values assigned to a parent. For example, if you enter a parent that has five child values, the allocation program adds the account balances of the five child accounts and uses the sum in each MassAllocation formula. You can sum only on parent values.
Constant (C): Assign this type to a child segment value to use the detail account balance associated with the child. You can use this type with a parent segment value only if there is a summary account associated with the parent.
Note: To use summary accounts in a mass allocation formula, all segments in the formula must be assigned a segment type of Constant.
3. Enter the Amount Type you want to use:
If you have average balance processing enabled, you can also select from the following values, however, your Balance Type must be Actual:
Note: You can mix standard and average amount types in the same MassAllocation formula.
4. Enter the Relative Period for the account balance you want to use:
5. Enter the account Balance Type to use for the formula line. If you enter the Budget balance type, you must also enter a Budget name. If you enter the Encumbrance balance type, you must also enter an Encumbrance Type.
6. Once you have entered your A, B, and C formula lines, enter the Target and Offset accounts.
See Also
Defining Segment Values
Assigning Segment Types
Entering a Target Account
Entering an Offsetting Account
Validating MassAllocation and MassBudget Batches
Generating MassAllocation Journals