Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor balance display

Former Member
0 Kudos
237

Hi All,

I need to calculate the vendor balance amount for particular year. Can anyone please let me know related tables for the same and how to find it out.

Thanks in advance!

Regards,

Kannan

5 REPLIES 5

Former Member
0 Kudos
52

Hi ,

you can use BSIK and BSAK for the Vendor opening Balances.

regards

Deepak .

Former Member
0 Kudos
52

Hi,

Table LFC1 will give you year wise monthwise Balances which may be used.

Table: BSIK For opem Vendor Items

BSAK Clear items for Vendors

Regards

Raju chitale

0 Kudos
52

Hi Kannan,

I hope your functional guy let you know the transation to see vendor balance for related year.

Now If you need to calculate vendor balance, two tables will help you, BSAK & BSIK.

BSAK is a vendor cleared item table and BSIK is for open item.

Take absolute sun value from BSAK for given year and add it with BSIK doc. for perticular venrdor and for given year.

Hope it's clear to you.

Regards

Nimesh S. Patel.

Former Member
0 Kudos
52

Hi,

i am sending few table related to vendor balance,

LFC3,

LFAT,

LFZA,

LFA1,

LFB1.

please reward points, if it is useful.

regards,

satish.

Former Member
0 Kudos
52

Hi Nimesh,

Thanks for you reply.

Can you please let me explain, how to find absolute sum amount value for particular vendor in BASK table ( you mean I need to add all enties WRBTR amount value for vendor?). Please confirm it.

Thanks,

Kannan