Skip to Content
avatar image
Former Member

How to get number of Late payments for CA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 20, 2013 at 02:10 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2011 at 09:12 PM

    Hi Murtuza,

    I think you are on right track.

    thanks,

    VR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2011 at 04:21 AM

    You yourself gave the solution.. 😊

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2012 at 04: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

    Add comment
    10|10000 characters needed characters exceeded