Understanding the A/R Unrealized Gain/Loss Report

You run the A/R Unrealized Gain/Loss Report (R03B426) to calculate unrealized gains and losses. The system produces a report that displays:

  • The base company currency and the transaction currency for each invoice.

  • The invoice number and due date.

  • The original and current domestic amount calculated for each invoice.

  • The foreign amount of each invoice.

  • The unrealized gain or loss for each open invoice.

To produce the report, the system uses information from these tables:

  • Customer Ledger (F03B11)

  • Receipts Detail (F03B14)

You specify whether you want to create journal entries for unrealized gains, losses, or both in a processing option. The system assigns these journal entries the document type JX. This is the only document type that is used to adjust the domestic side of a monetary (currency-specific) account. The system creates only one journal entry per company. If you leave the processing option blank, the system does not create journal entries.

You can also specify whether you want to create journal entries for unrealized gains or losses as of a specific date. The system selects invoices that are open as of the date that you specify in a processing option and uses the F03B14 As Of Aging Server (B03B136) to recalculate the domestic and foreign invoice amounts. Then, if specified in a processing option, the system creates journal entries for the unrealized gains or losses. With as of reporting, you can produce period-end reports to handle financial audit requirements such as balancing open invoices to accounts receivable trade accounts. If you run the A/R Unrealized Gain/Loss Report as of a specific date, be aware that the report takes longer to process. This is because the system first recalculates the open amounts as of the date that you specify and then it calculates the unrealized gains or losses.

Note: Run the A/R Unrealized Gain/Loss Report first without creating journal entries. Review the report and correct any exchange rates, if necessary. Continue to run the program without creating journal entries until you have corrected all exchange rates, and then run the program to create journal entries for unrealized gains and losses.

If you mix multiple currencies when you run the A/R Unrealized Gain/Loss Report, the foreign currency grand total and any other subtotals appear as **NA** (not applicable) because totals for more than one currency are meaningless. To prevent this, set up a different version of the report for each company with a different base currency. Setting up a separate version for each company has the added advantage of reducing the size of the report.

Important: To avoid duplicate journal entries, do not set the processing option to create journal entries more than one time per fiscal period.