Consolidation, Translation Methods, and Foreign Currency

Question about how NAV handles currency conversions on consolidations.

Our client has subsidiaries in France (EUR) and UK (GBP). We're consolidating up to a European consolidating company with a currency of EUR so we're going through a currency conversion when rolling up UK to Europe.

Our Balance Sheets account Translation Method in the UK and Europe companies are all set to 'Closing Rate'. When we closed January (1st month in system) we rolled the UK balances @ an x-rate of 1.0406. Now, we're consolidating February @ a rate of 1.107. The problem we're running into is this: Consolidated A/R balance <> FR A/R Balance + (UK A/R Balance * 1.107). It's off due to the fact that the January A/R balance in the consolidated company is at a rate of 1.0406 as opposed to 1.107.

Is there a different process for running consolidation in a foreign currency environment to ensure that that consolidated balance sheet account balances reflect the closing rate?

Mark