Excel Add-in: explanation of the CURR_INFO (E-Currency) function

Introduction

With the [CURR_INFO (co;curr_type)] function, you can retrieve the default currency code or the secondary currency code. You can also retrieve the exchange rate between these two currencies.

Explanation of the fields

Company
Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case 'CURR_INFO'.

Type
Select the value for which you want the information displayed. You can select the 'default currency', the secondary currency and the default currency factor.

Example

CURR_INFO(-1;0)
The value 'EUR' will be displayed if the default currency for the default company is the Euro and the currency code for the Euro is 'EUR'.

CURR_CODE_DATA (CURR_INFO(17;1);17;"oms30")
The description for the secondary currency for company 17 will be displayed.