Sunday, June 30, 2019

Creating Currency Exchange Rate Saved Search to Show Base Currency and Translation Currency in their Currency Symbol/Name Instead of Internal ID

The Currency Exchange Rate Type Search is not available when you go to the List of Search types under Lists>Search>Saved Search>New. However, the search can be created by navigating to Lists>Accounting> Currency Exchange Rates> New> Click on the Search Link on the upper left of the page>Click on Create Search button.

 

Enter the Criteria you wish to have to narrow down the information accordingly.

 

On the results Page: Replace the Base Currency field and the Transaction field as with the formula customized as follows:

 

Formula Field = CASE WHEN {basecurrency} = '1' then '[currency symbol of Currency with Internal ID = 1]' when {basecurrency} = '2' then '[currency symbol of Currency with Internal ID = 2]' when {basecurrency} = '3' then '[currency symbol of Currency with Internal ID = 3]' else null end

 

For example:

 

For the Base Currency:

 

Field= Formula Text

 

Formula Field = CASE WHEN {basecurrency} = '1' then 'USD' when {basecurrency} = '2' then 'GBP' when {basecurrency} = '3' then 'CAD' else null end

 

Column Label = base Currency

 

For the Transaction Currency:

 

Field= Formula Text

 

Formula Field = CASE WHEN {transactioncurrency} = '1' then 'USD' when {transactioncurrency} = '2' then 'GBP' when {transactioncurrency} = '3' then 'CAD' else null end

 

Column Label = Transaction Currency


 

Continue the Logic of the search based on the number of Currency records you may have. After running the search, it should allow see the exchange rates on a segmented single browser Page. It is also possible to export the result easier.

5 comments:

  1. Nice reading, I love your content. This is really a fantastic and informative post. Keep it up and if you are looking for Exchange Rates In Uae Today then visit Arab Local UAE


    ReplyDelete
  2. Thanks so much for this information. I have to let you know I concur on several of the points you make here and others may require some further review. Please visit this. Skrill To Perfect Money Exchange India

    ReplyDelete
  3. In a dispensed cryptocurrency mechanism, the cash is issued, controlled and encouraged by using the collective network peer network - the continuous pastime of which is known as mining on a peer's gadget.How to trade forex and cryptocurrency

    ReplyDelete
  4. I’m trampled by your contents carry on the wonderful work.
    bitcoin trading app

    ReplyDelete
  5. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. xbt to usd

    ReplyDelete