Revalue Across Multiple Balancing Segments

This example demonstrates how to revalue foreign currency balances across multiple balancing segments. Your company, Vision Corporation, has three lines of business.

You revalue foreign currency account balances for two divisions, Air Components and Repair Parts. The Installation Services line of business doesn't have foreign currency transactions. Your company is the primary balancing segment and your lines of business are represented in the secondary balancing segment.

Consider the following points when running the revaluation process:

  • The revaluation process posts the resulting gain or loss amounts against the unrealized gain or loss accounts, substituting the balancing segment values appropriately for all balancing segments.

  • Gain or loss accounts and revaluation account ranges aren't validated against your data access set security when the revaluation definition is created because the ledger context isn't known at the time of definition.

  • Data access set security is enforced when the Revalue Balances process is run. Limited write access to the gain or loss accounts due to inadequate access results in an error.

  • Segment value security rules are enforced when you enter account ranges and the unrealized gain and loss accounts. Only segment values that you have access to are available in the list of values.

  • Account ranges that you have read and write access to are revalued. Account combinations that you don't have access to are ignored.

  • The revaluation process expands the parent primary balancing segment to the child values. Data access set security applies to the child values only, not the parent value.

  • The posting process supports multiple balancing segments for calculating the entry to the Cumulative Translation Adjustment accounts when replicating revaluation journals to reporting currencies.

Defining Revaluations

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Financials

    • Functional Area: General Ledger

    • Task: Manage Revaluations

  2. On the Manage Revaluations page, click the Create icon.

  3. Complete the fields, as shown in this table.

    Field

    Value

    Name

    Vision Corporation Revaluation

    Description

    Revaluation for all foreign currency balances.

    Chart of Accounts

    Vision Corporation Chart of Accounts

    Currency

    Leave blank.

    Note: If blank, all currencies are revalued and after saving, the field automatically displays: All currencies.

    Conversion Rate Type

    Daily

    Days to Roll Forward

    5

    Unrealized Gain Account

    011-00-96600000-0000-000-000

    Unrealized Loss Account

    011-00-96700000-0000-000-000

    Income Statement Accounts Basis

    PTD

    Post Automatically

    Yes

  4. In the Revaluation Accounts section, click the Add Row icon.

  5. Click the Change filter conditions icon to enter the filter used to select the accounts to revalue.

  6. Click Add Fields and select Company.

  7. Accept the default operator of Equals and select 11 from the list of Company segment values.

  8. Click Add Fields and select Lines of Business.

  9. Change the operator to Between and select 30 for Air Components and 40 for Repair Parts.

  10. Click Add Fields and select Account from the list.

  11. Change the operator to Between and enter values 10000000 and 29999999.

  12. Click OK to accept the filters.

  13. Click Save and Close.

    Optionally, click Save and then click Generate to save and run the revaluation immediately.