Preparing for the Translate Within Ledger Process

To prepare for the Translate Within Ledger process, use the Translation Within Ledger component (MBXLAT).

Page Name

Definition Name

Usage

Translation Within Ledger - Ledger and TimeSpan Page

MBXLAT_STEP_LED_TM

Define a ledger and TimeSpan for the Translate Within Ledger process.

Translation Within Ledger - ChartFields Page

MBXLAT_STEP_CF

Identify the accounts that you want to include in your step.

Translation Within Ledger - Output and Journal Options Page

CURR_STEP_OUT_JR

Determine whether General Ledger automatically posts translated amounts to the ledger or generates journal entries for subsequent posting.

Translation Within Ledger - Gain and Loss ChartFields Page

CURR_STEP_GN_LS

Specify the specific accounts where you record translation gain or loss.

At the end of the accounting period, you can run the Translate Within Ledger translation process against the translation ledger to produce the appropriate gain or loss adjustment. This process handles the translation ledger in the same manner as revaluation processing. The Translate Within Ledger process only processes translation ledgers.

Prepare for this process on the Detail Ledger Group - Definition page by establishing a particular ledger as a translation ledger.

When journal lines are generated online for the secondary ledgers of a multibook ledger group, the base currency is calculated differently for currency (multibook) translation ledgers than for normal secondary ledgers. Normal secondary ledger lines contain a foreign currency and foreign amount equal to the transaction currency and transaction amount of the primary ledger. For multibook translation ledgers, lines are generated with the foreign currency and foreign amount equal to that of the base currency and base amount of the primary ledger. As a result, multibook translation ledgers have no more than one foreign currency at any time. This foreign currency will always be the base currency of the primary ledger of the ledger group.

The Translation Within Ledger process generates a translation adjustment with the multibook translation ledger for specified accounts in order to maintain a real-time balance for the accounts. Use the Translate Within Ledger Group pages to define the criteria for running this process.

To prepare for the Translate Within Ledger process, use the Translation Within Ledger component (MBXLAT).

Use the Translation Within Ledger - Ledger and TimeSpan page (MBXLAT_STEP_LED_TM) to define a ledger and TimeSpan for the Translate Within Ledger process.

Navigation:

General Ledger > Process Multi-Currency > Define and Process > Translation Within Ledger > Ledger and TimeSpan

This example illustrates the fields and controls on the Translation Within Ledger - Ledger and TimeSpan page.

Translate Within Ledger - Ledger and Timespan page

Although the Translation Within Ledger - Ledger and TimeSpan page is a different object than the Revaluation - Ledger and TimeSpan page, the fields are common to both pages.

Field or Control

Description

From Ledger Group and Ledger

Specify the from ledger group and specific ledger in which you want to perform the Translate Within Ledger process. You must specify a translation ledger for this process. If you do not specify a ledger, the Translate Within Ledger process is run by the system against all the translation ledgers in the ledger group.

TimeSpan

General Ledger generates journal entries for which the amounts represent the period of time indicated by the TimeSpan for the step definition being processed. The TimeSpan typically used is BAL (balance sheet accounts). With this TimeSpan, the system totals the account balances in periods 0 through n for balance sheet accounts.

Rate Type

Enter the applicable rate type for the process.

Use the Translation Within Ledger - Chartfields page (MBXLAT_STEP_CF) to identify the accounts that you want to include in your step.

Navigation:

General Ledger > Process Multi-Currency > Define and Process > Translation Within Ledger > Chartfields

This example illustrates the fields and controls on the Translation Within Ledger - Chartfields page.

Translate Within Ledger - Chartfields page

Although this ChartField page has a different object name than the Revaluation - Source Chartfields page, the fields are common to both pages. See the Specifying Source ChartFields for Revaluation topic.

Field or Control

Description

Chartfields

Select the accounts to be processed in the Chartfields group box. For example, you can list your balance sheet accounts individually as detail values or, more typically, you can define tree nodes. Using trees establishes rollups for the account values so that you can select particular types of accounts according to the structure of your business unit.

Use the Translation Within Ledger - Output and Journal Options page (CURR_STEP_OUT_JR) to determine whether General Ledger automatically posts translated amounts to the ledger or generates journal entries for subsequent posting.

Navigation:

General Ledger > Process Multi-Currency > Define and Process > Translation Within Ledger > Output and Journal Options

This example illustrates the fields and controls on the Translation Within Ledger - Output and Journal Options page.

Translate Within Ledger - Output and Journal Options page

Refer to the Specifying Output and Journal Options for Revaluation topic for information about specifying output options, journal information, and revaluation reversal options for the Translation Within Ledger process.

Use the Translation Within Ledger - Gain and Loss Chartfields page (CURR_STEP_GN_LS) to specify the specific accounts where you record translation gain or loss.

Navigation:

General Ledger > Process Multi-Currency > Define and Process > Translation Within Ledger > Gain and Loss Chartfields

This example illustrates the fields and controls on the Translation Within Ledger - Gain and Loss Chartfields page.

Translate Within Ledger - Gain and Loss ChartFields page

Refer to the Specifying Gain and Loss Chartfields for Revaluation topic when specifying Translate Within Ledger gain and loss accounts.