This problem requires the use of ACL software, which can be accessed through the textbook website. Information about downloading and using ACL and the commands used in this problem can also be found on the textbook website. 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. 

Required:

a. Obtain and print statistical information for Invoice Amount. What is the total amount of invoices generated during the year? Do any invoices have a negative value? 

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. 

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?

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