Unrealised Gain/Loss Report

If you are using the Foreign Currency module, this report summarises the foreign exchange losses and gains as at a specified date.

Header Details

Report process date and time
As at Date specified in the Parameters
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 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

These parameters are available when you run the report:

Branch Code From

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

Branch Code To

Enter the code for the last branch in the range of branches you want to include in the report. If you want to report on a single branch, leave this field blank.

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

As At Date

Select the date on which you want to report losses and gains.

Currency Code From

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

Currency Code To

Enter the code for the last currency in the range of currencies you want to include in the report. If you want to include a single currency code in the report, leave this field blank.

Leaving the Currency Code From field blank 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 that you want to include in the report.

To Supplier Code

Enter the code for the last supplier in the range of suppliers you want to include in the report. If you want to report on a single supplier, leave this field blank.

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

Exclude Zero Balances

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