Calculate future period rates in the Consolidated Exchange Rates page

Solution:

 

The future period rates in the Consolidated Exchange Rates page were taken from the currency exchange rates at the time the accounting period (base period) was created in NetSuite.

For example, you created a new base period (i.e. Mar 2015) for Q1 2015 today.  If you check the consolidated exchange rates for Mar 2015 period under Lists > Accounting > Consolidated Exchange Rates, you will notice that the rates were taken from the latest rates that you have in the Currency Exchange Rates page.