09-08-2009 5:51 AM
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
09-08-2009 5:59 AM
09-08-2009 6:01 AM
You can use FBL3N transaction to get G/L balances based on dates.
Also the same you can get using BSIS,BSAS tables.
09-08-2009 6:32 AM
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.
09-08-2009 6:41 AM
HI,
Why dont you use FAGLFLEXA table which will have the data of all the General Ledger: Actual Line Items.
Regards,
Jyothi.
09-08-2009 6:55 AM
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