Professional Application Case:

Adventure Sports Adventure Sports is a new chain of retail stores with both online and brick-and-mortar locations. They sell a variety of outdoor activity and sports products ranging from water sports to mountaineering and camping. The company is growing quickly, currently operating ten stores across five states. These stores are supplied with products from a distribution center that receives all its purchased products from vendors. Online sales are processed out of Adventure Sports distribution center. The brick-and-mortar stores focus on high-quality customer service and offer classes for new outdoor sports enthusiasts. The company has developed strong relationships with its vendors and its customers. Customers tend to return to the stores, demonstrating significant customer loyalty. Because Adventure Sports is growing so quickly, they want to automate more inventory purchasing processes to make them more efficient and effective, with better internal controls. What follows is an entity-relationship diagram (ERD) showing the tables and variables involved in the process. Four tables depict the entity-relationship diagram (E R D). The first table on the left titled, Vendor Master File, presents a list of data as follows: Vendor I D, Vendor Name, Vendor Address, Vendor City, Vendor State, Vendor Zip, and Vendor Pay terms. The second table beside the first table titled, Purchase Order, presents a list of data as follows: PO No, Vendor I D, Vendor Name, P O Date, P O Item I D, P O Item Description, P O Item Cost, P O Item Quantity, and P O Expected P receipt Date. The third table beside the second table titled, Receiving Report, presents a list of data as follows: R E C N O, P O No, Vendor I D, Vendor Name, Item I D, Item Description, Rec Item Quantity, and Rec Date. The fourth table on the right titled, Invoices, presents a list of data as follows: Invoice NO, PO No, Vendor I D, Vendor Name, Item I D, Item Description, Invoice Quantity, Invoice Item Cost, and Invoice Total.

PAC 10.1Accounting Information Systems: Use Process Automation for Accounts Payable Data Accounting Information Systems

You are the systems accountant reviewing the accounts payable process to approve vendor invoices for payment. Currently, the process requires manual matching between the invoice, receiving report, and purchase order to approve the invoice for payment. You have interviewed the AP clerk and the financial accountant and noted that to approve an invoice for payment, the following conditions must be met: The invoice data must match the data included on the purchase order including, VendorID, ItemID, and Quantity. The invoice data must match the data included on the receiving report including VendorID, ItemID, and Quantity Use Alteryx to build a workflow that results in two outputs: a file that is Okay to Pay invoices and a file that is Exceptions.