Hi all,
I am developing customised FBL3N report as per our client requirement.I searched standard function module for calculating opeing balance for given gl account but didn't find it. so, for calculating opening balance we are using following logic.
SELECT
A~BUKRS
A~HKONT
A~AUGDT
A~AUGBL
A~ZUONR
A~GJAHR
A~BELNR
A~BUZEI
A~BUDAT
A~BLDAT
A~WAERS
A~XBLNR
A~BLART
A~SHKZG
A~DMBTR
A~WRBTR
A~SGTXT
FROM BSIS AS A INNER JOIN SKA1 AS B
ON AHKONT = BSAKNR
INTO TABLE IT_BSIS1
WHERE A~BUKRS IN SO_BUKRS
AND A~HKONT IN SO_HKONT
AND A~BUDAT < SO_BUDAT-LOW
AND A~BLART IN SO_BLART
AND A~GSBER IN SO_GSBER
AND B~KTOKS IN SO_KTOKS.
I am using following code for getting accounting documents for given gl account.
SELECT
A~BUKRS
A~HKONT
A~AUGDT
A~AUGBL
A~ZUONR
A~GJAHR
A~BELNR
A~BUZEI
A~BUDAT
A~BLDAT
A~WAERS
A~XBLNR
A~BLART
A~SHKZG
A~DMBTR
A~WRBTR
A~SGTXT
FROM BSIS AS A INNER JOIN SKA1 AS B
ON AHKONT = BSAKNR
INTO TABLE IT_BSIS
WHERE A~BUKRS IN SO_BUKRS
AND A~HKONT IN SO_HKONT
AND A~BUDAT IN SO_BUDAT
AND A~BLART IN SO_BLART
AND A~GSBER IN SO_GSBER
AND B~KTOKS IN SO_KTOKS.
For closing balance I am doing sum of opening balance and amounts of accounting documents for given gl account.
the problem we are facing is they want output in following format.I am not able to club all this data as per desired output.
please help me to achieve this.
01.06.2011 01.06.2011 Op.Bal. 0835810021 0.00 13,258.00 0.00 13,258.00
30.05.2011 03.06.2011 0008000005 001 0835810021 24,500.00 0.00 24,500.00 0.00
0 0.00 25,000.00- 0.00 25,000.00-
003 500.00 0.00 500.00 0.00
01.06.2011 01.06.2011 Op.Bal. 0835810021 0.00 13,258.00 0.00 13,258.00
30.05.2011 03.06.2011 0030000072 001 0835810021 72,141.72- 0.00 72,141.72- 0.00
0 0.00 73,614.00 0.00 73,614.00
003 1,472.28- 0.00 1,472.28- 0.00
01.06.2011 01.06.2011 Op.Bal. 0835810021 0.00 13,258.00 0.00 13,258.00
04.06.2011 04.06.2011 0030000084 001 0835810021 25,000.00- 0.00 25,000.00- 0.00
0 0.00 24,038.46 0.00 24,038.46
003 961.54 0.00 961.54 0.00
01.06.2011 01.06.2011 Op.Bal. 0835810021 0.00 13,258.00 0.00 13,258.00
23.06.2011 23.06.2011 0012000089 0 0835810021 0.00 10,000.00 0.00 10,000.00
002 10,000.00- 0.00 10,000.00- 0.00
30.06.2011 30.06.2011 Cl.Bal. 999 0835810021 0.00 82,652.46 0.00 82,652.46
Thanks in advance.
Regatds,
Sheela Patil
Edited by: Sheela Patil on Nov 1, 2011 8:42 AM