Currency settings

Under this tab you can configure which company currency should be used when handling financial data in Monitor BI. This is the currency that other currencies will be converted into when data from multiple companies with different currencies is extracted. Amounts in different currencies from different companies must be converted into the same company currency in Monitor BI.

Please note! You will need to extract data from Scheduling for the new currency settings to be applied.

Currency data is maintained and extracted from the Currencies procedure in Monitor ERP.

Company code

In the Company code column, you select which company you would like to base your currency settings on.

Currency code

In the Currency code column, you select currencies that are available from the company selected in Company code.

Exchange rate code

In this column you select the type of exchange rate. The available alternatives are Current exchange rate or AFS rate.

Use historical currency rates

If this setting is activated, the system will use the exchange rate from when the transaction was created. This means that historical values are recalculated with the earlier exchange rate instead of the currency exchange rate.

If there is no exchange rate for that exact date, the system will automatically use the rate closest to the time after the transaction date.