Case A: PureProducts Company (Purchasing and Receiving Processes)

The PureProducts Company sells medical supplies to hospitals, clinics, and doctors offices. PureProducts uses an ERP system for all of its business processes. These supplies are maintained on a real-time basis in an inventory database in an enterprise system. The inventory records include reorder points for all regularly used items and one or two preferred vendors for each item. Vendors are researched and approved by the purchasing manager before being added to the vendor database by a clerk designated to maintain the database. PureProducts employs the following procedures for purchasing and receiving.

Throughout the day, the supplies clerk receives from the enterprise system an online report listing those items that have reached their reorder point. The clerk reviews the report and creates a purchase requisition by filling out a requisition form in the companys enterprise system. Each requisition has a unique identifier, and after creation, the purchase requisition data and inventory master data are updated to reflect the purchase requisition. Inventory manager approval is required for purchases over $1,000 and not covered by a blanket order. The inventory manager can log on to the enterprise system any time to look at open purchase requisitions that require approval and to approve those requisitions by checking the acceptance box. The computer records these approvals on the purchase requisition data.

Throughout the day, buyers in the purchasing department receive from the enterprise system online approved requisitions with a list of appropriate vendors. They select a vendor and enter PO data. After the PO is saved, the purchase requisition data and inventory master data are updated. The completed, prenumbered PO is then printed in the purchasing department and mailed to the vendor.

The receiving department inspects and counts the goods when they are received, compares the count to the packing slip, pulls up the PO in the enterprise system, and enters the quantity received. The PO and inventory master data are updated after the receiving record is saved. The general ledger master data are also updated to reflect the increase in the inventory balance.

Instructions: Create several examples of database tables used in the Order Entry/Sales process.