This problem requires the use of ACL software, which is included in the CD attached to the text. Information about installing and using ACL and solving this problem can be found in Appendix, pages 838-842. You should read all of the reference material preceding the instructions for "Quick Sort" before locating the appropriate command to answer questions a-e. For this problem use the Metaphor-AR-2002 file in ACL-Demo. The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.
a. Determine the total number and amount of September 2002 transactions in the file. (Filter, Count, and Total Field)
b. Determine and print the total amount for each of the five types of 2002 transactions for comparison to the general ledger. (Summarize) Which transaction type has the highest count?
c. For sales invoices (IN), determine the number of transactions, total amount, largest amount and average size. (Filter and Statistics)
d. Determine the number of days difference between the invoice date (DATE1) and the due date (DUE) for sales invoices (IN) and evaluate the internal controls over these two dates. (Computed Field)
e. To better decide the sales invoices to select for testing, you decide to stratify 2002 sales invoices (IN) after excluding all invoices less than $300. Print the output. (Filter and Stratify)