CA Clarity Tuesday Tip: Managing List of Data with Different Currencies

Discussion created by Kathryn_Ellis Employee on May 14, 2014
Latest reply on May 28, 2014 by samos2

How does Clarity manage list of data with different currency codes?

Within an investment, if the investment is not associated with an Entity, you can define and change the investment currency code at any time. Simply changing the currency code on an investment does not perform any recalculations on the existing number values within the investment to convert the data using the currency code foreign exchange rate. Other investments may be associated with an Entity that has specific currency codes defined. Once an investment is associated with an Entity, the investment currency code will use the defined codes in the Entity and cannot be changed. If the investment does not have any financial transactions created, the Investment billing currency code can be changed.

The Investment Cost Plan has two views. The 'Investment Currency View' allows the user to see the cost plan data with the investment currency code. This is the native amounts saved within the investment when the cost plan is created. The 'Billing Currency View' allows the user to see the cost plan data with the billing currency code and the monetary values are converted using the defined foreign exchange rates.

With an Object List View, it is possible to have a list of investments with different currency codes. Any monetary fields included in the list view configuration will simply display as the saved numerical value; no conversion calculations are applied. Therefore it is important to also include the currency code field on the list view so that the end-user will be aware of the meaning of the saved values.

With an Investment Hierarchy List View, there are limitations on how investments can be added as a 'Child' or 'Parent' investment. Only investments belonging to the same Entity or with no Entity association are shown on the 'Add Parent' or 'Add Child' pages. The reason for the limitation is that the Investment Hierarchy, Financial Roll-up list has to only allow investments within same Entity for one currency as our List Views and Hierarchical Grids are not Multi-Currency aware. It is up to the user, when selecting investments that do not belong to an Entity to be aware of the currency of the investment being added to the hierarchy. If an Investment Hierarchy includes a investments with different currencies, the end-user can create filters to manage the list for displaying aggregations that roll-up data for the same currency code. The list of hierarchy investments can also be exported to Excel for further manipulation by the end-user for converting and comparing monetary values.