4. THE INVENTORY MANAGEMENT SYSTEM This section documents the Inventory Management System of the Smith's Bikeworks information system. 4.1. STARTING UP Loading up dbase. SCREEN 4-1: STARTING UP THE INVENTORY SYSTEM /-----------------------------------------------------------------------------\ A> \-----------------------------------------------------------------------------/ Look at the screen, and find the "A>". To me, it shows that the computer (defaults and/or) expects me to enter a command. Next, I want to insert the program diskettes, then type dbase, because I want to load dbase III plus. INSERT: Disk 1 of the dbase III plus program in drive A INSERT: Smith's Bikeworks program diskette in drive B TYPE: DBASE PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: load dbase III plus. Q&A 4-1: Why do you type DBASE at the A>? SCREEN 4-2: Load dbase III plus /-----------------------------------------------------------------------------\ ZDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD3 3 dBASE III PLUS version 1.0 IBM/MSDOS DEMO 3 3 Copyright (c) Ashton-Tate 1984, 1985, 1986. All Rights Reserved. 3 3 dBASE, dBASE III, dBASE III PLUS, and Ashton-Tate 3 3 are trademarks of Ashton-Tate 3 3 You may use the dBASE III PLUS software and printed materials in 3 3 the dBASE III PLUS software package under the terms of the dBASE 3 3 III PLUS Software License Agreement. In summary, Ashton-Tate 3 3 grants you a paid-up, non-transferable, personal license to use 3 3 dBASE III PLUS on one microcomputer or workstation. You do not 3 3 become the owner of the package, nor do you have the right to 3 3 copy or alter the software or printed materials. You are legally 3 3 accountable for any violation of the License Agreement or of 3 3 copyright, trademark, or trade secret laws. 3 @DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDY Press the F1 key for HELP. Insert Sampler Disk 2 and press ENTER, or press Ctrl-C to abort. \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word abort. To me, it shows that the computer (defaults and/or) expects me to remove diskette 1 and insert diskette 2 in drive A.. Next, I want to insert diskette 2 of the dbase III plus program and press return to continue loading dbase III plus." INSERT: Disk 2 of the dbase III plus program in drive A PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Continue loading dbase III plus and display the dbase prompt. Q&A 4-2: Why do you insert a second diskette in drive A? 4.2. Display the dbase prompt SCREEN 4-3: Display the dbase prompt /-----------------------------------------------------------------------------\ 3 dBASE III PLUS version 1.0 IBM/MSDOS DEMO 3 3 Copyright (c) Ashton-Tate 1984, 1985, 1986. All Rights Reserved. 3 3 dBASE, dBASE III, dBASE III PLUS, and Ashton-Tate 3 3 are trademarks of Ashton-Tate 3 3 You may use the dBASE III PLUS software and printed materials in 3 3 the dBASE III PLUS software package under the terms of the dBASE 3 3 III PLUS Software License Agreement. In summary, Ashton-Tate 3 3 grants you a paid-up, non-transferable, personal license to use 3 3 dBASE III PLUS on one microcomputer or workstation. You do not 3 3 become the owner of the package, nor do you have the right to 3 3 copy or alter the software or printed materials. You are legally 3 3 accountable for any violation of the License Agreement or of 3 3 copyright, trademark, or trade secret laws. 3 @DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDY Press the F1 key for HELP. Insert Sampler Disk 2 and press ENTER, or press Ctrl-C to abort. (DEMO) . \-----------------------------------------------------------------------------/ Look at the screen, and find the "(DEMO) ." prompt. To me, it shows that the computer defaults and/or expects me to type a dbase III plus command. Next, I want to type DO SYSMENU, because I want to invoke the program SYSMENU which produces the system menu for the Smith's Bikeworks system. TYPE: DO SYSMENU PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Execute the SYSMENU program. Q&A 4-3: Why do you type DO SYSMENU? Comment: If you use a full blown version of dbase III plus, you will not see the word DEMO in front of the dot prompt. SCREEN 4-4: Execute the SYSMENU program /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Activity Menu << A. CUSTOMER INFORMATION System B. HUMAN RESOURCES MANAGEMENT System C. ACCOUNTING System D. INVENTORY MANAGEMENT System E. PRODUCTION PLANNING System F. EXIT From Bikeworks' Information System Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the choices (A to F). Next, I want to type D, because I want to activate the inventory management system. TYPE: D AND THE SYSTEM WILL: Activate the Inventory Management system and display its system menu. Q&A 4-4: How do you load the Inventory Management system? Comment: The Activity Menu controls entry into the Smith's Bikeworks subsystems. It is maintained as part of the Customer Information System. If an action is selected which is not one of the program's legal options, the screen will be erased, the menu redisplayed, and a new operator input accepted. 4.3. THE INVENTORY MANAGEMENT SYSTEM MENU This menu displays all the options in the inventory management system. 4.3.1. THE FILE MAINTENANCE OPTIONS The first two options allow the user to maintain files used in the inventory system. SCREEN 4-5: Display its system menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to type a letter between (A) and (I). Next, I want to type "A", because I want to perform the inventory file maintenance. TYPE: A AND THE SYSTEM WILL: Load the maintenance program which is named MFGMNT.PRG. This displays the inventory file maintenance submenu screen and the first record in the index. Q&A 4-5: What does the Manufactured Inventory file maintenance do? Comment: The MFGMNT program creates and maintains the Manufacturing Inventory file (MFGINV.DBF); and it creates the file's indexes the first time the program is run. Available options are to find, add, delete, recall, or edit records. 4.3.1.1. MANINV This is the maintenance operation for all manufactured inventory. SCREEN 4-6: Display first record in the index /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 5 of 5 Stock Number Description Vendor Merchandise Category Code Selling Price . Cost . Quantity -- On Hand On Order Reorder Point Sales This Period Cumulative Sales Order Lead Time . Last Updated : 02/11/87 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM" To me, it shows that the computer (defaults and/or) expects me to enter a letter enclosed in the pointed brackets. Next, I want to enter "K", because I want to change the key the file is indexed on. TYPE: K AND THE SYSTEM WILL: display the key choices at the bottom of the screen and allow the user to choose a key value. Q&A 4-6: What option would you select if you want to change the order of the file? Comment: The submenu of options at the bottom of the maintenance screen controls operation of MFGMNT.PRG. An option is requested by pressing the letter key associated with that option - the letter within the < >. SCREEN 4-7: Allow the user to choose a key value /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 5 of 5 Stock Number Description Vendor Merchandise Category Code Selling Price . Cost . Quantity -- On Hand On Order Reorder Point Sales This Period Cumulative Sales Order Lead Time . Last Updated : 02/11/87 -------------------------------------------------------------------------------- A. MSTOCKNO Press letter of desired key \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "key". To me, it shows that the computer (defaults and/or) expects me to enter the letter next to the index file I desire. Next, I want to enter "A", because I want the file to be indexed on the field STOCKNO. TYPE: A AND THE SYSTEM WILL: Utilize the index file MSTOCKNO.ndx. Q&A 4-7: Why change the index key? SCREEN 4-8: Utilize the index file MSTOCKNO.ndx /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 5 of 5 Stock Number Description Vendor Merchandise Category Code Selling Price . Cost . Quantity -- On Hand On Order Reorder Point Sales This Period Cumulative Sales Order Lead Time . Last Updated : 02/11/87 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word"PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the letter options enclosed in the pointed brackets. Next, I want to type "F", because I want to ind a record in the manufactured inventory file. TYPE: F AND THE SYSTEM WILL: Display the find screen with an entry field containing the key value of the current record. Q&A 4-8: Why is the key value of the current record displayed in the entry area? SCREEN 4-9: Manufactured Inventory System File Maintenance /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 5 of 5 Stock Number Description Vendor Merchandise Category Code Selling Price . Cost . Quantity -- On Hand On Order Reorder Point Sales This Period Cumulative Sales Order Lead Time . Last Updated : 02/11/87 -------------------------------------------------------------------------------- ENTER SEARCH VALUE. VALUE SHOWN IS FROM THE DISPLAYED RECORD. PRESS CTRL-Y TO CLEAR \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "CLEAR". To me, it shows that the computer (defaults and/or) expects me to clear the field to remove the search value of the current record. Next, I want to type the desired search value (F100000-10), because I want to find the record containing that search value. HOLD DOWN: Ctrl TYPE: Y TYPE: F100000-10 AND THE SYSTEM WILL: Display the first occurrence of the key value F100000-10. Q&A 4-9: What type of value should be entered as a search value? Comment: The search value is dependent on which index file is active. The MSTOCKNO is currently active, so the search will be conducted on stock number (STOCKNO). SCREEN 4-10: Display the first occurrence of the key value F100000-10 /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 1 of 5 Stock Number F100000-10 Description 26" FRAME SET MENS FUTURA Vendor FUTURA Merchandise Category Code B Selling Price 290.00 Cost 170.00 Quantity -- On Hand 9 On Order 0 Reorder Point 2 Sales This Period 1 Cumulative Sales 11 Order Lead Time 6.0 Last Updated : 08/30/83 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one enclosed in the pointed brackets. Next, I want to type "A", because I want to add a record to the file. TYPE: A AND THE SYSTEM WILL: display a blank record and allow you to enter the new field values. Q&A 4-10: Why does a blank screen appear when performing an add? Comment: Place the data for the new record at the cursor position starting at the top of the screen. Move among fields using the cursor control keys. Press RETURN to advance to the next field. Do not press RETURN after an entry that fills the entire field. SCREEN 4-11: Allow you to enter the new field values /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 7 of 7 Stock Number Description Vendor Merchandise Category Code Selling Price . Cost . Quantity -- On Hand On Order Reorder Point Sales This Period Cumulative Sales Order Lead Time . Last Updated : / / *** PRESS 'C' TO CONTINUE ADDING NEW RECS, ANYTHING ELSE TO QUIT -------------------------------------------------------------------------------- Enter data at cursor position. Move among fields with cursor control keys. Press ENTER to move to next field. Press ENTER alone to leave field unchanged. \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Stock number". To me, it shows that the computer (defaults and/or) expects me to enter a stock number for the new record and other field values. Next, I want to enter a stock number for the new record, because the cursor is at the stock number field. TYPE: KH1000-10 PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Advance to the next field. Q&A 4-11: Why do you type "return" after entering a field value? Continue entering the record: TYPE: TRAINING TOOLS PRESS: [<-'] Enter/Return key TYPE: BIKEWORKS PRESS: [<-'] Enter/Return key TYPE: B TYPE: 240 PRESS: [<-'] Enter/Return key TYPE: 150 PRESS: [<-'] Enter/Return key TYPE: 6 PRESS: [<-'] Enter/Return key TYPE: 0 PRESS: [<-'] Enter/Return key TYPE: 2 PRESS: [<-'] Enter/Return key TYPE: 1 PRESS: [<-'] Enter/Return key TYPE: 8 PRESS: [<-'] Enter/Return key TYPE: 5 PRESS: [<-'] Enter/Return key SCREEN 4-12: Allow you to enter the new field values /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 8 of 8 Stock Number KH1000-10 Description TRAINING TOOLS Vendor BIKEWORKS Merchandise Category Code B Selling Price 240.00 Cost 150.00 Quantity -- On Hand 6 On Order 0 Reorder Point 2 Sales This Period 1 Cumulative Sales 8 Order Lead Time 5.0 Last Updated : / / *** PRESS 'C' TO CONTINUE ADDING NEW RECS, ANYTHING ELSE TO QUIT -------------------------------------------------------------------------------- Enter data at cursor position. Move among fields with cursor control keys. Press ENTER to move to next field. \-----------------------------------------------------------------------------/ Look at the screen, and find the "blinking cursor after the word QUIT". To me, it shows that the computer (defaults and/or) expects me to type "C" to continue adding records or type any other key to return to the submenu. Next, I want to press the return key because I want to return to the submenu. PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Return to the submenu screen. Q&A 4-12: Why would you type "C"? SCREEN 4-13: Return to the submenu screen /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 8 of 8 Stock Number KH1000-10 Description TRAINING TOOLS Vendor BIKEWORKS Merchandise Category Code B Selling Price 240.00 Cost 150.00 Quantity -- On Hand 6 On Order 0 Reorder Point 2 Sales This Period 1 Cumulative Sales 8 Order Lead Time 5.0 Last Updated : 02/11/87 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one enclosed in the pointed brackets. Next, I want to enter "N", because I want to view the next record in the file. TYPE: N AND THE SYSTEM WILL: Locate and display the next record in the current index along with the submenu. Q&A 4-13: What is the purpose of the SKIP command? Comment: Next and Previous records are defined logically according to the active index, rather than by the physical order of the file. SCREEN 4-14: Display the next record in the current index /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 4 of 8 Stock Number TR10000-00 Description TRAINING ROLLERS Vendor BIKEWORKS Merchandise Category Code A Selling Price 149.95 Cost 0.00 Quantity -- On Hand 23 On Order 0 Reorder Point 0 Sales This Period 0 Cumulative Sales 92 Order Lead Time 0.0 Last Updated : 03/10/85 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the letter options in the pointed brackets. Next, I want to type "D", because I want to mark the currently displayed record for deletion. TYPE: D AND THE SYSTEM WILL: flag the currently displayed record for deletion. Q&A 4-14: Does the DELETE command remove a record permanently? Comment: When a record has been flagged for deletion, the system displays the word " * DELETED * " in the upper left hand corner of the screen as an indication. SCREEN 4-15: Flag the currently displayed record for deletion /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << * DELETED * Today's Date:02/11/87 Record 4 of 8 Stock Number TR10000-00 Description TRAINING ROLLERS Vendor BIKEWORKS Merchandise Category Code A Selling Price 149.95 Cost 0.00 Quantity -- On Hand 23 On Order 0 Reorder Point 0 Sales This Period 0 Cumulative Sales 92 Order Lead Time 0.0 Last Updated : 03/10/85 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the letter options enclosed in the pointed brackets. Next, I want to type "D", because I want to recall the record just flagged for deletion. TYPE: D AND THE SYSTEM WILL: remove the deletion flag from the record. Q&A 4-15: Why do you type "D" again? Comment: Recall is possible at this stage because the record has not been removed from the disk. SCREEN 4-16: Remove the deletion flag from the record /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Maintenance << Today's Date:02/11/87 Record 4 of 8 Stock Number TR10000-00 Description TRAINING ROLLERS Vendor BIKEWORKS Merchandise Category Code A Selling Price 149.95 Cost 0.00 Sales This Period 0 Cumulative Sales 92 Order Lead Time 0.0 Last Updated : 03/10/85 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: MSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the letter options enclosed in the pointed brackets. Next, I want to type "M", because I want to return to the inventory system menu. TYPE: M AND THE SYSTEM WILL: display the inventory system menu. Q&A 4-16: Why do you type "M"? 4.3.1.2. RAWINV This is the maintenance operation for raw materials inventory. SCREEN 4-17: Display the inventory system menu /-----------------------------------------------------------------------------\ A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the options "A" to "I". Next, I want to type "B", because I want to perform maintenance operations on the raw materials inventory file. TYPE: B AND THE SYSTEM WILL: Present the raw materials inventory file maintenance screen with a submenu for maintenance functions. Q&A 4-17: Why is there raw materials file maintenance? Comment: The submenu of options at the bottom of the maintenance screen controls the operation of the RAWMNT program. An option is requested by pressing the letter key associated with that option - the letter within the < >. SCREEN 4-18: Present the raw materials inventory file /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Raw Materials Inventory System File Maintenance << Today's Date:02/11/87 Record 1 of 4 Stock Number AT005-0.75 Description ALUMINUM TUBING .75" O.D. Vendor -- Primary ALUMCO Secondary MITCHELL'S METL Units Per Package FT Cost Per Package 0.30 Packages -- On Hand 8000 On Order 0 Reorder Point 500 Order Lead Time 0.5 Last Updated : 08/30/83 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: RSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of those contained within the pointed brackets. Next, I want to type "F", because I want to perform the ind selection. TYPE: F AND THE SYSTEM WILL: Display the find screen with an entry field containing the key value of the current record. Q&A 4-18: What value will the search be conducted on? SCREEN 4-19: Raw Mateials Inventory System File /-----------------------------------------------------------------------------\ >> Raw Materials Inventory System File Maintenance << Today's Date:02/11/87 Record 1 of 4 Stock Number AT005-0.75 Description ALUMINUM TUBING .75" O.D. Vendor -- Primary ALUMCO Secondary MITCHELL'S METL Units Per Package FT Cost Per Package 0.30 Packages -- On Hand 8000 On Order 0 Reorder Point 500 Order Lead Time 0.5 Last Updated : 08/30/83 -------------------------------------------------------------------------------- ENTER SEARCH VALUE. VALUE SHOWN IS FROM THE DISPLAYED RECORD. PRESS CTRL-Y TO CLEAR AT005-0.75 \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "CLEAR". To me, it shows that the computer (defaults and/or) expects me to enter a search value. Next, I want to clear the field to remove the search value of the current record. HOLD DOWN: [Ctrl] AND PRESS: Y TYPE: BC002-.25 PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: locate and display the first record with a matching stocknumber value. Q&A 4-19: Why do you enter a search value? SCREEN 4-20: Display first record with a matching stocknumber /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Raw Materials Inventory System File Maintenance << Today's Date:02/11/87 Record 3 of 4 Stock Number BC002-.25 Description BOLT,PLT STL 2"/.25" Vendor -- Primary AAA HARDWARE Secondary JONES SUPPLY CO Units Per Package 100 Cost Per Package 12.50 Packages -- On Hand 99 On Order 0 Reorder Point 50 Order Lead Time 1.0 Last Updated : 05/21/86 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: RSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of those enclosed in the pointed brackets. Next, I want to type "P", because I want to display the previous record in the index. TYPE: P AND THE SYSTEM WILL: Locate and display the previous record in the current index. Q&A 4-20: Why is the record number not sequential? SCREEN 4-21: Display the previous record in the current index /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Raw Materials Inventory System File Maintenance << Today's Date:02/11/87 Record 1 of 4 Stock Number AT005-0.75 Description ALUMINUM TUBING .75" O.D. Vendor -- Primary ALUMCO Secondary MITCHELL'S METL Units Per Package FT Cost Per Package 0.30 Packages -- On Hand 8000 On Order 0 Reorder Point 500 Order Lead Time 0.5 Last Updated : 02/11/87 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: RSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of those enclosed in the pointed brackets. Next, I want to type "E", because I want to edit the record currently displayed on the screen. TYPE: E AND THE SYSTEM WILL: display the file maintenance edit screen. Q&A 4-21: What must be done if you want to edit a record other than the one currently displayed? SCREEN 4-22: Display the file maintenance edit screen /-----------------------------------------------------------------------------\ >> Raw Materials Inventory System File Maintenance << Today's Date:02/11/87 Record 1 of 4 Stock Number AT005-0.75 Description ALUMINUM TUBING .75" O.D. Vendor -- Primary ALUMCO Secondary MITCHELL'S METL Units Per Package FT Cost Per Package 0.30 Packages -- On Hand 8000 On Order 0 Reorder Point 500 Order Lead Time 0.5 Last Updated : 02/11/87 ******** PRESS ANY KEY TO FINISH EDIT AND RETURN TO SUBMENU -------------------------------------------------------------------------------- Enter data at cursor position. Move among fields with cursor control keys. Press ENTER to move to next field. Press ENTER alone to leave field unchanged. \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the "Stock Number" field. To me, it shows that the computer (defaults and/or) expects me to make a change to the field which contains the cursor. Next, I want to press return to move to the next field to be edited. PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Advance to the next field to be edited. TYPE: ALUMINUM TUBING .85" O.D. PRESS: [PgDn] Page Down key AND THE SYSTEM WILL: Change the field description from .75" to .85" Q&A 4-22: Why was the description field edited? SCREEN 4-23: Return to the maintenance screen /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Raw Materials Inventory System File Maintenance << Today's Date:02/11/87 Record 1 of 4 Stock Number AT005-0.75 Description ALUMINUM TUBING .85" O.D. Vendor -- Primary ALUMCO Secondary MITCHELL'S METL Units Per Package FT Cost Per Package 0.30 Packages -- On Hand 8000 On Order 0 Reorder Point 500 Order Lead Time 0.5 Last Updated : 02/11/87 -------------------------------------------------------------------------------- ind Record dd Record elete/Recall dit Record Current Active

rev Record ext Record enu (return) ey Select Key: RSTOCKNO *** NEXT ACTION TO PERFORM \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERFORM". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of those contained in the pointed brackets. Next, I want to type "M", because I want to return to the inventory management system main menu. TYPE: M AND THE SYSTEM WILL: display the inventory management system menu. 4.3.2. THE ORDER ENTRY SYSTEM The order entry system allows the user to enter items that are at or below reorder point. SCREEN 4-24: Display the inventory management system menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to type a letter matching one of the options "A" to "I". Next, I want to type "C", because I want to enter orders from manufacturing inventory. TYPE: C AND THE SYSTEM WILL: display the order entry screen. Comment: ORDERS.PRG allows entry of orders, produces an invoice and packing slip for each order, updates the manufactured inventory file (MFGINV.DBF) by reducing the quantity on hand of each item sold, and updates the accounts receivable file (RECFILE.DBF) for credit sales. The period-to-date and the year-to-date sales values are updated in the accounts receivable file (RECFILE.DBF). Also, the years value and the last update fields are updated in the customer maintenance file (CUSTOMER.DBF). SCREEN 4-25: Display the order entry screen /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Beginning Invoice Number 100 Sales Tax Rate 0.045 Default Account Number 102.00 REPLACE VALUES AT CURSOR, OR JUST PRESS ENTER IF CURRENT VALUES ARE O.K. 'M' HERE RETURNS TO MENU, ANY OTHER KEY STARTS ORDER PROCESSING => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Number". To me, it shows that the computer (defaults and/or) expects me to to enter a new invoice number or press the return key. Next, I want to press the return key, because I want to accept the default value. PRESS: [<-'] Enter/Return key PRESS: [<-'] Enter/Return key Q&A 4-23: What is sales tax rate? PRESS: [<-'] Enter/Return key Q&A 4-24: What does the "orders" form do? SCREEN 4-26: Order Entry System /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Beginning Invoice Number 100 Sales Tax Rate 0.045 Default Account Number 102.00 REPLACE VALUES AT CURSOR, OR JUST PRESS ENTER IF CURRENT VALUES ARE O.K. 'M' HERE RETURNS TO MENU, ANY OTHER KEY STARTS ORDER PROCESSING => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the "=>" prompt. To me, it shows that the computer (defaults and/or) expects me to enter "M" to return to inventory system menu or any other key to start order processing. Next, I want to type S, because I want to start processing orders. TYPE: S AND THE SYSTEM WILL: Begin orders processing and present the results from the order entry system on the screen. Comment: Notice the selection bar at the bottom of the screen. Your chapter describes what each of these options allow you to do. SCREEN 4-27: Order Entry System /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Buyer Ship To Name Name Address Address City St Zip City St Zip Tax Rate For This Sale 0.045 Invoice Number 100 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTAL TAX: 0.01 TOTAL: 0.01 uyer hip

ay dd.Item el.Item ancel nter enu \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Menu". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of those enclosed in the pointed brackets. Next, I want to type "B", because I want to enter a buyer's name. TYPE: B AND THE SYSTEM WILL: Display the orders processing screen. Q&A 4-25: What does the uyer option do? SCREEN 4-28: Display the orders processing screen /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Buyer Ship To Name Name Address Address City St Zip City St Zip Tax Rate For This Sale 0.045 Invoice Number 100 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTAL TOTAL: 0.01 uyer hip

ay dd.Item el.Item ancel nter enu B \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Name". To me, it shows that the computer (defaults and/or) expects me to enter a new buyer's name. Next, I want to type the buyer's name, because I want the name to appear in orders processing. TYPE: HARRIS SUMMIT COMP. PRESS: [<-'] Enter/Return key PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Accept the entry and move down to allow the entry of the address. Q&A 4-26: Why do you enter a buyer's name? SCREEN 4-29: Move down to allow the entry of the address /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Buyer Ship To Name HARRIS SUMMIT COMP. Name Address Address City St Zip City St Zip Tax Rate For This Sale 0.045 Invoice Number 100 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTAL TAX: 0.01 TOTAL: 0.01 uyer hip

ay dd.Item el.Item ancel nter enu B \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Address". To me, it shows that the computer (defaults and/or) expects me to enter the address of the buyer. Next, I want to type the buyer's address. TYPE: P.O.BOX 1224 PRESS: [<-'] Enter/Return key TYPE: MIAMI PRESS: [<-'] Enter/Return key TYPE: FL TYPE: 33124 AND THE SYSTEM WILL: enter the buyer's address information and proceed to the buyer's information sub-menu. Q&A 4-27: What is the purpose of storing the address? Comment: There are enough lines to accommodate a four line address. SCREEN 4-30: Proceed to the buyer's information sub-menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Buyer Ship To Name HARRIS SUMMIT COMP. Name Address P.O.BOX 1224 Address City MIAMI St FL Zip 33124 City St Zip Tax Rate For This Sale 0.045 Invoice Number 101 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTA TAX: 0.01 TOTAL: 0.01 uyer hip

ay dd.Item el.Item ancel nter enu \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Menu". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching the letters enclosed in the pointed brackets. Next, I want to type "A", because I want to add the item. TYPE: A AND THE SYSTEM WILL: move the cursor down to the stock number field for entry of the item purchased. SCREEN 4-31: Order Entry System /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM Today's Date: 02/11/87 Buyer Ship To Name HARRIS SUMMIT COMP. Name Address P.O.BOX 1224 Address City MIAMI St FL Zip 33124 City St Zip Tax Rate For This Sale 0.045 Invoice Number 101 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTAL F100000-10 TAX: 0.01 TOTAL: 0.01 uyer hip

ay dd.Item el.Item ancel nter enu A \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor in the "STOCK NUMBER" field. To me, it shows that the computer (defaults and/or) expects me to enter the stock number. Next, I want to enter the stock number of the item being purchased. because I want the description of the item to appear. TYPE: F100000-10 AND THE SYSTEM WILL: Access the MFGINV file to find the record for that stock number. If it is found, the current price and quantity on hand from the inventory file are displayed at the bottom of the screen. Comment: The PRICE and QTY fields can be edited. You would edit the PRICE field in the case of discount prices for wholesalers. SCREEN 4-32: Order Entry System /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Buyer Ship To Name HARRIS SUMMIT COMP. Name Address P.O.BOX 1224 Address City MIAMI St FL Zip 33124 City St Zip Tax Rate For This Sale 0.045 Invoice Number 101 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTAL F100000-10 26" FRAME SET MENS FUTURA 290.00 2 TAX: 0.01 TOTAL: 0.01 Current Item Price $ 290.00 Current Quantity on Hand : 9 \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor in the "PRICE" field. To me, it shows that the computer (defaults and/or) expects me to change the price or press return. Next, I want to press return, because I want to compute the subtotal. PRESS: [<-'] Enter/Return key TYPE: 2 PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Compute the subtotal. SCREEN 4-33: Compute the subtotal /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Order Entry System << Today's Date: 02/11/87 Buyer Ship To Name HARRIS SUMMIT COMP. Name Address P.O.BOX 1224 Address City MIAMI St FL Zip 33124 City St Zip Tax Rate For This Sale 0.045 Invoice Number 101 ash/Chg/isa/ill Card, Check Num Account 102.0 STOCK NUMBER DESCRIPTION PRICE QTY SUBTOTAL 1: F100000-10 26" FRAME SET MENS FUTURA 290.00 2 580.00 TAX: 26.10 TOTAL: 606.11 uyer hip

ay dd.Item el.Item ancel nter enu \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Menu". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of those enclosed in the pointed brackets. Next, I want to type "M", because I want to return to the inventory system menu. TYPE: M AND THE SYSTEM WILL: Display the inventory system menu. 4.3.3. THE MANUFACTURED INVENTORY FILE LISTING This is the option that allows the user to print a report containing information on all manufactured inventory. SCREEN 4-34: Display the inventory system menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter an option matching letters "A" to "I". Next, I want to print the manufactured inventory report. TYPE: D AND THE SYSTEM WILL: Activate the manufactured inventory file listing and display the corresponding menu. Q&A 4-28: What file is the manufactured inventory report printed from? Comment: MFGRPT.PRG prints a variety of specialized inventory summary reports of the Manufactured Inventory file. Report options are for the entire inventory: items out of stock, items at or below reorder point, and items on order. All these reports may be indexed on stock number, vendor, or item category code if desired. 4.3.3.1. LIST ALL INVENTORY ITEMS This item in the submenu prints all manufactured items. SCREEN 4-35: Display the corresponding menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 A. List ALL INVENTORY Items B. List Items OUT OF STOCK C. List Items at or BELOW REORDER Point D. List Items ON ORDER E. Return to INVENTORY MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter an option matching letters "A" to "E". Next, I want to type "A". TYPE: A AND THE SYSTEM WILL: Display a setup screen for entering the parameters. SCREEN 4-36: Display a setup screen for entering the parameters /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 Beginning STOCK NUMBER to Include in Report Ending STOCK NUMBER to Include in Report zzzzzzzzzz Run Report From The Following FILE MFGINV Ordered by the Following INDEX MSTOCKNO Using the REPORT FORMAT Named MFGLIST REPLACE VALUES AT CURSOR, OR JUST PRESS ENTER IF CURRENT REPORT DESCRIPTION IS O.K. 'M' HERE RETURNS TO MENU, ANY OTHER KEY STARTS THE REPORT => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Report". To me, it shows that the computer expects me to enter the stock number the report should begin with. Next, I want to type CT10000-00. TYPE: CT10000-00 AND THE SYSTEM WILL: Advance the cursor to the next entry. Q&A 4-29: Why type CT10000-00? SCREEN 4-37: Advance the cursor to the next entry /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 Beginning STOCK NUMBER to Include in Report CT10000-00 Ending STOCK NUMBER to Include in Report zzzzzzzzzz Run Report From The Following FILE MFGINV Ordered by the Following INDEX MSTOCKNO Using the REPORT FORMAT Named MFGLIST REPLACE VALUES AT CURSOR, OR JUST PRESS ENTER IF CURRENT REPORT DESCRIPTION IS O.K. 'M' HERE RETURNS TO MENU, ANY OTHER KEY STARTS THE REPORT => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Report". To me, it shows that the computer expects me to a either accept the default values or enter new values for the remaining parameters. Next, I want to press the Page Down key to accept the remaining default values and print the report. PRINTER MUST BE ON PRESS: [PgDn] Page Down key AND THE SYSTEM WILL: begin printing the report and then return to the inventory menu Q&A 4-30: What is the last stock number to appear in the report? SCREEN 4-38: Return to the inventory menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter a letter matching one of the options "A" to "I". Next, I want to print the manufactured inventory report. TYPE: D AND THE SYSTEM WILL: Activate the manufactured inventory file listing and display the corresponding menu. 4.3.3.2. LIST ITEMS OUT OF STOCK This option lists all items out of stock. SCREEN 4-39: Display the corresponding menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 A. List ALL INVENTORY Items B. List Items OUT OF STOCK C. List Items at or BELOW REORDER Point D. List Items ON ORDER E. Return to INVENTORY MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter a letter matching one of the options "A" to "E". Next, I want to enter "B". TYPE: B AND THE SYSTEM WILL: Display the setup screen for out of stock items. PRINTER MUST BE ON TYPE: F100000-10 PRESS: [PgDn] Page Down key AND THE SYSTEM WILL: print the report and return to display the inventory menu. TYPE: D 4.3.3.3. LIST ITEMS AT OR BELOW REORDER POINT This option prints a list of all items at or below reorder point. SCREEN 4-40: Return to display the inventory menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 A. List ALL INVENTORY Items B. List Items OUT OF STOCK C. List Items at or BELOW REORDER Point D. List Items ON ORDER E. Return to INVENTORY MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter an option matching one of the letters "A" to "F". Next, I want to enter "C". TYPE: C Q&A 4-31: What do you do when an item is below reorder point? SCREEN 4-41: Manufactured Inventory System /-----------------------------------------------------------------------------\ >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 Beginning STOCK NUMBER to Include in Report Ending STOCK NUMBER to Include in Report zzzzzzzzzz Run Report From The Following FILE MFGINV Ordered by the Following INDEX MSTOCKNO Using the REPORT FORMAT Named MFGLIST REPLACE VALUES AT CURSOR, OR JUST PRESS ENTER IF CURRENT REPORT DESCRIPTION IS O.K. 'M' HERE RETURNS TO MENU, ANY OTHER KEY STARTS THE REPORT => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Report". To me, it shows that the computer expects me to enter a stock number to indicate the beginning of the range of records to include in the report. Next, I want to type AT005-0.75. PRINTER MUST BE ON TYPE: AT005-0.75 PRESS: [PgDn] Page Down key Q&A 4-32: Why start the search for stockout items on KAT005-0.75? TYPE: D 4.3.3.4. LIST ITEMS ON ORDER This option prints a listing of items currently on order. SCREEN 4-42: Manufactured Inventory System File Listing /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Listing << Today's Date: 02/15/87 A. List ALL INVENTORY Items B. List Items OUT OF STOCK C. List Items at or BELOW REORDER Point D. List Items ON ORDER E. Return to INVENTORY MENU Press Letter Matching Desired Option 1 \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter an option "A" to "E". Next, I want to enter option "D". TYPE: D AND THE SYSTEM WILL: Activate the program for listing MFGINV items that are presently on order. Next, I want to type CT10000-00. PRINTER MUST BE ON TYPE: CT10000-00 PRESS: [PgDn] Page Down key Q&A 4-33: What is the difference between the MFGINV file and the RAWINV file? 4.3.4. THE RAW MATERIALS INVENTORY REPORT This option prints a listing of all raw materials in stock SCREEN 4-43: Activate the program for listing MFGINV items /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer expects me to enter a letter matching one of the options "A" to "E". Next, I want to type "E". TYPE: E AND THE SYSTEM WILL: Display the set up screen for the Raw Materials Inventory report. Raw Materials Inventory System File Listing /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Raw Materials Inventory System File Listing << Today's Date: 02/15/87 Beginning STOCK NUMBER to Include in Report Ending STOCK NUMBER to Include in Report zzzzzzzzzz Run Report From The Following FILE MFGINV Ordered by the Following INDEX MSTOCKNO Using the REPORT FORMAT Named MFGLIST REPLACE VALUES AT CURSOR, OR JUST PRESS ENTER IF CURRENT REPORT DESCRIPTION IS O.K. 'M' HERE RETURNS TO MENU, ANY OTHER KEY STARTS THE REPORT => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Report". To me, it shows that the computer expects me to enter the stock number of the first record to include in the report. Next, I want to type CT10000-00. TYPE: CT10000-00 AND THE SYSTEM WILL: Advance the cursor to the next entry field. PRINTER MUST BE ON PRESS: [PgDn] Page Down key AND THE SYSTEM WILL: Print the report and return to the inventory menu. 4.3.5. CLEAR SALES COUNTS This option resets this period's sales figures and cumulative sales figures in the Manufactured Inventory file to zero. SCREEN 4-44: Return to the inventory menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to type an letter matching one of the options "A" to "I". Next, I want to type "F", because I want to clear sales accounts. TYPE: F AND THE SYSTEM WILL: Display the manufactured materials inventory sales reset screen. Q&A 4-34: What does the clear accounts function do? SCREEN 4-45: Manufactured Inventory System Sales Reset /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System Sales Reset << Today's Date: 02/11/87 Figure to Clear: PERIOD or CUMULATIVE PERIOD THIS PROGRAM CLEARS THE CURRENT PERIOD SALES FIGURE, OR BOTH THE CURRENT AND CUMULATIVE. 'M' HERE RETURNS TO MENU. ANY OTHER KEY STARTS PROGRAM => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "PERIOD". To me, it shows that the computer (defaults and/or) expects me to specify whether this period's sales figures or cumulative sales figures are to be cleared. PRESS: [<-'] Enter/Return key SCREEN 4-46: Manufactured Inventory System Sales Reset /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System Sales Reset << Today's Date: 02/11/87 Figure to Clear: PERIOD or CUMULATIVE PERIOD THIS PROGRAM CLEARS THE CURRENT PERIOD SALES FIGURE, OR BOTH THE CURRENT AND CUMULATIVE. 'M' HERE RETURNS TO MENU. ANY OTHER KEY STARTS PROGRAM => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the "=>" prompt. To me, it shows that the computer (defaults and/or) expects me to enter either a "M" to return to the menu or any other key to clear the accounts. Next, I want to enter any key to clear the accounts. TYPE: C AND THE SYSTEM WILL: Clear the accounts andreturn to the Inventory menu. Q&A 4-35: What inventory file was the clear accounts function performed on? 4.3.6. FILE CLEANUP OPTIONS These options allow the user to permanently remove deleted records. SCREEN 4-47: Return to the Inventory menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the options. Next, I want to type "G", because I want to perform the manufactured inventory file clean up. TYPE: G AND THE SYSTEM WILL: Execute the program named MIREPACK.PRG. Q&A 4-36: What does the MANUFACTURED INVENTORY File CLEAN UP option accomplish? 4.3.6.1. MANINV CLEANUP Remove records flagged for deletion in the MANINV file. SCREEN 4-48: Execute the program named MIREPACK.PRG /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Manufactured Inventory System File Clean Up << Today's Date: 02/11/87 THIS PROGRAM PERMANENTLY REMOVES RECORDS FLAGGED FOR DELETION FROM THE MFGINV FILE. 'M' HERE RETURNS TO MENU. ANY OTHER KEY STARTS REPACK => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after "=> prompt". To me, it shows that the computer (defaults and/or) expects me to enter either a "M" to return to menu and abort the packing or enter any other key to pack. Next, I want to type "M", because I want to return to the menu and abort the clean up. TYPE: M AND THE SYSTEM WILL: Display the Inventory menu. Q&A 4-37: Can you recall your records after the file clean up? SCREEN 4-49: Display the Inventory Manu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the options "A" to "I". Next, I want to type "H", because I want to perform the raw materials inventory file clean up. TYPE: H AND THE SYSTEM WILL: Display the raw materials inventory clean up screen. Q&A 4-38: What program performs the raw materials inventory file clean up? 4.3.6.2. RAWINV CLEANUP Removes records flagged for deletion in the raw inventory file. SCREEN 4-50: Display the raw materials inventory clean up screen /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Raw Materials Inventory System File Clean Up << Today's Date: 02/11/87 THIS PROGRAM PERMANENTLY REMOVES RECORDS FLAGGED FOR DELETION FROM THE RAWINV FILE. 'M' HERE RETURNS TO MENU. ANY OTHER KEY STARTS REPACK => \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the "=>" prompt. To me, it shows that the computer (defaults and/or) expects me to enter either an "M" to return to the menu and abort or any other key to perform. Next, I want to type "K", because I want to pack the file. TYPE: K AND THE SYSTEM WILL: Pack the file. Q&A 4-39: What does the PACK command perform? 4.3.7. RETURNING TO SYSMENU Option "I" allows the user to return to the system activity menu SCREEN 4-51: Inventory Management System Menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Inventory Management System << A. MANUFACTURED INVENTORY File Maintenance B. RAW MATERIALS INVENTORY File Maintenance C. Enter ORDERS From Manufactured Inventory D. Print MANUFACTURED INVENTORY Reports E. Print RAW MATERIALS INVENTORY Reports F. Clear SALES COUNTS G. MANUFACTURED INVENTORY File CLEAN UP H. RAW MATERIALS INVENTORY File CLEAN UP I. Return to SYSTEM MENU Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the options "A" to "I". Next, I want to Type "I", because I want to return to the Smith's Bikeworks main menu. TYPE: I AND THE SYSTEM WILL: return to the System menu. SCREEN 4-52: Return to the system menu /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Activity Menu << A. CUSTOMER INFORMATION System B. HUMAN RESOURCES MANAGEMENT System C. ACCOUNTING System D. INVENTORY MANAGEMENT System E. PRODUCTION PLANNING System F. EXIT From Bikeworks' Information System Press Letter Matching Desired Option \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the word "Option". To me, it shows that the computer (defaults and/or) expects me to enter a letter matching one of the options "A" to "F". Next, I want to type "F", because I want to exit Smith's Bikeworks altogether. TYPE: F AND THE SYSTEM WILL: Return to the dbase prompt. SCREEN 4-53: Return to the dbase prompt /-----------------------------------------------------------------------------\ SMITH'S BIKEWORKS INFORMATION SYSTEM >> Activity Menu << A. CUSTOMER INFORMATION System B. HUMAN RESOURCES MANAGEMENT System C. ACCOUNTING System D. INVENTORY MANAGEMENT System E. PRODUCTION PLANNING System F. EXIT From Bikeworks' Information System Press Letter Matching Desired Option F (DEMO) . \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the "(DEMO)." prompt. To me, it shows that the computer expects me to enter a Dbase III plus command. Next, I want to type QUIT. TYPE: QUIT PRESS: [<-'] Enter/Return key AND THE SYSTEM WILL: Return to the DOS A>. Q&A 4-40: What does the Quit command do? Comment: It's a good habit to exit Dbase by typing QUIT because this updates all files properly and helps maintain data integrity. SCREEN 4-54: Return to the DOS A> /-----------------------------------------------------------------------------\ END RUN dBASE III PLUS END RUN dBASE III PLUS A> \-----------------------------------------------------------------------------/ Look at the screen, and find the cursor after the "A>" prompt. To me, it shows that the computer expects me to take out my diskettes. Next, I want to take out my disks.