Rolling Thunder Bicycles: Purchase Orders

A relatively straightforward purchase order. It records the employee placing the order, the date, the supplier (manufacturer) and the list of items ordered. Note that it only records the actual price paid, not a "list price." Also note that the order form is used to record receipt of shipments, so we might receive fewer items than we ordered. Inventory is automatically adjusted when items are recorded as received.

To speed data entry, the product number combo box can be restricted to display a limited set of items. Limit either by category or by manufacturer.

Ideally, as noted in the RT exercises, security should be set so that employees who place orders do not have permission to create new suppliers. Security is currently inactive because it tended to cause problems in an educational setting.

Related Information

Order Form Bicycle Assembly
Purchase Order Receive Supplies
Customer Transactions Manufacturer Transactions
Company Operations Bicycle Industry Value Chain
Product Management

Rolling Thunder Home Page

Management Information Systems Textbook

Database Management Textbook

Return to top of Web site.