Share
Report
2,046Hi 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
All responses (
Answers (
