Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Case Summary: ABC Company is a large retailer that collects its order-to-cash data in a large ERP system that was recently updated to comply with
Case Summary: ABC Company is a large retailer that collects its order-to-cash data in a large ERP system that was recently updated to comply with the AICPAs audit data standards. ABC Company currently collects all relevant data in the ERP system and digitizes any contracts, orders, or receipts that are completed on paper. The credit department reviews customers who request credit. Sales orders are approved by managers before being sent to the warehouse for preparation and shipment. Cash receipts are collected by a cashier and applied to a customers outstanding balance by an accounts receivable clerk. You have been assigned to the audit team that will perform the internal controls audit of ABC Company. In this lab, you should identify appropriate questions and develop a hypothesis for each question. Then you should translate questions into target fields and value in a database and perform a simple analysis. Note: Submit your answers for the following Analysis Questions in the text entry field below. List some of the tables and fields from the audit data standard that relate to each question you identified in Part 1. For example, if youre looking for the shipment timing and approval data, you would need the Shipments_Made_YYYYMMDD_YYYYMMDD table and Approved_By, Entered_Date, and Approved_Date fields. AQ2. Are there data values you identified in Part 1 that dont exist in the tables? Explain how you might collect the missing data or where you might locate them
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started