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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Ranger 10/25/2017 12:27:43 PM

Exchange Reate Calculation Method Needed in Report

Hi all,

our crappy gp parter did a report for us, which is Received But Not Invoiced report.   What they failed to do was include the exchange rate calculation method (divide or multiply) in the SSRS report, so now we have a bunch of entries that aren't calculating the exchange rate correctly.  And, since we have historical data in there now, this cannot be changed.

So I found the appropriate tables in the Dynamics database, but I have no idea how to join in a table to a report (or query) that comes from two different databases.   The only thing I can think of is to create a DataMart database (maybe in Access -- yuck), that can pull from two different data sources. 

Can anyone think of a cleaner method to do this?  All  I need is the flag for RTCLCMTD from the table MC40300 to make the report right.  Maybe Management Reporter can do this?



Version: GP 2013
Section: Dynamics GP, Management Reporter, Microsoft Access, Report Writer, 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