We currently have a cube view built out to compare specific GL account values from quarter to quarter. Some of these values needs to be translated using using FX rates. We have AverageRate and ClosingRate, but when assigning the Currency in the Cube view it seems to default to AverageRate, but the requirement is to be using ClosingRate values.
Is this best way to do this through an XFBR rule? Help is greatly appreciated, thanks!
Hi Andy
What type of accounts are these? Typically you would expect the accounts to translate based on their account type:
and the cube properties:
What is the purpose of the comparison cube view? Are you expecting the accounts to translate at closing rate in the cube view, and at average rate during consolidation?
Hi MarkBird ,
Two of these accounts are liability and one is an asset account.
The purpose of the cube view is just to view balances for these accounts for certain entities. The ask is just to have the cube view display the translation using period ClosingRates for review purposes checking values in the GL.
Hope this information helps and thank you your help!
Have you configured flows for this accounts? I assume you are referring to the the EndBal or equivalent member, that looks something like this?
If so, make sure the Switch Type is set to false. Else it will treat those intersections a P&L (it will convert at average rate).
