Help your Organization do business in local and foreign currencies using Record level currency feature.
This is the corporate currency used for reporting by the Organization headquarters. This also serves as the base for all currency conversion rates. Base currency is set initially during sign up process to the user’s geolocation currency. For example, Base Currency of the user signing up to Vtiger from the USA region is set to USD.
This is the transaction currency of the record and set to the user preferred currency by default. Only one record currency can be set for all currency fields in a record. The conversion rate of the record currency with respect to Base currency is stored at the record level.
In addition to base currency, each user gets to choose his preferred currency which is used for showing report, sales insights and forecast aggregates.
This is the deactivated currency. Admin can mark any currency as inactive if an Organization no longer does business. However, existing records with inactive currencies are untouched.
This feature is available in Sales Enterprise and Vtiger One Enterprise editions.
Consider Grasspods Inc as an Organization with its headquarters in the USA, and branches in Australia, India, Japan, and Germany.
The sales rep in India can create Opportunities in Rupees, and Sales rep in Japan can create Opportunities in Yen. CEO present in the USA can view Opportunities created by all the Sales Reps both in local currencies(Rupees, Yen, etc) as well as in his/her preferred currency (US Dollars).
In this section, we will walk you through how to Change Base Currency, add multiple currencies and select My Preference (user preferred) currency.
Base currency is set initially during sign up process to the user’s geolocation currency. The administrator can change the base currency already chosen during the signup process.
Follow the below steps to change base currency:
Follow few simple steps to add new currencies
In the create view of new currency, you’ll need to fill up the following fields
|a.||Currency Name||Select desired currency from the drop-down|
|b.||Currency Code||The currency code of the selected currency is automatically populated|
|c.||Symbol||The symbol of selected currency is automatically populated|
|d.||Conversion Rate||Provide conversion rate of selected currency in accordance with your base currency. For instance, 1 USD = 0.5 EUR|
|e.||Status||Enable the check-box to make currency active|
Note! Only active currencies will appear for selection in a Currency field.
We will consider INR as a sample Record Currency, EUR as My Preference Currency and USD as Base Currency for examples used in this article.
Sample conversion rates used for INR To USD and EUR to USD conversions.
1 USD = 0.5 EUR
1 USD = 60 INR
Vtiger allows user to view currency fields in a record in his preferred currency with a simple configuration available in My preferences > Currency and Number Field
Only when the record currency is different from the user’s preferred currency, the currency value in user preferred currency appears in shown.
Follow few simple steps to configure My preference currency
In the Currency and Number Field Configuration block, locate Currency field and select the desired currency.
Show amounts in preferred currency checkbox.
Note! Vtiger Currencies also supports Bitcoin Currency.
Product Unit Price and Service Price can be set in multiple currencies, by ignoring conversion rates.
For Quote, line item values will only be shown in Quote currency. The same is true for Subscription, Invoice, PO, and SO.
For Payment records, the Payment currency will change to the Invoice currency, after the Invoice is selected. The same is true if a Payment is linked to a Purchase order.
All the currency values in a non-inventory record (ex: Opportunity), share a common currency. If the currency of one currency field is changed in a record, the currency of the other fields in the same record will also be updated.
For each currency values, the following information is stored in the database
Conversion rate at the time of saving the record (stored at record level) (1 USD=60)
If a user’s preferred currency is different from the record currency, then the value in the user’s preferred currency is shown on the side.
Note! Customers who signed up for Vtiger before Nov 25th, 2016 should contact Vtiger support team to enable Record level currency feature. The process requires migration of data during which the system should not be used.
Learn how to handle currencies in
If you have a condition that says Amount = Rs 10,000, then the value is converted to base currency at the time of saving the filter (if the exchange rate is Rs 100=$1, then the filter is saved as Amount > $100).
When a user views the list, the system will search all records that match the above condition. After conversion, the values are displayed in record currency and the user’s preferred currency. Even after the conversion rate has changed, the filter list remains the same.
1. If “equals” is used in a condition, it might be possible that a condition such as an Amount equals Rs 10,000 might not return records with value = Rs 10,000, if the conversion rate changed between the time of creating the filter and the time the record is saved. This usually could happen, when you do listview search.
When searching within listview (by specifying a value in the column), the value is converted from user’s preferred currency to base currency using current conversion rate, and records that match this base currency value will be displayed.
List view and Record Detail view show values in the record’s currency. If the record currency is not the same as the user’s preferred currency, then the value in the user’s preferred currency is shown on the side.
In Detail Report, and when exporting Lists or Reports, Currency values will be in record currency. Currency code and conversion rate (to base currency) columns will also be exported.
In Report Summary, or Pivot Report, or Charts wherever values are aggregated (Ex: SUM, AVG), the computation is done on the value stored in base currency for records that are not in user’s preferred currency, and then converted to user’s preferred currency at the time of displaying, using current conversion rate. For records whose record currency is the same as the user’s preferred currency aggregation is done on the user currency values.
In Insights and Forecasts, the computation is done on the value stored in base currency (even if record currency is user’s preferred currency it is ignored), and then converted to user’s preferred currency at the time of displaying.
Record Import supports Record Currency by default, provided your CSV files contains these 3 fields - Currency field(Eg, Opportunity Amount), Record Currency(INR, USD, EUR, YEN) and Record Conversion Rate.
If record currency and record conversion rate are not provided in the CSV file, then Vtiger will consider the current user’s preferred currency and its latest exchange rate.
Consider the following 4 cases while you import a CSV file with assumptions as
|Case||Amount||Record Currency||Conversion Rate||Result|
|1.||500||INR||50||Amount = INR 500(Record Currency), Conversion rate, 1 USD = 50 INR, for the record|
|2.||500||-||50||Amount = EUR 500(Record Currency set to User’s preferred currency), Conversion rate, 1 USD = 0.5 EUR(configured conversion rate)|
|3.||500||INR||-||Amount = INR 500(Record Currency), Conversion rate, 1 USD = 60 INR(configured conversion rate)|
|4.||500||Currency not present in Vtiger or Incorrect Currency code||50||Amount = EUR 500(Record Currency set to User’s preferred currency), Conversion rate, 1 USD = 0.5 EUR(configured conversion rate)|
Note! During Import, if you select an action to merge the duplicate record or merge records, multi-currency fields is not be available in the duplicate field criteria.
An administrator can mark a currency as inactive if they are no longer doing business in this currency. However, this does not impact the records that are already present in the old inactive currency.
You can edit the currency field value but not the currency type.
For example, Consider an Opportunity Amount = INR 500. If the Euro is made inactive by the admin, the Currency India, Rupees(INR) is freezed. Thus, you can only change the Amount value from INR 500 to INR 1000.
Note! If a user’s preferred currency is set to an inactive currency, the user preference currency is automatically reset to the base currency.