How is Average Days to Pay calculated in Customer Maintenance?

Note: This information is also available in the on-line Help screens. Use the Index search and type "calculating average days paid".
The calculations that follow are performed in the order shown for each invoice processed in the Cash Receipts Journal update. The average is based on the most recent 20 invoices so that the total days (and invoice) do not become too large.

• NOI = Number of Invoices to use in Days calculation (Limited to range of 0 to 20)
• ADP = Average Days Payment from Invoice Date (Posting Date ? Invoice Date)
• In versions 3.71 through 4.05, this field is found in the AR1 file, Field 1, Starting Position 316, Length 3.
• In version 4.10 and later, this field is found in the AR_Customer file, Field 49

                  (Total Days for last 20 invoices ) ( Avg. Days for this invoice )
                  (Previous ADP x Previous NOI ) + ( Post Date ? Invoice Date )
ADP =       --------------------------------------------------------------------------------------
                  (Previous NOI + 1 (Limited to 20) )

• ADO = Average Days Overdue from Invoice Due Date (Posting Date ? Invoice Date)
• In versions 3.71 through 4.05, this field is found in the AR1 file, Field 1, Starting Position 319, Length 3.
• In version 4.10 and later, this field is found in the AR_Customer file, Field 50

                 (Total Days for last 20 invoices ) ( Avg. Days for this invoice )
                 (Previous ADO x Previous NOI ) + ( Post Date ? Invoice Date )
ADO =      ----------------------------------------------------------------------
                (Previous NOI + 1 (Limited to 20) )

• NOI = Number of Invoices to use in Days calculation (Limited to range of 0 to 20)
• In versions 3.71 through 4.05, this field is found in the AR1 file, Field 1, Starting Position 322, Length 3.  
• In version 4.10 and later, this field is found in the AR_Customer file, Field 48

NOI = Previous NOI + 1 (Limited to 20)