I have come up with this report to satisfy one of the clients request. So I thought I should share it with the community.
It allow users to check/calculate the exchange gain/loss in the given period.
It will show invoice, cashbook and bankstatement gain losses.
Do take note that the period end rate can be keyed into a specify conversion type which can be chosen during the generation of the report. The excahnge rate have to be valid to the last day of the period.
Any comments and suggestions are welcome.
http://www.red1.org/compiere/cooldog/UnrealisedGainLoss.tar.gz