Currency exchange rates are used to calculate the Reporting CurrencyCurrencies. Account balances are entered in the company’s local currency. The local currency is converted to the Reporting Currencies Currency using the local currency of the company to the Reporting currency selected in the report. This allows for reporting currency exchange ratesand comparisons in a single currency for all the Companies.
All Currency exchange rates are entered in for a Lead Currency for each included Leading Currency to an Included currency. The cross rates are the be calculated by ApliqoFPM. The cross rates can be seen on the Cross Rates tab in on the Currency Conversion page.
The Lead Leading Currency, Reporting Currencies and Included Currencies are set up in the Currency Setup.
...
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 Currencies in Apliqo FPM
...
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.
...
...
The currency rates can be loaded from Excel using the Load Currency popup.
...
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.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.
...
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.
Apply Rates Popup
If the historical exchange rates have changed for the Actual Version, then the Reporting Currencies need to be recalculated for the Actual Version.
Click on the Apply Rates button to open the Apply Rates popup.
...
In the popup select the Period From and the Period To for the period of the rate change. Select the companies that use the rates that have changed as their local currency. Click on the Run button to recalculate the Reporting Currencies for the Actual Version.
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 Reporting Currencies of archived versions cannot be recalculated.
Subsets
Two types of subsets can be defined for the FIN Currency dimension, Static subsets, and Dynamic subsets.
Static Subsets
Static subsets are a list of elements that do not change unless the static subset is redefined.
To define a Static Subset, click on Subsets > Static from the toolbar.
...
To create a new static subset, click on the + button. To change an existing static subset, select the static subset that is to be changed in the left-hand widget. To add an element to the subset, select the element in the middle widget and click on > to add. To remove an element from the subset, right click on the element and select Remove. The order of the elements can be changed by dragging the element up or down the list. To save the changes to the FIN Currency dimension click on Save or Save and Close button.
Dynamic Subset
Dynamic subsets are subsets that change as the dimension changes. Dynamic subsets are defined using an MDX statement for the subset.
To define a Dynamic Subset, click on Subsets > Dynamic from the toolbar.
...
To create a new dynamic subset, click on the + button. To change an existing dynamic subset, select the dynamic subset that is to be changed in the left-hand widget. The middle widget defines the dynamic subset. Enter the MDX statement in the Subset Expression field. Or select from the list of common dynamic subset definitions found in the drop-down menu in the Automated MDX Type field. Selecting an Automated MDX Type may show other options to be configured. Choose to keep the subset dynamic or make it a semi-dynamic using the Keep Subset Dynamic option. Choosing to keep the subset semi-dynamic means that the MDX statement is revaluated each time the dynamic subsets are rebuilt for the dimension. Choosing to keep the subset dynamic means the MDX statement is revaluated each time the subset is used. The right-hand widget shows the elements that make up the dynamic subset. Click on Save or Save and Close to rebuild the dynamic subsets that have been defined for the FIN Currency dimension. Applying the Currency Rates