Vendor Account Balances

[Former Member]

Hi Experts,

I want to get both opening and closing Vendor balances by period wise. I know the tables are BSIK and BSAK, but I would like to know whether any FM's or BAPI's available for an efficient way to generate the reports.

Pls advise.

thanks & regards

sankar.

Edited by: ABAP Learner SR on Sep 27, 2008 9:04 AM

[Former Member · Accepted solution]

Hi,

Use this FM

BAPI_AP_ACC_GETBALANCEDITEMS

Or,

If you want period wise Vendor accout balance

Use this Table,

LFC1 - Vendor master (transaction figures) Like T-Code FK10N.

&& FM for that table READ_LFC1

Thanks,

Durai.V

Edited by: Durai V on Sep 27, 2008 10:22 AM

[former_member181995]

There are plenty of report on system already.

please use SAP reports as much as possible.

S_ALR_87012077 - Vendor Information System

S_ALR_87012082 - Vendor Balances in Local Currency

S_ALR_87012093 - Vendor Business

S_ALR_87012079 - Transaction Figures: Account Balance

Also Check FK10N,F.98

For Customer you can refer:

Edited by: Ámit Güjärgoüd on Sep 27, 2008 9:42 AM

[Former Member]

Hi all,

As u said, i do agree on that there are more std SAP reports, byt my client wants line items of particular month transactions of a vendor with closing balances.

For Ex: In select-options date from 01.07.2008 to 31.07.2008

Then I've to get the closing c/fwd balance of 30.06.2008 as a 1stline, then line items of july month transactions, I've to report them with cumulative balance.

I got a FM for my get period, but I've stuck in to get the closing balance of June (30.06.2008).

I can also write for report coding to get from LFC1 but for efficient way, Im posting for help is it any FM available for the period closing balance of Vendor .

Pls advise.

regards

sankar,

[former_member585060]

Try this Tcode FK10N