Customer payments

[Former Member]

Hi all

Is there any report to see how much a customer paid against an invoice (we post items as residulas on payment) without having to subtract the residual item from the original invoice number in the fbl5n screen?

Thanks in advance for all your efforts to figure this out...

[Former Member · Accepted solution]

heloo murugappan,

i hav a solution for u..i hope it can be helpfull for u..go to fbl5n and give customer and execute. select billing document in lay out..click on top of billing document and click on subtotals in menu bar. i.e adjecent symbol of summation. u will get

details of how much payment u got against your invoice..

I think it is helpful to u..

Regards,

Vasanth.

[Former Member]

Hi,

Are you using the sort key in the customer master? If not, Create a sort key for reference field. The assignment field will then contain the common reference field for invoice, payments and residual items. Try sorting the line item report FBL5N by this assignment field. and getting the data you want.

Rgds

Shivram.

[Former Member]

HI,

Please check for all standard available reports on customers in TCode f.99.

IF useful grant points to me,

Thank you,

Purnachandra RM

[Former Member]

Hi

Which version of SAP are you using. From ERP 2005 onwards, SAP has a sub module called Collections Management. Using that module, you can see the partial payments against an invoice. If you are using a version lower than ERP 2005, you may have to develop the report.

Regards

Mahendra

[Former Member]

Hi

We use EcC 5.0...but my point is not to see partial payments but to see how much a customer paid against an invoice as a residual payment actually clears the whole amount & posts the balance as open item..

Thanks

[Former Member]

Hi,

In FBL5N select the Cleared Items button, then you will see the full amount of the payment and you can link this to the invoices that were paid using the clearing document number.

[Former Member]

Hi Peter

I know that. Actually I wanted to see the exact payment amount on the screen as a report without having to refer to the reference number & then going to the open item list to find out how much was paid.

I want to see a list of payments the customer made the last 4 or 5 times. I dont know if SAP has a standard report because whenever we make a residual payment, it creates a new invoice for the balance amount & clears the whole of the original invoice..I dont know if I am explaining the right way...basically all payment amounts of the customer

Thanks

[Former Member]

muruggan

I am not sure but I think if you are using lockbox, then log of imported checks might provide the information you are looking for. we use a customized report for the same requirement that you asked for..

[Former Member]

Dear Narayanan,

Use transaction FD11. Enter the customer, company and fiscal year. Go to the payment history tab. You will get what you need I think and much more.

Regards,

Vishal.