Defining Distribution Criteria In Allocation Templates

The distribution criteria in allocation templates is derived from the rule or basis selected when creating the allocation template.

In case of fixed templates, If no allocation rule is selected, you can define the distribution criteria manually.

To do so for fixed allocation templates:

  1. Open a fixed template record and click the Distribution Criteria tab.
  2. In the Company field, search for select the company you want to allocate to.
  3. In the General Ledger Account field, search for the GLA you want to enter.
  4. In the Dimension 1-4 fields, search for the required dimensions.
  5. In the Allocation (%) field, enter the percentage you want to allocate.
  6. Click Save. The distribution criteria is defined.

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:
  • To spread the allocation percentage equally across the lines, click Spread Evenly.
  • If no rule is selected while creating a fixed template and the Allow Use of Local GLAs custom setting in the Accounting Settings is enabled, in the Distribution 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 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 a rule is not selected to create a template and you use a local company in the distribution criteria manually in one line, when you add new lines in the distribution criteria, the Company field for all the lines is automatically populated with the same company. You cannot edit the local company in the distribution criteria manually. To edit it, you must delete all the lines.
    • 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.
  • Last unsaved changes in the Distribution Criteria tab are recorded and retained when using the same browser on the same computer.

For statistical allocation templates:

In the case of statistical templates, it is mandatory to select either an allocation rule or basis when creating the template. The lines are derived from that rule or basis to reflect in the Distribution Criteria grid of the template. You cannot add lines to the grid manually.

If you select an allocation basis while creating a statistical template, In the Distribution Criteria grid, you can select the distribution fields that you want to display in that grid by clicking Select Distribution Fields. You can also add filters to refine the grid by clicking .

For more information on selecting distribution fields and updating filters, seeDefining Allocation Rule Criteria.

Notes:
  • If a rule or basis is selected for the template and that rule or basis does not have values in a column, that column is not displayed in the distribution criteria of the template.
  • The Distribution Criteria grid is read only when it is derived from a selected allocation rule or basis. To make any changes in the criteria, edit the criteria in the selected allocation rule or basis. That change will be reflected in the distribution criteria of the template.

Managing Output General Ledger Accounts

The output general ledger accounts are retrieved when running allocations. In statistical allocation templates, these general ledger accounts are retrieved according to the option selected in the Manage Output GLA window.

To manage output general ledger account (GLA):

  1. Click Manage Output GLA in the Distribution Criteria tab. The Manage Output GLA window appears.
  2. Select any one of the following options:
    1. Copy from Basis or Rule: If selected, the output general ledger accounts are copied from the selected rule or basis.
    2. Copy from Source: If selected, the output general ledger accounts are copied from the transaction lines according to the source criteria defined.
    3. Select General Ledger Accounts: If selected, the General Ledger Accounts field is visible below this option. Search for and select one or more general ledger accounts. These general ledger accounts (GLAs) are used in the distribution criteria grid.
  3. Click Save. The distribution criteria is saved.

The visibility of the output GLA options in the Manage Output GLA window depends on the following factors:

Template State Options Visible
Template is created with rule or basis having no GLA in the General Ledger Accounts field.
  • Copy from Source (selected)
  • Select General Ledger Accounts
Template is created with a rule or basis having General Ledger Account field or both Company and General Ledger Account fields.
  • Copy from Basis or Rule (selected)
  • Select General Ledger Accounts
Template is created with a rule or a basis having General Ledger Account or both General Ledger Account and Dimension fields.
  • Copy from Basis or Rule (selected)
  • Copy from Source
  • Select General Ledger Accounts
Template is created with rule that does not have the General Ledger Account field selected as the distribution field on the rule.
  • Copy from Source (selected)
  • Select General Ledger Accounts
Template has the Allocate to Multiple Companies checkbox selected and the Distribution Criteria grid has only Company and General Ledger Account field, and no Dimension 1-4 fields.
  • Copy from Basis or Rule (selected)
  • Copy from Source
  • Select General Ledger Accounts