Function module for Opening Balance day wise

[SrihariNerella]

Hi,

I am preparing vendor ledger report for day wise .

For example : i/p fields are : Lifnr , Budat,Bukrs

O/p fields are : Opening balance ( Before the date of lifnr Closing balance ).

Debit

Credit

Closing Balance ( Opening balance + D/C).

For this Opening balance i require the function module .

Please help me .

Regards

Nandan.

[GauthamV]

You can use FBL1N transaction instead of creating a custom report.

[SrihariNerella]

Hi,

My requirement is Vendor balance Report according to Posting date wise.

o/p fields are

blart budat augdt belnr openingbalance ClosingBalance Credit Debit

Credit is when schkz is 'H'.

Debit is when schkz is 'S'.

Closing Balance = Opening Balance + Credit / Debit

Regards

Nandan.

[SrihariNerella]

Using Bapi i got the keydate balance BAPI_AP_ACC_GETKEYDATEBALANCE.

[Former Member]

Hi,

Did you get the solution for this? I am stuck on the same situation. Pl help.

Regards

Purnand