Simpson Company ACL Assignments Essay

check off whether the record counts in the three tables are self-consistent with the development you received from the IT department.Simpson master file of accounts due 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. sink if the amounts for each of the four act types are consistent with the information you received from the IT department.The image of IN gross sales invoices totals $1,525,763,83. This is consistent with what IT has said. The second of PM payments from guests totals $-890,466.09. This is not consistent with what IT total to be $860,466.09. The number of CM impute memos totals $-191,358.22. This is not consistent with what IT total 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 thither are any transaction types otherwise than t he four allow ind in the knowledgeability to the case. List the exceptions, if any, and describe the likely pose 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 pass judgment this out because the document number for the IY is I-88496 which is consistent with document types for IN.Question 7 Determine the guest name for any customer records you identified with the unusual transaction type. blush though customer names are not included in the sales transaction table, this table can be related tothe 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.