Reconciliate when having subsidiary views for fx rate

Options
johan.marketoft
johan.marketoft Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor
in Planning & Modeling

Hi,

 

I have an actuals module that has all transactional data from the actuals in local currency. In there I created a line item, Amount FX, that has a subsidiary view since it has the FX Rate dimension added to it so it can do the FX rate conversion on the line item Amount.

 

The numbers in the import are validated so they are good but the numbers flowing through to reporting based on this Amount FX line item is off. Problem is when I am going to analyze the problem: I need to go into the subsidiary view to see the conversion but then the filter is broken as subsidiary views doesn't seem to respect filters. I even tried forcing the numbers to go to USD which is the base currency, so basically taking the value times 1 but still getting the incorrect result. (I did SELECT: USD from Currency List).

 

Can someone advice on how to analyze this situation? Or if I should take a very different approach to handling a data module coming in with multiple currencies?

Best regards,

Johan 

Tagged:

Categories