ian maclauchlan 6/24/2015 12:30:14 PM

SQL code to look at Exchange Rates

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 

Version: GP 2013
Section: SQL Scripts, SSRS


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3