Simpson Company ACL Assignments Essay

delimitate whether the record counts in the three tables are consistent with the information you accredited 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 non consistent with IT records that totals 45.Question 5. desex if the amounts for each of the four achievement types are consistent with the information you received from the IT department.The consider of IN gross revenue 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 act types other th an the four include 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 judge 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 ludicrous transaction type. Even 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.