Setting up the Ledger Interface Posting Details

Ledger Interface (LIS) is used to define the overall requirements for a particular type of journal interface. This includes many different posting options.

The fields on Ledger Interface Header Setup (LIS) set the Ledger Import processing options and apply when the journals are processed by Ledger Import in Financials.

Note: If the Batch Posting Option is selected, you can override these options on the Ledger Import Run-Time Parameters form when you select the batches for processing by Ledger Import.
  1. Specify this information:
    Posting Type

    For postings from Order Fulfillment only the following value can be used:

    • Post if No Errors Found - only post the journals if they pass the validation rules. If errors are found, the posting details can be corrected and the journal(s) reposted using Recover Failed Postings (RFP).
    Posting Write to Hold
    Select this to post the journals as held journals in Financials.
    Provisional Posting
    Select this to post the journals as provisional postings. Leave this blank to post the journals as permanent transactions. This is only required if provisional postings are optional in Financials.
    Posting Allow Balance Trans

    There are three possible settings for this option: Never, Generate Exchange Differences, and Generate Balancing Transactions, as follows:

    • Never - imbalances are treated as errors that prevent the journal from being posted.
    • Generate Exchange Differences - balancing adjustments are generated for imbalances due to currency conversion rounding differences, and all other imbalances are treated as errors that prevent the journal from being posted. Adjustment transactions are posted to the corresponding Balancing Accounts identified on the Business Unit Setup >> Value 1, Value 2, Value 3 or Value 4 tab, depending on the currency value being adjusted (providing that the rounding difference is within the threshold for that currency value, also specified on the Business Unit Setup).
    • Generate Balancing Transactions - for any imbalances detected, balancing adjustments are posted to the Error Suspense Account, the Other Account or the Reporting Account specified on the Validation tab, depending on the currency value being adjusted.
    Note: For an imbalance to be considered as due to a currency conversion rounding difference, the journal must balance in at least one of the currency values.
    Base Suspense Account
    The Financials account to which a balancing journal transaction is posted if the balancing adjustment is required in the base currency. You cannot select a suspended or closed account, or a memo account. If the account code on a journal transaction is invalid this account is used as the substitution.
    Transaction Suspense Account
    The Financials account code to which a balancing transaction is posted if the transaction currency journal values do not balance and the amount of the imbalance is greater than the rounding tolerance. This is only required if the transaction currency is in use for the business unit. You cannot select a suspended or closed account, or a memo account.
    Reporting Suspense Account
    The Financials account code to which a balancing transaction is posted if the second base or reporting currency journal values do not balance and the amount of the imbalance is greater than the rounding tolerance. This is only required if the second base or reporting currency is in use for the business unit. You cannot select a suspended or closed account, or a memo account.
    Post Balance By

    The additional transaction details for which the journal lines must balance. This imposes an additional level of balancing, over and above the normal journal balancing requirements. If you do not wish to impose additional balance conditions select No Extra Balancing. Otherwise select one of the following options to ensure the journal transactions balance for the selected field: ledger analysis 1 to 10, transaction date or transaction reference.

    Note: The Transfer Options allow you to transfer selected field values from the Order Fulfillment source transaction into the journal Transaction Date and Transaction Reference fields. If you choose to balance the journal by either of these fields you must ensure that the transfer options will not prevent the journal balancing. For example, if the Post Balance By option is set to Transaction Reference, and one of the Transfer Options transfers different transaction reference values onto each journal line, the journal will not balance.
    Report Errors Only

    If this is set the Ledger Import report only reports on transactions that contain field value substitutions or which have been rejected. Leave this blank to report on all of the transactions.

    Note: If you use online posting for processing ledger postings and have not specified a report in Ledger Interface Setup, a default report is produced when using ledger import. You can switch this off by checking this check box.
    Suppress Substitute Message
    If this option is selected substitution lines for blank accounting periods, transaction dates and other insignificant substitutions are excluded from the Ledger Import report.
    Posting Report Format
    The document format to be used for the Ledger Import posting report that is produced automatically when journals are posted to Financials. The document format must have been defined using Document Formats.
    Allow Over Budget
    This allows a journal posting to take a ledger account over budget regardless of any budget checking controls in place.
    Post to Suspended Accounts
    Allows the journal transaction to post to a suspended Financials account.
    Suppress Journal Num. Message
    When producing a ledger posting and the Report Errors Only check box is checked, as detailed above, a message is displayed indicating that the posting has been successful, and also containing the journal number. Check this check box if you do not want the journal number to be displayed.
  2. Save your changes.