Hints and tips

How is Average Days to Pay Calculated?

In SYSPRO 6.0 Issue 007, a change was made to the method of calculating Average Number of Days to Pay against a customer.

Previously, the Average number of days to pay calculated against a customer was calculated as in the following example:

   Invoice 1 is settled in 29 days 
   Invoice 2 is settled in 5 days 
   Invoice 3 is settled in 30 days 

The Average number of days to pay is calculated as:

   (29 + 5) / 2 = 17
   (17 + 30) / 2 = 23.5 (rounded to 24)

New fields on the Accounts Receivable Customer Master Balances file/table (ARSBAL/ArCustomerBal) enables the Average number of days to pay to be calculated using the actual number of days to pay divided by the actual number of zero invoices. Using the same example, the Average number of days to pay will now be calculated as:

   (29 + 5 + 30) / 3 = 21.33 (rounded down to 21)