How do you perform automated consolidations of multiple currencies and countries?

While at Sage Summit 2013, a lot of Sage 300 ERP customers and partners a like had this question on their mind: How do you perform automated consolidations of multiple currencies and countries?

What advice would you give?