Defining Allocation Rule Criteria

This topic relates to defining allocation rule criteria in Lightning.

Fixed Rule Criteria

To define the rule criteria:

1. Navigate to the Rule Criteria tab of the fixed rule for which you want to define the criteria.
2. [Optional] In the Company field, enter the company name.
3. In the General Ledger Account field, search for and select the GLA.
4. [Optional] In the Dimension 1-4, search for and select the valid dimensions. If you have selected Include Disabled Dimensions, disabled dimensions will also get listed in the drop-down list.
5. In the Allocation (%) field, enter a value in percentage and click Save.
6. Click in the toolbar to add a new line and follow the steps from 2 to 5.

The fixed allocation rule can be saved only when one of the following takes place:

• No company is mentioned in any of the lines.
• All lines have the same company with a local chart of accounts and local GLA, provided that the Local Chart of Accounts feature is enabled in the organization.
• All lines have a company non local chart of accounts and non local or corporate GLA.

Adding Lines

To add lines:

1. Click in the grid toolbar.
2. Enter the values in the fields as above, and click Save.

Cloning Lines

To clone the existing line:

1. Select the line that you want to clone.
2. Click in the grid toolbar and click Save.

Deleting Lines

To delete the existing line:

1. Select the line that you want to delete.
2. Click . In the confirmation message window click Delete.
3. Click Save. The selected line is deleted.

Notes:

• The sum of values in the Allocation (%) field must always be 100.

• If you select or deselect Include Disabled Dimensions in the Details tab, after saving, refresh the page to see the updated behavior of the Dimension fields.

• When the Allow Use of Local GLAs custom setting in Accounting Settings is enabled, in the Rule Criteria tab:

  • If no company is specified for a line in the Company column, the General Ledger Account column allows you to search for and select GLAs with the Chart of Accounts field as blank or with the value “Corporate”.
  • If a company with a local chart of accounts assigned is specified, the General Ledger Account column allows you to search for and select GLAs from the local chart of accounts for that company only.
  • If you assign a local company in a line and save the rule, when you add another line to the grid, that line will automatically display that local company and you cannot edit it.
  • If you select local GLA, ensure that the company is specified, it has local chart of accounts, and the specified local GLA is associated with that specific chart of accounts.
• When you click Activate after defining the rule criteria, the Active checkbox is automatically displayed as selected on the Rule Criteria page.
• Last unsaved changes are recorded and retained when using the same browser on the same computer.

To spread the allocation percentage evenly across the lines, click Spread Evenly and then click Save. Allocation percentage is equally spread across all the lines.

Notes:

• After saving, If you add more lines and click Spread Evenly again, the calculation overrides the value that is already saved in the Allocation (%) column. The existing value is discarded and replaced with the new one.
• You must add at least one line to to the allocation rule criteria to use the Spread Evenly action.

Statistical Rule Criteria

To define the rule criteria:

1. Navigate to the Rule Criteria tab of the statistical rule for which you want to define the criteria.
2. The Rule Criteria grid derives and displays the columns and values from the allocation basis that you selected while creating the rule. This grid is read only.
3. [Optional] To select the fields that you want to view in the grid, click Select Distribution Fields. The Select Distribution Fields window displays. It only displays those fields that are available in the selected allocation basis.
4. Select the fields that you want to display in the grid and click Save.
5. Click Save in the grid toolbar. The grid displays the selected fields only.

Notes:

• The sum of the values in the Value column are displayed in the Total field at the bottom of the column.
• The Allocation (%) column automatically calculates the percentage of the value displayed for the line.

To filter the grid:

1. Click in the toolbar. The Filters panel is displayed.
2. Click Add Filter and a pop-up window opens.
3. Select the field from the drop-down list.
4. Select the operator in the Operator field.
5. Mention the value in the Value field and click Done. The filter is displayed on the Filters panel.
6. Click Save and the grid is refined accordingly.

Notes:

• The values in both the Total fields are updated if there are any changes in the sum of values when the filters are applied.
• If you deselect any distribution field in the Select Distribution Fields window that is used as a filter in the
• Filters panel, it is removed from the Filters panel also.

Once the allocation rule criteria is defined, you can activate it by clicking Activate.

If you want to deactivate the rule, click Deactivate.

To create an allocation template from the rule page:

1. Click Create Allocation Template on the allocation rule record page. The Create Allocation Template window appears.
2. The Template Record Type and Rule Name fields are derived from the allocation rule. These fields are read only.
3. Enter the details in the remaining fields. For more information, see Creating Allocation Templates.

Notes:

• The Create Allocation Template button is visible only when the rule is activated.
• Ensure that all the changes made to the rule are saved before creating the template.