Re: Formula for RCM->CAPD

[KASP6281@xxxxxxx]

>From the help text:

Average Days to Pay:  The average days to pay (ADP) is the average number of 
days a customer takes to pay invoices. The panel displays a customer's ADP for 
current, each of the past twelve months, total, and average.
 
CDM does not calculate customer ADP internally, the value is captured from 
the Customer Master file. The formula uses to determine ADP is described as 
follows:
 
First, the invoice Days to Pay is determined for each invoice, using the 
formula I = P - D.                                              
 
Where:
 
    I     Invoice days to pay
    P     Date of the invoice payment
    D     Invoice date
 
The Invoice Days to Pay is then used to determine the customer ADP, using the 
formula N = (I * .1) + (C * .9).
 
    Where:
 
    N     New current ADP value.
    I     Invoice days to pay.
    C     Current ADP value from the RCM file.
 
After N is determined, it is used as the value of C for the next ADP 
calculation.