Calculating Unrealized Gain/Loss

Use this procedure only if you use multiple currencies. The program compares the currency exchange rate at the time of the transaction to the exchange rate defined for the revalue date. The difference creates a record showing a gain or loss which is then transferred to the general ledger.

To calculate unrealized gain/loss

  1. Access Unrealized Gain/Loss Report (AR196).
  2. Select the company or company group. Specify a revalue date to compare the currency exchange rate in effect at the time of transaction entry to the exchange rate in effect defined in the revalue date. If the transaction is still open the next time this program is run, the original unrealized gain or loss entries will be reversed and new entries will be created. Use the following guidelines to enter field values:
    Qualify Future Applications

    Select "N" if you do not have future dated applications and the "as of" date specified is today's date. This reduces processing time dramatically. Select "Y" if you do have future dated applications and the "as of" date is not today's date.

    Currency

    You can select a non-base currency code to calculate unrealized gains and losses for transactions of a specific currency only. If left blank, all non-base currency transactions will be included.

    Loss Only

    Select whether you want to calculate unrealized losses only.

    Reverse Only

    Select whether you want to only reverse unrealized gains and losses created the last time you ran AR196.

    Update Option

    Select whether you want a report only or update and report.

    Report Option

    Select D for Detail and S for Summary.

  3. Run Application Closing (AR190) to update balances and create distribution records. Then, to transfer the unrealized gain or loss to the general ledger, run Distribution Closing (AR195)Distribution Closing. Closing the Day