Creating budget allocation lines
Use the allocation line to define the allocation calculation rules. This list shows examples of rules:
- The processing order
- The allocated balances
- The method by which balances are allocated
- Select Processing > Allocations > Allocation Control.
- On the Budget tab, open an allocation control record.
- On the Allocations tab, open an allocation record.
- On the LinesCreate.
-
Specify this information:
- Allocation Line
- Specify the name and description of the allocation line.
- Step
- Specify a step number for the allocation
line if it is different from the default step.
Step values are used when a subsequent allocation depends on the results of a previous allocation. For example, if this calculation depends on other allocation calculations, then identify whether this allocation should be calculated first. Otherwise, it is calculated after initial allocations are calculated.
-
On the Parameters tab, specify this
information:
- From Post Option
- This field is used to calculate the Post From budget allocation transactions.
Valid values are Retain,
Consolidate,
Split, Compute and
Compute and Bypass Source
Balance.
For additional setup for the from and to post options, see Valid combinations of To and From posting options.
- To Post Option
- This field is used to calculate the Post To budget allocation
transactions. Valid values are Retain,
Consolidate,
Split, Compute and
Compute and Bypass Source
Balance.
For additional setup for the from and to post options, see Valid combinations of To and From posting options.
- Source Percentage
- Specify a percentage of the budget to allocate. The default value is 100.
- Allocate Units
- Select this check box to allocate units.
- Allow Negative Weights
- Select this check box to allow negative manual weights and to process credit balances as negative when weight percentages are calculated.
- Use Custom Group in Source Address
- Select this check box to select a custom group for the accounting entity instead of a single accounting entity in the source address. When this field is selected, the Accounting Entity Custom Group field is displayed in the Source Address section. If you select a custom group for the accounting entity, then you cannot select a single accounting entity.
- Minimum Transaction Amount for Split
- Specify a value to calculate the minimum transaction amount
during an allocation run. You can specify a minimum transaction
amount if the From Post
Option field or the To Post Option is Split. For
example, if the minimum transaction amount is 100, then individual
transactions that are less than 100 are not generated. Instead, they
are allocated to the last generated transaction.
This field must be blank to create transactions for any calculated transaction amount.
- Overthrown Amount Option
- Select Default From Allocation to
inherit the overthrown amount option setting of the allocation.
Select Last Transaction or Last
Highest Weight to override the value of the
allocation.
- If Last Transaction is selected, then the overthrown amount is allocated to the last generated transaction of the allocation.
- If Last Highest Weight is selected,
then the overthrown amount is allocated to the override with
the last highest weight.
This setting is applied to the allocation line when a minimum transaction amount for split is specified.
-
In the Source Address section, specify the origin of funds to allocate by
selecting a value for each of the dimensions.
The available dimensions depend on the budget scenario dimensions. If a required or optional dimension is not enabled in the budget scenario, then the dimension is treated as not enabled in the Finance Enterprise Group.
The dimension value selections that are displayed are based on the structures that are assigned in the Structures tab. By default, the budget basis structures are assigned in the Structures tab, but you can specify an alternate structure. You can specify a posting, summary, or node value.
-
Specify this information:
- Ledger
- Select a ledger of the budget to allocate. The default is the Core ledger.
- Process Posting Balances
- This check box is applicable only if a
dimension is a summary or a node. This value is ignored if a
dimension is a posting element.
If the dimension is a summary, then select this check box to process source balances for each posting dimension in the selected summary. If the Use Posting Dimensions in Compute check box is selected, then the posting dimensions can be used in a weight compute statement to retrieve weight data.
If the dimension is a node, then select this check box to process source balances for each of the posting elements. Blank values under the node are included based on the allocation line structures.
Clear this check box to process source balances at the specified summary or top level node element based on the allocation line structures.
A node level element is defined when a node is selected or when the value for the dimension is blank. The Treat blank <Dimension> as empty check box must be cleared.
Note: The Dimension name in the Treat blank <dimension> as empty field is changed based on the user dimensions that are specified in the enterprise group setup. - Treat blank Dimension as empty
- This check box only applies to non-required dimensions. Select the check box to only allocate balances for entries where the value for the dimension is blank or empty. Clear the check box to allocate all balances within the assigned structure. This includes balances where the value for the dimension is blank.
- Click Save.
- Continue with the setup based on the selected posting options.