In bpm’online, the base currency is the currency that is used for financial calculations in the system. The exchange rate defines the value of a currency in terms of the base currency. The ratio shows the amount of base currency that corresponds to the established exchange rate.
For example, 100 Japanese Yen are worth 0.84 US Dollars. If the yen is set as the base currency and the ratio of the dollar rate is 100, the exchange rate will be 0.84.
The ratio of the currency in terms of the base currency is specified in the [Currencies] lookup. The exchange rate of the selected currency in terms of the base currency is specified on the [Exchange rate] detail of the [Currencies] lookup.
Fig.1 Possible content of the [Currencies] lookup
Use the “Base currency” system setting to select a base currency.
Calculating the product price in an order
Let's see how the product price is calculated in an order when the price is specified in US Dollars and the order currency is Yen. The base currency of the system is Yen, the ratio of US Dollar is 100, the product price is 20 $.
1. Open the [Orders] section and add a record.
2. On the displayed page, enter the order details:
- Specify the customer that the order is created for.
- Enter the planned end date and the employee who is responsible for completing the order.
- On the [Order details] tab, select the currency of the order – “Yen“. The [Exchange rate] field will be filled in automatically with the rate of the selected currency in terms of the base currency. Since the base currency is the order currency, the exchange rate will be equal to 1.
3. Open the [Products] detail. From the menu, select the [Add] option.
4. In the displayed string, click on the button in the [Product] field.
5. In the displayed lookup, select the product whose price is specified in US Dollars.
Fig.2 Selecting a product from the lookup (the price is specified in US Dollars)
As a result, a new product will be added to the detail. The price of the product will be specified in Yen and calculated using the following formula:
[Product price]*[Ratio]/[Exchange rate] – 20*100/0.84=2380.95.
Fig.3 Product in order (the price is specified in Yen)
Like