Understanding the A/P Unrealized Gain/Loss Report
You run the A/P Unrealized Gain/Loss Report (R04425) to calculate unrealized gains and losses. The system produces a report that displays:
Base company currency and the transaction currency of each voucher.
Voucher number and due date.
Original and current domestic amount calculated for each voucher.
Foreign amount of each voucher.
Unrealized gain or loss for each open voucher.
Discount amounts for the voucher.
Pay status of the voucher.
To produce the report, the system uses information from the F0411 and F0414 tables.
You specify whether you want the system to create journal entries for gains or losses, or both, in a processing option. The system assigns journal entries for unrealized gains and losses a document type of 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 vouchers that are open as of the date that you specify in a processing option and uses an As Of Aging Server to recalculate the domestic and foreign voucher 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 vouchers to accounts payable trade accounts. If you run the A/P 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.
If you mix currencies when you run the A/P Unrealized Gain/Loss Report, the foreign 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 for each company that has a different base currency. Setting up a separate version for each company has the added advantage of reducing the size of the report.