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.
|Order Form||Bicycle Assembly|
|Purchase Order||Receive Supplies|
|Customer Transactions||Manufacturer Transactions|
|Company Operations||Bicycle Industry Value Chain|
Rolling Thunder Home Page
Management Information Systems Textbook
Database Management Textbook
Return to top of Web site.