Skip to Content
0
Former Member
Nov 01, 2011 at 07:40 AM

Problem in calculating opeing and closing balance in fi report

41 Views

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