ave days to pay 1

[randva]

Macola 7.5.102e, Pervasive

Does anyone know how Macola calculates the "ave days to pay YTD" and the "ave days to pay Last YTD"?

Thanks in advance for any replies.

 

[crystalreporting]

Portal document 00.659.912:

Progression calculates the average number of days it took a customer to pay as follows:

1. It calculates the number of days it took the customer to pay the current invoice by determining the number of days from invoice date to the final payment date.

2. It calculates the number of days it took the customer to pay all existing invoices excluding the current invoice. (The average days to pay YTD multiplied by the number of invoices paid YTD.)

3. It then adds the two totals together to receive the total number of days (the total now includes the current invoice.)

4. The new total number of invoices paid is calculated by adding 1 to the number of invoices paid YTD.

5. It then divides the total number of days by the total number of invoices to get the new average. (New total days divided by the new number of invoices equals the new average.)

Peter Shirley

http://www.srhconsulting.com