10-24-2011 5:23 PM
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
09-20-2013 3:10 PM
I used query on DFKKOP and DFKKKO where XBLNR is provided in this way only line items related to invoices were taken.
10-24-2011 10:12 PM
10-25-2011 5:21 AM
02-16-2012 4:12 PM
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
09-20-2013 3:10 PM
I used query on DFKKOP and DFKKKO where XBLNR is provided in this way only line items related to invoices were taken.