Covert GL balances after changing Master Data - Balance in Local Currency

Gurus!

We have a requirement where the client has opted for several GL accounts to be set to 'Balance in Local Currency'. These are open item managed balance sheet type accounts. These accounts have been posted to as well.

However, for subsequent reporting, now it is realized that some of these accounts need to have tranaction currency balances as well.

Other than reposting and using another GL account, if you could suggest any program either to :

1. Convert the existing local currency balances into transaction currency balances

or

2. Generate a report reflecting transaction currency balances irrespective of the fact whetehr the accounts are maintained with 'Balance in Local Currency'. Please note, I am interested in balances only. Running line item display is NOT an option because of hughe amount of data.

Regards

Saurabh