Page 1 of 1

When did the customer make his last payment...

Posted: Fri Jul 27, 2018 5:20 pm
by sapnov05
Hi folks,

We are working towards a credit policy in our company and have hundreds of thousands of customers. We need to find out when any particular customer or list of customers made their 'last' payment to us. Is there any simple way to find this out/ Any customer table or FI table that would give us this? I don't want the list of BSID or BSAD - I want to know when the last payment was done among many payments of any particular customer...

thanks a lot in advance!

Re: When did the customer make his last payment...

Posted: Sat Jul 28, 2018 1:00 pm
by YYZ_SAP
Hi,

If you have credit functionality setup you should be able to check the credit master sheet.
Note: there are a number of postings on other sites than this one related to the last payment date of a customer.

Regards,
Jan Pel

Re: When did the customer make his last payment...

Posted: Sat Jul 28, 2018 4:33 pm
by sapnov05
Thanks, Jan. We don't have the credit functionality set up yet, moving towards it, this requirement is in exploratory stage and trying to get the data. Do you know which other sites have this info? I tried SDN but couldn't get anything specific. of course, the S_ALR_87012177 report is there but that only gives the months in which payments were made + the # of times they were made, but not the specific date.

Re: When did the customer make his last payment...

Posted: Tue Jul 31, 2018 11:29 am
by YYZ_SAP
Hi,

I did another search, this time on "sap field last payment date customer".

And I found a number of links, including this one (although unfortunately not applicable for you):
Last Payment date is not Updated in Credit Managment Sheet
https://archive.sap.com/discussions/thread/1656632

But it might provide some clues.
Maybe you need to look into an user exit or BADI to fulfill the requirement.

Regards,
Jan Pel