You can configure multiple currencies and rates of exchange in Fluid.
Currencies and rates can be managed and updated in one of two ways - both available in the Financial Administration console and both outlined in this article:
- Under Currency Management (Financial Settings)
- Via Data Management download/upload
To access the Financial Administration console navigate to 'Financial Administration' from the drop-down menu under your Avatar.
To access the Financial Administration console and edit currencies and rates you will need Application Administrator or Financial Administrator access.
1) Configuring Currencies and rates using Currency Management
From the Financial Administration Console select Currency Management under Financial Settings.
From here you can either EDIT currencies by clicking on the edit pencil icon in front of the currency entry or create a NEW currency entry by clicking on ADD CURRENCY.
Make your changes and additions to the currency dialog and save your changes. See the table at the bottom of the article for a full description of each field.
2) Currency & Rate Download/Upload
On the same Financial Administration console, scroll down to the Data Management section of the page, and download the Currency & Rates to excel by selecting DOWNLOAD
Make your desired changes to the excel spreadsheet that you downloaded. See the table at the bottom of the page for a full description of each column.
When you are happy with your changes, select UPLOAD and then UPLOAD DATA
Field and Column descriptions
There are 2 tabs on the download file.
The table below describes the columns on the FIRST TAB.
Column & Title in upload file
|Field title in on-screen dialog|
What happens if field is left blank in upload file?
|A. Code||N/A||The entries currency code (e.g. USD, GBP, etc)||Text||Mandatory field. Must be populated for an entry to be created.|
|B. Name||Currency Name||Full descriptive name for the currency entry. (e.g. United States Dollar, Great British Pount, etc)||Text||Field is left blank.|
|C. IsDefault||Default Currency||Set to TRUE (Yes) to identify the entry as the main/default reporting currency for the instance. Only one currency can be set as default.||Yes/No||Field is set to FALSE (No).|
|D. RateToDefault||Conversion rate to default currency||The current conversion rate to the default currency (see note below)||Numeric||Field is set to 0,00|
|E. RateToRestated||Conversion rate to default restated||The restated conversion rate to the default currency (see note below)||Numeric||Field is set to 0,00|
|F. Locked||Locked||The currency is not available for selection by users of the system.||Yes/No||Field is set to FALSE (No).|
|G. Active||Active||The currency is||Yes/No||Field is set to FALSE (No).|
|H. Symbol||Symbol||The currency symbol (e.g. $, £, etc)||Text||Field is left blank.|
|I. Guid||N/A||The unique string identifier for the currency in Fluid.||Alphanumeric||A new currency is added.|
Below is a mapping of the column letters in the upload/download extract against the fields in the on-screen dialog.
TAB 2 in the download allows you to set month on month conversion rates for each of the currencies in turn for both default and restated rates.
Should no month on month conversion rates have been set yet - the second tab will not contain any content.
To configure specific rates month on month, add headers for each month in turn (enter the month headers by typing the first 3 letters of the month and the year - i.e. Nov 2019) and enter the required conversion values for each currency. Any values defined on the Rates tab will override the currency rate values set in the UI.
Column & Title
What happens if this field is left blank?
|A. Currency||The full descriptive name for the currency entry. (e.g. United-States Dollar, Great British Pound, etc)||Text||Mandatory field. Rates will not be updated without this field.|
|B. ConversionTo||The rate to which the currency can be converted to. It may either be Default or Restated.||Text||Mandatory field. Rates will not be updated without this field.|
|C - end. Monthly conversion Values||The rate conversions for each month.||Numeric||No value is uploaded|