Hi,
I currently have a list of bank accounts in various currencies. I need to convert these currencies into the product currency.
I am currently converting all bank balances into GBP using a FX module and then converting all back to the product currency.
However, is there another way to do this? The excel file I'm trying to replicate removes this extra step and looks at the direct conversion rate between the base currency and the fund currency. How do I set up a module to do this?
Thanks in advance,
Sure,
Create a list of currencies
Create a module dimensioned by this list with 1 line item called Rate
Then in your transaction module try this formula:
It's basically just a lookup to the module containing the rates.
You will need to specify the currency in a FX List formatted line item
Let me know if you need more help
Regards,
Anirudh
Hi,
To enable the conversion between currencies you need to create an FX module which contains both a base currency and a target currency.