cancel
Showing results for 
Search instead for 
Did you mean: 

Table for customer and vendor balance

former_member221515
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Answers (2)

Answers (2)

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
0 Kudos

Use LFC1 for Vendor Totals

Use KNC1 for Customer Totals

Regards,

Chintan Joshi

former_member221515
Active Contributor
0 Kudos

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