Setting up the Line Details for the Transaction Values Type

After you have completed the general details for the ledger interface line details, the remaining information required is dependent on the Ledger Interface Value Type. A different set of information is required for each type, and this information is used in different ways. This topic covers the Transaction Values type of ledger interface.

  1. Click the Transaction Value tab only, then the front row of tabs containing Value Label, Analysis Suppression, and Transfer Data Codes. If you click the Inventory Cost or Business Line Import tabs in error, the correct information is not displayed. Click the Transaction Value tab again to display the correct information.
  2. Specify this information:
    Value Label
    On the journal lines generated, the value to be transferred can be split into four parts: base, transaction, and reporting values, and a memo value. Financials fourth and fifth currencies are not supported for ledger interfaces between Order Fulfilment and Financials.
    Value Labels are required to transfer transaction values into Financials. Each value label identifies a value on the Order Fulfilment transaction being processed that is to be transferred to the appropriate Financials ledger transaction value.
    Select the value label that identifies the transaction values in use within your business unit: base, transaction, reporting/second base and memo.
    You must take care to assign the correct Order Fulfilment transaction values to the correct ledger transaction values. For example, to assign the base currency value on the purchase transaction to the base currency value field on the ledger transaction.
    You would normally expect to post Order Fulfilment currency values to the same currency value type in the Financials and post non-currency values to the Memo value in Financials. In exceptional circumstances you may wish to override this, for example, when posting to memo accounts.
    Value labels are defined using Value Labels (VLB).
    Value Label Value Type
    The Value Type determines the format of each of the four transaction or cost values being transferred. This is required to translate the value into the format required by Financials. You must take care to assign the appropriate value type to each value being transferred.

    The valid options are:

    • Without Units - a number without a unit of measure attached to it. For example, a percentage.
    • With Units - a number with a unit of measure attached to it. For example, a quantity.
    • Corresponds to Base Currency - a number that is the base currency.
    • Corresponds to Transaction Currency - a number that is the transaction currency.
    • Corresponds to Reporting or 2nd Base Currency - a number that is the reporting or 2nd base currency.
    Preset Analysis Code
    For each of the ten analysis dimension codes on the journal, you can specify where the analysis code is derived from.
    Suppress OR Replace with
    Select Suppress if no analysis code is to be entered in the journal. Select Replace if the value is to be entered as an analysis code.
    If Suppress or Replace are not entered, the system checks the Analysis Mapping to Ledger (ANM) settings which define where the analysis code is derived from.
  3. The Transfer Data Code options allow you to transfer selected field values from the Order Fulfilment source transaction into the Transaction Date and Transaction Reference fields on the Financials transaction. If you choose to transfer details into either of these fields and you have chosen to balance journals by either of these fields, you must ensure that these transfer options will not prevent the journal balancing. For example, if the Post Balance By option on the Ledger Interface header is set to Transaction Reference, and one of the Transfer Data Code options transfers different transaction reference values onto each journal line, the journal will not balance.
    Transaction Date
    A date from the Order Fulfilment transaction that is to be transferred to the Transaction Date field on the generated journal.
    Journal Source
    A field from the Order Fulfilment transaction that is to be transferred to the Journal Source field on the generated journal.
    Transaction Reference
    A reference number field from the Order Fulfilment transaction that is to be transferred to the Transaction Reference field on the generated journal.
    Description
    A field from the Order Fulfilment transaction that is to be transferred to the Description field on the generated journal.
  4. Save your changes.