Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions