Hello everyone,
I'm trying to create a business process where I'll be able to modify the currency "rate" value (I have my own data source), but I can't see this field to modify. This is the only field from the 'Currency' lookup which I cannot choose. Could you please tell me what I need to do? Thank you a lot in advance.
Like
Damian Rynkowski,
The Exchange rate column in the Currency object is virtual, so it is not shown in the Lookup and cannot be edited directly from the Lookup.
The Rate itself is saved in the CurrencyRate table with a link to CurrencyId each time it is changed.
The base stores the inverse of the exchange rate. For example:
Base currency: 人民幣(RMB)
Dollar exchange rate: 0,15
Which is inconvenient to understand, so a Lookup with a more user-friendly currency display, but converting to a reverse exchange rate, has been developed to support backward compatibility.
This way you can enter the usual exchange rate of USD = 6.79 (RMB to USD) on the interface. And the base will already save 0.15 (USD per 1 RMB).
These different types of rate (6.79 and 0.15) will determine the formula by which you will then calculate the amounts. You can read from the CurrencyRate table and get a rate of 0.025 and:
1) convert it to a familiar rate - 1/0.15 = 6.79.
2) either work already with 0.15, but then the calculation of the amount will be different.
So, the Rate column is virtual, but you can use CurrencyRate (exchange rate) to calculate the exchange rate.
Hello,
Please note that you can easily change the "rate" column of the Currencies lookup in the lookups content:
If you need to change it specifically via buiness process, can you please specify what for and what is the business logic you are trying to achieve this way?
Mira Dmitruk,
Hi,
Thank you for your reply. I am aware that I can modify this column through a lookup, but what I really need is to automate this process.
I have currency rates stored in different lookups, and I want to create an automated process to update the currency values every night. Currently, I am unable to modify the "Rate" field directly because it is not visible in the business process editor when the Currency object is selected.
Damian Rynkowski,
The Exchange rate column in the Currency object is virtual, so it is not shown in the Lookup and cannot be edited directly from the Lookup.
The Rate itself is saved in the CurrencyRate table with a link to CurrencyId each time it is changed.
The base stores the inverse of the exchange rate. For example:
Base currency: 人民幣(RMB)
Dollar exchange rate: 0,15
Which is inconvenient to understand, so a Lookup with a more user-friendly currency display, but converting to a reverse exchange rate, has been developed to support backward compatibility.
This way you can enter the usual exchange rate of USD = 6.79 (RMB to USD) on the interface. And the base will already save 0.15 (USD per 1 RMB).
These different types of rate (6.79 and 0.15) will determine the formula by which you will then calculate the amounts. You can read from the CurrencyRate table and get a rate of 0.025 and:
1) convert it to a familiar rate - 1/0.15 = 6.79.
2) either work already with 0.15, but then the calculation of the amount will be different.
So, the Rate column is virtual, but you can use CurrencyRate (exchange rate) to calculate the exchange rate.