Im in the process of creating a suite of reports on Contracts admin and have a query regarding Exchange Rates.
Part of the suite will be reporting our contract's in GBP, so a contract stated in GP as USD with a bill date of 28/03/2015 I need the Exch rate as at 01/03/2015 GBP-USD
or a contract in SGD with a Bill Date of 12/11/2014 will look up Exch Rate as at 01/11/2014 for GBP-SGD
I hope that this makes sense as I have not got a clue how to do it!!
Many thanks