Can someone please help with an issue I'm having with GL Consolidation in 5.6.  The Consolidated Company (a separate database) and GL is Multicurrency (CAD), one source company is Multicurrency (CAD) and imports fine, the other is Multicurrency (USD) and when I try to import it I get the "Bad Currency" error.  I can confirm that in the import unit maintenance, the functional currency does match the import file (i.e. USD), however am still getting this error. 

What I am trying to achieve is to have the CAD source GL Transactions imported in CAD, the USD source GL Transactions imported in USD (with a functional currency balance CAD calculated using a monthly average rate).  I was then going to run the revaluation process over the USD Balance Sheet GL Accounts in the Consolidated Company to revalue these at the month end rate.  This way I have FX Profit and loss and Equity transactions recorded in the Consolidated company at the monthly average rate, and the FX balance sheet recorded at the month end rate (with an unrealized FX gain/loss being the balancing account).  Combined with the CAD balances this should provide a complete consolidated overview without the need for Excel.

Any assistance would be much appreciated. Thanks