customer statement

[Former Member]

I m creating customer statement . In BSID and BSAD only closed and open items are avilable .Can anyone suggest me in which table the actual amounts paid by the customer are available. or how to calculate the paid amounts from

BSID and BSAD . Thanks regards

[saikrishna_vallurupalli]

Where u have created customer statement?, can u explain indetail.

[Former Member]

I want to create cust a/c statement for credit recovery department.In the statement invoice numbers , payments made if any , amounts credited from cr.memos issued if any and the balance reamining related to that invoice are wanted . And invoice aging also required For eg 'due pending over 30 days' .I appreciate your help .thak you

[saikrishna_vallurupalli]

Hi Reddy,

You can get the customer statement through FB12, where u can select the SP06 FOR ACCOUNT STATEMENT., but u can't get the due pending over 30 days, if u want customized field u can modify the form as per your requirement.

please assign the points if its useful

regards

sai krishna

[Former Member]

Hi Srinivas,

You can find the amount paid by the customer in the same tables. Whenever you receive the payment from the customer you post a document. Select all the documents by document type you will get the total amount paid by the customer.

And there is a standard report in SAP which gives Customer Payment history ( S_ALR_87012177).

Regards

RS