Same G/L Appearing in Both sides Assets and Liabilities

[Former Member]

Dear Experts,

We are facing an issue,

There is one G/L appearing in both sides assets and liabilities.

due to that values are mismatching. Actually it should display the value in Liabilities.

I have checked in ECC also. In FSE3 tcode financial statement version it is displaying in both sides.

When i execute f.01 it is displaying the values in only liabilities.

I asked my client, they are saying that it is possible to maintain in both sides for bank g/l's. If it has Debit value it will display in Assets or if it has credit value it will display in Liabilities side.

But Our 0GL_Account_Hier is displaying both sides of Balance sheet. Query created on 0FIGL_C10.

Please guide me how can i solve this problem.

Thanks,

Nag

[Former Member]

Based in debit/credit it will be appearing along with the indicator. What is your issue?

Regards,

Dilip.

[Former Member]

Hi Dilip,

Thanks for your response.

i have created balance sheet query on 0FIGL_C10.

Rows- 0GL_Account (Hier)  Columns - 0Balance

When i execute the report in Analyzer. there is one G/L displaying balances in both the sides(Assets and Liabilities). Actually it should display in Liabilities only as per R/3 F.01 tocde.

How can i restrict when it is having credit balance it should be into  Liabilites only and When it is having Debit balance it should be into Assets only.

Thanks,

Nag

[Former Member]

Your issue can be addressed with If Else statement.

(CB>0)*Asset+0

(DB>0)*Liability+0

But is your balance matching with R/3, its better you check at the cube level instead of working at query level.

Regards,

Dilip.

[Former Member]

Hi Dilip,

Thank you very much,

Balance are exactly matching with R/3. Except this duplication.

Can you please guide me where and how can write a statement. Plz provide step by step.

Thanks,

Nag

[Former Member]

Create a formula in columns.

Formula1(Assets) : (CB>0)*Asset+0

Formula2(Liabilities) : (DB>0)*Liability+0

Check the following doc from 12th page to find how to create If Else statement.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d08b56a8-daf5-2e10-2397-904d6aeb5...