2007 Nov 14 6:10 AM
Hi friends,
I am creating a report to get the opening balance for the given date.For the select option I am giving the input fields -
company code, g/l account number, posting date.
Is there any function module to get closing balance of the previous period , so that I can directly use it as the opening balance for the required date(period).
Hi friends,
I am creating a report to get the opening balance for the given date.For the select option I am giving the input fields -
company code, g/l account number, posting date.
Is there any function module to get closing balance of the previous period , so that I can directly use it as the opening balance for the required date(period).
2007 Nov 14 6:19 AM
Hi
Use the Tables BSIS and BSAS to calculate the Opening/Closing Balance for the GL accounts based on the posting date
I think there is no straight fun module to calculate this
Regards
Anji
2007 Nov 14 6:20 AM
Hi Ram,
The following BAPI's might help you.
BAPI_GL_GETGLACCBALANCE - closing balance of G/L account for a chosen year.
BAPI_GL_GETGLACCCURRENTBALANCE - closing balance of G/L account for the current year
BAPI_GL_GETGLACCPERIODBALANCES - Posting period balances for each G/L account.
Reward if useful.
Thanx & Rgds.