Ledger Conversion (LCN)

  1. Open Ledger Conversion (LCN).
  2. Specify this information:
    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.

  3. Save your changes.