How to get number of Late payments for CA

[murtuza_chhatariya]

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

[Former Member]

Hi Murtuza,

I think you are on right track.

thanks,

VR

[raviahuja]

You yourself gave the solution..

[murtuza_chhatariya]

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 · Accepted solution]

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