fi report to find last payment date

[former_member184551]

Hi guys

How can i find the last payment date of a customer.

Suppose a customer has a balance of 100 $ as of today and he clears an amount of 20 $ tomorrow so 21.10.2008 becomes his latest payment date, where will this be stored any idea?

Thanks

[former_member184551]

thanx guys

[Former Member]

IN KNKK table there is a field CASHD & CASHA.check if this works.

otherwise do this,

there will be a doc type for customer payment (DZ or something)

give that doctype in BKPF and get the line items from BSEG and filter it based on customer number.

Sort the records based on the posting date descending.first record would give the last payment.

[Former Member]

Try table BSAD.

Do transactions FBL5N or FD10N give you what you need?

Rob

Edited by: Rob Burbank on Oct 20, 2008 5:07 PM