Currency Translation Adjustment (CTA) in HFM
YohanaFeb 13 2012 — edited Oct 19 2012Dear all,
I'm sure, all of you who has been implementing HFM knows about this CTA. I know how it calculates, I just curious, to which account this CTA normally calculated ? And just to make sure, HFM doesn't have a proper or pre-built calc for this CTA, right ? So, we have to develop our own.
Concerning this CTA on my application, I notice there are only several accounts impacted or requested by user to have a view of CTA. They are Capital, Non Controlling Interest. But when I read in one of HFM book, there might be some other accounts that can have an impact of this CTA. My first question is, how do I know which account will be impacted by CTA ? is that all account that using historical rate only ?
Still related to CTA, to handle this, I created a member called Translation Adjustment in custom dimension. I thought every account can have an impact for this CTA so i put it in Custom dimension. How do you guys handle this based on your experience ? Do you pull everything in one account as Translation Adjustment or do you create a custom dimension just like mine ?
Thanks,
- Anna