Consolidation Options

  1. Click the Consolidation Options tab in the Ledger Revaluation Profile (LEP) dialog
  2. Specify this information:
    Consolidation Method

    This option determines the level at which the revaluation posting is made. Three options are available:

    • Select Yes to consolidate the revaluation transactions according to the options you set on this tab.
    • Select No to generate and post transactions at the lowest level of detail.
    • Select One to One to generate a separate revaluation posting for each account and allocate the same Revaluation Link Reference to the source posting and the new revaluation difference posting.
    Note: It is strongly recommended that you always use the same Consolidate option (either One to One, Yes, or No) for revaluations on a ledger.
    Period

    This determines whether the transactions for each account selected for revaluation are consolidated by accounting period, prior to the revaluation. This option is not available for profit and loss account types. Select the check box to consolidate the transactions by period. Leave it unchecked to revalue the transactions for each period individually.

    Asset

    This determines whether the transactions selected for revaluation are consolidated by asset code prior to the revaluation. Select the check box to consolidate the transactions by asset. Leave it unchecked to revalue the transactions individually for each asset.

    Transaction Currency

    This determines whether the transactions selected for revaluation are consolidated by Value 2 currency code prior to the revaluation. Value 2 is written as zero in the revaluation transactions. Select the check box to consolidate the transactions by transaction currency (Value 2). Leave it unchecked to revalue the transactions individually for each Value 2 currency.

    Fourth Currency

    This determines whether the transactions selected for revaluation are consolidated by Value 4 currency code prior to the revaluation. Select the check box to consolidate the transactions by the fourth currency (Value 4). Leave it unchecked to revalue the transactions individually for each Value 4 currency.

    Account

    This determines whether the transactions selected for revaluation are consolidated by account prior to the revaluation. Select Yes to consolidate the transactions by account. Select No to revalue the transactions for each account individually.

    Consolidated Net Account

    The field is displayed depending on the Exchange Gain/Loss Post Rule set for the ledger on the Ledger Setup (LES) - if Net Gains and Losses is selected. Enter the account to which the consolidated net gains and losses are posted. This is required if the transactions are consolidated across several accounts, so that the gain or loss adjustments cannot be posted to the original transaction accounts.

    Consolidated Loss Account

    This field is displayed depending on the Exchange Gain/Loss Post Rule set for the ledger in Ledger Setup (LES). Enter the account to which the consolidated losses are posted. This is required if the transactions are consolidated across several accounts, so that the gain or loss adjustments cannot be posted to the original transaction accounts.

    Consolidated Gain Account

    This field is displayed depending on the Exchange Gain/Loss Post Rule set for the ledger in Ledger Setup (LES). Enter the account to which the consolidated gains will be posted. This is required if the transactions are consolidated across accounts, so that the gain or loss adjustments cannot be posted to the original transaction accounts.

    Consolidation Transaction Analysis Dimensions 1 to 10

    For each analysis dimension assigned to the ledger transactions, you can determine whether the transactions selected for revaluation are consolidated for the analysis dimension, within the account, prior to the revaluation. Select the check box to consolidate the transactions that reference a selected dimension, within each account. Leave it unchecked to generate separate revaluation postings for each analysis code, for the dimension.

  3. Save your changes.