Allocation Fields

Retrieve Source Buttons

Retrieve Source Header

Key: * – Mandatory field; S – Single-company mode only; M – Multi-company mode only

Element		Description
Filters Applied		Shows the number of filter groups created.
From	S	Start date or period for the transactions you want to retrieve. If left blank, all the transactions up to the To date or period are retrieved.
N Value	S	Numerical value for soft dates Salesforce refers to soft dates as "relative date values". Accounting supports the following relative date values: Today, Tomorrow, Yesterday, Last "n" Days, Next "n" Days, This Week, Last Week, Next Week, This Year, Last Year, Next Year. See the Salesforce Help for details of how these relative date values are resolved. Note that Last "n" Days and Next "n" Days are ranges. For example if today is May 25 then Last 3 Days is from May 23 to May 25. A filter on transaction date of "< Last 3 days" would retrieve transactions dated prior to May 23. and soft periods.
Only Retrieve Intercompany Transactions	M	Indicates that you only want to retrieve transactions that are associated with an intercompany transfer Object used as a staging location for data used when transferring costs to other companies in the same organization..
Time Period	* S	The period or date range of the transactions that you want to retrieve. You can specify soft dates or soft periods if required. You cannot select the special periods 000 or 101.
To	* S	End date or period for the transactions you want to retrieve.
What do you want to allocate?	*	Picklist to select the source type.

Retrieve Source Filter Group

Key: * – Mandatory field; S – Single-company mode only; M – Multi-company mode only

Field		Description
Account		Multi-select list or range of available accounts In this context, accounts are organizations or people that you conduct business with, such as customers or vendors. Account is a standard Salesforce object. Certinia accounts can be any Account Record Type. you want to retrieve. If you have encryption switched on in your org, you must be as specific as possible when typing the account name to ensure that the account is found. See Shield Platform Encryption for more information.
Company	* M	List of available current companies. The companies you select for the allocation must all share the same dual currency.
Dimension 1-4		Dimensions Custom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you. you want to retrieve. If you want to exclude transactions that have dimensions, select "– No Dimension –". This will only retrieve transactions that have null in the corresponding field.
General Ledger Account		Multi-select list or range of available general ledger accounts The general ledger will normally include general ledger accounts (GLAs) for items such as income, expenses, assets, liabilities, and reserves..
Local GLA	S	Multi-select list or range of available local general ledger accounts 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.. Note: Only available if local GLAs are enabled in your org and you are creating a fixed allocation.
Period - From	M	For the selected company, multi-select list or range of available periods. Enables you to specify the period or periods of the transactions you want to retrieve. You cannot select the special periods 000 or 101.
To	* M	For the selected company, end of the time period for the transactions you want to retrieve.

Element	Description
Clear Group	Clears all the fields in a filter group. To delete a filter group, click the cross icon at the top of the group.
	Changes the mode of the adjacent filter field between Multi-select and selecting a From-To range.

Retrieve Source Summary Lines

Retrieve Source Transaction Line Items

The individual transaction line items are displayed when you expand a summary line on the Retrieve Source page.

Key: S – Single-company mode only; M – Multi-company mode only

Element		Description
Document Currency		Displays the associated document currency The currency in which values are entered on a document..
Description		Description on the originating document line items.
Document Number		Number on the originating document.
Document Value		Total value of the line, in document currency The currency in which values are entered on a document..
Dual Value	M	Amount in dual currency The currency in which your corporate headquarters reports financial statements. This defaults to, and is normally the same as, the corporate currency..
Home Value	S	Amount in home currency The main working currency of the current company..
Transaction Line Item Number		Unique numeric identifier for the originating transaction line item, with a lookup to the related transaction line item.
Transaction Number		Number of the associated transaction, with a lookup to the related transaction.

Proportional Basis Configuration Header

Proportional Basis Configuration Filter Buttons

Proportional Basis Configuration Grid

Statistical Basis Configuration Header

Field	Description
Allocation Rule	The allocation rule Stores distribution criteria for reuse and helps speed up the process of splitting costs and revenue from selected GLAs and dimensions, and allocating them to other GLAs and dimensions. Fixed allocation rules use set percentages or amounts as the basis for an allocation. Statistical allocation rules use sets of values that may vary as the basis for an allocation. you want to use. Alternatively, you can specify your distribution criteria manually by selecting a statistical basis A saved set of variable values that are used to calculate the distribution of an allocation, such as employee headcount. When you update the values set on an existing statistical basis, the previous version is saved and the new version used in all subsequent allocations that use that statistical basis., selecting distribution fields and creating appropriate filters.
Distribution Fields	The distribution fields available are taken from the statistical basis you have selected and are the fields you want to base your allocation percentage on. These fields form part of your overall distribution.
Filters Applied	Shows the number of filters created and applied to the data in the grid.
Statistical Basis	The set of saved statistical values you want to use for this allocation, created from the Statistical Bases tab. To view details of the selected statistical basis, click . Alternatively, click to enter custom statistical values that you can save as a new statistical basis.

Statistical Basis Configuration Buttons

Button	Description
	Enables you to: Save the details you have entered as a new allocation rule. Update the selected allocation rule. Change the rule name of a selected rule to save any changes as a new rule.
	Create a custom statistical basis to use with this allocation.
	View details of the selected statistical basis.

Statistical Basis Configuration Filter Buttons

Statistical Basis Configuration Filters

To remove a row, click .

For each field, the operator and value are mandatory.

Statistical Basis Configuration Grid

Key: * – Mandatory field; M – Multi-company mode only

Fixed Distribution Fields

Field

Description

Allocation Rule

The allocation rule Stores distribution criteria for reuse and helps speed up the process of splitting costs and revenue from selected GLAs and dimensions, and allocating them to other GLAs and dimensions. Fixed allocation rules use set percentages or amounts as the basis for an allocation. Statistical allocation rules use sets of values that may vary as the basis for an allocation. you want to use. If you are using local GLAs 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. in this allocation, only active rules that have the current company set on them will be available for selection. If you do not want to use an allocation rule, you can use the grid to specify your distribution criteria manually.

Fixed Distribution Buttons

Button	Description
	Enables you to: Save the distribution details you have entered as a new allocation rule. Update the selected allocation rule. Change the rule name of a selected rule to save any changes as a new rule.

Fixed Distribution Summary

Fixed Distribution Grid

Key: * – Mandatory field

Statistical Distribution Fields

Statistical Distribution Grid

Fields

Key: * – Mandatory field; M – Multi-company mode only

Preview Grid

Key: F – Fixed allocations only

Element		Description
Credit		Indicates a credit is to be posted.
Debit		Indicates a debit is to be posted.
Dimension 1-4		Dimension the line is posting to.
General Ledger Account		Corporate GLA the line is posting to.
Local GLA	F	Local GLA 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. the line is posting to.
Total Credits		Sum of all credits in the allocation summary.
Total Debits		Sum of all debits in the allocation summary.