...
If the Currency Version is being used by a Planning Version, then future exchange rates must be entered to cover the planning months.
Related Links
Setup Currency
Entering Default Currencies
Enter the Closing and Average exchange rates in the Enter Currency Rate widget. All currency rates are entered from the Lead Currency to the Included Currency.
...
Loading Currencies from Excel
...
The currency rates can be loaded from Excel using the Load Currency popup.
See how
Aura html |
---|
params | JTdCJTIyaHRtbENvZGUlMjIlM0ElMjIlM0NkaXYlMjBzdHlsZSUzRCU1QyUyMndpZHRoJTNBNzAlMjUlNUMlMjIlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTNDc2NyaXB0JTIwc3JjJTNEJTVDJTIyaHR0cHMlM0ElMkYlMkZqcy5zdG9yeWxhbmUuaW8lMkZqcyUyRnYxJTJGc3RvcnlsYW5lLmpzJTVDJTIyJTNFJTNDJTJGc2NyaXB0JTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2RpdiUyMGNsYXNzJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBzdHlsZSUzRCU1QyUyMnBvc2l0aW9uJTNBcmVsYXRpdmUlM0JwYWRkaW5nLWJvdHRvbSUzQWNhbGMoNjguOTklMjUlMjAlMkIlMjAyN3B4KSUzQndpZHRoJTNBMTAwJTI1JTNCaGVpZ2h0JTNBNTAlMjUlM0J0cmFuc2Zvcm0lM0FzY2FsZSgxKSU1QyUyMiUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlM0NpZnJhbWUlMjBjbGFzcyUzRCU1QyUyMnNsLWRlbW8lNUMlMjIlMjBzcmMlM0QlNUMlMjJodHRwcyUzQSUyRiUyRmFwbGlxby5zdG9yeWxhbmUuaW8lMkZkZW1vJTJGa29qZ2hjeDRhanhwJTVDJTIyJTIwbmFtZSUzRCU1QyUyMnNsLWVtYmVkJTVDJTIyJTIwYWxsb3clM0QlNUMlMjJmdWxsc2NyZWVuJTNCJTIwY2FtZXJhJTNCJTIwbWljcm9waG9uZSU1QyUyMiUyMHN0eWxlJTNEJTVDJTIycG9zaXRpb24lM0FhYnNvbHV0ZSUzQnRvcCUzQTAlM0JsZWZ0JTNBMCUzQndpZHRoJTNBMTAwJTI1JTNCaGVpZ2h0JTNBMTAwJTI1JTNCYm9yZGVyJTNBbm9uZSUzQiU1QyUyMiUzRSUzQyUyRmlmcmFtZSUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlM0MlMkZkaXYlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTNDJTJGZGl2JTNFJTIyJTJDJTIyY3NzQ29kZSUyMiUzQSUyMiUyMiUyQyUyMmpzQ29kZSUyMiUzQSUyMiUyMiUyQyUyMnRoZW1lJTIyJTNBJTIyZHJhY3VsYSUyMiU3RA== |
---|
|
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. 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.
Copying Rates from another Currency Version
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.
If the historical exchange rates have changed for the Actual Version, then the Reporting Currencies need to be recalculated for the Actual Version.
Aura html |
---|
params | JTdCJTIyaHRtbENvZGUlMjIlM0ElMjIlM0NkaXYlMjBzdHlsZSUzRCU1QyUyMndpZHRoJTNBNjAlMjUlNUMlMjIlM0UlNUNuJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTNDc2NyaXB0JTIwc3JjJTNEJTVDJTIyaHR0cHMlM0ElMkYlMkZqcy5zdG9yeWxhbmUuaW8lMkZqcyUyRnYxJTJGc3RvcnlsYW5lLmpzJTVDJTIyJTNFJTNDJTJGc2NyaXB0JTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2RpdiUyMGNsYXNzJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBzdHlsZSUzRCU1QyUyMnBvc2l0aW9uJTNBcmVsYXRpdmUlM0JwYWRkaW5nLWJvdHRvbSUzQWNhbGMoNjguOTklMjUlMjAlMkIlMjAyN3B4KSUzQndpZHRoJTNBMTAwJTI1JTNCaGVpZ2h0JTNBMCUzQnRyYW5zZm9ybSUzQXNjYWxlKDEpJTVDJTIyJTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQ2lmcmFtZSUyMGNsYXNzJTNEJTVDJTIyc2wtZGVtbyU1QyUyMiUyMHNyYyUzRCU1QyUyMmh0dHBzJTNBJTJGJTJGYXBsaXFvLnN0b3J5bGFuZS5pbyUyRmRlbW8lMkZpZnJ4aTY5YjN2eGwlNUMlMjIlMjBuYW1lJTNEJTVDJTIyc2wtZW1iZWQlNUMlMjIlMjBhbGxvdyUzRCU1QyUyMmZ1bGxzY3JlZW4lM0IlMjBjYW1lcmElM0IlMjBtaWNyb3Bob25lJTVDJTIyJTIwc3R5bGUlM0QlNUMlMjJwb3NpdGlvbiUzQWFic29sdXRlJTNCdG9wJTNBMCUzQmxlZnQlM0EwJTNCd2lkdGglM0ExMDAlMjUlM0JoZWlnaHQlM0ExMDAlMjUlM0Jib3JkZXIlM0Fub25lJTNCJTVDJTIyJTNFJTNDJTJGaWZyYW1lJTNFJTVDbiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUzQyUyRmRpdiUzRSU1Q24lMjAlMjAlMjAlMjAlMjAlMjAlM0MlMkZkaXYlM0UlMjIlMkMlMjJjc3NDb2RlJTIyJTNBJTIyJTIyJTJDJTIyanNDb2RlJTIyJTNBJTIyJTIyJTJDJTIydGhlbWUlMjIlM0ElMjJkcmFjdWxhJTIyJTdE |
---|
|
If the currency rates have changed for the Working Plan Versions, then the working plan version needs to be resubmitted so that the exchange rates are recalculated.
The reported currency of archived versions cannot be recalculated.Applying the Currency Rates
Currency Subsets
Adding a Currency Version
Deleting a Currency Version
Assigning Currency Version to a Working Version