cancel
Showing results for 
Search instead for 
Did you mean: 

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

saurabh_goel6
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

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

Regards,

Sadashivan

Former Member
0 Kudos

Hi,

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