Program Description
This program can be found on the Collections Reports menu (CO-4-10). The purpose of the report is to provide an aging breakdown of the money that has been received in the current month. For example, the report displays how much of the paid amount is for invoices that are over 120 or 90 or 60 days old. The paid invoice is linked to the last collection activity record found in the Collection Activity (COL.DT) file. If a payment has been made and a customer's last collection activity record has a contact date after or equal to the date of the invoice, the report records the payment collection as Cash. If there is no last collection contact or the date of the last contact is prior to the invoice date, the payment is recorded as Non-Collection Cash.
Payment information comes from the Cash Receipts data file (CRECD) that is updated by the Cash Posting program and also creates the data for the Cash Receipt Journals. Once the AR Billing End of Month Procedures are performed, payment data is purged. The report includes all Payments (PMT), Cash on Accounts (COA), Returned Checks (R/C), and Non A/R Cash received within the current month and entered in the Cash Posting program. Adjustments, allowances, and transfers are not included.
The report can be sorted by customer number or branch/customer number. The report can also be sorted by user initials of the collection person or the person who made the last collection contacts. Also displayed is the total amount of money that was received using the contacts of a specific collection person. There is also the ability to include only past due invoices that have been paid by selecting a range of days past due.
The report can be run in detail or summary:
When the report is run in detail, it prints a line for each payment that is made on an invoice. The customer to which the invoice is assigned is included. The total payment amount of all invoices is included as well as the aging totals for each amount.
When the report is run in summary, the total payment amount and aging period is printed. No detail on customers or invoices is included.
Rev 14 Changes
If the aging breakdown totals at the end of the report were over 9 million dollars, the amount would print with a #. The program was modified so that the aging breakdown totals can print larger numbers.
Rev 13 Changes
The following field has been added:
Invoice/Customer
Option 5 has been added to the Sort By list. This allows the user to sort by invoice number, then customer number. There is a total payment amount and aging breakdown for all customer payments that are included on the report. The report results are similar to the sort by customer number.
Results
The following screen display shows the detailed results for all dates, all branches, all Collector's initials, and all days past due. It is sorted by option 5 Invoice/Customer:
