Work through the samples in the IDEA Manual, Section 2-Accounts Receivable to end of this section this week.NOTE: the page numbers will vary depending on the manual you are using due to operating system differences in your computers.

Hint: Staying actively involved while completing the tutorial assignment will help you to complete the IDEA problems more efficiently.

Please submit your answers to the following problems to your instructor in a Word document. You may need to take a screen shot of your results and copy them into the Word document to upload if asked to perform any analysis using the software

Problem 5a

Open the Sample-Customers file. This file was automatically loaded in when you installed the software in week 1.

The company has a policy that credit limit cannot exceed $100,000.You want to quickly find all of the customers in this database that have credit limits over this amount.

oHow many customers were over $100,000 limit?

Now sort this list by COUNTRY. Hint: Double click the field name for COUNTRY in the report you just created.Print screen the results to submit in with your answer for this problem.

Clear the Criteria

Problem 5b

Using the sameSample-Customers file determine how many companies are owned by someone with the lat name of Reyes. . Hint: when searching for text you must but the words in quote marks and the format has to be exactly like it is in the database so in this case the criteria would be LAST_NAME="REYES".This is because all of the last name are all capital letters. Print screen the results to submit in with your answer for this problem.

oHow many customers have the last name of Reyes?

Close this file

Problem 5c

Open theSample-Detailed Sales file.This file was automatically loaded in when you installed the software in week 1.

You will be creating an aging report using the file listed above.Hint:Click on Analysis, Aging

oEnter in the Aging date as of 12/31/2015.The format for this field is YYYY/MM/DD so you would enter in 2015/12/31

oYou can leave the other information as pre set and click ok.Print screen the results to submit in with your answer for this problem.

Do you see anything unusual about this aging report?

Close this file

Problems 5d

Print the history log for this problem Hint: Use History in the Properties window and be sure to expand all sections by clicking on the + sign. Print screen the results to submit in with your answer for this problem.

IDEA Problem 6

There is technical assistance available for the educational version of IDEA, please contact technical support: 1-888-641-2800 Option#4 or email the help desk at H..k@audimation.com

Work through the samples in the IDEA Manual, Section 2-Accounts Receivable to end of this section this week.NOTE: the page numbers will vary depending on the manual you are using due to operating system differences in your computers.

Hint: Staying actively involved while completing the tutorial assignment will help you to complete the IDEA problems more efficiently.

Please submit your answers to the following problems to your instructor in a Word document. You may need to take a screen shot of your results and copy them into the Word document to upload if asked to perform any analysis using the software

Open the file called Sample-Detailed Sales.

Problem 6a

One aspect of gathering evidence is obtaining copies of invoices. IDEA is useful for testing completeness and finding gaps in invoice numbers. With the Sample-Detailed Sales file open on the Analysis tab, select Gap Detection to open the Gap Detection window. Make sure INV_NO is selected and click ok.Print screen the results to submit in with your answer for this problem.

How many gaps are there within the invoice numbers for the database?

Close the file

Problem 6b

Open the file called Sample-Detailed Sales.

Another aspect of gathering evidence is making sure the data is accurate. IDEA is useful for testing duplicate invoices. With the Sample-Detailed Sales file open on the Analysis tab, select Duplicate Key and select Detection to open the Duplicate Key Detection window.Select Outputduplicate records with key of Inv_No. .Print screen the results to submit in with your answer for this problem.

How many duplicates are there within the invoice numbers for the database?

Why would there be duplicate invoice numbers?

Problem 6c

Print the history log for this problem Hint: Use History in the Properties window and be sure to expand all sections by clicking on the + sign. Print screen the results to submit in with your answer for this problem.

-----------------------------------------------------------------------------------------------------------------

Submit your answers to Problems 5 and 6 in the same Word document.Be sure to label your answers clearly with the problem numbers and clearly identify the print screens of your results.