Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR196


AR196 - Unrealized Gain Loss Report

**Form Purpose
Run Unrealized Gain Loss Report (AR196) to calculate unrealized gains and
losses for open, non-base currency transactions and create entries for posting
to the general ledger.

**Processing Effect
AR196 compares the currency exchange rate in effect at the time a non-base
currency transaction was entered or created to the exchange rate in effect on
the Revalue Date you define on this form. If a difference exists, AR196
creates an unrealized gain or loss record for the transaction. If the
transaction is still open the next time you run this program, AR196 reverses
the calculated unrealized gain or loss entries from the previous AR196 run and
creates new entries.

AR190 (Application Closing) creates a realized gain or loss general ledger
transactions for non-base currency transactions to reflect the difference in
the currency exchange rate in effect on the transaction date and on the
payment date during cash application.




Updated Files

    ARDISTRIB  - Primary record created for unrealized gain loss.

    AROITEMS   - Used to access the open item detail records.

    CKPOINT    - The environment file used for recovery.


Referenced Files

    ARADJUST   - Used to determine open amount.

    ARAPPLIED  - Used to determine if applied records exist for obligations or
                 credit memos. If they do exist the GL date of the record is
                 used to calculation of the transaction open amount at the time
                 the report is run.

    ARCODE     - Used to validate the AR code.

    ARCOMP     - Used to validate the AR company.

    ARCUSTOMER - Used to access customer information for matrix definition.

    AROIHDR    - Used to access open item header records.

    CUACCT     - Used to determine the GL account to be used in currency
                 gain/loss records.

    CUCONV     - Used to determine the exchange rate between the company base
                 currency and
                 another currency.

    CURELAT    - Used to validate the relationship between the company base
                 currency and
                 another currency.

    GLADDRESS  - Used in the validation of the GL company.

    GLCHART    - Validates general ledger company chart information.

    GLCODES    - Used in the validation of the GL company.

    GLSYSTEM   - Used in the validation of the GL company.


INVOKED Programs

    IFAC
    ACAC
    ACCL
    API4
    IFCU
    IFSG
    SLSE
    SLSU
    IFSC