3 Replies Latest reply on Jun 16, 2009 10:57 PM by John A Booth

    Exchange Rate Calculations in FDM

      I have a requirements where data import into FDM will happen in local currency but export into HFM will happen in USD. we would need to multiply the input amounts with exchange rate amounts.

      has anyone handled such a requirement? any pointers in this regard would be useful
        • 1. Re: Exchange Rate Calculations in FDM
          Just out of curiousity - why would you do the currency translation inside FDM and not in HFM? HFM is a consolidation tool that has built in currency translation functionality. It does not require any scripting in HFM to do this. FDM does not have native currency translation functionality and any solution would involve heavy customization.

          You would have to do this through customization in FDM, though it will be extremely involved. You will have to try to store FX rates for the Balance sheet (End of month rates) and for the P&L accounts (Average rate or weighted average). Many companies translate the values for the P&L using the periodic consolidation method. This does not take a local currency YTD balance and multiply it by that month's P&L rate - instead it takes period 1's periodic value at the Period 1 FX rate, takes period 2's local currency value * the period 2 FX rate, etc. It then adds all periods together to get a YTD USD balance. Building that functionality into FDM (periodic consolidation), in addition to grabbing the right FX rates for each account type would be very customized.

          I would push back on this requirement if possible. I struggle to see the value add if it is something that HFM can do with 15 minutes of set up versus hours of FDM customization.


          Robert Cybulski, CPA
          Finit Solutions
          1 person found this helpful
          • 2. Re: Exchange Rate Calculations in FDM
            thanks a lot for the advice. the requirement above was a an inquiry about whether this can be done in FDM. I was also of the idea that this is best left for HFM to do it.

            I was initially thinking of using logic accounts to do the exercise. But I think I will suggest to the stakeholders to handle this in HFM instead.

            • 3. Re: Exchange Rate Calculations in FDM
              John A Booth
              I agree with Robert that HFM is the proper place for your currency conversion. You would have a very non-standard FDM installation if you were to attempt currency conversion and it will take quite a bit of time to implement it (if possible).