General

  1. Click the General tab in the Allocation Sources window.
  2. Specify this information:
    Source Account Code From/To

    The account code, or range of account codes, to be used to calculate the source amount for an allocation. Transactions posted to this range of accounts are selected and used as the source of an allocation.

    When a split type allocation is specified in Corporate Allocation Setup (CAD), the source transactions are reversed out of this account during an Corporate Allocation Run (CAL). These are called the source reversal postings.

    Source Offset Account

    This account is only required for split type allocations, and only if the target transactions are to be posted to a different business unit. Source reversal balancing postings are made to this account to keep the source business unit in balance.

    Source Actual Budget

    The ledger from which the source transactions are selected. For example, you may want to use the transactions in the actuals ledger as the basis for generating budget updates, in which case you would select the actuals ledger here as the source. A ledger is identified by a letter between A and K.

    Source Amount

    The source amount determines the accounting periods for which transactions are selected from the source accounts. The following options are available:

    • Average Balance - the average balance is calculated by finding the balance of each day in a period, totalling these balances and dividing by the number of days in the period selected during the allocation run. The days in the period included in the average balance calculation can be controlled using the allocation calendar.
    • Balance - the transactions selected include all postings up to and including the periods specified during Allocation Run.
    • Period - the source transactions include transactions for the period, or period range, selected during the allocation run.
    • Year to Date - the transactions selected include all postings made during the current year, up to and including the periods specified during the allocation run.
    • Change in Balance - the source transactions include transactions entered since the previous allocation run, up to the periods selected during the allocation run.

    The Change in Balance option uses the journal number of the last source transaction processed to determine the subsequently posted journals (with higher journal numbers) to include in the allocation run. This means that prior posted transactions (with lower journal numbers) are not considered as source data for a run, even if the transactions are posted to the current period selected for the run.

    Note:  Therefore, using the Change in Balance option means that some specific transactions may be excluded from the allocation run, and under certain circumstances the run may not find any data that fulfils the source criteria.

    For example, a transaction with journal number 20 is posted in period 08 with an automatic reversal posted to period 09. Subsequently, journal number 21 is posted to period 08. You perform an allocation run up to and including period 08. Afterwards, the allocation run for period 09 will not include the reversal transaction posted to period 09, because the journal number on the period 09 transaction is prior to the last journal number processed.

    To avoid this situation, consider using the Period option and running an allocation for each period after the period is closed to all other postings.

    Retain Source Period

    If this option is selected, the source reversal and source reversal balancing transactions are posted to the accounting period on the original transactions, rather than the period defined in the allocation run. This option only applies if a source offset account is specified. Otherwise, the source reversal is always posted to the same accounting period as the target transactions to keep the journal in balance.

    Allocation Targets

    Click this to define or review allocation targets as defined using Corporate Allocation Targets (CAT).

    Allocation Setup

    Click this to define or review allocation definitions as defined using Corporate Allocation Setup (CAD).

    Allocation Ratios

    Click this to define or review allocation ratios, as defined using Corporate Allocation Ratios (CAR).

  3. Save your changes.