Skip to Content

Vendor Line item - Opening and closing balance

Hi Guys,

We are creating a custom vendor/customer/GL report (combined FBL1N FBL3N FBL5N) to show the all transactions posted. Also the opening balance is to be calculated, for eg: posting date in input screen is 01.08.2019 to 31.08.2019, then the opening balance is to be start of that vendor transaction to 31.07.2019 and closing balance is to be start of that vendor transaction upto 31.08.2019.

But how to arrive at that logic with the table BSIK and BSAK ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 22, 2019 at 11:17 PM

    Hi

    There are BAPI available to do that

    BAPI_AR_ACC_GETBALANCEDITEMS Customer account clearing transactions in a given time period

    BAPI_AR_ACC_GETCURRENTBALANCE Closing balance of customer account in current fiscal year

    BAPI_AR_ACC_GETKEYDATEBALANCE Customer account balance at a key date

    BAPI_AR_ACC_GETPERIODBALANCES Posting period totals per customer account in current fiscal year

    BAPI_AP_ACC_GETBALANCEDITEMS Vendor Account Clearing Transactions in a given Period

    BAPI_AP_ACC_GETCURRENTBALANCE Vendor Account Closing Balance in Current Fiscal Year

    BAPI_AP_ACC_GETKEYDATEBALANCE Vendor Account Balance at Key Date

    BAPI_AP_ACC_GETPERIODBALANCES Posting Period Balances per Vendor Account in Current Fiscal Year

    Regards

    Sanil Bhandari

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.