Allocation Rule Fields

The Allocation Rule object includes the following fields.

Header Details

Key: * – Mandatory field; F – Fixed allocation only; S – Statistical allocation only; L - Lightning only; The number indicates the number of characters that are allowed in this text field, where appropriate.

Field  

 

Description
Active    

Enable this checkbox if you want to use this rule for allocations. You can only make a rule active when you have allocated 100% of the source data.

Note:

In Lightning, this field cannot be updated manually. To update the status of this checkbox, click Activate or Deactivate on the allocation rule record page.

Allocation Basis * S, L  

Sets of saved allocation bases values. These are created from the Allocation Bases tab. Alternatively, click to enter a custom set of statistical values for this allocation rule.

Note:

In Lightning, you can select an already created allocation basis from the picklist.

Allocation Type *  

The type of allocation you want to use this rule for.

Note:

In Lightning, this field is Record Type.

Company * F, L  

The company this allocation rule is for. This field is only available if local GLAsClosed A general ledger account that is used in local statutory reporting. You can only use local GLAs in allocations if you are in single-company mode. are enabled in your org and is only mandatory if you are selecting local GLAs from the distribution grid. See What is a Chart of Accounts Structure? for more information on local GLAs.

When you select a company, only those local GLAs that belong to the local chart of accounts structure set on that company are available from the distribution grid. If you do not select a company, only corporate GLAs are available.

You cannot change the company if you have already created lines in the distribution grid for that company. You must delete the lines before you can change the company.

Note:

In Lightning, the company is used at the line level only.

Distribution Fields * S   The fields you want to calculate your allocation percentage or value on. You can select GLAs, dimensions, companies or a combination of all three. The contents of this field are derived from the selected allocation basis.
Include Disabled Dimensions L   When selected, the disabled dimensions are included in the drop-down list of the dimension fields in the Rule Criteria tab.
Allocation Basis * S, L  

Sets of saved statistical values. These are created from the Allocation Bases tab. Alternatively, click to enter a custom set of statistical values for this allocation rule.

Note:

In Lightning, you can select an already created allocation basis from the picklist.

Rule Description   255 Description of the allocation rule.
Rule Name * 80 Name of the allocation rule.
Total Fixed Allocation Percentage     The sum of all the values in the Allocation (%) field of all the lines.

Distribution or Rule Criteria Grid

In Sencha, for fixed allocation rules, to remove a row, click .

For statistical allocation rules, you must change the filters to change the contents of the distribution grid.

To find specific entries in the grid, type in the Search field.

To control which columns are visible in the grid, click the down arrow in a dimension column heading and select Columns. You can then add or remove the tick next to a column name.

To sort the contents of a column in the grid, click the column heading to switch between an ascending and a descending sort order on that column.

In Lightning, these fields are available in the Rule Criteria grid. To understand how to use the grid, hover over in the grid toolbar.

Key: * – Mandatory field; F - Fixed allocation only; S - Statistical allocation only; L - Lightning only

Field   Description
Allocation (%) L * The percentage you want to allocate to each GLA and dimension, up to four decimal places.
Company   The companies to which the allocation is distributed.
Dimension 1-4 *

The dimensions you want to allocate to. Some of these may have been hidden by your administrator. You must enter a value in at least one of the Dimension columns. To auto populate the grid with all available dimension values, click the down arrow in each Dimension column heading and select Populate All. The dimensions are listed on separate rows in the grid.

Note:

In Lightning, dimension fields are not mandatory.

General Ledger Account   The corporate GLAs you want to allocate to. In Lightning, for fixed allocation rules, this field is mandatory, and you can assign local GLAs also. For more information, see Defining Allocation Rule Criteria
Local GLA F

The local GLAsClosed A general ledger account that is used in local statutory reporting. You can only use local GLAs in allocations if you are in single-company mode. you want to allocate to.

This column is only available if you have selected a company that has a local chart of accounts structure in the header details. You can only select local GLAs that belong to the local chart of accounts structure set on the selected company.

Note:

This field is visible in Sencha only.

Percentage (%) *

The percentage you want to allocate to each GLA and dimension, up to four decimal places. To split the allocation equally between the GLAs and dimensions listed in the grid, click the down arrow in the Percentage (%) column heading and select Spread Evenly.

Note:

This field is visible in Sencha only.

Value * S

The amount you want to allocate to each GLA and dimension.

Statistical Allocation Rule Filters

To remove a row, click .

For each field, the operator and value are mandatory.

Field Description
Field Field you want to use to set filter criteria. The fields available are derived from Distribution Fields.
Operator Mathematical or logical operation used on the filter.
Value Value for the filter.

Buttons

Key: S - Statistical allocation rule only; F - Fixed rule only; L - Lightning only

Button   Description
Activate L Activates the allocation rule to be used in allocation templates.
Allocation Rules List   Returns you to the list of allocation rules.
Cancel   Cancels without saving.
Deactivate L Deactivates the allocation rule.
Delete   Deletes the currently displayed allocation rule.
Duplicate L Duplicates the allocation rule along with its lines.
Edit   Enables you to edit the currently displayed allocation rule.
Select Distribution Fields L Displays the Criteria grid fields to select from and display the selected fields on the grid.
Save   Saves the current allocation rule. If this button is not displayed, click Edit.
Spread Evenly F, L Spreads the allocation equally between all the allocation lines.
S Creates a custom statistical basis for use with this allocation rule, instead of using an existing statistical basis.
S Enables you to edit the selected statistical basis.
  Opens the related Accounting Help topic.
  Maximizes or restores the page in your browser window.
L Adds lines to the Rule Criteria grid.
L Clones the selected lines.
L Deletes the selected lines.

Proportional and Statistical Allocation Rule Filter Buttons

Key: L - Lightning only

Button   Description
Add Filter L Adds the filter criteria to the rule.
Cancel L Cancels the applied changes.
Clear All   Clears the filter criteria currently set on this allocation rule.
Hide Filter/Show Filter   Displays or hides your filter criteria.
Preview   Retrieves your data based on the selected set of proportional or statistical values, distribution fields and filters and displays it in the Distribution grid.
Remove All L Removes the applied filter criteria.
Save L Saves the filter criteria.