SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get number of Late payments for CA

murtuza_chhatariya
Active Participant
0 Kudos

Hi,

I have a requirement in which I need to find number of late payments in last one year for a particular CA.

I think I can query on DFKKOP in which clearing date is after net due date. Is this way correct or i need to take care of any other thing?

Thanks,

Murtuza

1 ACCEPTED SOLUTION

murtuza_chhatariya
Active Participant
0 Kudos

I used query on DFKKOP and DFKKKO where XBLNR is provided in this way only line items related to invoices were taken.

View solution in original post

4 REPLIES 4

former_member215295
Contributor
0 Kudos

Hi Murtuza,

I think you are on right track.

thanks,

VR

raviahuja
Contributor
0 Kudos

You yourself gave the solution..

murtuza_chhatariya
Active Participant
0 Kudos

Hi All,

The above mentioned way is not complete logic. It has many complexities.

First, Late payments should be counted per invoice. If there are subitems and if they all are paid after due date then also it should be considered one late payment as per invoice amount.

Another thing about Account maintenence, it generates open item for open credit and clears it. Here it does a trick, it generates item with past due date and clears with current date and makes it obvious late payment which is in fact early payment!!

Please let me know if you have any proper logic to derive late payment count.

Thanks,

Murtuza

murtuza_chhatariya
Active Participant
0 Kudos

I used query on DFKKOP and DFKKKO where XBLNR is provided in this way only line items related to invoices were taken.