Question
Please download the Roger Company IDEA files, if you haven't already. See instructions for obtaining the Roger Company files in the Chapter 5 assignment Roger
Please download the Roger Company IDEA files, if you haven't already. See instructions for obtaining the Roger Company files in the Chapter 5 assignment
Roger Company's policy is to not ship goods unless a valid purchase order has been received. However, based on information obtained during your walkthrough to confirm your understanding of processes and controls, you learned that occasionally a rush order is received via telephone and the goods are shipped before receiving the purchase order. Rush orders are only processed for existing customers. When rush orders are received the sales person taking the order completes a "Rush Order" form, which is then approved by the sales department supervisor. The "Rush Order" form is then attached to the purchase order when it is received and the details of the two forms (i.e., product and quantity) are compared. To test the effectiveness of the controls around rush orders, you want to identify all instances where product is shipped before a purchase order is received. Using the Roger Company Shipping file, determine the number of invoices related to orders that were shipped before a purchase order was received.
Hint:In the Properties window you can open the equation editor by clicking on Criteria. You will be looking for records where the shipping date is before the order date. If you need to clear any prior Criteria, use Ctrl + E when the Criteria Equation Editor is open. Alternatively, you can create a direct extraction of the pertinent shipments. I need the total number of records
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