Clarity

Expand all | Collapse all

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

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

    Posted 05-06-2015 06:16 PM

    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!



  • 2.  Re: Parameterized Lookup Between 2 Charge Codes That Pulls Back Exchange Rate from Clarity Table

    Posted 05-07-2015 03:45 AM

    Can you provide more details? Maybe a draft of the query that is not working.