|
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.
Application Closing (AR190) 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
ADDRDATA -
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.
INSTCTRYCD -
WFSETUP -
INVOKED Programs
IFAC
ACAC
ACCL
ACTA
API4
IFCU
IFOB
IFSG
IFLU
IFAU
SLSE
SLSU
IFSC
|