Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ave days to pay 1

Status
Not open for further replies.

randva

Technical User
Jan 19, 2005
105
US


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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top