Balance Sheet

[Former Member]

Hi Experts,

I want to prepare balance sheet in the following format:

I tried with the following tcodes but the client wants the above format:

FAGLGVTR to carry forward the balance.

f.01,  S_ALR_87012252, S_ALR_87012301 , S_ALR_87013336 , S_ALR_87012277  ,S_ALR_87012279

S_ALR_87012252: actual/actual periodic comparision,

S_ALR_87013336: Profit centre wise report

S_ALR_87013612: cost cetre wise

S_ALR_87012301: Trail balance report

S_ALR_87012277: G/L Account Balances   (Trail balance report)

S_ALR_87012279: structured account balances (structure that we have declared in  financial statement version –OB58

Since I don't have much experience in SAP, could anyone please tell me is balance sheet in above format is really possible in SAP? If yes, please guide. I would be grateful. If not also, what could be the best solution?

Thanking in advance

Mani

[suma_mani]

Hi Mani,

You can able to create same report with using of report painter or else discuss with technical team with proper functional specs to do the same.

All cumulative values can get in FAGLFLEXT table or GLT0 table.

For report painter transaction codes are FGI4 where you create form & FGI1 to create report with using of above form.

Regards

Mani

[Former Member]

Thanks for your kind suggestion. But i am not able to understand all liabilities & Assets in table FAGLFLEXT'.

In my report i want  the following format:

Liablities         Amount                               Assets       Amount

Capital Account                                        Fixed asset    

Secured loan                                            Investment

Current liablities                                        Fixed deposit

                                                                 Current Asset

                                                                Loans & Advance

                                                                 Tax receivable.(Input tax,Input vat,Tds receivable)

At the end I want opening and closing balance.

Can u elaborate where I may get those fields and in which Table.

Regards

Mani

[suma_mani]

Hi Mani,

You have to do GL accounting grouping for that either in Z table or else financial statement version. Mentioned link can help you.

http://scn.sap.com/thread/1077669

Don't forget all values must be fetch from FAGLFLEXT table only or GLT0

Regards

Mani Kumar