Compute Payment Statistics
This routine calculates averages according to the customer payment history. The factors may be viewed from the Address Master screen by executing the Customer Info. function. The totals are shown under abbreviated headings "Average Days To Pay" and "Payment Factor".
The Address Master screen will display two figures in the "Average Days To Pay" field. The totals will be followed by a one-letter abbreviation. "H" for history, "C" for current.
The program calculates these averages based on the following criteria:
Current - calculates the average age of all receivable invoices with an outstanding balance.
History - calculates the average number of days to pay based on all invoices in the A/R system. Invoices that been purged will not be included in this average.
Weighted - calculates average days to pay based on invoice total. This weighted average will tell you if the customer takes longer to pay larger invoices, or vice-versa.
This routine is found on the A/R Main Menu. When selected, the program will begin processing immediately, and the following screen with messages will appear:
SELECTING A/R FILE FOR PROCESSING
NOW PROCESSING TRANSACTIONS
The customer IDs, A/R balances, and dates will be displayed.
SELECTING A/R FOR 2ND STAGE PROCESSING
NOW PROCESSING STAGE 2
The customer IDs will be displayed again, and will redisplay the A/R menu when completed.