Vendor Line item - Opening and closing balance

[former_member601407]

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 ?

[sanilbhandari]

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