information required

[Former Member]

I want to generate a report where, if i specify a date i get info on the total amount i have received from a particular customer. How can I generate this report. What would be the the table and field used for genrating this report

[srinivasavepa]

Hi Shanta,

Please check the table, which consists of the cleared items of the customer. From this table, you can get the required information .

Srinivasa Vepa

[srinivasavepa]

It is BSAD table.

[sridhar_muthekepalli3]

Hi:

You can use the SAP Standard Report

FBL5N - Display/Change Line Items

Give customer no,company code, date and select open items/cleared items/all items check box.

You will find all the information you need.

Please let me know if you need more information.

Assign points if useful.

Regards

Sridhar M

[Former Member]

i have checked the customer line items it gives the list of all open , cleared and all item list but if there is down payment it shows in the special GL. but in the report i want a total of all the payments made by the particular customer so what do yuo think will it be useful if i check up customer payment history report