...
The currency rates can be loaded from Excel using the Load Currency popup.
| Aura html |
|---|
| params | JTdCJTIyaHRtbENvZGUlMjIlM0ElMjIlM0NkaXYlMjBzdHlsZSUzRCU1QyUyMndpZHRoJTNBNTAlMjUlM0IlMjBoZWlnaHQlM0E1MCUyNSU1QyUyMiUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlM0NzY3JpcHQlMjBzcmMlM0QlNUMlMjJodHRwcyUzQSUyRiUyRmpzLnN0b3J5bGFuZS5pbyUyRmpzJTJGdjElMkZzdG9yeWxhbmUuanMlNUMlMjIlM0UlM0MlMkZzY3JpcHQlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTNDZGl2JTIwY2xhc3MlM0QlNUMlMjJzbC1lbWJlZCU1QyUyMiUyMHN0eWxlJTNEJTVDJTIycG9zaXRpb24lM0FyZWxhdGl2ZSUzQnBhZGRpbmctYm90dG9tJTNBY2FsYyg2OC45OSUyNSUyMCUyQiUyMDI3cHgpJTNCd2lkdGglM0ExMDAlMjUlM0JoZWlnaHQlM0E1MCUyNSUzQnRyYW5zZm9ybSUzQXNjYWxlKDEpJTVDJTIyJTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2lmcmFtZSUyMGNsYXNzJTNEJTVDJTIyc2wtZGVtbyU1QyUyMiUyMHNyYyUzRCU1QyUyMmh0dHBzJTNBJTJGJTJGYXBsaXFvLnN0b3J5bGFuZS5pbyUyRmRlbW8lMkZrb2pnaGN4NGFqeHAlNUMlMjIlMjBuYW1lJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBhbGxvdyUzRCU1QyUyMmZ1bGxzY3JlZW4lM0IlMjBjYW1lcmElM0IlMjBtaWNyb3Bob25lJTVDJTIyJTIwc3R5bGUlM0QlNUMlMjJwb3NpdGlvbiUzQWFic29sdXRlJTNCdG9wJTNBMCUzQmxlZnQlM0EwJTNCd2lkdGglM0ExMDAlMjUlM0JoZWlnaHQlM0ExMDAlMjUlM0Jib3JkZXIlM0Fub25lJTNCJTVDJTIyJTNFJTNDJTJGaWZyYW1lJTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQyUyRmRpdiUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlM0MlMkZkaXYlM0UlMjIlMkMlMjJjc3NDb2RlJTIyJTNBJTIyJTIyJTJDJTIyanNDb2RlJTIyJTNBJTIyJTIyJTJDJTIydGhlbWUlMjIlM0ElMjJkcmFjdWxhJTIyJTdEJTdCJTIyaHRtbENvZGUlMjIlM0ElMjIlM0NkaXYlMjBzdHlsZSUzRCU1QyUyMndpZHRoJTNBNzAlMjUlNUMlMjIlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTNDc2NyaXB0JTIwc3JjJTNEJTVDJTIyaHR0cHMlM0ElMkYlMkZqcy5zdG9yeWxhbmUuaW8lMkZqcyUyRnYxJTJGc3RvcnlsYW5lLmpzJTVDJTIyJTNFJTNDJTJGc2NyaXB0JTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2RpdiUyMGNsYXNzJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBzdHlsZSUzRCU1QyUyMnBvc2l0aW9uJTNBcmVsYXRpdmUlM0JwYWRkaW5nLWJvdHRvbSUzQWNhbGMoNjguOTklMjUlMjAlMkIlMjAyN3B4KSUzQndpZHRoJTNBMTAwJTI1JTNCaGVpZ2h0JTNBNTAlMjUlM0J0cmFuc2Zvcm0lM0FzY2FsZSgxKSU1QyUyMiUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlM0NpZnJhbWUlMjBjbGFzcyUzRCU1QyUyMnNsLWRlbW8lNUMlMjIlMjBzcmMlM0QlNUMlMjJodHRwcyUzQSUyRiUyRmFwbGlxby5zdG9yeWxhbmUuaW8lMkZkZW1vJTJGa29qZ2hjeDRhanhwJTVDJTIyJTIwbmFtZSUzRCU1QyUyMnNsLWVtYmVkJTVDJTIyJTIwYWxsb3clM0QlNUMlMjJmdWxsc2NyZWVuJTNCJTIwY2FtZXJhJTNCJTIwbWljcm9waG9uZSU1QyUyMiUyMHN0eWxlJTNEJTVDJTIycG9zaXRpb24lM0FhYnNvbHV0ZSUzQnRvcCUzQTAlM0JsZWZ0JTNBMCUzQndpZHRoJTNBMTAwJTI1JTNCaGVpZ2h0JTNBMTAwJTI1JTNCYm9yZGVyJTNBbm9uZSUzQiU1QyUyMiUzRSUzQyUyRmlmcmFtZSUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlM0MlMkZkaXYlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTNDJTJGZGl2JTNFJTIyJTJDJTIyY3NzQ29kZSUyMiUzQSUyMiUyMiUyQyUyMmpzQ29kZSUyMiUzQSUyMiUyMiUyQyUyMnRoZW1lJTIyJTNBJTIyZHJhY3VsYSUyMiU3RA== |
|---|
|
...
For a given currency version, year, and Lead Currency, the spreadsheet must have the currency type in column 1, the Included Currency to in column 2 and the 12 Months in the remaining columns.
...
Select or drag-and-drop the excel file on the Load data from Excel widget.
| View file |
|---|
| name | Sample Upload for Default Rates.xlsx |
|---|
|
...
Exchange rates loaded from excel are incrementally loaded to ApliqoFPM. If an included currency is missing from the excel sheet, that currency is not loaded from excel.
...
Click on the Copy popup found on the Enter Currency Rate widget.
...
| Aura html |
|---|
| params | JTdCJTIyaHRtbENvZGUlMjIlM0ElMjIlM0NkaXYlMjBzdHlsZSUzRCU1QyUyMndpZHRoJTNBNTAlMjUlNUMlMjIlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTNDc2NyaXB0JTIwc3JjJTNEJTVDJTIyaHR0cHMlM0ElMkYlMkZqcy5zdG9yeWxhbmUuaW8lMkZqcyUyRnYxJTJGc3RvcnlsYW5lLmpzJTVDJTIyJTNFJTNDJTJGc2NyaXB0JTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2RpdiUyMGNsYXNzJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBzdHlsZSUzRCU1QyUyMnBvc2l0aW9uJTNBcmVsYXRpdmUlM0JwYWRkaW5nLWJvdHRvbSUzQWNhbGMoNjguOTklMjUlMjAlMkIlMjAyN3B4KSUzQndpZHRoJTNBMTAwJTI1JTNCaGVpZ2h0JTNBMCUzQnRyYW5zZm9ybSUzQXNjYWxlKDEpJTVDJTIyJTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2lmcmFtZSUyMGNsYXNzJTNEJTVDJTIyc2wtZGVtbyU1QyUyMiUyMHNyYyUzRCU1QyUyMmh0dHBzJTNBJTJGJTJGYXBsaXFvLnN0b3J5bGFuZS5pbyUyRmRlbW8lMkZjcXJwendlcnBvanQlNUMlMjIlMjBuYW1lJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBhbGxvdyUzRCU1QyUyMmZ1bGxzY3JlZW4lM0IlMjBjYW1lcmElM0IlMjBtaWNyb3Bob25lJTVDJTIyJTIwc3R5bGUlM0QlNUMlMjJwb3NpdGlvbiUzQWFic29sdXRlJTNCdG9wJTNBMCUzQmxlZnQlM0EwJTNCd2lkdGglM0ExMDAlMjUlM0JoZWlnaHQlM0ExMDAlMjUlM0Jib3JkZXIlM0Fub25lJTNCJTVDJTIyJTNFJTNDJTJGaWZyYW1lJTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQyUyRmRpdiUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlM0MlMkZkaXYlM0UlMjIlMkMlMjJjc3NDb2RlJTIyJTNBJTIyJTIyJTJDJTIyanNDb2RlJTIyJTNBJTIyJTIyJTJDJTIydGhlbWUlMjIlM0ElMjJkcmFjdWxhJTIyJTdE |
|---|
|
Select the Currency Version to copy from. Select the period to be copied in the From and To fields. Select the currency to be copied or select Total FIN Currency ALL to copy all currencies.
...