You can use filters to restrict the transactions that are selected for the source accounts. The filters can be used to only select transactions that reference particular analysis dimension codes, or other ledger transaction details. For example, if you only want to allocate transactions relating to Product A and product is identified in an analysis dimension.
All of the filter criteria must be met before a source transaction's value is included in the allocation source amount.

Tip: If you need to include more than three analysis dimensions in the selection criteria you should enter allocation source continuations.
Source Analysis Dimension 1-3
Up to three analysis dimensions, or other ledger transaction selection details, can be chosen here and used to select the source transactions. You can choose any of the analysis dimensions that have been assigned to ledger transactions, ledger accounts, or assets using Analysis Structure Setup (NS). In addition, you can choose any of the following ledger transaction details:

Selection From/To 1-3
For each of the three selection criteria chosen, you can enter a particular code, or a range of codes, to be used to select the source transactions. You may also use masking in these fields to select matching codes. For example, if you enter AB***, any five character code beginning with AB, for the appropriate analysis dimension, is considered valid.
Source Threshold From/To Debit/Credit
The threshold range identifies a range of source values. If this is entered, the total of the selected source transactions must fall within this range for the transactions to be used as the basis of an allocation. For example, you may only want to allocate head office costs if the total cost is over ё5000.
If the total of the source transactions is outside this range, the allocation is not performed. The Allocation Run report indicates the reason for the exclusion.

Note: If the To value is left blank, then zero is assumed. Therefore, if you want to identify a single source amount, rather than range, you must enter the amount in the From and To values.

Consolidation Tab
Click here to see a screenshot
Source Reversal
When a split type allocation is specified in Allocation Setup, transactions are generated to reverse the original source transactions and these are posted back to the source account. To reduce the number of transactions generated, you can choose to consolidate these reversal transactions according to some, or all, of the existing analysis codes on the transactions. If so, you must select the analysis dimensions for which you want to consolidate the postings, and thus remove the analysis, when posting the source reversal transactions.
Source Offset
Similarly, if the allocation is posting across business units, you can choose to consolidate the source offset balancing transactions generated by selecting the analysis dimensions required.
Discuss in forum

Comments

Only registered users can write comments.
Please login or register.