only balances in local currency

[Former Member]

hi experts

is it possible to select only balances in local currency for the accounts which have balances.

thanks

[Former Member]

can you explain a bit more?

if you want to see the transactions which is made in local currency (that i mean the document currency is local currency) , u can use filter to get the transactions in local currency. or in the selection screen (fbl1n,fbl5n,fbl3n) you can also select document currency type.

[sridhar_muthekepalli3]

Dear suja:

It is possible to select only balances in local currency for the accounts which have balances.

Select the standard report, Enter the GL Accounts and currency type. i.e you can view the accounts in local currency.

Ex: for GL Account balances, select the standard report S_ALR_87012277 - G/L Account Balances,Enter Chart of accounts,GL Accounts,Company code,Account currency as USD for USA or INR for India.

you can view the accounts in local currency.

Please let me know if you want more information.

Assign points if useful.

Regards

MSReddy

[Former Member]

hi sirdhar thank u for responce

and i want to select the only balances in local currency check box also for the accounts having balances.

thank u

[Former Member]

i will explain in details

with out selecting only balances in local currency some gl accounts have been created and posting have been made to that gl accounts.

now i want to select only balances in local currency check box.

this is my requirement.

regards.

[Former Member]

Sys will allow to select Only balence in Local Curriency that G/L should be Balensheet A/C,

Now you wan to Select This Check Box Relevent G/Ls first you should maintain Zero Balences,

any way sys shows both curriencys like Local as well as other Currencys,

If u post inv while using other than comp code currency sys convert into the local currency also,

Regards,

TML

[Former Member]

hi swathi points are assigned

thank u.