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.