MEM Entity Allocation

Use this page to set up entity allocation templates. Entity allocation templates are applied at the transaction level to allocate revenue or expenses to multiple entity accounts. The allocations are specified in percentages, where the total of all percentages must equal zero percent (0%) or have a sum less than or equal to 100%. If the template has a sum total less than 100%, the remainder is allocated to the entity assigned to the transaction.

You can create zero-allocation templates for multiple entities but leaving the percentage allocation amounts as 0%.

IC Trade Allocation: Specify whether this is an IC trade allocation template.

Allocation Method: Specify the allocation method of the template - Amount or Percentage.

Note icon. Note: Currently, entity allocation templates are available for the following inventory journals only: 

  • Physical Inventory Journals (Inventory Count)
  • Physical Inventory Order (New Inventory Count)
  • Item Journal (Adjustments + / - )
  • Item Reclassification Journal (Transfer between Locations)
  • Item Revaluation Journal

Also, for sales and purchasing transactions, allocation templates are available for line the following line types: items (service or non-inventory items) and G/L accounts .

Note icon. Note: You might require permission to access the setup pages and perform setup tasks. For assistance, contact your system administrator.

Basic Allocation Template

Review the following examples to better understand how entity allocation templates work.

Allocation template is 100%

The entity allocation TemplateA is setup as follows: 

Entity Code Allocation Table
Entity Code Allocation %
100 50%
200 20%
300 30%

On a Journal page, you create the following transaction for entity 000: 

Entity Code Allocation Table
Entity Code Account Debit Credit Allocation Template
000 11200 1000    
000 14300   1000 TemplateA

Based on entity allocation template TemplateA, the general journal distributions are updated as follows: 

Entity Code Allocation Table
Entity Code Account Debit Credit
000 11200 1000  
100 14300   500
200 14300   200
300 14300   300

Allocation template is less than 100%

The entity allocation TemplateB is setup as follows: 

Entity Code Allocation Table
Entity Code Allocation %
100 50%
200 20%

The percentages of this entity allocation template is less than 100%. The remaining 30% is allocated to the entity of the transaction (header level).

On a Journal page, you create the following transaction for entity 000: 

Entity Code Allocation Table
Entity Code Account Debit Credit Allocation Template
000 11200 1000    
000 14300   1000 TemplateB

Based on entity allocation template TemplateB, the general journal distributions are updated as follows: 

Entity Code Allocation Table
Entity Code Account Debit Credit
000 11200 1000  
000 14300   300
100 14300   500
200 14300   200

Because the template amount is less than 100%, the remaining amount is allocated to the entity in the header.

Template with Other Dimension Values

The following example shows how the dimension values are used in an entity allocation template. The entity allocation for a template is setup as follows: 

Entity Code Area Code Group Business Group Allocation %
ADM 10 A LARGE 5.00
PROD 20   SMALL 11.00
PROD 20 A   12.00
PROD 20     13.00
PROD   B   14.00
PROD     SMALL 30.00
SALES       15.00

For a receivables transaction, the General Ledger entries are as follows:  

Entity Code Customergroup Code Posting Date Document Type Document No. G/L Account No. Description Area Code Group Business Group Amount Bal. Account type Bal. Account No.
PROD   July 30, 2020   003 10400 Trey Research       100.00 G/L Account  
ADM LARGE July 30, 2020   003 10100 Trey Research 10 A LARGE -5.00 G/L Account  
ADM LARGE July 30, 2020   003 ADM-DUE FROM Due From PROD 10 A LARGE 5.00 G/L Account  
PROD   July 30, 2020   003 PROD-DUE TO Due To ADM       -5.00 G/L Account  
PROD SMALL July 30, 2020   003 10100 Checking Account 20   SMALL -11.00 G/L Account  
PROD   July 30, 2020   003 10100 Checking Account 20 A   -12.00 G/L Account  
PROD   July 30, 2020   003 10100 Checking Account 20     -13.00 G/L Account  
PROD   July 30, 2020   003 10100 Checking Account   B   -14.00 G/L Account  
PROD SMALL July 30, 2020   003 10100 Checking Account     SMALL -30.00 G/L Account  

 

IC Trade Allocation template

The following example show how line Type, account No, dimension value used in an IC Trade Allocation template. Once you marked IC Trade Allocation in the page, the allocation template become to IC Trade Allocation template. To set dimension information, go to Line -> dimensions. Line Type can be G/L account and Item. The inventory item doesn’t work with the IC Trade Allocation template.

Entity Code Type No. Allocation % DimSetID
100 G/L Account 60100 10 10
200 Item NON_INVENTORY 20 20

 

Create Template

To create an entity allocation template, follow these steps:

  1. From the MEM Entity Allocations list.
  2. Select New to open the MEM Entity Allocation page.
  3. In the General FastTab, specify a unique Allocation Template ID and specify a Description for the template.
  4. Mark if it’s IC Trade Allocation templates.

If marked:

  1. In the Allocation Templates Lines FastTab, for each line you want to add, do the following:
    1. Select the Entity Code.
    2. Select Type as needed.
    3. Select No. as needed.
    4. Specify the Allocation %.
    5. Specify the dimensions as needed. Select line you where you want to add dimension and select Line > Dimensions. It opens Edit Dimension Set Entries window, you can add dimension values here.

If unmarked:

  1. If needed, select up to three other Allocation Dimensions.
  2. Mark if it’s IC Trade Allocation templates. If Marked:
  3. In the Allocation Templates Lines FastTab, for each line you want to add, do the following: 
    1. Select the Entity Code.
    2. Select line type as needed.
    3. Edit the three Allocation Dimension Values as needed.
    4. specify the Allocation %.
  4. To add a line between existing lines, select the line where you want a new line and select Manage > New Line. The new line is added above the line you selected.
  5. To delete a line, select the line and select Manage > Delete Line.
    1. When you are asked to confirm the action, select Yes.
  6. To add another entity allocation template, select Create a new entry and repeat these steps.

Purchase and Sales Invoice Documents

For allocation templates used for Purchase Invoice and Sales Invoice documents, the entity codes for the allocation lines are not required for the Get Recurring Purchase Lines and Get Recurring Sales Lines actions to work with Multi-Entity Management.

Delete Template

To delete an entity allocation template, follow these steps: 

  1. In the MEM Entity Allocations list, select the line you want to delete.
  2. Select Manage > Delete.
  3. When you are asked to confirm the action, select Yes.

Copy Template

To create a copy of an existing entity allocation template, follow these steps:

  1. Open the MEM Entity Allocations list and select the template you want to copy.
  2. Select Actions > Copy Template.
  3. Specify the New Allocation Template ID, and select Actions > Copy Template

The newly copied template appears in the Entity Allocation list. You can select the entity allocation template and edit it as needed.

List Fields

This MEM Entity Allocations list contains the following fields: 

Field Description
Description Displays the description of the entity allocation template.
Template Name Displays the entity allocation template name.

Fields

This MEM Entity Allocation page contains the following fields: 

Field Description
General
Allocation Template ID

Specify a unique identifier for the entity allocation template. After you enter the identifier, you cannot change it.

Description

Specify a description for the entity allocation template.

Allocation Dimension 1, 2, 3 Select other dimensions that you want to use for the allocation. You can select up to three other dimensions for the allocation.
Allocation Template Lines
Entity Code

Select an entity. You can select only from the entities to which you have access.

Allocation Dimension Value 1, 2, 3 Select the other allocation dimension values as needed. The default values are from the header.
Allocation %

Specify the percentage to be allocated to the entity. The sum of all lines must be equal to 100%.

If you create a zero-allocation template, the sum of all lines must be zero. Editable only when allocation method is set to "Percentage".

Allocation Amount Specify the local currency amount to be allocated to the entity. Editable only when allocation method is set yo "Amount".
Footer  
Total Allocation % Display the total percentage of the template. It only shows when the Allocation Method is Percentage.
Dimension values The dimension value code fields will appear if the dimension been set as Shortcut Dimension in the General Ledger Setup.

Actions

This page contains the following actions: 

Button Description
List
Actions > Import Allocation Template

Allows you to select a file for importing existing allocation templates.

For file format information, see Entity Allocation Template.

Note icon. Note: The Import action is a hidden field, as of MEM version 1.1.102.0. For more information about accessing hidden fields, see Work with fields and columns.

Window
Actions > Copy Template Creates a copy of the entity allocation template.
Allocation Template Lines > Manage > Allocate Equally Specify in even percentages on each line in the template. User can also select lines to specified even percentage for selected lines. It’s only available for the Allocation Method Percentage.
Allocation Template Lines > Line > Dimension Allows users to enter allocation dimension(s).