This website is not affiliated with, sponsored by, or approved by SAP AG.

When did the customer make his last payment...

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, Baz, darkduck

When did the customer make his last payment...

Postby 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!
sapnov05
 
Posts: 294
Joined: Sun Feb 06, 2005 8:35 am

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

Postby 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
YYZ_SAP
 
Posts: 1893
Joined: Thu May 08, 2003 11:44 am
Location: YYZ

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

Postby 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.
sapnov05
 
Posts: 294
Joined: Sun Feb 06, 2005 8:35 am

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

Postby 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
YYZ_SAP
 
Posts: 1893
Joined: Thu May 08, 2003 11:44 am
Location: YYZ


Return to Financials

Who is online

Users browsing this forum: Google [Bot] and 7 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.