Knowledgebase: HFM
When Data Is Translated Into Another Currency, The Values In Entity Currency Adjustments Do Not Appear In The Adjustments Value For The Other Currency
Posted by Priya Doyle on 08 December 2010 05:15 PM

When Data Is Translated Into Another Currency, The Values In Entity Currency Adjustments Do Not Appear In The Adjustments Value For The Other Currency [ID 1061185.1]

 Modified 16-FEB-2010  

Applies to:

Hyperion Financial Management - Version: 9.2.0.0.00 to 11.1.1.3.00 - Release: 9.2 to 11.1
Information in this document applies to any platform.

Goal

When data is translated into another currency, the values in do not appear in the Adjustments value for the other currency. Why?


Solution

The currency hierarchy is not "mirrored" when translated, the "Adjustments" value for non-default currencies will never contain translated values from <Entity Currency Adj>; it will only ever contain adjustments explicitly posted against that currency (when it's either the default currency or the parent currency).

What will come up in the translated cells is actually reflecting Parent Total (or, when that doesn't exist, <Entity Currency Total>), rather than <Entity Currency>. So for example, if the GBP / USD rate is 2:

<Entity Currency>
10
(GBP)
<Entity Currency Adj>
-1
(GBP)
<Entity Currency Total>
9
(GBP)
USD
18
(which is <ECT> * the translation rate)
USD Adj
18

USD Total
18


This is the expected behaviour with default rules. If you want something different, you have to define custom translation rules.



(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: