Allocation Formula Rules



Use the following definition rules when creating your allocation formulas. The allocation validation program checks that your formulas adhere to these rules.

For formula lines A, B and C (operand lines):
• You can enter either an amount or an account in lines A, B and C.
• If you enter an account, child values must have a Constant segment type.
• Parent values may have a Constant, Looping or Summing segment type.
• You can use a Constant segment type with a parent value only if it references a summary account.
• If you use a Looping segment type on the same segment in more than one of the operand lines, you must use the same parent.
• If you use a Looping segment type in your Target line, you must use a Looping segment type on the same segment using the same parent in lines A, B or C.
• To use summary accounts, all segments in your formula must be assigned a segment type of Constant.

For target and offset lines (lines T and O)
• You must enter an account in the Target and Offset lines.
• Detail values must have a Constant segment type.
• Parent values must have a Looping segment type.
• Your Target account must be different from your Offset account.

Validation Business Rules
If you choose to use Full Cost Pool Allocation, below are the business rules used to validate your Allocation Formula Rules for lines A, B, and C. If your full cost pool allocation contains violations of the business rules, the execution report will detail the errors.
1. Line A is account or constant based.
2. Line B is account based.
3. Line B has at least one looping segment.
4. Line C is account based and has the same segment values as line B.
5. Line C uses Constant or Summing segment type if line B uses Constant or Summing segment type.
6. At least one Summing or Constant segment in line C corresponds to a looping segment in line B.

Mass Allocation Validation Business Rules

When Line C uses the Looping Segment? I only can think of Summing or Constant segment in line C.