Questions regarding 'Average Days to Pay'

The average days to pay field is calculated by Microsoft Dynamics GP itself, and not Collections Management.

You can get to the field by going to Sales pane >> Cards >> Summary, choose a customer, and then click the Credit Summary button in the lower right hand corner.

The Microsoft Help file describes its calculation the following way:

After a customer has paid his or her first invoice, the average days to pay (ADTP) is calculated based on the number of invoices a customer has, the time taken to pay the first invoice, and the time taken to pay the most recent invoice. The formula for calculating the average days to pay is:

ADTP = (Current ADTP) x (Number of Invoices) + (Number of Days Taken to Pay Most Recent Invoice) / (Number of Invoices + 1)

The time it took to pay the first invoice would provide the initial value for the Current ADTP. Any later invoices paid by this customer will provide the values for the number of invoices and the number of days taken to pay the most recent invoice. The ADTP calculated on the customer’s initial invoices then becomes the “Current ADTP.” You can use this value when you recalculate the ADTP for later invoices.

If you have further questions on Average Days to Pay, please check with your partner or open a ticket with Microsoft support.