Program Description
This program can be found on the System Manager Customer File menu (LMSY-1-1-16). It will calculate the average number of days it takes the customer to pay their invoices and write the average into the Customer File (CUSTD). The number is displayed in the Customer Profile Inquiry (BI-2-2), which can be found on the Billing Inquiries menu. The Customer Profile Inquiry allows the user to recalculate the average days to pay on a specific customer number only. This program will recalculate the average for a range of customers numbers or all customer numbers.
Rev 14 Changes
A new global option was added to the Billing Control File (Global Record 2). This is field number 51 Number Of Months To Calculate Avg Days To Pay (1-99, 0=Entire History). Prior to Revision 14, the average days to pay was calculated by looking at the customer’s AR and AR History. If the system has five years of AR History, then it would use the entire five years in the calculation. This new global option, allows a limit to be set when calculating average days to pay. This field will store the number of months prior to the current system date that should be checked. For example, if a 12 is stored in this field, then only the prior year’s AR and AR History will be included in the calculation. The transaction date on the invoice is that date that is used. If a 0 is placed in this new Global field, then the program will work like it did prior to Revision 14 and use the entire AR and AR History for the customer.
Rev 13
The following prompts are described below:
Beginning Customer #, A'll, Or E'nd
Ending Customer Number
Enter a specific customer number, range of customer numbers or A for all customer numbers. If the ending customer number entered is less than the beginning customer number, the message Beginning Customer Is Greater Than Ending Customer will display and the cursor will return to the ending customer number field for re-entry.
Continue (Y'es Or N'o)
Enter Y for yes to have the program calculate and update the Average Days to Pay field in the Customer file (CUSTD). Enter N for no to cancel the program and return to the menu.
Results
The following screen display shows the results in the Customer Profile Inquiry program. The Avg Days To Pay field is updated:
