Question
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
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. Case B: Internet Payment Platform (Purchasing and Receiving Processes) The following describes the purchasing and receiving processes at the United States Department of the Treasurys Bureau of Engraving and Printing (BEP) during a pilot of the Internet Payment Platform (IPP). Components of the IPP include a server with an appreciating database located at Xign, Inc. and an Intel server at BEP called the Enterprise Adapter. BEPs mainframe, legacy enterprise system is called BEPMIS, which has an IDMS network database. Contracting officers (COs) in BEPs Office of Procurement enter purchase orders (POs) into the BEPMIS purchasing module, where they are stored on the IDMS database. Because the IPP does not accommodate a digitally signed PO and does not include sufficient text to comply with the Federal Acquisition Regulation (FAR), POs are printed by the BEPMIS system, signed by the CO, and mailed to the supplier. A routine on the BEPMIS system, written for the IPP pilot, is manually initiated each evening to extract and format POs for suppliers participating in the pilot. The core PO data (vendor, items, amounts, quantities, and so on, but not including additional descriptive and contractual text) are extracted by this routine, as a batch, directly from the IDMS (BEPMIS) database and sent to the enterprise adapter, which converts the PO data from IDMS format into XML, encrypts the batch, and sends it to the IPP server at Xign, where it is stored on the IPP appreciating database. Now a PO record exists on both the IDMS (BEPMIS) database and the IPP appreciating database. After a PO is posted to the IPP database, IPP notifies suppliers via e-mail. Having been notified that a PO has been issued, an employee at a BEP supplier logs on to IPP and reads the POs onscreen. Depending on the nature of the PO and a suppliers policies, its employees might be required to wait for the paper PO before beginning the process of providing the goods, or they might be permitted to act on the electronic PO. The supplier sends the goods with a packing slip to BEP, where receiving personnel record the receipt into BEPMIS (no record of the receipt was recorded on the IPP appreciating database). BEPMIS prints a stock notice, and it and the goods are sent to the warehouse. Instructions:
Develop an Entity-Relationship (E-R) Diagram for the Order Entry/Sales process.
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