How to match G/L Account balance from FAGL003 using BSEG and BSIS?

[Former Member]

Our trial balance numbers are matching to FAGL003. But, when I am pulling data from BSEG and BSIS for last 20 years and doing the cumulative sum, its not matching. Please advise how can we get balance sheet account ending balance using BSEG and BSIS and which matches to FAGL003?

[sanilbhandari · Accepted solution]

Hello rahulmishra25

If you are on ECC, the GL Balances will always be drawn from FAGLFLEXT and not BSEG+BSIS.

I am not sure, what exactly you want to achieve, but BSEG will also have line items for noted items and other entries which should not be part of your GL Balances. This may not be the most optimum way.

I would suggest you to look at FAGLFLEXT table, if you want to draw up GL balances

Thanks & Regards

Sanil Bhandari

[Former Member · Accepted solution]

Thank You for this help. It helps.