Skip to Content
0
Former Member
Dec 01, 2009 at 07:28 AM

Totalling of GL balances

233 Views

Hi,

I have got a requirement to extract monthwise summary GL balances. I have already extracted the individual transaction details from BSEG.

Now, I need to calculate the final closing balance for the month, in respect to individual GL accounts. The calculation for a single GL account (BSEG-HKONT) will be :

(sum of BSEG-WRBTR for Debit) - (sum of BSEG-WRBTR for Credit).

The extract file will contain a single line for individual GL account and corresponding debit/ credit closing balance.

Please help in this regard.

Thanks,

Hari.