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
Showing results for 
Search instead for 
Did you mean: 

closing balance

Former Member
0 Kudos

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).

2 REPLIES 2

Former Member
0 Kudos

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

Former Member
0 Kudos

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.