GL balances totals by currency

[Former Member]

Hi experts

I am looking for a report that displays GL totals by currency.

FBL3N is not good enough cause it runs on the line items, do even if I exclude the line items from the output and display only the total per currency, it sometimes takes a lot of time (for accounts with many transactions)

Thanks

Ofer

[Former Member]

Hello Kavitha

What is this?

There is no FAGLB03 transaction (or program) in my system.

Thanks

Ofer

[Former Member]

Hi

Have you tried FAGLB03 ?

Regards

Kavitha

[Former Member]

Hi, Thanks

Srinivas, this is not good enough - it's what I have wrote about FBL3N.

Jigar,

In the S_ALR reports you sent there is no total per currency.

The S_PL0 reports you sent dont exist in my system (ver. 4.7)

Any more suggestions?

Regards

Ofer

[Former Member]

Hi,

Please check the following reports:

S_ALR_87012277 - G/L Account Balances

S_PL0_86000030 - G/L Account Balances (New)

S_PL0_86000031 - Transaction Figures: Account Balance

S_ALR_87012301 - Totals and Balances

Regards,

Jigar

[Former Member]

Thanks. This was also an option.

The only problem with the FS10N is that I have to scroll between the different currencies and see every currency in a different page.

[Former Member]

Hello

Try with FS10N,,,,,,,,,,,, and save desired lay out accordingly

Regards

Dinabandhu

[srinivasa_maruvada]

Hi

To resovlve issue, you need crete/ change the layout

Goto TCode FS10N

Select line items

Select Change layout

Select Local currency(S) from the hidden fields and move it to left side

Select Copy

Then set filter as currency

Enter your currency

Cheers

Srinivas