Skip to Content
0
Oct 21, 2019 at 11:20 AM

Vendor Line item - Opening and closing balance

254 Views Last edit Oct 21, 2019 at 11:21 AM 2 rev

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 ?