Table for customer and vendor balance

[Former Member]

Hi

Please let me know the table from where we can get closing balance of a vendor as well as customer. I want this for entering into customer and vendor confirmation correspondence

[Former Member · Accepted solution]

Hi,

Refer the following link:

http://www.sap-img.com/financial/important-tables-in-sap-fi.htm

[Former Member]

Hi,

Please find below some table details related to your requirement.

BSIK - Vendor open items

BSAK - Vendor cleared items

BSID - Customer open items

BSAD - Customer cleared items

Hope this informatin will helpful for you.

Thanks & Best Regards,

M.Ganesan

[Former Member]

Use LFC1 for Vendor Totals

Use KNC1 for Customer Totals

Regards,

Chintan Joshi

[Former Member]

I tried for vendor. Its showing one line item in the table with Rs. 500000 Debit.

In open items in FBL1n is as follows:

2,500,000.00 (Advance)

500,000.00-

551,500.00-

551,500.00-

551,500.00-

Total of above is 345500 debit.

Why this difference is coming

Edited by: Deepak Agrawal on Jun 2, 2010 1:45 PM