preview

CAUA 8 Essay

Decent Essays

Q 1: Perform Verify and Count Commands for all three tables and identify any exceptions.
Verify Tests: 0 data validity errors detected in Jaysberg_Auth_Prices, Jaysberg_Sales_Returns, and Jaysberg_Sales_Trans, and the counts were respectively: 101, 55, and 383.

Count Command:

Q 2: Test the accuracy of the monthly postings to the general ledger. Note that the table includes a month code. Monthly sales per the general ledger are provided below:

I compared the monthly postings to the general ledger, and the general ledger amounts and found there were no errors. The accuracy of the monthly postings is satisfactory.
Q 3: Perform the following tests of controls. For each control state the command or commands that you did to test the …show more content…

Commands: I did a count command on the Shipping document number column, and the sales invoice number column, and both columns contained 383 records. I also visually skimmed the columns to make sure there were no blank cells. I then performed a duplicates command on both columns to make sure there were no duplicates, and each sales invoice had a unique shipping document number.
Results: I have determined there is a shipping document number for each sales invoice number.
b. Determine the two product numbers with the largest total dollar sales for subsequent follow-up to verify the selling prices and quantities shipped.

Commands: I first used the classify command. I used the Product number as the “classify on option”, and the total selling price in the subtotal field. Then, I clicked the File button so I could sort the results by descending order for total selling price. I used the Total command to find the total price of the unit selling price*units shipped, and then compared that with the total selling price. They weren’t the same, so I found the difference.
Results: The two product numbers with the largest unit selling prices were 726, and 988. The unit selling price*units is $7,133.98 higher than the total selling price. We need to do further investigation.
c. Determine the two product numbers with the largest unit selling prices for subsequent follow-up to verify the unit selling prices.

Commands: In the

Get Access