his problem requires the use of ACL software, which can be accessed

through the textbook Web site. Information about downloading and using ACL and

the commands used in this problem can also be found on the textbook Web site. You

should read all of the reference material preceding the instructions about "Quick Sort"

before locating the appropriate command to answer questions a. through c. For this

problem, use the "Invoices" file in the "Sales and Collection" subfolder under tables in the

ACL_Rockwood project. This file contains information on sales invoices generated during

calendar year 2014, including those that have been paid versus those still outstanding. The

suggested command or other source of information needed to solve the problem requirement

is included at the end of each question. pg 260 Auditing and Assurance Services 16th edition

a. Obtain and print statistical information for Invoice Amount. What is the total

amount of invoices generated during the year? Any invoices have a negative value?

(Statistics)

b. What is the total amount of invoices still outstanding (not yet paid) at the end of the

year? Note the file includes a default payment date for unpaid invoices that will be

updated once payment is received. (Summarize)

c. From the summary created in part b. above, click on the "Outstanding" invoices to

examine the details of those still outstanding. Sort the "invoice_date" column in

ascending order. What concerns do you have, if any, about the collectibility of the

invoice amounts? (Quick Sort)

d. How might the evidence obtained in parts a. through c. above help the auditor in testing

accounts receivable?