The ABC Company sells mass-produced items to retail stores on credit. At the beginning of each month, ABC sends each customer a monthly statement that lists all sales transactions for the previous month. Customers must pay by the 20th of the month. If they have not paid by then, they will not be allowed to make any additional purchases on credit, but will have to pay for all subsequent deliveries at the time of the delivery (C.O.D.). The database for ABC Company’s revenue cycle includes the fol¬ lowing tables and attributes:

Required

a. List the control procedures that should be applied to every new customer order. {Hint: you may wish to review Chapter 10 for a description of common threats and control procedures, and Chapter 8 for a description of various input controls.) Identify the attribute(s) to which a particular control applies, explain the purpose of the control, and explain how the control accomplishes that purpose.

b. Design a form in Access (or any DBMS to which you have access) to record customer orders. Implement the controls you listed in step a in your form.

Transcribed Image Text:

Table Name Inventory Customer Take Customer Order Customer Order-Inventory Attributes Item #, quantity-on-hand, quantity-available, standard cost, list price, discount allowed (Y/N), description, weight Customer #, name, zip code, account balance, credit limit Order #, date, total amount of order, instructions Order #, item #, quantity ordered, price per unit