Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

how to get a gl balance for a date

Former Member

‎09-08-2009 5:51 AM

0 Kudos

Hi,

I am trying to develop a reprt for a gl transaction from user entered date. The problem i am facing is fi table contains data for a period. So whenevri try to fetch opening balance it comes from start of the month not from any date into the maonth say 10th.

Please provide me code to capture the balance of gl in any day of the month.

CHEERS

5 REPLIES 5

former_member198275
Active Contributor

‎09-08-2009 5:59 AM

0 Kudos

why dont u use BSIS and BSAS ?

GauthamV
Active Contributor

‎09-08-2009 6:01 AM

0 Kudos

You can use FBL3N transaction to get G/L balances based on dates.

Also the same you can get using BSIS,BSAS tables.

Former Member
In response to GauthamV

‎09-08-2009 6:32 AM

0 Kudos

Hi,

Thanks for your reply

the table you have given contains the data with document numbers. To calculate the current date balance i have to consider all the documents till date.

For fbl3n please guide me how can i catch the closing balance in report for a particular date. Because when i am running the tcode it is shownig the balance in structure from whic i am not able to get the balance.

Former Member

‎09-08-2009 6:41 AM

0 Kudos

HI,

Why dont you use FAGLFLEXA table which will have the data of all the General Ledger: Actual Line Items.

Regards,

Jyothi.

Former Member
In response to Former Member

‎09-08-2009 6:55 AM

0 Kudos

hi jyothi,

this table give me monthly balace ( periodwise) not daily. If you have code to extract daily balance from the above kindly share it.

Edited by: NITIN on Sep 8, 2009 7:56 AM