In this article
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
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: 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: 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 % |
100 | 50% |
200 | 20% |
300 | 30% |
On a Journal page, you create the following transaction for entity 000:
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 | 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 % |
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 | 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 | 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:
- From the MEM Entity Allocations list.
- Select New to open the MEM Entity Allocation page.
- In the General FastTab, specify a unique Allocation Template ID and specify a Description for the template.
- Mark if it’s IC Trade Allocation templates.
If marked:
- In the Allocation Templates Lines FastTab, for each line you want to add, do the following:
- Select the Entity Code.
- Select Type as needed.
- Select No. as needed.
- Specify the Allocation %.
- 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:
- If needed, select up to three other Allocation Dimensions.
- Mark if it’s IC Trade Allocation templates. If Marked:
- In the Allocation Templates Lines FastTab, for each line you want to add, do the following:
- Select the Entity Code.
- Select line type as needed.
- Edit the three Allocation Dimension Values as needed.
- specify the Allocation %.
- 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.
- To delete a line, select the line and select Manage > Delete Line.
- When you are asked to confirm the action, select Yes.
- 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:
- In the MEM Entity Allocations list, select the line you want to delete.
- Select Manage > Delete.
- 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:
- Open the MEM Entity Allocations list and select the template you want to copy.
- Select Actions > Copy Template.
- 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: 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). |