management reporter multicurrency - revaluation question

(0) Share

Report

Posted on by iruser2

2,048

Hi folks

I am using Management Reporter CU12 2.1.12000.26

I am a Canadian company that wants to show income statement in both functional CAD and non functional USD.

In GP I set tomorrow's exchange rate at 4 pm today with the closing rate from the markets.

When month end falls on a weekday I will get two rates for that day.

At 12:00:01 am the rate is yesterday's close rate.

At 20:00:00 (I assume no one will transact after 8:00pm) I have the month end spot rate.

In management reporter I have a column format that shows my income statement in US. I set currency display = Z-US$

MR sees that I have two rates on my rate table. It is choosing the first rate. I need it to use the second / last if I have more than 2 rates. Is there a setup change I can make, or is MR operating as designed (which would imply I need another rate table that can hold only the month end rates, one per month - highly inefficient).

thanks!

*This post is locked for comments

I have the same question (0)