{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T03:31:30-04:00", "answer_date": "2024-06-28 03:31:30", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4229857", "url": "\/study-help\/questions\/work-through-the-samples-in-the-idea-manual-section-4229857", "question_creation_date_js": "2024-06-28T03:31:30-04:00", "question_creation_date": "Jun 28, 2024 03:31 AM", "meta_title": "[Solved] Work through the samples in the IDEA Manu | SolutionInn", "meta_description": "Answer of - Work through the samples in the IDEA Manual , Section 2-Accounts Receivable to end of this section this week .NOTE: th | SolutionInn", "meta_keywords": "work,samples,idea,manual,section,2-accounts,receivable,end,week,note,page,numbers", "question_title_h1": "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", "question_title": "Work through the samples in the IDEA Manual , Section 2-Accounts Receivable", "question_title_for_js_snippet": "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 same Sample 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 the Sample 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 O utputduplicate 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 ", "question_description": "

Work through the samples in the IDEA Manual<\/em><\/strong>, Section 2-Accounts Receivable <\/strong><\/em>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. <\/em><\/p>

<\/p>

Hint<\/em><\/strong>: Staying actively involved while completing the tutorial assignment will help you to complete the IDEA problems more efficiently. <\/p>

<\/p>

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 <\/em><\/p>

<\/strong><\/p>

<\/strong><\/p>

Problem 5a<\/strong><\/p>

Open the Sample-Customers <\/strong>file. This file was automatically loaded in when you installed the software in week 1. <\/p>

<\/p>

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. <\/p>

oHow many customers were over $100,000 limit?<\/p>

<\/strong><\/p>

Now sort this list by COUNTRY. Hint<\/strong>: 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.<\/em><\/p>

<\/strong><\/p>

Clear the Criteria<\/p>

<\/strong><\/p>

<\/strong><\/p>

Problem 5b<\/strong><\/p>

Using the sameSample-Customers <\/strong>file determine how many companies are owned by someone with the lat name of Reyes. . Hint<\/strong>: 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.<\/em><\/p>

oHow many customers have the last name of Reyes?<\/p>

<\/p>

Close this file<\/p>

<\/strong><\/p>

<\/strong><\/p>

Problem 5c<\/strong><\/p>

Open theSample-Detailed Sales <\/strong>file.This file was automatically loaded in when you installed the software in week 1.<\/p>

<\/p>

You will be creating an aging report using the file listed above.Hint<\/strong>:Click on Analysis<\/strong>, Aging<\/strong><\/p>

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<\/p>

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.<\/em><\/p>

Do you see anything unusual about this aging report?<\/p>

<\/p>

Close this file<\/p>

<\/p>

Problems 5d<\/strong><\/p>

Print the history log for this problem Hint<\/strong>: Use History<\/strong> in the Properties<\/strong> 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.<\/em><\/p>

<\/p>

<\/p>

IDEA Problem 6<\/em><\/strong><\/p>

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<\/em><\/strong><\/p>

<\/em><\/strong><\/p>

Work through the samples in the IDEA Manual<\/em><\/strong>, Section 2-Accounts Receivable <\/strong><\/em>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. <\/em><\/p>

<\/p>

Hint<\/em><\/strong>: Staying actively involved while completing the tutorial assignment will help you to complete the IDEA problems more efficiently. <\/p>

<\/strong><\/p>

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 <\/em><\/p>

<\/strong><\/p>

<\/strong><\/p>

Open the file called Sample-Detailed Sales<\/strong>.<\/p>

<\/strong><\/p>

Problem 6a<\/strong><\/p>

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 <\/strong>file open on the Analysis<\/strong> tab, select Gap Detection<\/strong> to open the Gap Detection<\/strong> window. Make sure INV_NO is selected and click ok.Print screen the results to submit in with your answer for this problem.<\/em><\/p>

<\/p>

How many gaps are there within the invoice numbers for the database?<\/p>

<\/p>

Close the file<\/p>

<\/strong><\/p>

Problem 6b<\/strong><\/p>

<\/p>

Open the file called Sample-Detailed Sales<\/strong>.<\/p>

<\/strong><\/p>

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

<\/p>

How many duplicates are there within the invoice numbers for the database?<\/p>

Why would there be duplicate invoice numbers?<\/em><\/p>

<\/p>

<\/strong><\/p>

Problem 6c<\/strong><\/p>

Print the history log for this problem Hint<\/strong>: Use History<\/strong> in the Properties<\/strong> 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.<\/em><\/p>

<\/p>

<\/p>

<\/strong><\/p>

-----------------------------------------------------------------------------------------------------------------<\/strong><\/p>

Submit<\/u><\/strong> 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. <\/p>

<\/strong><\/p>", "transcribed_text": "", "related_book": { "title": "Global Strategy", "isbn": "0357512367, 978-0357512364", "edition": "5th Edition", "authors": "Mike W. Peng", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/649592eaa157d_32303.jpg", "uri": "\/textbooks\/global-strategy-5th-edition-9780357512364", "see_more_uri": "" }, "free_related_book": { "isbn": "1478219440", "uri": "\/textbooks\/one-year-later-the-wall-street-reform-and-consumer-protection-act-implementation-of-title-vii-1st-edition-978-1478219446-253474", "name": "One Year Later The Wall Street Reform And Consumer Protection Act Implementation Of Title Vii", "edition": "1st Edition" }, "question_posted": "2024-06-28 03:31:30", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/on-december-31-20x1-a-company-purchased-1-million-of", "description": "On December 31, 20X1, a company purchased $1 million of 10-year, 10% debentures for $885,300. The market interest rate was 12%. 1. Using the balance sheet equation format, prepare an analysis of bond...", "stars": 3 }, { "url": "\/study-help\/essentials-of-understanding-behavior\/how-might-the-fundamental-attribution-error-apply-to-sterlings-view-1980484", "description": "How might the fundamental attribution error apply to Sterlings view that his players were ungrateful?", "stars": 3 }, { "url": "\/hospitable-co-provides-the-following-sales-forecast-for-the-next", "description": "Hospitable Co. provides the following sales forecast for the next four months: The company wants to end each month with ending finished goods inventory equal to 25% of next months sales. Finished...", "stars": 3 }, { "url": "\/study-help\/questions\/5-revenue-on-the-income-statement-was-145100-accounts-receivable-9837286", "description": "-...5 Revenue on the income statement was $145,100. Accounts receivable were $3,400 on January 1 and $3,700 on December 31. Unearned revenue was $1,000 on January 1 and $1,600 on December 31....", "stars": 3 }, { "url": "\/study-help\/questions\/an-investment-project-costs-1-6-8-0-8178700", "description": "An investment project costs $ 1 6 , 8 0 0 and has annual cash flows of $ 3 , 9 0 0 for six years. a . What is the discounted payback period if the discount rate is zero percent? Discounted payback...", "stars": 3 }, { "url": "\/study-help\/questions\/the-international-space-station-considers-what-many-believe-to-have-1000486", "description": "The International Space Station considers what many believe to have been the ultimate international engineering project in history. The initial plans involved the direct participation of 16 nations,...", "stars": 3 }, { "url": "\/study-help\/questions\/two-days-after-talking-with-karen-daniel-received-a-packet-1211230", "description": "Two days after talking with Karen, Daniel received a packet of information from the mayor s office. The information included news clippings, minutes from community meetings, and the telephone numbers...", "stars": 3 }, { "url": "\/study-help\/questions\/decedent-is-a-citizen-of-the-philippines-and-a-resident-4621348", "description": "Decedent is a citizen of the Philippines and a resident of Quezon City, died leaving the following: Rest house in Batangas inherited from his father during marriage Car received as gift from his...", "stars": 3 }, { "url": "\/study-help\/questions\/ion-16-of-21-identify-whether-each-scenario-is-4760063", "description": "ion 16 of 21 > Identify whether each scenario is an example of a marginal cost, marginal benefit, or neither. Answer Bank a marginal cost. not marginal. a marginal benefit. Chipset, Inc. sells...", "stars": 3 }, { "url": "\/study-help\/questions\/choose-23-changes-you-would-consider-making-to-deal-with-1050414", "description": "Choose 2-3 changes you would consider making to deal with some of the potential issues that might be leading to turnover. what key concepts you think apply, some potential solutions to the problem...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/61-discussion-government-vs-forprofit-statementsdiscussion-topic-starts-nov-30-4229856", "next": "\/study-help\/questions\/in-the-market-for-apartments-for-rent-prices-are-too-4229858" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Work through the samples in the IDEA Manual , Section 2-Accounts Receivable", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/work-through-the-samples-in-the-idea-manual-section-4229857" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }: "1" } }