AnsweredAssumed Answered

Parameterized Lookup Between 2 Charge Codes That Pulls Back Exchange Rate from Clarity Table

Question asked by VballVol on May 6, 2015
Latest reply on May 7, 2015 by Roberto Barra - Ágila

Team,

 

I have a difficult query that I am trying to pull off where we have a Billing Currency and an Invoicing Currency.  We then have an Exchange Rate attribute that will be used in calculated fields that we want to be pulled through based on the exchange rate table that is stored within Clarity.  I have the currency attributes setup and the rates in the exchange rate tables.  I am having difficulty pulling off the dynamic query that ties it all together.  Any help would be greatly appreciated!

Outcomes