What is best practice for handling fx rates for forecast or rolling forecast scenarios?

[OSAdmin]

Originally posted by Nick Kroppe

10/6/2018

Hey Guys, what is best practice for handling fx rates for forecast or rolling forecast scenarios? If the client wants different rates by forecast, are there any other options outside of creating a new fx rate type for each forecast scenario?

[OSAdmin]

Originally posted by Chul Smith

i use custom translation rule, too. most customers have used either the most recent average or closing rate from actuals so you can build in that logic. there are some implications if you're doing some wacky translation in the forecast scenario - you can't just pull the rate for that account type for that scenario. you'd need to go to the most recent actual period and find that rate since it was the rate used. but that's where clever scenario names come into play.