When did the customer make his last payment...

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, Baz, darkduck

Post Reply
sapnov05
Posts: 295
Joined: Sun Feb 06, 2005 8:35 am

When did the customer make his last payment...

Post by sapnov05 » Fri Jul 27, 2018 5:20 pm

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!

YYZ_SAP
Posts: 1897
Joined: Thu May 08, 2003 11:44 am
Location: YYZ

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

Post by YYZ_SAP » Sat Jul 28, 2018 1:00 pm

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

sapnov05
Posts: 295
Joined: Sun Feb 06, 2005 8:35 am

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

Post by sapnov05 » Sat Jul 28, 2018 4:33 pm

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.

YYZ_SAP
Posts: 1897
Joined: Thu May 08, 2003 11:44 am
Location: YYZ

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

Post by YYZ_SAP » Tue Jul 31, 2018 11:29 am

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

Post Reply