Customer/Vendor/ GL Totals........

[Former Member]

Hi,

Kindly guide me from which table i can get balance as of date of customer/ vendor / Gl.

I am getting only total open items from BSIS/ BSID/ BSIK table, but client requirement is Balance as of date or given date.

Regards,

Venkat

[Former Member]

Hi,

I hope you are using ECC.

We can have a work around.

For e.g. we can find out the balances of GL accounts period wise for Debit and Credit Balances separately from Table FAGLFLEXT.

Like wise for customer it is KNC1.

And for Vendors it is LFC1.

After this you can find out the difference between these two entries to arrive at the balance per period.

Hope this info is of some use to you.

Appreciate if you can award points if found useful.

Regards,

Venkat

[former_member581688]

Within the classic GL, there are not any tables that contain balances as of a particular date. The only balance tables are by posting period. They are:

GLT0 - G/L account transaction figures

KNC1 - Customer monthly transaction figures

LFC1 - Vendor monthly transaction figures

In the New GL, I understand it is possible to set up a separate ledger for daily balances, however, I do not have experience with the new GL.

Regards,

Shannon

[Former Member]

Hi,

For vendor use table BSAK and for customer usetable BSAD.

with regards,

Sudipto

[Former Member]

Dear Paul,

Hope you understood my requirement. We need Yet to date Balance of customer/vendor/ Gl.

We able to get closed document details from below table.

Regards,

Venkat

[Former Member]

Please use for vendor balances:-

S_AC0_52000888

Regards,

Alok

[Former Member]

Dear Alok,

Thanks for your kind reply, Very gladfull if you could have given Table names instead of Tcode.

We need table names.

Regards,

Venkat