The subsequent audit operations.Jason elected to include the following items in the audit work file (1) account number,(2) name,(3) address,(4) credit limit, 5) current balance, (6) last invoice (sale) date,(7)last invoice amount, (8) last credit(payment or credit memo) date, a(9) last credit amount.
An audit record containing these data was created for each customer account record, and these audit records were written in sequential order onto a separate audit work file.
The second run also performed a variety of edits and other tests on the information recorded on the merged master and transaction file,
and it printed an exception report containing the results of these tests.
For each set of customer records all sales on account were added to the all sales previous balance, and all cash collections and credit memo amounts were subtracted;
whenever the result was not equal to the customer's current balance amount, the GAS was directed to print all data pertaining to the account on an exceptiorr report.
A series of edit checks were also performed on selected data fields, with all erroneous records listed on the exception report. Among the edit checks performed in this case were validity checks on the transaction codes and dates, a complete- ness test of each type of record, a sign test of the current balance, field checks of all numeric fields, and a sequence check of each file based on account number.
These various tests identified a few minor errors in the records.
After further investigation Jason concluded that these errors had a negligible effect on NBS's accounts, that they were probably caused by inadvertent mistakes in data entry, and that they did not have serious implications with respect to the overall reliability of NBS’s accounts receivable information.