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

<div><br /></div><div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; "><font face="helvetica" style="font-family: inherit !important; "><table width="100%" border="0" cellpadding="0" cellspacing="6" style="font-family: Arial, Helvetica, sans-serif !important; "><tbody><tr><td align="left" valign="TOP" colspan="6"><strong>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]</strong></td></tr><tr><td valign="TOP" align="left" colspan="6"><hr size="1/" /></td></tr><tr><td valign="TOP" colspan="2" width="25%">&nbsp;</td><td valign="TOP" colspan="3" width="50%"><em>Modified</em> 16-FEB-2010 </td><td valign="TOP">&nbsp;</td></tr></tbody></table></font></span><hr size="1" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; " /><p style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; " /><p style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; " /><h2 class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: rgb(51, 51, 51); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(196, 209, 230); padding-top: 0.5em; ">Applies to:</h2><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">Hyperion Financial Management - Version: 9.2.0.0.00 to 11.1.1.3.00 - Release: 9.2 to 11.1</span><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; "><br /></span><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">Information in this document applies to any platform.</span><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; "><br /></span><h2 class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: rgb(51, 51, 51); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(196, 209, 230); padding-top: 0.5em; "><a name="GOAL"></a>Goal</h2><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">When data is translated into another currency, the values in</span><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">&nbsp;</span><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">&lt;entity>do not appear in the Adjustments value for the other currency. Why?<br /><br /><br /></entity></span><h2 class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: rgb(51, 51, 51); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(196, 209, 230); padding-top: 0.5em; "><a name="FIX"></a>Solution</h2><p style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">The currency hierarchy is not "mirrored" when translated, the "Adjustments" value for non-default currencies will never contain translated values from &lt;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).</p><p style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">What will come up in the translated cells is actually reflecting Parent Total (or, when that doesn't exist, &lt;entity Currency Total>), rather than &lt;entity Currency>. So for example, if the GBP / USD rate is 2:<br /></p><table cellspacing="1" cellpadding="1" border="1" align="left" style="font-family: Arial, Helvetica, sans-serif !important; font-size: 13px; "><tbody><tr><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">&lt;entity Currency><br /></td><td align="center" class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">10<br /></td><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">(GBP)<br /></td></tr><tr><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">&lt;entity Currency Adj><br /></td><td align="center" class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">-1<br /></td><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">(GBP)<br /></td></tr><tr><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">&lt;entity Currency Total><br /></td><td align="center" class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">9<br /></td><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">(GBP)<br /></td></tr><tr><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">USD<br /></td><td align="center" class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">18<br /></td><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">(which is <ECT> * the translation rate)<br /></td></tr><tr><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">USD Adj<br /></td><td align="center" class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">18<br /></td><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; "><br /></td></tr><tr><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">USD Total<br /></td><td align="center" class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; ">18<br /></td><td class="km" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-right-color: rgb(196, 209, 230); border-bottom-color: rgb(196, 209, 230); padding-top: 4px; padding-right: 4px; padding-bottom: 4px; padding-left: 4px; vertical-align: top; "><p><br /></p></td></tr></tbody></table><p style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; " /><p style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; ">This is the expected behaviour with default rules. If you want something different, you have to define custom translation rules.</p><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; "><br /></span><font class="Apple-style-span" face="Arial, Helvetica, sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><br /></span></font></div>