Sales Creatio, commerce edition
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

How is the monetary amount calculated during conversion

You can work with various currencies in Creatio. The conversion is performed automatically, taking into account the conversion currency exchange rate in relation to the base currency and multiplicity ratio.

  • The base currency is the currency based on which the rate for all other currencies is set. Use the [Base currency] system setting to select a base currency.

  • The conversion currency is any other currency to which the money is converted.

  • The exchange rate determines the conversion currency amount in the base currency.

  • The multiplicity ratio indicates how many monetary units of the base currency correspond to the set exchange rate.

The exchange rate and ratio of the currency are specified in the [Currencies] lookup (Fig. 1).

The exchange rate of the conversion currency is specified in terms of the base currency taking into account the ratio. Currency rates are automatically re-calculated according to their base currency exchange rates and ratio.

For example if the Yen is the base currency and the USD will have the 56537.3 exchange rate value for the 1000 ratio in the [Currencies] lookup, the exchange rate will be displayed in the additional window of the currency field as 17.6874 USD for 1000 Yen.

Fig. 1 – Possible content of the [Currencies] lookup

scr_chapter_currencies_lookup.png 

Note

The [Currencies] lookup structure is described in a separate chapter. Use the “Base currency” system setting to select a base currency.

How to set up exchange rates

Set up the exchange rates for proper currency conversion towards the base currency. To do this:

1.Open the [Currencies] lookup.

2.Set the “1” value for the rate of the base currency.

3.Select the currency to set up the rate (for example, euro). Click btn_edit.png.

4.On the opened currency settings page, set the ratio, for example “1000”.

Note

For a more accurate calculation of prices during conversion, specify a high ratio for currencies, for example “1000”.

5.Specify the exchange rate between the current currency and the base currency in the [Rate] field, considering the ratio. Save the changes.

Example

If the base currency is yen and the euro to yen ratio is 63.9655, specify the “63965.5” as the exchange [Rate] and “1000” as the [Ratio].

6.Repeat steps 3 through 7 for all currencies specified in the lookup.

Update all data in the lookup if the exchange rates are changed,

Calculating exchange rate with ratio.

The following formula is used for calculating exchange rates in Creatio:

[Rate]=[Amount in conversion currency]*[Ratio]/[Amount in base currency]

Example

1000 Japanese yen are worth 0.84 US Dollars. Yen is selected as the base currency and the dollar ratio is 100. The actual conversion is as follows:

[Rate]=19.40*100/1000=1.94

Thus, when the ratio is 100, the US dollar exchange rate to yen is 1.94

Calculating monetary amounts during conversion

When converting monetary amounts from the base currency into another currency, use the following formula:

[Amount in conversion currency]=[Rate]*[Amount in base currency]/[Ratio]

For example, 1,000 yen must be converted to US dollars. Yen is selected as the base currency, the USD / yen exchange rate is 1.94 and the ratio is 100. The actual conversion is as follows:

[Amount in conversion currency]=1.94*1000/100=19.4

Thus, the amount of 1000 yen is equal to 19.40 USD.

When converting monetary amounts from one currency to another, calculations are made based on the base currency. The following formula is used:

[Amount in conversion currency(2)]=[Amount in conversion currency(1)]*[Ratio(1)]*[Rate(2)]/[Ratio(2)]*[Rate(1)]

For example, USD 100 must be converted to euro Yen is selected as the base currency. The dollar / yen exchange rate is 1.94, with the ratio of 100 and the euro / yen exchange rate is 1.73, with the ratio of 100. The actual conversion is as follows:

[Amount in euro]=100*100*1.73/100*1.94=89.2

Thus, USD 100 is converted to EUR 89,20.

How to calculate the product price in an order

Let's see how the product price is calculated in an order.

Example

The order currency is yen. Add a product with the price is specified in US dollars to the order. The base system currency is yen, the ratio of US dollar is 100, the product price is USD 14.6.

Click btn_chapter_mobile_wizard_new_role.png on the [Products] detail to add products to the order. On the product selection page, all products are priced in the currency used for the order (Fig. 2). In this case, “yen”.

Fig. 2 The order product selection page

scr_chapter_currencies_produst_in_order.png 

For the products with the base price specified in foreign currency, the product price is automatically converted to the base currency according to current exchange rate specified as follows:

[Product price]*[Ratio]/[Exchange rate] – 14.6*100/1.5092=967.40

As a result, a new product will be added to the detail. The price of the product will be specified in yen. The [Price] and [Total] fields are populated automatically and are not available for editing.

See also

How to work with currency fields

The [Currencies] lookup

Did you find this information useful?

How can we improve it?