Skip to Content
Sep 10, 2009 at 09:18 AM

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



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


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.