Customer Statement

[Former Member]

Hi intellects,

has anyone ever developed customer statment or worked on the tables BSID and BSAD - it is being sent to the customers to keep an acount of invoices sent to them , amount outstanding etc.

its really urgent so plz try ur best to help me.

if possible give ur gmail id if u know about this.

Thanks

[Former Member]

vivek here d example

bsid

belnr amount rebzg

160001 200 18000

160002 300

160003 400

no entry for 18000 here.

bsad

augbl belnr amount rebzg

16002 16002 11000

16002 18000 11000

[former_member193831]

hi Aman,

I have worked on the customer account stamt. The tables.

What is exact query?

Rgds

Vivek

[Former Member]

actually wat is happening is an invoice 1800000(110000) has four payment documents al less than it .now a payment document(16000220) is created by the tester yesterday with an amount 11000 clearing the same invoice.

now two entries have been created in bsad one for payment and another for invoice.

due to this the entry for invoice in bsid has got vanished but all the four payment docs still hold the invoive number in rebzg field , so how should it be displyed i mean should hthose four docs have any link to the invoice noe or are they open.

plz if u have a sample code jus temme my job is at stake.