Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Sign Up Now!Log In
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