Hello,
I have a saved search where I want to show the amount in:
- Transaction amount - Amount (foreign currency)
- Base currency amount - {fxamount}*{fxrate}
- Consolidated amount - Amount
The consolidated exchange rate is set to Average.
The problem is that currency revaluation transactions show 0 in the FX amount filed. I've understood that this is a system limitation?
But is there ANY workaround for this to get all different amounts in one saved search?