Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AP191

AP191 - Unrealized Gain/Loss

Run AP191 (Unrealized Gain/Loss) for companies that pay non-base currency
invoices to calculate and create unrealized gain and loss general ledger
transactions for payment accrual and unrealized gain and loss accounts.
Unrealized gain and loss transactions are created for released, non-base
currency invoices only.

AP191 compares the currency exchange rate in effect at the time of invoice
entry to the exchange rate in effect as of the Revalue Date you define. If a
difference exists, the program creates an unrealized gain or loss transaction
for the invoice. If the rate increased, this program creates an unrealized
loss transaction. Likewise, if the rate decreased, the program creates an
unrealized gain transaction. When the invoice is paid, AP191 reverses the
unrealized gain or loss entry, and AP170 (Payment Closing) creates a realized
gain or loss general ledger transaction to reflect any exchange rate
fluctuation between the invoice date and the payment date.

If unrealized gain/loss transactions are created for the same invoice in more
than one accounting period, the entries for the previous periods are
automatically reversed and the newly calculated unrealized gain and loss
entries are sent to the general ledger for the current accounting period.
Entries created by this program are summarized when they are transferred to
the general ledger.

For Strategic Ledger users: If you selected "Yes" in the Suspend Strategic
Ledger field in GL01.4 (System Codes) for the Accounts Payable system this
program is affected by that decision. The information that is interfaced to
the Strategic Ledger system is processed in the Strategic Ledger Interface
(SLIFGTFILE) file to reduce processing time on the daily interface file
(IFGT). This information is not automatically loaded into the Strategic Ledger
system. You must run SL195 (Transaction Interface) to load information for use
in the Strategic Ledger system.

Updated Files

    APDISTRIB  - Creates invoice distribution records.

    APINVOICE  - Updates invoice records with revalued base amount.

    APMONITOR  - Creates and deletes monitor file records.

    APPAYMENT  - Updates invoice payment records with revalued base amounts.

    APVENBAL   - Updates vendor balance records with revalued base amounts.

    CKPOINT    - Updates check point records.

    JBOOKHDR   - Referenced and updated by general ledger common routines.

    SYSTEMCODE - Validates the system code updating general ledger and updates
                 the object id.


Referenced Files

    APACCRCODE - Validates invoice accrual code and accesses invoice accrual
                 account.

    APCOMPANY  - Validates company.

    APPAYGROUP - Validates pay group.

    APPROCLEV  - Validates process level.

    APVENGROUP - Validates vendor group.

    APVENLOC   - Validates vendor location record.

    APVENMAST  - Validates vendor record.

    CUACCT     - Accesses currency gain and loss accounts.

    CUCONV     - Accessed by currency common routines.

    CURELAT    - Accessed by currency common routines.

    GLADDRESS  - Accessed by general ledger common routines.

    GLCHART    - Referenced by general ledger common routines.

    GLCODES    - Accessed by general ledger common routines.

    GLSYSTEM   - Accessed by general ledger common routines.

    JBKOPCODE  - Accessed by general ledger common routines.

    JBKSYSCODE - Referenced by general ledger common routines.


INVOKED Programs

    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFCC
    IFFC
    IFGT
    IFOB
    IFRS
    IFSC
    SLSB
    SLTV
    IFJR
    SLFD