Hi Flieger,

I just tested this and I am not getting the same result as you. 
Have you tested this by going into the Currency settings in CRM and changing it there and then going back to the oppo? That's how I'm testing it and it works fine for me.
You can also inspect the SQL that gets executed if you are so inclined -> SELECT Curr_CurrencyId, Curr_Symbol, Curr_DecimalPrecision, Curr_Rate FROM vSearchListCurrencies. That's mostly my SQL. If the value is changed in SQL at the time the query is executed, then it should return the most current value in SQL. 

Hi Flieger,

I just tested this and I am not getting the same result as you. 
Have you tested this by going into the Currency settings in CRM and changing it there and then going back to the oppo? That's how I'm testing it and it works fine for me.
You can also inspect the SQL that gets executed if you are so inclined -> SELECT Curr_CurrencyId, Curr_Symbol, Curr_DecimalPrecision, Curr_Rate FROM vSearchListCurrencies. That's mostly my SQL. If the value is changed in SQL at the time the query is executed, then it should return the most current value in SQL. 

Hi Conrad,

maybe my description was a little irritating. I changed the currency value by doing an UPDATE Statement on the database directly. Changing the currency in the Administration section works as expected, but doing an update on the database table does not have the same effect. 

If I am operating a metadata refresh from console, only the currency table in the Admin section gets updated, not the values in the oppo.

When I do the Update-Statement and look at the values in vSearchListCurrencies before and after, they have changed.

Oh I see. Forcing a meta-update is the key here. I just tested as you explained and I needed to do a metadata (Refresh System Parameters) in order for it to show up correctly. It could be in code the update is not performing the required refreshes correctly.

Let me see what I can test on my side with some code as well.
Can I have some background as to what CRM version you are running and how are you executing the script? Is TLS/ASP Page? How does that script get triggered to run?

I am using 2020R1 Version.

The UPDATE-Query I am executing manually in SQLServerManagementStudio. The Databse refresh I am performing via a js-Script that I execute in the cmd on the server. The Script simply contains the following:

var CRM = new ActiveXObject("eware.<instanceName>");
CRM.Logon("<user>", "<password>");
CRM.RefreshMetadata();

In the "ewaresystem"-Log nearly the same information is documented as starting the refresh from Admin console.

Thank you for help

Hi Flieger, I'm getting the same thing. I presume that the JS refresh is not actually doing a "proper" meta refresh. I'm going to investigate some other options for you in the interim.

Hi Conrad,

did you come to solution for this problem or do you have any suggestions? I made several test to inspect the problem but none of them took me to a  solution.

Greetings

Unfortunately I was not able to find something that would help, I will engage with some of my colleagues to see if we can find a solution.