Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos


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.



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos


In FS10N report, if you click the document currency tab, the pop will show you the transaction currency with you can choose and

display the report in transaction currency. Changing the GL Master in FS00 is not possible as transaction data exists.

I have not tried with T.Code MASS with object type BUS3006 for table name SKB1 and field name SKB1-XSALH. Expecting

further replies to this post



Former Member
0 Kudos


1. Check whether any spare GL account which is already created and not using for your day to day account.

2. Transfer existing balances (showing as on date) to that spare GL account through JV (F-02) temporarily

3. Activate 'Only balances in local currency' in GL Master for all GL accounts

4. Reverse the JV created above in step 2.

Try once.

Sarma BH