The Equus Platform Exchange Rate Import can be used to load exchange rates into the Equus Platform™ system. Exchange Rates can be imported at the system and/or company level. The Companies >> Company Configuration >> Exchange Rate Settings screen should be utilized to specify the exchange rate source and date sensitivity setting for each company.
The Exchange Rate Import expects a comma separated list of values. There are 4 fields required for every line of the Import:
FROM_CURRENCY, TO_CURRENCY, EXCHANGE_RATE, EFFECTIVE_DATE
Important Checks
Do not change the order of the file columns
Import file must only contain data rows (header row not to be included)
All rows must have the same number of columns (every column must be populated for every data row)
Imported currency value must match the values in the Equus Platform. Codes can be valided by reviewing the Countries screen at the system level
Any date values should be expressed in a sortable date format or in US standard month-day-year format. This includes “YYYY-MM-DD”, “YYYY/MM/DD” and “MM/DD/YYYYY”
Use only one worksheet tab for all FX rates
Rates should be use a full stop (.) and not a comma and must not be followed by a space character
Values are stored in the database with a data type of 'Float' which allows for increased precision. They are stored with unlimited decimal points even though it might appear that they have been truncated on the Exchange Rate Lookup screens. Rates should be imported with a minimum of 6 significant figures to avoid any conversion discrepancies.
To upload the exchange rates, they must be in the below format and saved as a comma delimited file (.CSV).
Please note: Effective dates are in US format, numbers are using a decimal point and there are no comma thousand separators (e.g. 1,000 )
Please note: Pay special attention to the following two currencies to ensure you upload to the correct currency code: Polish Złoty should be PLN and Turkish Lira should be TRY