Our company is set up to report is EUR - this means all transactions are (usually) in EUR but our accounting currency is USD as this is what the parent company is so we have both currencies in our TB.
When I go to utilize the ledger settlements (new feature of finance version 10.0.25 is in use) the 'marked' value is my USD translated value that is checked to equal nil to allow the ledger settlement.
The problem is my opening balances - these were recorded at year end at the average rate for the month. The revaluation was run and an FCR entry created to move the exchange rate to the month end exchange rate.
The opening balance is then at the month end exchange rate.
In the new year, the year end entry is automatically reversed by the system and reverses at the ORIGINAL rate (i.e. the av rate for the month) to my amounts do not settle to nil.
I am able to settle the monthly recording and then in the new month reversing as these are done at the same rate.
I note the FCR entries but they combine revaluation amounts for all months and I cannot take a piece to settle my opening balance.
To summarize, how do I settle my opening balance brought forward when it was brought forward at the month end rate the then reversed at the original average rate? 