Translating account balances for reporting bases

You translate amounts by reporting basis. Translation converts balances from an accounting entity's functional currency to any of the selected currencies.

  1. Select Processing > Reporting Basis > Reporting Basis.
  2. Select the reporting basis and click Translate.
  3. Specify this information:
    Ledger
    To translate a single ledger, select one of the ledgers that is associated with the reporting basis. If this field is blank, then all of the ledgers for the reporting basis are processed for translation.
    Accounting Entity
    To translate a single accounting entity, select one of the accounting entities that is associated with the reporting basis. If this field is blank, then all of the accounting entities for the reporting basis are processed for translation.
    Entity Group
    To translate an entity group, select an entity group that is comprised of accounting entities that are associated with the reporting basis.
    Period Option
    Select the period for which to translate account balances such as current, previous, or next. You must select a period option in this field or a date range on the Date Range fields.
    Or Date Range
    To translate account balances for a date range rather than a period, click the icon in this field and specify a begin date and end date.
    Changed Totals Only
    Select this check box to revalue only totals that have changed since the last revaluation.
    Gain Loss Post Option
    Specify which dimension is the default on the gain or loss offsetting transaction.

    • Zone Or System: If the accounting entity is zoned, the gain or loss offsetting transaction goes to the zone accounting unit of the originating accounting unit. If dimension 1 is zoned, the gain or loss offsetting transaction goes to the zone dimension of the originating dimension 1.

      If zoning is not used, the system accounting unit and system dimension 1 are used.

    • Originating Dimension: the gain or loss offsetting transaction goes to the accounting unit or dimension 1 being processed for translation.
    By System Code
    Select this check box to generate transactions by system code for revaluation and translations.
    Auto Reverse
    Select this check box to have the resulting journal reverse in the next close configuration period for this reporting basis.
    Create Released
    Select this check box to create the journals in released status. Revaluations and translations are posted automatically unless this check box is selected.
    Save Calculation
    Provides visibility to the balances that were used in the calculation of revaluations and translations. Select this check box to view the amounts that are used in the revaluation and translation calculations. To view the amounts, select My Reports > Reporting Basis > Basis Gain Loss from the DrillAround action on the Gain Loss Account Related Transactions panel.
    Alternate Currency, Alternate 2 Currency, Alternate 3 Currency
    Select the check boxes for the accounting entity currencies to process for translation.
    CAD, USD, HKD, SGD, KHR
    All of the reporting currencies are displayed on the form. Select the reporting currencies to process for translation.
  4. Click OK.