Defining the Ledger Conversion Source and Targets

Ledger Conversion (LCN) allows you to swap or generate ledger, budget and archive transactions from a source business unit into a target business unit. This allows you to manipulate the use of the currency and memo transaction values. For example, you could swap the base currency values from one business unit into the second base values in the new business unit, and vice versa.

Note: The usage of Ledger Conversion is restricted to values 1, 2, and 3, and the memo value.

Ledger Conversion generates and posts transactions to the target business unit, based on the conversion rules you define. See What is Ledger Conversion?.

There are four stages in the Ledger Conversion process and this is the first. Once you have entered the source and target details, click Next to move to the next stage.

For a summary of all of the steps required, see Running Ledger Conversion.

Ledger Conversion (LCN)

Source Business Unit: The business unit to be used as the basis of the Ledger Conversion. The transactions posted to this business unit are used as the basis for the Ledger Conversion.

Note: The transactions and static data held in this business unit are not updated in any way.

Value 1 Currency/Pivot: The Value 1, base currency set for the source business unit is displayed automatically. If this is the pivot currency it is indicated alongside.

Value 2 Pivot: If Value 2 is set as the pivot currency this is indicated. The value 2 currency can vary from one transaction to another, so a currency code is not displayed.

Value 3 Pivot: If a Value 3, second base or reporting, currency is defined for the source business unit it is displayed automatically. If this is the pivot currency, this is indicated alongside.

Memo Value: If the Memo Value is in use for the source business unit this is identified.

Target Business Unit: The business unit into which Ledger Conversion generates and posts new transactions. This business unit must have been defined and static data must have been setup.

Value 1/2/3/Memo Value Source

For each value on the target business unit, the Source Value identifies the value on the source business unit ledger transactions to be swapped into, or used to generate, the equivalent target business unit ledger transactions.

Ledger Conversion uses the source and target business unit definitions to predict your requirements. For example, if EUR is defined as the Value 1 currency on the source business unit and as the Value 3 currency on the target business unit, the system assumes you want to swap Value 1 into Value 3 and sets the flag accordingly. You can override any of the system's default settings.

You must enter one of the following codes to define the conversion requirements for each of the available Source values on the target business unit:

1 to swap the Value 1 source values into the appropriate target value.
2 to swap the Value 2 source values into the appropriate target value.
3 to swap the Value 3 source values into the appropriate target value.
M to swap the Memo source values into the equivalent target value.
+ to generate the values using the rates defined for the currency code specified. You can only generate Value 1 and Value 3 values.
- to blank out the existing values in the target business unit.

If a currency value is not being used for the target business unit, you are not able to enter the Source or Currency values. A currency value is not in use if the Currency Post Rule is set to Undefined in Business Unit Setup.

Currency: The Value 1 and Value 3 currency codes are displayed from the target business unit setup.
If either of these currencies is different to the Value 1 and Value 3 currencies used in the source business unit, the system checks to ensure that currency conversion codes exist to convert from the source currencies to the target currencies, via the pivot. An error message appears if these codes have not been defined.

Value 1/2/3 Pivot: The pivot currency set for the business unit is indicated alongside the relevant currency. This is set using Business Unit Setup.

Validate Only: Set this option to validate the Ledger Conversion rules and produces a report of any errors. This option does not generate or post any transactions to the target business unit.