Program Description
This report is located in the Accounts Receivable Accounting Reports II menu and the Billing Reports Accounting Reports II menu (AR-4-2-3 & BI-4-6-3). When a customer name is entered, it gives the total of each customer’s A/R balance for amounts both current and past due, according to each aging period. A final total of these accounts is given at the end of the report.
Rev 14 Changes
Internal changes were made to create the temporary indices in the program larger.
Also, screen displays during processing were removed in order to speed up the programs speed on Non-SuperDOS systems.
The report will now ask for a range of company numbers, and branch numbers. Both are stored in the Accounts Receivable file (ARECD).
The report will also ask the operator to enter specific Item Types to be printed, or “ALL” to print all item types. The Primary Item Type On Invoice field in the Accounts Receivable file (ARECD) is used to determine if an invoice should print on the report.
When the report is ran for a range of company numbers, range of branch numbers, or specific item types, the report will not check to see if there is a variance between the customer’s account and the AR Balance. Since all of a customer’s invoices are not printed, every customer could have an AR Variance.
The report can now also be ran for a range of customer numbers. This is the customer number for the Bill-To Customer from the Accounts Receivable File (ARECD).
Example:
Results:
The report will now also print two additional totals at the end of the report. These are the total customers on the report and the total past due customers on the report.
Rev 13 Changes
This report has been revised to correct the situation in which the customer number and accounts receivable balances were not printing correctly when there was a variance between the accounts receivable detail and the customer file accounts receivable total.
A temporary index was enlarged to prevent the Index File Full stop.
Also, the problem was corrected with the Illegal Filename stop at line 3992 if printing to a disk during the End of Month Report chain.
Internal program changes were also made to have the port number used instead of task number to name the temporary index.
Results
Following is a screen display of a summary report for all AR balances sorted by customer name:
