GL, Customer and Vendor ledger in opening and transaction format.

[Former Member]

Hi

My client requirement is: Any GL account (FBL3N), Vendor ledger (FBL1N) and customer ledger (FBL5N) should be in format: Opening +/- transactions = closing.

For example, in FBL1N, when we execute for 1st November to 30th November, then it should show opening balance as on 1st November and then transactions between 1st November to 30th November and then closing.

At present, SAP shows only transactions between 1st November to 30th November and does not show opening balance as on 1st november.

Please let me know if there any standard report for such format

[atif_farooq]

Hi:

There is no such standard report in SAP which will provide you customer, vendor and GL reporting in this format. However with the help of ABAP you can easily get such reports developed..There are BAPIs which returns you values at key date.. Please find them

for GL

BAPI_GL_ACC_GETBALANCE

BAPI_GL_ACC_GETCURRENTBALANCE

BAPI_GL_ACC_GETPERIODBALANCES (make use of BSIS and BSAS)

for customer OB

BAPI_AR_ACC_GETKEYDATEBALANCE (make use of BSID and BSAD tables for transactioal data)

for vendor OB

BAPI_AP_ACC_GETKEYDATEBALANCE (make use of BSIK and BSAK )

I hope it will help you.

Regards

[Former Member]

Same way, if i click on open items in FBL1N (Open date: as 30th November 2011), it shows open line items for previous year also. I want that it should be shown as opening as on 1st April 2011 (since we do carry forward activities) and then current years transactions.

Same way when i check any profit and loss A/c, it shows line items for all the years. Ideally is should show current year's line item only..

Please help

[atif_farooq]

Hi:

This is what i told you in my last post. I have not seen any SAP report which shows the cumulative balance carried forward balance to next date for customer , vendor and GL reports. Organizations have ABAPED reports to meet such reporting requirement and sap has provided BAPIs to enhance reporting

Regards