Simpson Case ACL
Simpson Company ACL Assignments
Chapter 7
Question 4. Determine whether the record counts in the three tables are consistent with the information you received from the IT department.
Simpson master file of accounts receivable has 64 records which is consistent with IT.
Simpson shipping documents for cut-off tests has 47 records which is not consistent with IT records that totals 45.
Question 5. Determine if the amounts for each of the four transaction types are consistent with the information you received from the IT department.
The number of IN sales invoices totals $1,525,763,83. This is consistent with what IT has said.
The number of PM payments from customers totals $-890,466.09. This is not consistent with what IT totaled to be $860,466.09.
The number of CM credit memos totals $-191,358.22. This is not consistent with what IT totaled to be $181,276.35.
The number of WO write-offs totals $-4,725.85. This is not consistent with what IT totaled to be $4,725.85.
Question 6. Determine whether there are any transaction types other than the four included in the introduction to the case. List the exceptions, if any, and describe the likely cause of exception.
Exception(s):
The transaction number 924 has a transaction of IY.
Cause(s):
The reason for IY is because it is a typo, it should say IN. We figured this out because the document number for the IY is I-88496 which is consistent with document types for IN.
Question 7 Determine the customer name for any customer records you identified with the unusual transaction type. Even though customer names are not included in the sales transaction table, this table can be related to the Simpson master file table, which does include names.
We discovered the customer number 262001 from the sales transaction table and filtered this number in the Simpson master file. The name that is linked to this customer number is Bully Industries.
Question 8. Determine the 12/31/14 balance in
Chapter 7
Question 4. Determine whether the record counts in the three tables are consistent with the information you received from the IT department.
Simpson master file of accounts receivable has 64 records which is consistent with IT.
Simpson shipping documents for cut-off tests has 47 records which is not consistent with IT records that totals 45.
Question 5. Determine if the amounts for each of the four transaction types are consistent with the information you received from the IT department.
The number of IN sales invoices totals $1,525,763,83. This is consistent with what IT has said.
The number of PM payments from customers totals $-890,466.09. This is not consistent with what IT totaled to be $860,466.09.
The number of CM credit memos totals $-191,358.22. This is not consistent with what IT totaled to be $181,276.35.
The number of WO write-offs totals $-4,725.85. This is not consistent with what IT totaled to be $4,725.85.
Question 6. Determine whether there are any transaction types other than the four included in the introduction to the case. List the exceptions, if any, and describe the likely cause of exception.
Exception(s):
The transaction number 924 has a transaction of IY.
Cause(s):
The reason for IY is because it is a typo, it should say IN. We figured this out because the document number for the IY is I-88496 which is consistent with document types for IN.
Question 7 Determine the customer name for any customer records you identified with the unusual transaction type. Even though customer names are not included in the sales transaction table, this table can be related to the Simpson master file table, which does include names.
We discovered the customer number 262001 from the sales transaction table and filtered this number in the Simpson master file. The name that is linked to this customer number is Bully Industries.
Question 8. Determine the 12/31/14 balance in