Unrealised Gain/Loss Report

If you are using the Foreign Currency module, use this report to summarise the foreign exchange losses and gains for a specified date.

Header Details

Report process date and time
As at date
Page number

Line Details

This information displays for each supplier:

Supplier code
Supplier name
Supplier's currency code
Multiple divider for currency code (whether it is a multiply or a divide rate).
Foreign outstanding value
Average rate
Original local outstanding value
Current rate
Current local outstanding value
+/- Loss/Gain value

The report will summarise information and display sub-totals based on the Profile selected in the report parameters. Options include:

Supplier code
Supplier name
Branch/Supplier code (sub-total by branch and supplier)
Branch/Supplier name
Currency/Supplier code
Currency/Supplier name

The report also displays a Grand Total of all supplier balances.

Parameters

You can set these parameters for the report:

Branch Code From

Enter the code for the first branch in the range of branches to include in the report.

Branch Code To

Enter the code for the last branch in the range of branches to include in the report. To report on a single branch, leave this field empty.

Leaving the Branch Code From field empty and entering zzzzzz in this field includes all branches in the report.

As At Date

Select the date on which to report losses and gains.

Currency Code From

Enter the code for the first currency in the range of currencies to include in the report.

Currency Code To

Enter the code for the last currency in the range of currencies to include in the report. To include a single currency code in the report, leave this field empty.

Leaving the Currency Code From field empty and entering zzz in this field includes all currencies in the report.

From Supplier Code

Enter the code for the first supplier in the range of supplier to include in the report.

To Supplier Code

Enter the code for the last supplier in the range of suppliers to include in the report. To report on a single supplier, leave this field empty.

Leaving the From Supplier Code field empty and entering zzzzzz in this field includes all suppliers in the report.

Exclude Zero Balances

Select this option to generate the report without transactions that have zero balances.