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?
thanks,
george