In your USD company GL export setup you must select Multicurrency Destination Company and Translate To Different Functional Currency and then select CAD in Currency Code.

You must also use a Mapping Table, in the Mapping Table you must select the Rate Type.

In your Exchange Rates you must have a rate for USD to CAD.

Thanks Ettienne.  Are you saying that GL Consolidations does not allow the consolidated company to import/maintain GL transactions/balances in both source currency (USD in this case) and functional currency (CAD)?  Or that I have to use a mapping table to achieve this (something I haven't done)?

I was trying to avoid using the mapping table because of the maintenance required, but can do so.

Just a general question in relation to he mapping table, Is it possible to use the mapping table only for some GL Accounts, or does it have to be populated for all GL Accounts?  What happens if a GL Account mapping is missing?   I would like to setup an import mapping from the Canadian entity just for intercompany GL Accounts so they can be eliminated from the financial reporting.

No I'm not saying that "GL Consolidations does not allow the consolidated company to import/maintain GL transactions/balances in both source currency (USD in this case) and functional currency (CAD)".

GL cons exports the transactions with USD being the source currency and CAD being the functional currency - hence you need to "Translate To Different Functional Currency = CAD".

Save yourself the hassles and use the mapping table for all GL accounts. Look at the options for Mapping in Export Setup. I've done thousands of these... just do it that way.

PS... I designed the software.

That makes sense, thanks.  I will do some more testing and find out why I was unable to import transactions in source currency.  Is it possibly that both the source and destination companies are multicurrency?  

Re the mapping table, when you have a customer that is constantly adding new GL Accounts, is the best practice to maintain the mapping table in Excel and use the export/import function, or is there an easier way?

Both companies can be multicurrency, or single currency - it does not matter as long as your setup is correct.

I use a macro to maintain the mapping table, customers run it before doing an export and it adds missing GL accounts. The macro simply runs an SQL query to add the missing GL accounts.

Both companies can be multicurrency, or single currency - it does not matter as long as your setup is correct.

I use a macro to maintain the mapping table, customers run it before doing an export and it adds missing GL accounts. The macro simply runs an SQL query to add the missing GL accounts.

I have another series of questions regarding GL Consolidation please:

1.What is the best approach to use for importing data into a separate consolidation entity? Balances (for opening GL Balances), and then Net Changes (for monthly GL Account Balance movements)?  Or Transactions (by Fiscal Period or Posting Seq)?  My concern is to avoid duplicating data on import or missing data so am looking for best practice please.

2. What is the best process to correct the consolidation entity if there has been duplication of imported data, or other errors with data imported for a particular month?

Thanks

Is Anyone able to assist with these queries please:

1.What is the best approach to use for importing data into a separate consolidation entity? Balances (for opening GL Balances), and then Net Changes (for monthly GL Account Balance movements)?  Or Transactions (by Fiscal Period or Posting Seq)?  My concern is to avoid duplicating data on import or missing data so am looking for best practice please.

2. What is the best process to correct the consolidation entity if there has been duplication of imported data, or other errors with data imported for a particular month?

Thanks