Customer Balance Report

[former_member234033]

Hi Gurus

I want to generate a report having following column

Customer Name

Invoice Number

Invoice Date

Invoice Net Amount

Invoice Due Date

Payment received (adj against that Invoice only)

Invoice Balance

Please let me know Table and Fields from where I can get this details.

If any one have similar report, please submit code.

Thanks

Sunil Kolambkar

[Former Member]

Try going to SQVI and create a new query with table join for tables VBRK, VBRP, BSEG, BSID.

With transaction SQ01 AND SQ02 you can select the fields which you want to see in your report.

Just try and let me know if it works

Regards

Ravi

[Former Member]

Check FBL5N. It should partially serve the purpose.

Regards,

Rajesh Banka

[Lakshmipathi]

Dear sunil

As for as Invoice datas are concerned, you can use VBRK and VBRP. For Payment details, use BSEG.

thanks

G. Lakshmipathi

[Former Member]

Hi,

You can extract the following informations from :

VBRK (Billing document Header Table)

VBRP (Billing document Item Table)

For Payment recieved you need to check with FI table (BSAD).

Reward points if this help.

Regards,

Harsh