Shareware 1 2 the Maxx

home *** CD-ROM | disk | FTP | other *** search

/ Shareware 1 2 the Maxx / sw_1.zip / sw_1 / DAYO / DAYOFE.ZIP / DAYOFE.EXE / DAYOMRP.DOC < prev next >

Wrap

Text File | 1991-09-10 | 447KB | 5,540 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ █▄███████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀███████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ███▄ ▄███▒░ ║ ║ █████▒░ █████▒░ ███▄███████▒░ ║ ║ ██████▒░██████▒░ ███▒░ ███▒░ ███▄███████▒░ ║ ║ ███▒██████▒███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║ ║ ███▒░████▒░███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║ ║ ███▒░ ██▒░ ███▒░ ███████████▒░ ███▒░ ███▒░ ║ ║ ███▒░ ██▒░ ███▒░ ███▀████▒░ ███▀███████▒░ ║ ║ ███▒░ ▀▀ ███▒░ ███▒░▀███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ▀███▒░ ███▒░ ║ ║ ███▒░ ▀███▒░ ███▒░ ║ ║ ███▒░ ║ ║ ║ ║ ║ ║ MATERIALS REQUIREMENT PLANNING MODULE ║ ║ ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║ ║ ║ ║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║ ║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║ ║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║ ║ ██ ██ ██ ▀▀ ███████████ T D W ║ ║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║ ║ ▀███▀ ██ MicroComputer & Network ██████████ A A R ║ ║ ▀███▀ Solutions & █████*████▌ R R K ║ ║ Applications ▐███████████ E E S ║ ║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║ ║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║ ║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║ ║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║ ║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║ ║ █████ ▀▀▀█ Forms ║ ║ P.O. Box 585366 █ ║ ║ Orlando, Florida 32858-5366 (407) 291-3960 ▄▄▄▄▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 1 year after date of registration or purchase. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 2......SAMPLE DIAGRAM OF A BILL OF MATERIALS 2......ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM 3......EVEN ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM 3......COPYRIGHT/LICENSE 3......DISCLAIMER 4......REQUIREMENTS *** 4......SETUP 5......MAIN MENU 5......PASSWORD/NAME 6......SHOP ORDERS 7......CREATE A NEW SHOP ORDER 8......EXAMPLE OF SHOP ORDER NOTES INPUT 9......SHOP ORDER BROWSE & MAINTENANCE 10......FULL SCREEN EDIT - F2 10......EDIT SHOP ORDER NOTES 11......ADD RECORD TO SHOP ORDER - CTRL N 11......DELETE SHOP ORDER RECORD - CTRL U 11......RESET SHOP ORDER TOTAL COST - ALT F1 11......FIND SHOP ORDER RECORD 12......ALLOCATE SHOP ORDER 13......TRANSFER TO W.I.P. 15......ASSEMBLE SHOP ORDER 17......UPDATE INVENTORY WITH FINISHED ENDITEMS 19......PRINT/REPRINT SHOP ORDER 20......EXAMPLE OF A SHOP ORDER 21......PRINT/REPRINT A TRAVELER 22......EXAMPLE OF A USER DEFINED TRAVELER 23......MAKE SHOP ORDERS FROM BACK ORDERS 25......FILE MAINTENANCE FOR SHOP ORDERS 26......BILL OF MATERIALS (BOM) BROWSE & MAINTENANCE 27......FULL SCREEN EDIT - F2 28......CREATE A NEW BILL OF MATERIALS (BOM) - F3 29......ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM) 30......ADD ITEM FROM INVENTORY FOR CURRENT BOM - CTRL N 31......DELETE BOM RECORD - CTRL U 31......RESORT A BOM - CTRL F10 31......RESET ITEM FIELD 32......BOM TRANSFERS TO/FROM INVENTORY ONHAND & BOM WIP_QTY - ALT F5 33......ASSEMBLE CURRENT ENDITEM - ALT F6 34......UNASSEMBLE CURRENT ENDITEM - ALT F7 35......PRINT TRAVELER - ALT P 35......FIND BOM RECORD F5 35......CURRENT INDEX - F6 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 36......REPORTS 36......REPORTS/ROUTINES LISTING 37......ENDITEMS LIST 37......ENDITEMS LIST EXAMPLE 38......ENDITEMS EXPANDED REPORT #1 38......ENDITEMS EXPANDED REPORT #2 39......ABBREVIATED BILL OF MATERIALS REPORT 40......ABBREVIATED BILL OF MATERIALS REPORT EXAMPLE 41......BOM FLOW CHART #1 42......BOM FLOW CHART #2 43......BOM FLOW CHART #3 44......ALL - BOM FLOW CHART #1 46......ALL - BOM FLOW CHART #2A 47......ALL - BOM FLOW CHART #3A 48......BOM SHORTAGE REPORT 49......BOM SHORTAGE REPORT EXAMPLE 50......SHOP ORDERS LIST 51......SHOP ORDERS LIST EXAMPLE 52......SHOP ORDERS EXPANDED #1 53......SHOP ORDERS EXPANDED #2 54......SHOP ORDERS HISTORY #1 55......SHOP ORDERS HISTORY #2 56......MANUFACTURING HISTORY REPORT 57......MANUFACTURING HISTORY FOR A SINGLE ITEM REPORT 58......COMPONENT/WHEREIS ITEM REPORT 59......VIEW REPORTS ON SCREEN 60......REPORT VIEWING SCREEN 61......CONFIGURATION STATUS REPORT 61......EXAMPLE OF THE CONFIGURATIONS SETTINGS REPORT 62......PRINTER DRIVER (SETUP) 62......PRINTER DRIVER OPTIONS 63......CHANGE DEFAULT PRINTER 64......FULL SCREEN EDIT - F2 64......PRINTER DRIVER DATABASE FIELD DEFINITIONS 65......CONFIGURATION 65......CONFIGURATION OPTIONS LISTING 66......COMPANY NAME 66......COMPANY ADDRESS 66......COMPANY TELEPHONE 66......MRP CLASS CODES 67......ALLOW BROWSE EDITING 67......INVENTORY LOCATION/DIRECTORY 67......BACK ORDERS LOCATION/DIRECTORY 67......CUSTOMERS (AR) LOCATION/DIRECTORY DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 68......POINT OF SALE (POS) LOCATION/DIRECTORY 68......GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY 68......CURRENT DIRECTORY DATABASE LOCATION 68......REPORT PRINTER TYPE 68......REPORT PRINTER PORT 69......VISUAL INDEXING 69......AUTOMATIC DAILY INDEXING 69......AUTOMATICALLY PRINT SHOP ORDERS WHEN CREATED 69......SHOP ORDER PRINTER TYPE 70......SHOP ORDER PRINTER TYPE 70......PRINT DUEDATE ON SHOP ORDER 70......NUMBER OF SHOP ORDER COPIES TO PRINT 70......SHOP ORDER PRINTER PORT 70......LAST SHOP ORDER NUMBER 71......TRAVELER PRINTER TYPE 71......TRAVELER PRINTER PORT 71......LAST TRAVELER NUMBER 71......SKIP PAGE BETWEEN ENDITEMS ON THE TRAVELERS 72......TRAVELER SETUP & DEFINITION 72......TRAVELER STYLE/TYPE 73......TRAVELER FIELDS 74......DEFINED FIELDS 74......AUTOMATIC GL POSTING 75......EDIT CLASS CODE RECORD 75......ADD NEW CLASS CODE RECORD 76......FIND CLASS CODE 76......COLOR MONITOR 76......COLOR INTENSITY 77......MISCELLANEOUS ROUTINES 77......MISC ROUTINES MENU: 78......APPEND FROM 80......BROWSE DATABASES 82......COPY (.DBF) TO 84......CREATE DATABASE 86......DELETE RECORDS 87......ERASE FILE 87......EXIT TO DOS 88......INDEX A DATABASE 89......LIST FIELDS 92......MODIFY DATABASE 93......PACK DATABASE 94......RECALL RECORDS 94......RETURN TO MENU 94......RUN (DOS COMMAND) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 95......SIMPLE EDITOR 96......SORT DATABASE 97......TYPE (PRINT) FILE 98......ZAP DATABASE 100......HELP SCREENS 101......EXPANDED HELP 102......USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 103......VIEW DOCUMENTATION ONSCREEN 104......DATABASE STRUCTURES 104......BOM.DBF STRUCTURE 105......SO.DBF STRUCTURE 105......SOHIST.DBF STRUCTURE 106......SO_NOTES.DBF STRUCTURE 106......DATA DICTIONARY 109......DAYO MRP MAINTENANCE & QUIRKS 110......TJS 'Computer' LAB DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 1 ■ INTRODUCTION DAYO Materials Requirement Planning (MRP) is a module designed for use by manufacturers or anyone that 'builds' items from other items in their inventory. DAYO MRP provides you with a method of building items (ENDITEMS) from other items. This module is totally integrated with DAYO Inventory and other DAYO modules. The MRP process starts with the defining of the Bill of Materials (BOM) for an ENDITEM. After defining the BOM, you can 'build' the new item from items in the inventory database INV.DBF (if the items are available). The MRP process takes quantity from the inventory database and places it in the Work in Process (WIP) quantity fields in the database BOM.DBF. When enough of every sub component to an ENDITEM is obtained, the process will produce the ENDITEM which can in turn be placed into the inventory database. Some of the DAYO MRP highlights are: Multiuser (ie: Novell) Shop Orders Multi-level ENDITEMS & Component Items Travelers (2 Types/Styles) Automatic Inventory Posting Many Reports, ie: ENDITEM lists, Shop Orders and Bill of Materials Databases are dBase (tm) Compatible Miscellaneous Database Routines Passwords (with DAYO Passwords) Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sales Billing & Invoicing DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO EOP End of Period Post & Pack, Physical Inventory DAYO BO Back Orders DAYO GL General Ledger DAYO Smart Reports A variety of reports pertaining to the above modules DAYO Passwords Password protect your DAYO system DAYOX Network/LAN Index Maintenance Utility DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 2 ■ SAMPLE DIAGRAM OF A BILL OF MATERIALS To help illustrate a Bill of Materials for an ENDITEM, the following diagram is given for an imaginary ENDITEM (78000): COMPONENT ITEMS ┌───────────────────┐ COMPONENT ITEMS │Item 21461 (10 per)│ & SUB ENDITEMS │Item 93571 (5 per) │ ┌───────────────────┐ ┌──┤Item 97561 (4 per) │ │Item 12464 (1 per)─┼<─┘ │Item 97567 (4 per) │ │Item 13466 (10 per)│ └───────────────────┘ │Item 75647 (2 per) │ ┌───────────────────┐ │Item 15675 (1 per)─┤<────┤Item 44314 (1 per) │ │Item 70930 (1 per) │ │Item 37241 (30 per)│ │Item 8393A (1 per) │ └───────────────────┘ ENDITEM │Item 8393B (1 per) │ ┌───────────────────┐ ┌──────────────┐ │Item 28868 (4 per) │ │Item 45771 (3 per) │ │ENDITEM 78000 ├<───┤Item 28686 (5 per) │ │Item 14745 (3 per) │ └──────────────┘ │Item 12688 (5 per)─┼<────┤Item 67865 (3 per) │ │Item 83930 (1 per) │ └───────────────────┘ │Item 34230 (1 per) │ │Item 86770 (1 per) │ ┌───────────────────┐ │Item 99777 (1 per) │ │Item 56751 (1 per) │ │Item 37599 (1 per)─┼<────┤Item 10033 (10 per)│ │Item 92039 (2 per) │ └───────────────────┘ │Item 97647 (1 per)─┼<─┐ ┌───────────────────┐ │Item 94579 (1 per) │ └──┤Item 10000 (1 per) │ └───────────────────┘ │Item 45651 (1 per) │ │Item 23715 (5 per) │ │Item 76431 (5 per) │ └───────────────────┘ *** Note that the Bill of Materials for ENDITEM 78000 requires 138 component items! *** Also note that there is no limit to the number of BOM sub levels... ■ ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM Not all BOMs need to be complex. The following diagram depicts the BOM for ENDITEM: PICTURE-1020 ┌───────────────┐ │PHOTO (1 per) │ ┌──────────────────────┐ │TACKS (2 per) │ │ENDITEM: PICTURE-1020 ├<─────┤BOX-6X7 (1 per)│ └──────────────────────┘ │PADDING (1 per)│ └───────────────┘ *** Note that the Bill of Materials for ENDITEM PICTURE-1020 requires 5 component items! DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 3 ■ EVEN ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM ENDITEM LEVEL1 LEVEL2 ---------- ---------- ---------- MOTOR123 MOTOR123 * DOOR MOTOR123 DOOR DOORHANDLE MOTOR123 DOOR DOORLOCK MOTOR123 DOOR DOORGLASS MOTOR123 * WHEELS4 MOTOR123 WHEELS4 TIRES4 MOTOR123 WHEELS4 RIMS4 MOTOR123 WHEELS4 BOLTS20 MOTOR123 * RADIO MOTOR123 RADIO SPEAKERS MOTOR123 RADIO WOOFERS MOTOR123 RADIO WIRING * Asterisked items are Sub-ENDITEMS. Also note that 9 component items comprise the ENDITEM (MOTOR123). ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO MRP software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO MRP. DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 4 ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO MRP, use the SETUP program found on the DAYO Menu or Update disk, or copy the contents of the DAYO MRP floppy disk into a directory on your hard disk (ie: \DAYOMRP). DAYO MRP will create all the database, index, and configuration files it requires for operation the first time it is 'run'. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO MRP configuration. Type and enter 'DAYOW' at the DOS prompt to run the program (ie: C:\DAYOW ). Be sure to insure that your CONFIG.SYS file (found on your boot up disk), has an adequate 'FILES' statement in it, ie: 'FILES=99'. DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 5 ■ MAIN MENU From the main menu, you can access all the major menu options, or return to DOS... DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ │S M T W T F S │ █ 1 SHOP ORDERS █ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ █──────────────────────█ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│ █ 2 BILL OF MATERIALS █ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│ █──────────────────────█ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│ █ 3 REPORTS █ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│ █──────────────────────█ █▀██▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │ █ 4 CONFIGURATION █ │ │ █──────────────────────█ Copyright (c) 1990-1991 └────────────────────┘ █ 5 MISC ROUTINES █ █──────────────────────█ ███▄ ▄███░ █ 6 EXIT █ █████░ █████░ ███▄███████░ ███▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀███ ██████░ ██████░ ███░ ███░ ███▄███████░ ██ Manufacturing ██ ███░██████░███░ ███░ ███░ ███░ ███░ █▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ ███░ ████░ ███░ ███░ ███░ ███░ ███░ ███░ ██░ ███░ ███████████░ ███░ ███░ ███░ ██░ ███░ ███▀████░ ███▀███████░ ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ ███░ ▀▀ ███░ ███░ ▀███░ ███░ █Database # Records Size█ ███░ ███░ ███░ ▀███░ ███░ █BOM 8802 1731632█ Materials ███░ ▀███░ ███░ █INV 5326 1189272█ Requirement ███░ █INVADJ 44562 2317587█ Planning ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ Build Enditems, Shop Orders, Planning Tools ■ PASSWORD/NAME From the main menu you can enter any of the routines/options, but not until you enter your name (or password if using DAYO Passwords): ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 6 ■ SHOP ORDERS Shop orders contain a group (1 or more) of ENDITEMS that are to be assembled or built. In DAYO MRP, shop orders can be 'tied' to a customer, invoice, back order invoice, or a user inputted comment. The use of shop orders is not required to assemble ENDITEMS, the BOM routine has the capability to do the job... Shop orders are used to schedule the production of ENDITEMs. They also provide a means of prioritizing the assemble process. If using shop orders, the assembly stage is broken down into 5 steps: 1. Create 2. Allocate (add to the required quantity in database BOM.DBF) 3. Transfer ('move' quantities from the inventory to the BOM database, into the field 'WIP_QTY'. This step creates inventory adjustment records for items taken from the inventory database) 4. Assemble (Create the ENDITEM if enough required WIP quantity is present) 5. Update the Inventory (Move the finished/assembled ENDITEMs from the BOM database to the inventory database. Inventory adjustment records are created at this point for the quantities moved) DAYO MRP Version 3.0 TJS LAB ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ ▄███░ ██░ ██░ ▄███▄ █▄███░ █ SHOP ORDERS █ ██░ ██░ ██░ ██░██░ ██░██░ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ▀██▄ ██████░ ██░██░ ██▀██░ █ CREATE SHOP ORDER █ ██░ ██░ ██░ ██░██░ ██░ █ BROWSE SHOP ORDERS █ ███▀ ██░ ██░ ▀███▀ ██░ █ ALLOCATE SHOP ORDER █ █ TRANSFERS: W.I.P. █ ▄███▄ █▄███░ █▄███░ ████░ █▄███░ ▄███░ █ ASSEMBLE SHOP ORDER █ ██░██░ ██░██░ ██░██░ ██░ ██░██░ ██░ █ UPDATE INVENTORY █ ██░██░ ██▄██░ ██░██░ ███░ ██▄██░ ▀██▄ █ RE/PRINT SHOP ORDER █ ██░██░ ██▀█▄ ██░██░ ██░ ██▀█▄ ██░ █ RE/PRINT TRAVELER █ ▀███▀ ██░██░ █▀███░ ████░ ██░██░ ███▀ █ BO SHOP ORDERS █ █ SO FILE MAINTENANCE █ ███▄ ▄███░ █ EXIT █ █████░ █████░ ███▄███████░ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ ██████░ ██████░ ███░ ███░ ███▄███████░ ███░██████░███░ ███░ ███░ ███░ ███░ ███░ ████░ ███░ ███░ ███░ ███░ ███░ ███░ ██░ ███░ ███████████░ ███░ ███░ █ █░ ███░ █▄██░ ███░ ██░ ███░ ███▀████░ ███▀███████░ █ ▄ █░ █░ █░ █░ ███░ ▀▀ ███░ ███░ ▀███░ ███░ █▄ █░▄█░ █░ █░ █░ ███░ ███░ ███░ ▀███░ ███░ █▄█▄█░ █░ █▀▀▀ ███░ ▀███░ ███░ █░█░■ ███░■ █░■ ███░ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 7 ■ CREATE A NEW SHOP ORDER This menu option is used to create new shop orders. A browse selection of all unique ENDITEMS is displayed onto the screen. Find the ENDITEM(s) you want, then press enter to select. ╔═════════════════════════[ CREATE A NEW SHOP ORDER ]════════════════════════╗ ║ ENDITEM DESC COST ║ ║ Select the ╔═══════════════╤════════════════════════════════╤════════════║ ║ ENDITEMS ->║ A2345 │ BIG CAR │ 3432.060 ║ ║ for this ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 16.528 ║ ║ Shop Order. ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 17.560 ║ ║ ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 18.590 ║ ║ █▄ █░ ║ C234234 │ PALADINO NYLON 3-PKT BELLY BAG │ 4.132 ║ ║ ██▄ █░ ║ DD23F │ DOOR │ 5.160 ║ ║ █░█▄█░ ║ E2323 │ HANDLE, DOOR │ 6.190 ║ ║ █░ ▀█░ ║ H23Q │ ADULT BELLY BAGS │ 9.290 ║ ║ ║ I2435 │ ADULT-4 PKT BELLY BAGS │ 10.330 ║ ║ ████░ ║ J4432 │ ADULT-2 PKT BELLY BAG │ 11.360 ║ ║ █▄▄ ║ J64634 │ WIDE MOUTH HIPPO │ 0.000 ║ ║ █▀▀ ║ │ │ ║ ║ ████░ ║ │ │ ║ ║ ║ │ │ ║ ║ █░ █░ ║ │ │ ║ ║ █░ █░ ║ │ │ ║ ║ █▄█▄█░ ║ │ │ ║ ║ █░█░ ║ │ │ ║ ╚══════════════╩═════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (List Selections) A window will appear onto the screen with prompts for key information about the shop order record. Note, a positive quantity is required. The customer and invoice number is not required. Use the COMMENT field for anything you want. ╔═══════════════════════════════════════════════════════════════║ ║ Enditem: A2345 ║ ║ Desc: BIG CAR ║ ║ ║ ║ Comment: Comment Here! ║ ║ * Quantity: 1.000 ║ ║ ║ ║ Customer: 1000 ║ ║ Invoice: 23224 ║ ║ Due Date: 01/19/91 ║ ║ ║ ║ Cost: 2432.060 ║ ║ ║ ║ Hours: 3.220 ║ ║ Labor: 3.761 ║ ║ Labor1: 4.137 ║ ║ Labor2: 5.642 ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 8 Press F2 while adding ENDITEMs to the new shop order to display all records so far added to the shop order. ╔═══════════════════[ SHOP ORDER (40) - LIST OF ENDITEMS ]═══════════════════╗ ║ ENDITEM DESCRIPTION COMMENT ║ ║ A2345 BIG CAR George Moonilal & Sons ║ ║ J42343 NEON ADULT-2 PKT BELLY BAG Shiner's Cars ║ ║ C2434 PALADINO NYLON 3-PKT BELLY BAG Green Dist. Inc. ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... After adding the ENDITEMS, you have the option of adding any comments to the shop order. Note, only the first 21 lines of the notes will print onto the shop order. ╔════════════════════════════════════════════════════════════════════╗ ║ Do you wish to add any notes to this Shop Order? (Y/N) ■ ║ ╚════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF SHOP ORDER NOTES INPUT ─────────────────────────────[ SHOP ORDER NOTES ]───────────────────────────── Put ANY information, comments or notes in this routine! ────────────────────────────────────────────────────────────────────────────── Esc (Exit) Ctrl W (SAVE & Exit) F1 (Help) 5/16 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 9 ■ SHOP ORDER BROWSE & MAINTENANCE This is the maintenance routine for shop orders already created. Use this routine to view, edit fields, edit notes, add ENDITEMS to existing shop orders, delete shop order records, and to reset total cost for a shop order (recorded in the shop order notes database: SO_NOTES.DBF). ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ SHOP ORDER BROWSE & MAINTENANCE ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █ Shop Order: 10002 Invoice: 5054 Customer: 40003 ENDITEM: BP0003 █ █ Comment: Shelf Stockage #89 Desc: GATOR STEM GLASS █ █ QTY: 9.000 Assembled: 0.000 Cost: 18.594 █ █ Date Added: 01/05/91 Last Date Accessed: 01/06/91 Due 01/05/91 █ █ Hours: 3.766 Labor: 5.268 Labor1: 5.795 Labor2: 6.848█ █ Status: Open Allocated?: No Printed?: No Priority: 0.00 █ █ Onhand: 501.000 OnOrder: 0.000 Back Ordered: 0.000 █ █▄▄▄▄▌Total Cost: 2.069▐▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ █ SO COMMENT ENDITEM █ █───────────────────╥────────────────────────────────╥───────────────────────█ █ 10001 ║ For Green & Co. ║ A10001 █ █ 10001 ║ For Green & Co. ║ A10001 █ █ 10002 ║ Shelf Stockage #23 ║ BP0003 █ █ 10002 ║ Shelf Stockage #89 ║ BP0003 █ █ 10003 ║ Martin ║ BP3 █ █ 10003 ║ Martin ║ BP3 █ █ 10003 ║ Martin ║ BP3 █ █ 10004 ║ Glassware, Inc ║ D90001 █ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ Esc (Exit) F1 (Help) F2 (Edit) Ctrl F1 (Shop Order Notes) Ctrl N (Add) Ctrl U (Delete) Alt F1 (Reset Total) F5 (SO) F6 (Comment) F7 (Enditem) F8 (Desc) F9 (Customer) F10 (Invoice) <INSERT ON> 6/100 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 10 ■ FULL SCREEN EDIT - F2 Press F2 to view and subsequently edit all the fields onto the screen at once. ┌────────────────────[ FULL SCREEN EDIT - ENDITEMS.DBF ]─────────────────────┐ │ SO: 10002 │ │ COMMENT: For Order #838 │ │ ENDITEM: BP0003 │ │ DESC: GATOR GLASS #23 │ │ QTY: 9.000 │ │ COST: 18.594 │ │ ASSEMBLED: 0.000 │ │ DATE: 01/05/91 │ │ DUEDATE: 01/05/91 │ │ LASTDATE: 01/06/91 │ │ HOURS: 3.766 │ │ LABOR: 5.268 │ │ LABOR1: 5.795 │ │ LABOR2: 6.848 │ │ PRIORITY: 0 │ │ OPEN: T │ │ ALLOCATED: F │ │ PRINTED: F │ │ CUSTOMER: 103 │ │ INVOICE: 24244 │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ EDIT SHOP ORDER NOTES Press Ctrl F1 to edit the shop order notes. ╔════════════════════════════════════════════════════════════════════╗ ║ Do you wish to add any notes to this Shop Order? (Y/N) ■ ║ ╚════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 11 ■ ADD RECORD TO SHOP ORDER - CTRL N Press Ctrl N to add an ENDITEM to an existing shop order. ╔══════════════════════[ ADD RECORD/MODIFY A SHOP ORDER ]════════════════════╗ ║ ENDITEM DESC COST ║ ║ Select ╔═══════════════╤════════════════════════════════╤════════════║ ║ ENDITEMS ->║ A1234 │ BIG CAR #34 │ 1243.060 ║ ║ to be added ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 16.520 ║ ║ to this ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 17.560 ║ ║ Shop Order. ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 18.590 ║ ║ ▄█▄ ║ C34534 │ PALADINO NYLON 3-PKT BELLY BAG │ 4.130 ║ ║ █░█░ ║ D4 │ DOOR │ 5.160 ║ ║ ██▀██ ║ E4F │ HANDLE, DOOR │ 6.198 ║ ║ █░ █░ ║ HDF345 │ ADULT BELLY BAGS │ 9.290 ║ ║ ║ I634 │ NEON ADULT-4 PKT BELLY BAGS │ 10.330 ║ ║ █▄███░ ║ J234 │ NEON ADULT-2 PKT BELLY BAG │ 11.360 ║ ║ █░ █░ ║ JAR-2 │ JAR #2 │ 0.000 ║ ║ █░ █░ ║ R2D2 │ ROBOT #4,404,499,383,383 │ 1.500 ║ ║ █▀███░ ║ │ │ ║ ║ ║ │ │ ║ ║ █▄███░ ║ │ │ ║ ║ █░ █░ ║ │ │ ║ ║ █░ █░ ║ │ │ ║ ║ █▀███░ ║ │ │ ║ ╚══════════════╩═════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (List Selections) ■ DELETE SHOP ORDER RECORD - CTRL U Press Ctrl U to mark a shop order record for deletion. Note, this only marks the record, use the SO FILE MAINTENANCE routine to 'pack' out the deleted records. ■ RESET SHOP ORDER TOTAL COST - ALT F1 Press Alt F1 to recompute the total cost for a shop order. The result is found in the COST field, in the database SO_NOTES.DBF. ■ FIND SHOP ORDER RECORD Press: F5 to find a shop order based on the SO number F6 for comment search F7 for ENDITEM search F8 for Description search F9 for Customer search F10 for Invoice search DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 12 ■ ALLOCATE SHOP ORDER Use this option to update the required quantity field (REQ_QTY) in the BOM database (BOM.DBF). Note, the required quantity field determines the maximum total amount of items transferred from the inventory to the WIP quantity field (WIP_QTY). ╔══════════════════════════[ ALLOCATE SHOP ORDER ]═══════════════════════════╗ ║ Shop Order: 10923 Comment: GEN MORGAN Date: 01/05/91║ ║ End Item: MISSILE Desc: MISSILE, LONG RANGE Due: 01/05/91║ ║ Qty: 1.000 Assembled: 4.000 Cost: 12422.000 Last Date: 01/06/91║ ║ Customer: 1212 Invoice: 39901 Hours: 123.418 Labor: 0.000║ ║ Priority: 99 Open: Yes Allocated: Yes Printed: Yes ║ ║ SO COMMENT ENDITEM ║ ║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║ ║ Shop ->║ 1212 │ GEN MORGAN │ MISSILE ║ ║ Order ║ 1212 │ GEN MORGAN │ TUBEXXAR657 ║ ║ Record To ║ 1213 │ Harper Florist │ PAR3-1 ║ ║ Allocate ║ 1213 │ │ A244 ║ ║ ║ 1213 │ │ C4 ║ ║ A ║ 1213 │ (Green Only) │ A234 ║ ║ L ║ 1214 │ Geo & Morgan, Inc │ BP0003 ║ ║ L ║ 1214 │ Stacy Smithy │ D243 ║ ║ O ║ 1215 │ George Moonilal │ A234 ║ ║ C ║ 1217 │ Ron Davidson & Co. │ BP0003 ║ ║ A ║ 1217 │ Brenda's Teeth │ BTEETH3 ║ ║ T ║ 1217 │ Gums │ GUMS123 ║ ║ E ║ 1217 │ Bridge │ BRIDGE ║ ╚═════════════╩══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F5 - F10 (Find) You have the option of allocating all records in a shop order, or a specific record (ENDITEM). ╔═══════════════════════════════════════════════════════════════║ ║ Select Option -> Allocate Only Current Shop Order Record ║ ║ Allocate Entire Shop Order ║ ║ Exit/Abort ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 13 The progress of the process is displayed onto the screen: ╔═══════════════════════════════════════════════════════════════║ ║(Level) Item Per-Qty Req-Qty Total Cost ║ ║MISSILE 0.000 1.000 122167.000 ║ ║TRUCK 1.000 12.000 12235.000 ║ ║TUBE 4.000 48.000 1230.000 ║ ║ LINER 4.000 48.000 2154.900 ║ ║ GREASER 8.000 96.000 3233.000 ║ ║BREACH 4.000 48.000 2121.200 ║ ║CONTROLER 1.000 12.000 12300.000 ║ ║ INTERFACE 4.000 48.000 4560.900 ║ ║ SEAT 2.000 24.000 25.000 ║ ║ AC 1.000 12.000 3005.000 ║ ║ STEREO 1.000 12.000 2003.990 ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) ■ TRANSFER TO W.I.P. This is the routine that moves quantity from the inventory database (INV.DBF) into the BOM database (BOM.DBF), and into the WIP_QTY field. The amount TRANSFERRED will not exceed the REQ_QTY, but is totally dependant on the quantity in the inventory ONHAND field. Inventory adjustment records will be created during this process. ╔═══════════════════════════[ TRANSFER TO W.I.P. ]═══════════════════════════╗ ║ Shop Order: 10203 Comment: LaRossa Nose Company Date: 01/05/91║ ║ End Item: NOSEITAL05 Desc: Italian Nose, 5 inch Due: 01/05/91║ ║ Qty: 11.000 Assembled: 0.000 Cost: 100.000 Last Date: 01/06/91║ ║ Customer: 0 Invoice: 0 Hours: 4.603 Labor: 5.605║ ║ Priority: 0 Open: Yes Allocated: No Printed: No ║ ║ SO COMMENT ENDITEM ║ ║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║ ║ Shop ->║ 10023 │ Harper's │ BP0003 ║ ║ Order ║ 10023 │ │ BP0001 ║ ║ Record To ║ 10024 │ Terry J. Smith, Inc │ A243 ║ ║ Transfer ║ 10203 │ LaRossa Nose Company │ NOSEITAL05 ║ ║ To W.I.P. ║ 10203 │ LaRossa Rose Company │ NOSEITAL10 ║ ║ T ║ 11126 │ AAA & Daughters │ C243 ║ ║ R ║ 11126 │ │ BP0003 ║ ║ A ║ 11126 │ │ APSBH-2 ║ ║ N ║ 11126 │ │ C234 ║ ║ S ║ 11127 │ Order #231 │ APSBH-2 ║ ║ F ║ 11127 │ │ BP0001 ║ ║ E ║ 11127 │ │ BP0001 ║ ║ R ║ 11127 │ │ BP0003 ║ ╚═════════════╩══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F5 - F10 (Find) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 14 You can transfer for a specific shop order record (ENDITEM), or the entire shop order. ╔═══════════════════════════════════════════════════════════════║ ║ This option will attempt to move enough inventory into W.I.P. ║ ║ in order make it possible to later assemble the number of ║ ║ ENDITEMS that are as yet unassembled. The quantity of ║ ║ inventory items transferred will not exceed the required ║ ║ quantity as defined in the BOM 'BOM.DBF'. ║ ║ ║ ║ Select Option -> Transfer To W.I.P. For Current Record ║ ║ Transfer To W.I.P. For Entire Shop Order ║ ║ Exit/Abort ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) A report can be printed that simply lists the quantities moved. ╔═══════════════════════════════════════════════════════════════║ ║ This option will attempt to move enough inventory into W.I.P. ║ ║ in order make it possible to later assemble the number of ║ ║ ENDITEMS that are as yet unassembled. The quantity of ║ ║ inventory items transferred will not exceed the required ║ ║ quantity as defined in the BOM 'BOM.DBF'. ║ ║ ║ ║ Select Option -> Transfer To W.I.P. For Entire Shop Order ║ ║ ║ ║ Do you want a Printed Report? (Y/N) ■ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 15 The progress of the operation is displayed onto the screen: ╔═══════════════════════════════════════════════════════════════║ ║(Level) Item Per-Qty Req-Qty Transferred ║ ║D234 7.000 2.000 1.000 ║ ║H243 3.000 2.000 2.000 ║ ║YK90086 3.000 19.000 2.000 ║ ║A234 0.000 0.000 2.000 ║ ║ APSBH-1 10.000 10.000 0.000 ║ ║ APSBH-2 2.000 2.000 0.000 ║ ║B234 3.000 2.000 7.000 ║ ║C4233 4.000 24.000 13.000 ║ ║ YK90086 5.000 24.000 14.000 ║ ║ YKEL1 3.000 24.000 1.000 ║ ║ YKEL2 7.000 27.000 27.000 ║ ║ G2434233-3 8.000 3.000 3.000 ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) ■ ASSEMBLE SHOP ORDER This routine will assemble ENDITEMS if possible based on the quantities found in the WIP_QTY field. ╔══════════════════════════[ ASSEMBLE SHOP ORDER ]═══════════════════════════╗ ║ Shop Order: 1005 Comment: Battle King Parlor Date: 01/05/91║ ║ End Item: BIGGUNBAR Desc: BIG GUN BAR Due: 01/05/91║ ║ Qty: 6.000 Assembled: 4.000 Cost: 112.069 Last Date: 01/06/91║ ║ Customer: 0 Invoice: 12330 Hours: 2.510 Labor: 4.762║ ║ Priority: 0 Open: Yes Allocated: Yes Printed: Yes ║ ║ SO COMMENT ENDITEM ║ ║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║ ║ Shop ->║ 1005 │ Battle King Parlor │ BIGGUNBAR ║ ║ Order ║ 1005 │ │ TAP ║ ║ Record To ║ 1022 │ Perkins Boats │ CATAMAR2 ║ ║ Be ║ 1022 │ Green │ SAIL32-12 ║ ║ Assembled ║ 1022 │ Red │ SAIL32-24 ║ ║ A ║ 1023 │ Harley Limpwrist & Friends │ WHIP#1 ║ ║ S ║ 1023 │ │ WHIP#2 ║ ║ S ║ 1023 │ │ WHIP#3 ║ ║ E ║ 1023 │ │ LEATHERRAW ║ ║ M ║ 1023 │ #4 │ LEATHERCURE ║ ║ B ║ 1023 │ #4 │ BIKER-23 ║ ║ L ║ 1023 │ │ SCOOTER ║ ║ E ║ 1023 │ │ MOPED-3 ║ ╚═════════════╩══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F5 - F10 (Find) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 16 You have the option of assembling the entire shop order, or a specific shop order record (ENDITEM). ╔═══════════════════════════════════════════════════════════════║ ║ This option will assemble then ENDITEM(s) for the Shop ║ ║ Order up to the amount not yet assembled. Shortages of the ║ ║ components will result in fewer Finished/Assembled ENDITEMS. ║ ║ An option exists to print a shortage report for this process. ║ ║ ║ ║ Select Option -> Assemble Only Current Record ║ ║ Assemble Entire Shop Order ║ ║ Exit/Abort ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) A simple report listing the process can be printed. ╔═══════════════════════════════════════════════════════════════║ ║ This option will assemble then ENDITEM(s) for the Shop ║ ║ Order up to the amount not yet assembled. Shortages of the ║ ║ components will result in fewer Finished/Assembled ENDITEMS. ║ ║ An option exists to print a shortage report for this process. ║ ║ ║ ║ Select Option -> Assemble Entire Shop Order ║ ║ ║ ║ Do you wish to pause between ENDITEMs, to adjust the ║ ║ Finished Quantity? (Y/N) ■ ║ ║ ║ ║ Do you want a Printed Report? (Y/N) ■ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 17 A prompt will appear prompting you to enter the number of ENDITEMS to be built. This number defaults to the maximum number that can be built based on the quantities found in the WIP_QTY field. ╔════[ Assemble: 1.000 ]════════════════════════════════════║ ║ ║ ║ 1.000 of 8.000 ENDITEMS can be Assembled! ║ ║ ║ ║ Enter Final Quantity To Be Assembled: 1.000 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) ■ UPDATE INVENTORY WITH FINISHED ENDITEMS Use this routine when ready to move assembled/finished ENDITEMS back into the inventory database from the BOM database. The finished quantity is found in the field: FINIS_QTY. ╔════════════════[ UPDATE INVENTORY WITH FINISHED ENDITEMS ]═════════════════╗ ║ Shop Order: 90002 Comment: FOREVER CARE Date: 01/05/91║ ║ End Item: CASKET34 Desc: Casket #34 Due: 01/05/91║ ║ Qty: 2.000 Assembled: 1.000 Cost: 2050.000 Last Date: 01/19/91║ ║ Customer: 18003 Invoice: 4009 Hours: 0.000 Labor: 0.000║ ║ Priority: 0 Open: Yes Allocated: Yes Printed: No ║ ║ SO COMMENT ENDITEM ║ ║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║ ║ Shop ->║ 90002 │ FOREVER CARE, INC │ CASKET34 ║ ║ Order ║ 90002 │ │ LINER34 ║ ║ ║ 90002 │ │ MOURNERSx15 ║ ║ ║ 90002 │ │ BIGBURN ║ ║ ║ 90003 │ Morgan, Inc │ B33243 ║ ║ ║ 90003 │ │ D234 ║ ║ U ║ 90003 │ │ A243 ║ ║ P ║ 90003 │ │ B23403 ║ ║ D ║ 90003 │ │ B32431 ║ ║ A ║ 90003 │ │ A233 ║ ║ T ║ 90003 │ (See Joe) │ B23401 ║ ║ E ║ 90003 │ │ APSBH-2 ║ ║ ║ 90003 │ │ C42234 ║ ╚═════════════╩══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F5 - F10 (Find) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 18 You can update the inventory for the entire shop order, or the currently highlighted record (ENDITEM). ╔═══════════════════════════════════════════════════════════════║ ║ Select Option -> Update Inventory For Current Record ║ ║ Update Inventory For Entire Shop Order ║ ║ Exit/Abort ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) A simple report of the operation can be printed out. ╔═══════════════════════════════════════════════════════════════║ ║ Select Option -> Update Inventory For Entire Shop Order ║ ║ ║ ║ Do you want a Printed Report? (Y/N) ■ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) The progress of the operation is displayed onto the screen: ╔═══════════════════════════════════════════════════════════════║ ║(Level) Item Per-Qty Req-Qty Transferred ║ ║CASKET34 1.000 1.000 1.000 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╩═══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 19 ■ PRINT/REPRINT SHOP ORDER Shop order can be configured to automatically print upon completion of adding a new one. Use this routine to print or reprint shop orders. ╔════════════════════════[ PRINT/REPRINT SHOP ORDER ]════════════════════════╗ ║ Shop Order: 1022 Comment: Perkins Boats Date: 01/05/91║ ║ End Item: ABIGBOAT Desc: BIG BOAT Due: 01/05/91║ ║ Qty: 8.000 Assembled: 2.000 Cost: 9100.000 Last Date: 01/19/91║ ║ Customer: 1029 Invoice: 1222 Hours: 56.500 Labor: 25.000║ ║ Priority: 2 Open: Yes Allocated: Yes Printed: No ║ ║ SO COMMENT ENDITEM ║ ║ Select ╔═══════════╤════════════════════════════════╤═════════════════║ ║ The Shop ->║ 1022 │ Perkins Boats │ BOAT1 ║ ║ Order ║ 1022 │ │ BOAT34 ║ ║ To ║ 1022 │ │ BOAT40 ║ ║ Print ║ 1022 │ │ BOAT55 ║ ║ or RePrint ║ 1022 │ │ SAIL32-3 ║ ║ ║ 1022 │ │ SAIL40-1A ║ ║ R ║ 1022 │ │ JETSKISUZ233 ║ ║ E ║ 1023 │ Able Morgan │ D ║ ║ P ║ 1023 │ │ A ║ ║ R ║ 1023 │ │ BP0003 ║ ║ I ║ 1025 │ Harley Limpwrist │ BP0001 ║ ║ N ║ 1026 │ Smith, Joe (Green) │ A ║ ║ T ║ 1026 │ (Red & Green) │ BP0001 ║ ╚═════════════╩══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F5 - F10 (Find) Ctrl F1 (Shop Order Notes) A window appears onto the screen while it prints the shop order. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Shop Order: 2 Original Printing! ║ ║ Printing 1 copy of the STANDARD Shop Order on Port: LPT1 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 20 ■ EXAMPLE OF A SHOP ORDER Shop Order: 2 YOUR COMPANY, INC - SHOP ORDER Page: 1 Date Created: 01/05/91 Customer: 100092 Date Due: 01/19/91 Invoice: 1222 Date Printed: 01/19/91 Cost ENDITEM Hours VENDITEM Description/Comment Qty Labor Extended ------------ ------------------------------ ---------- ---------- ---------- BIGCAR BIG CAR 1.000 C 1000.000 1000.000 CAD-1965 CADILAC, OLD JUNK 1.000 H 3.300 3.300 Joe Morgan /// EA L 5.000 5.000 < Allocated > BP0003 GATOR COFFEE MUG WITH LID 10.000 C 18.500 185.000 BETRAS18 222-GATOR COFFEE MUG WITH LID 18/// EA H 3.700 37.000 Salley Morgan L 5.200 52.000 < Allocated > DOOR3 DOOR 1.000 C 5.000 5.000 DOOR-JOES 222-DOOR 5/// EA H 3.300 3.300 Jose George Morgan L 3.800 3.800 < Allocated > ------------------------------------------------------------------------------ Special Comments: Totals! Pieces: 18.000 Weight: 0.000 + Cost: 1190.000 Hours: 43.300 + Labor: 60.800 + Labor1: 0.000 + Labor2: 0.000 -------------------------------- DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 21 ■ PRINT/REPRINT A TRAVELER Use this routine to print a Traveler. Note, read more about the traveler in the configuration options section of this manual. ╔════════════════════════[ PRINT/REPRINT A TRAVELER ]════════════════════════╗ ║ Shop Order: 1032 Comment: Joe Morgan Date: 01/05/91║ ║ End Item: BIGBIKE Desc: HARLEY 1300CC Due: 01/05/91║ ║ Qty: 1.000 Assembled: 0.000 Cost: 12003.000 Last Date: 01/19/91║ ║ Customer: 1003 Invoice: 0 Hours: 104.750 Labor: 0.000║ ║ Priority: 0 Open: Yes Allocated: Yes Printed: No ║ ║ SO COMMENT ENDITEM ║ ║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║ ║ Shop ->║ 1032 │ Joe Morgan │ BIGBIKE ║ ║ Order ║ 1032 │ Joe Morgan │ BIGSEAT ║ ║ ║ 1032 │ Joe Morgan │ BIGHELMET ║ ║ ║ 1033 │ Carmen, Tony & AJ │ BP0003 ║ ║ ║ 1033 │ │ BP0001 ║ ║ T ║ 1033 │ │ A2344 ║ ║ R ║ 1033 │ │ 4P0001 ║ ║ A ║ 1033 │ #4 │ APSBH-12 ║ ║ V ║ 1033 │ │ C324342 ║ ║ E ║ 1033 │ │ BP02343 ║ ║ L ║ 1033 │ #4,red │ APSBH-2 ║ ║ E ║ 1033 │ green │ C342342 ║ ║ R ║ 1033 │ │ APS3BH-4 ║ ╚═════════════╩══════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F5 - F10 (Find) There are 2 user defined Traveler types to select from: ╔══════════════════════════════════════════════════════════════════════════╗ ║ Select Traveler -> Traveler Type 1 ║ ║ Traveler Type 2 ║ ║ Exit ║ ║ ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) A window is displayed onto the screen while it prints the report: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Select Traveler -> Traveler Type 1 ║ ║ ║ ║ Traveler: 25 ║ ║ ║ ║ Printing STANDARD Traveler on Port: LPT1 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 22 ■ EXAMPLE OF A USER DEFINED TRAVELER TRAVELER YOUR COMPANY, INC Page 1 Type 1 Date: 01/19/91 Time 20:16:28 Item PER QTY Required WIP QTY Dept #1 Dept #2 Dept #3 ------------ ---------- ---------- ---------- -------- -------- -------- A24234 0.00 110.00 0.00 ________ ________ ________ APSBH-2 1.00 110.00 0.00 ________ ________ ________ APSBH-1 2.00 220.00 0.00 ________ ________ ________ BP0003 2.00 220.00 0.00 ________ ________ ________ D234432 2.00 220.00 0.00 ________ ________ ________ H234234432 20.00 2200.00 0.00 ________ ________ ________ YK90086 10.00 1100.00 0.00 ________ ________ ________ A423432 1.00 110.00 0.00 ________ ________ ________ APSBH-1 10.00 1100.00 10.00 ________ ________ ________ APSBH-2 2.00 220.00 2.00 ________ ________ ________ B243432 1.00 23.00 7.00 ________ ________ ________ C432324 1.00 24.00 0.00 ________ ________ ________ YK90086 1.00 25.00 0.00 ________ ________ ________ YKEL14 1.00 26.00 0.00 ________ ________ ________ YKEL24 1.00 27.00 0.00 ________ ________ ________ G423432 45.00 28.00 0.00 ________ ________ ________ E40 9.00 29.00 0.00 ________ ________ ________ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 23 ■ MAKE SHOP ORDERS FROM BACK ORDERS This special routine was added for the use of DAYO users that create invoice back orders for ENDITEMS that are later to be assembled. If run, all records not deleted, and with the field MRP equal to false (.F.) will be 'looked at' to determine if it is an ENDITEM, and if so, to create a shop order for it (New shop order number created for unique invoice number). ╔═══════════════════[ MAKE SHOP ORDERS FROM BACK ORDERS ]════════════════════╗ ║ This routine will make Shop Orders out of all Back Orders that contain a ║ ║ manufactured item (defined in the BOM as an ENDITEM). ║ ║ ║ ║ Only 1 Shop Order per Back Order Invoice (number) will be created. ║ ║ ║ ║ Do you wish to continue? (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██▄████░ ▄█████▄ ▄██████░ ▄█████▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██▄ ██░ ██░ ██░ ║ ║ ███████░ ██░ ██░ █████████■ ▀█████▄ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██▀ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██▀████░■ ▀█████▀■ ██████▀■ ▀█████▀■ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 24 The progress of the operation is displayed with an 'hour glass' type progress graph: DAYO MRP Version 3.0 TJS LAB ╔══╔══════════════════════╗ SHOP ORDERS FROM BACK ORDERS ]═══════════════════╗ ║ ║ ░░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░░ ║hop Orders out of all Back Orders that contain a ║ ║ ║ ░░▌ ▐░░ ║ed in the BOM as an ENDITEM). ║ ║ ║ ░░▌ ▐░░ ║ ║ ║ ║ ░░▌██████████████▐░░ ║ck Order Invoice (number) will be created. ║ ║ ║ ░░▌██████████████▐░░ ║ ║ ║ ║ ░░▌██████████████▐░░ ║ (Y/N) ║ ║ ║ ░░█▄▄▄▄▄▌ ▐▄▄▄▄▄█░░ ║ ║ ║ ║ ░░░░░░░░▌██▐░░░░░░░░ ║ ║ ║ ║ ░░░░░░░░▌ ▐░░░░░░░░ ║ ║ ║ ║ ░░█▀▀▀▀▀▌ ▐▀▀▀▀▀█░░ ║ ║ ║ ║ ░░▌100% ▐░░ ║ ║ ║ ║ ░░▌80% ██ ▐░░ ║████▄ ▄██████░ ▄█████▄ ║ ║ ║ ░░▌60% ▐░░ ║░ ██░ ██░ ██░ ██░ ║ ║ ║ ░░▌██████████████▐░░ ║░ ██░ ██▄ ██░ ██░ ██░ ║ ║ ║ ░░▌██████████████▐░░ ║░ ██░ █████████■ ▀█████▄ ██░ ██░ ║ ║ ║ ░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░ ║░ ██░ ██▀ ██░ ██░ ██░ ║ ║ ║ ░▌ PROGRESS GLASS ▐░ ║░ ██░ ██░ ██░ ██░ ║ ║ ║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ║████▀■ ██████▀■ ▀█████▀■ ║ ║ ╚══════════════════════╝ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 25 ■ FILE MAINTENANCE FOR SHOP ORDERS Use this routine to permanently remove deleted records from the databases BOM.DBF and SO.DBF. Shop order notes can also be deleted and removed if so desired. ╔════════════════════[ FILE MAINTENANCE FOR SHOP ORDERS ]════════════════════╗ ║ This routine will remove all closed Shop Orders (OPEN=.F.) from the ║ ║ active Shop Orders database (SO.DBF). The records will be placed into ║ ║ the Shop Order History database (SOHIST.DBF). ║ ║ Deleted records from the BOM database (BOM.DBF) are removed. ║ ║ An option exists to delete and remove Shop Order notes from the database: ║ ║ SO_NOTES.DBF if the Shop Order has been closed. ║ ║ Deleted records in all databases are PERMANENTLY REMOVED, so please be ║ ║ VERY careful when running this routine! ║ ║ A backup of the databases is highly recommended BEFORE using this routine! ║ ║ ║ ║ Perform File Maintenance? (Y/N) ║ ║ ║ ║ Remove Closed Shop Order Notes? (Y/N) ║ ║ ║ ║███░███░█░ ███░ █▄ ▄█░ █ ███░█░ █░█████░███░█░ █░ █░ █░ █░▄██░███░║ ║█░ █░ █░ █░ █▀█▀█░ █▀█░ █░ ██░█░ █░ █░ ██░█░ █▀█░ ██░█░█░ █░ ║ ║███░ █░ █░ ██░ █░█░█░ █░█░ █░ ████░ █░ ██░ ████░ █░█░ ████░█░ ██░ ║ ║█░ █░ █░ █░ █░█░█░▄█▄█▄ █░ █░██░ █░ █░ █░██░▄█▄█▄ █░██░█░ █░ ║ ║█░ █░ █░ █░ █░▀ █░█░ █░ █░ █░▀█░ █░ █░ █░▀█░█░ █░█░▀█░█░ █░ ║ ║█░ ███░███░███░ █░ █░█░ █░███░█░ █░ █░ ███░█░ █░█░ █░█░ █░▀██░███░║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 26 ■ BILL OF MATERIALS (BOM) BROWSE & MAINTENANCE This is the browse and maintenance routine for the Bill of Materials (BOM) database: BOM.DBF. This database is the heart of the MRP application. From this routine, you can accomplish many MRP process, ie: edit, Add/Define new ENDITEMS and Bill of Materials, Add new records to existing BOMs, delete records, resort BOMs, transfer quantities, assemble items, UnAssemble items, print a Traveler, or find records based on 11 indexes. ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ Bill of Materials (BOM) Browse & Maintenance ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █ End Item: ABIGCAR Item: WHEELS4 Cost: 986.500 Type: CAR █ █ Description: WHEELS Class: CW Last Date: 01/19/91█ █ Per Qty: 4.000 Required: 28.000 WIP Qty: 8.000 Pos: 1.02 █ █ Mfg PTD: 458.000 Mfg YTD: 4476.000 Assembled: 0.000 █ █ Hours: 0.240 Labor: 1.771 Labor1: 4.148 Labor2: 5.657 █ █ Onhand: 6.000 Onorder: 360.000 Back Order: 10.000 █ █▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ █ ENDITEM DESC COST LEVEL1 █ █──────────────╥────────────────────────────────╥────────────╥───────────────█ █ ABIGCAR ║ BIG CAR ║ 13322.000 ║ █ █ ABIGCAR ║ WHEELS ║ 986.500 ║ WHEELS4 █ █ ABIGCAR ║ INSURANCE ║ 1615.900 ║ CARINS12FUL █ █ APSBH-2 ║ FL NEON KIT ║ 316.528 ║ █ █ APSBH-2 ║ FLORIDA WATER BOTTLE ║ 19.627 ║ BP2690A █ █ APSBH-2 ║ GATOR COFFEE MUG WITH LID ║ 18.594 ║ BP0003 █ █ APSBH-2 ║ NINJA TURTLE BIG MOUTH WTR BTL ║ 23.759 ║ BP4963B █ █ APSBH-2 ║ HANDLE, DOOR ║ 6.198 ║ BP2690A █ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ Esc (Exit) F1 (Help) F2 (Edit) F3 (Add/Define New ENDITEM and BOM) Ctrl N(Add) Ctrl U(Delete/Recall) Ctrl F10(ReSort BOM) Ctrl F1(Reset) Alt F5 (Transfers) Alt F6 (Assemble) Alt F7 (UnAssemble) Alt P (Print) F5 (Find) F6 (Change Index) Current Index: ENDITEM DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 27 ■ FULL SCREEN EDIT - F2 Press F2 to edit all fields in the database BOM.DBF at once onto the screen. ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ ENDITEM: ABIGCAR LASTTIME: 18:27:03 │ │ DESC: WHEELS HOURS: .240 │ │ COST: 986.500 LABOR: 1.771 │ │ LEVEL1: WHEELS4 LABOR1: 4.148 │ │ LEVEL2: LABOR2: 5.657 │ │ LEVEL3: OVERRIDE: F │ │ LEVEL4: POSITION: 1.02 │ │ LEVEL5: │ │ LEVEL6: │ │ LEVEL7: │ │ LEVEL8: │ │ BUILD_QTY: 0.000 │ │ FINIS_QTY: 0.000 │ │ OPEN_QTY: 0.000 │ │ WIP_QTY: 8.000 │ │ REQ_QTY: 28.000 │ │ PER_QTY: 4.000 │ │ PTD_QTY: 458.000 │ │ YTD_QTY: 4476.000 │ │ DATE: 01/05/91 │ │ LASTDATE: 01/19/91 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 28 ■ CREATE A NEW BILL OF MATERIALS (BOM) - F3 Press F3 to create a new Bill of Materials. ╔══════════════════[ CREATE A NEW BILL OF MATERIALS (BOM) ]══════════════════╗ ║ ║ ║ ITEM DESC ONHAND ║ ║ ╔══════════════╤════════════════════════════════╤══════════║ ║Select ENDITEM ->║ ABIGCAR │ BIG CAR │ 1.00 ║ ║ ║ APSBH-1 │ FL GATOR DELUXE FOAM WTR BOTTL │ 0.00 ║ ║ ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 0.00 ║ ║ ██▄██▄██░ ║ B342KIT │ 4-PKT BELLY BAG LEATHER LK │ 0.00 ║ ║ ██░██░██░ ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 174.00 ║ ║ ██░██░██░ ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 3505.00 ║ ║ ██░ ██░ ║ BP2690A │ FLORIDA WATER BOTTLE │ 610.00 ║ ║ ║ BP2690AB │ FLORIDA BIG MOUTH WATER BOTTLE │ 205.00 ║ ║ ██▄████░ ║ BP4945B │ NEW KIDS BIG MOUTH WATER BOTTL │ 215.00 ║ ║ ██░ ██░ ║ BP4963 │ NINJA TURTLES WATER BOTTLE │ 226.00 ║ ║ ██▀▀██▀ ║ BP4963B │ NINJA TURTLE BIG MOUTH WTR BTL │ 237.00 ║ ║ ██░ ▀██░ ║ BP5666B │ SIMPSONS WATER BOTTLE │ 246.00 ║ ║ ║ BP5666WH │ SIMPSONS PLASTIC MUG │ 234.00 ║ ║ ██▄████░ ║ BP7080WH │ GATOR WATER BOTTLE │ 265.00 ║ ║ ██░ ██░ ║ C2342 │ PALADINO NYLON 3-PKT BELLY BAG │ 0.00 ║ ║ ██▀▀▀▀▀ ║ D142 │ DOOR │ 0.00 ║ ║ ██░ ║ E52333 │ HANDLE, DOOR │ 0.00 ║ ╚═════════════════╩══════════════════════════════════════════════════════════╝ Esc (Exit) F5 (ITEM) F6 (DESC) F7 (VENDOR) F8 (VENDITEM) F9 (TYPE) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 29 ■ ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM) After selecting the ENDITEM, you will be given a browse of all inventory items to select the component items for the ENDITEM. ╔═══════════[ ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM) ]═══════════╗ ║ ║ ║ ITEM DESC ║ ║ ╔══════════════════╤════════════════════════════════════║ ║Select Components ->║ BP2690A │ FLORIDA WATER BOTTLE ║ ║ ║ BP2690AB │ FLORIDA BIG MOUTH WATER BOTTLE ║ ║For LEVEL1 ║ BP4945B │ NEW KIDS BIG MOUTH WATER BOTTL ║ ║ ║ BP4963 │ NINJA TURTLES WATER BOTTLE ║ ║ ║ BP4963B │ NINJA TURTLE BIG MOUTH WTR BTL ║ ║ █▄██░ ║ BP5666B │ SIMPSONS WATER BOTTLE ║ ║ █░ █░ ║ BP5666WH │ SIMPSONS PLASTIC MUG ║ ║ █▀▀█░ ║ BP7080WH │ GATOR WATER BOTTLE ║ ║ █▀██░ ║ C124324 │ PALADINO NYLON 3-PKT BELLY BAG ║ ║ ║ D4142142 │ DOOR ║ ║ ████░ ║ E63G43525 │ HANDLE, DOOR ║ ║ █░ █░ ║ EV044JW │ DENIM BELLY BAG ║ ║ ████░ ║ F354453F │ PALADINO LEATHER LOOK-BLACK BB ║ ║ ║ GFF3434 │ CHILDREN'S BELLY BAGS ║ ║ █▄█▄█░ ║ H34F34 │ ADULT BELLY BAGS ║ ║ █░█░█░ ║ IF3434F43 │ NEON ADULT-4 PKT BELLY BAGS ║ ║ █░ █░ ║ J2345324 │ NEON ADULT-2 PKT BELLY BAG ║ ╚════════════════════╩═══════════════════════════════════════════════════════╝ Esc (Exit) F5 (ITEM) F6 (DESC) F7 (VENDOR) F8 (VENDITEM) F9 (TYPE) 19/26 The Per Quantity is the basic number/quantity of each item that it requires to build one (1) ENDITEM. Must be greater than 0 for anything other than an ENDITEM or SUB ENDITEM. ╔═════════════════════════════════════════════════════════════════════╗ ║ Enter Per Quantity: 10 . ║ ╚═════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 30 If the level1 item is found to be an ENDITEM itself, the progress of the merging is displayed onto the screen: ╔═════════════[ COMPONENT IS AN ENDITEM, ADDING ITS COMPONENTS ]═════════════╗ ║LEVEL1 LEVEL2 LEVEL3 LEVEL4 LEVEL5 LEVEL6 ║ ║D11ASD B100112 ║ ║D11ASD A100112 APSBH-2 ║ ║D11ASD A299112 APSBH-1 ║ ║D11ASD A399112 ║ ║D11ASD YK90086 ║ ║D11ASD H323312 ║ ║D11ASD ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ ADD ITEM FROM INVENTORY FOR CURRENT BOM - CTRL N Press Ctrl N to add a BOM record. THE NEW RECORD WILL FALL JUST AFTER THE CURRENTLY HIGHLIGHTED RECORD. ╔════════════════[ ADD ITEM FROM INVENTORY FOR CURRENT BOM ]═════════════════╗ ║ Will Insert New Record Between the following: ║ ║ ENDITEM LEVEL1 LEVEL1 DESCRIPTION ║ ║ BP2690A BP2690A DOOR ║ ║ ************ ************ ************ ****************************** ║ ║ BP2690A D2423 D2344 DOOR HANDLE ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ITEM DESC ONHAND ONORDER ║ ║════════════════╤════════════════════════════════╤═══════════╤══════════════║ ║ ABIGCAR │ BIG CAR │ 1.00 │ 12.00 ║ ║ APSBH-1 │ FL GATOR DELUXE FOAM WTR BOTTL │ 0.00 │ 0.00 ║ ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 0.00 │ 58.00 ║ ║ B2345 │ 4-PKT BELLY BAG LEATHER LK │ 0.00 │ 12.00 ║ ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 174.00 │ 78.00 ║ ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 3505.00 │ 82.00 ║ ║ BP2690A │ DOOR │ 610.00 │ 97.00 ║ ║ D2344 │ DOOR HANDLE │ 205.00 │ 0.00 ║ ║ BP4945B │ NEW KIDS BIG MOUTH WATER BOTTL │ 215.00 │ 0.00 ║ ║ BP4963 │ NINJA TURTLES WATER BOTTLE │ 226.00 │ 0.00 ║ ║ BP4963B │ NINJA TURTLE BIG MOUTH WTR BTL │ 237.00 │ 0.00 ║ ║ BP5666B │ SIMPSONS WATER BOTTLE │ 246.00 │ 0.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Item) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 31 After selecting the item, you will be given the option of editing or changing the different levels that contain item numbers. ╔════════════════[ ADD ITEM FROM INVENTORY FOR CURRENT BOM ]═════════════════╗ ║ Will Insert New Record Between the following: ║ ║ ENDITEM LEVEL1 LEVEL1 DESCRIPTION ║ ║ BP2690A BP2690A DOOR ║ ║ ************ ************ ************ ****************************** ║ ║ BP2690A D D DOOR HANDLE ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║ Level1: BP4945B ║ ║ Level2: ║ ║ Level3: ║ ║ Level4: ║ ║ Level5: ║ ║ Level6: ║ ║ Level7: ║ ║ Level8: ║ ║ ║ ║ Per Quantity: 0.000 ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Item) ■ DELETE BOM RECORD - CTRL U Press Ctrl U to mark a record for deletion. ■ RESORT A BOM - CTRL F10 This option resets and rebuilds the PRIORITY field in the database BOM.DBF. ┌─────────────────────────────────┐ │ Standby, Doing A ReSort! 1.00 │ └─────────────────────────────────┘ ■ RESET ITEM FIELD Press Ctrl F1 to reset the ITEM field on each BOM component record. This field is useful in determining what ENDITEMS are related to a specific component item DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 32 ■ BOM TRANSFERS TO/FROM INVENTORY ONHAND & BOM WIP_QTY - ALT F5 This option is used to move quantities from the inventory and into the BOM, Work in Process (WIP), or to move WIP quantity back to the inventory. Note, inventory adjustments records are created. ╔══════════[ BOM TRANSFERS TO/FROM INVENTORY ONHAND & BOM WIP_QTY ]══════════╗ ║ This routine transfers items to/from the Inventory database (INV.DBF) ║ ║ ONHAND field and to/from the BOM database (BOM.DBF) WIP_QTY field. ║ ║ Note, an Inventory Adjustment record is created for every transaction... ║ ║ ENDITEM: BP2690A Desc: MOTOR #32 Cost: 19.627║ ║ ITEM: H234234 Desc: TORQUE SHAFT Cost: 9.297║ ║ Per Qty: 180.000 Required: 0.000 Wip 0.000 POS: 2.00║ ║ Finished: 0.000 Onhand Inventory: 0.000 Last Date: / / ║ ║ Fill ALL Required (ONHAND to WIP_QTY) ║ ║ Select Fill Required WIP_QTY From ONHAND, This ENDITEM Only ║ ║ Transfer Fill Required WIP_QTY From ONHAND, This Record Only ║ ║ Option -> ALL Finished QTY to Inventory ║ ║ Finished QTY to Inventory For This ENDITEM Only ║ ║ Exit ║ ║ █▄███░▄███▄ █░ █░ █████░█▄███░ █░ █░ █░▄██▄ ████░████░█▄███░▄██▄ ║ ║ █░ █░█░ █░██░██░ █░ █░ █░ ███░ ██░ █░█░ █░ █░ █░ █░█░ ║ ║ █░ █░█░ █░█████░ █░ █░ █░ █░█░ ███░█░█░ █░ █░ █░ █░█░ ║ ║ █████░█░ █░█░█░█░ █░ █████░ █░█░ █░███░▀██▄ ███░ ███░ █████░▀██▄ ║ ║ █░ █░█░ █░█░█░█░ █░ █░██░ ███░ █░ ██░ █░█░ █░ █░██░ █░ ║ ║ █░ █░█░ █░█░▀ █░ █░ █░ █▄ █▀ ▀█░█░ ▀█░ █░█░ █░ █░ █▄ █░ ║ ║ █▀███░▀███▀ █░ █░ █░ █░ █░█░ █░█░ █░▀██▀ █░ ████░█░ █░▀██▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) A progress graph is displayed onto the screen as the routine performs the action: ╔═╔══════════════════════╗ TO/FROM INVENTORY ONHAND & BOM WIP_QTY ]══════════╗ ║ ║ ░░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░░ ║tems to/from the Inventory database (INV.DBF) ║ ║ ║ ░░▌ ▐░░ ║ the BOM database (BOM.DBF) WIP_QTY field. ║ ║ ║ ░░▌██████████████▐░░ ║tment record is created for every transaction... ║ ║ ║ ░░▌██████████████▐░░ ║esc: MOTOR #32 Cost: 19.627║ ║ ║ ░░▌██████████████▐░░ ║esc: TORQUE SHAFT Cost: 9.297║ ║ ║ ░░▌██████████████▐░░ ║quired: 0.000 Wip 0.000 POS: 2.00║ ║ ║ ░░█▄▄▄▄▄▌ ▐▄▄▄▄▄█░░ ║nhand Inventory: 0.000 Last Date: / / ║ ║ ║ ░░░░░░░░▌ ▐░░░░░░░░ ║ ║ ║ ║ ░░░░░░░░▌██▐░░░░░░░░ ║ ║ ║ ║ ░░█▀▀▀▀▀▌ ▐▀▀▀▀▀█░░ ║HAND ║ ║ ║ ░░▌100% ▐░░ ║ ║ ║ ║ ░░▌80% ▐░░ ║ration? (Y/N) ║ ║ ║ ░░▌60% ██ ▐░░ ║ ║ ║ ║ ░░▌40% ▐░░ ║████░█▄███░ █░ █░ █░▄██▄ ████░████░█▄███░▄██▄ ║ ║ ║ ░░▌██████████████▐░░ ║ █░ █░ █░ ███░ ██░ █░█░ █░ █░ █░ █░█░ ║ ║ ║ ░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░ ║ █░ █░ █░ █░█░ ███░█░█░ █░ █░ █░ █░█░ ║ ║ ║ ░▌ PROGRESS GLASS ▐░ ║ █░ █████░ █░█░ █░███░▀██▄ ███░ ███░ █████░▀██▄ ║ ║ ║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ║ █░ █░██░ ███░ █░ ██░ █░█░ █░ █░██░ █░ ║ ║ ╚══════════════════════╝ █░ █░ █▄ █▀ ▀█░█░ ▀█░ █░█░ █░ █░ █▄ █░ ║ ║ █▀███░▀███▀ █░ █░ █░ █░ █░█░ █░█░ █░▀██▀ █░ ████░█░ █░▀██▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 33 ■ ASSEMBLE CURRENT ENDITEM - ALT F6 This routine will create finished ENDITEMS from the component items if enough required WIP quantity (WIP_QTY) is available. The maximum number of ENDITEM that can be built is the de facto standard. ╔════════════════════════[ ASSEMBLE CURRENT ENDITEM ]════════════════════════╗ ║ This routine will determine the maximum number that can be assembled for ║ ║ this ENDITEM. You can adjust that quantity prior to the ASSEMBLING the ║ ║ ENDITEM. THIS ROUTINE DOES NOT UPDATE THE SHOP ORDER DATABASE (SO.DBF)! ║ ║ ║ ║ ENDITEM: BP2690A Desc: MOTOR #3 Cost: 19.627║ ║ ITEM: H234 Desc: GEAR #32 Cost: 9.297║ ║ Per Qty: 180.000 Required: 0.000 Wip 0.000 POS: 2.00║ ║ Finished: 0.000 Onhand Inventory: 79.000 Last Date: / / ║ ║ ║ ║ ║ ║ Continue With Operation? (Y/N) ■ ║ ║ ║ ║ █░ ▄███▄ ▄███▄ █████░ █░ █░ █▄████░ █░ █████░ ║ ║ █▀█░ █░ █░ █░ ██░ ██░ █░ █░ █░ █░ ║ ║ █▀ ▀█░ █░ █░ █░ ███▄███░ █░ █░ █░ █░ ║ ║ █░ █░ ▀███▄ ▀███▄ ███░ █░███░█░ ██████░ █░ ███░ ║ ║ █▄▄▄█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ ██░ ██░ █░ █░ █░ █░ ▀ █░ █░ █░ █░ █░ ║ ║ █░ █░ ▀███▀ ▀███▀ █████░ █░ █░ █▀████░ █████░ █████░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 34 ■ UNASSEMBLE CURRENT ENDITEM - ALT F7 Use this routine to unassemble ENDITEMS into its component items. This step will sometimes be necessary, since the assembly routine only 'looks at' component items, ignoring the field FINIS_QTY of component items. ╔═══════════════════════[ UNASSEMBLE CURRENT ENDITEM ]═══════════════════════╗ ║ This routine will un-assemble the finished quantity (FINIS_QTY), or the ║ ║ ONHAND in the inventory. ║ ║ This step is REQUIRED in the DAYO assembly process, since the process ║ ║ does not utilize the FINIS_QTY or ONHAND quantities of 'Sub' ENDITEMS. ║ ║ ENDITEM: D444 Desc: DOOR Cost: 5.165║ ║ ITEM: B234 Desc: DOOR HANDLE Cost: 3.099║ ║ Per Qty: 23.000 Required: 23.000 Wip 7.000 POS: 6.00║ ║ Finished: 0.000 Onhand Inventory: 0.000 Last Date: 01/19/91 ║ ║ ║ ║ ║ ║ Continue With Operation? (Y/N) ■ ║ ║ ║ ║ ║ ║█░ █░ █░ █░ █░ ▄███▄ ▄███▄ ████░ █░ █░ █▄████░ █░ ████░║ ║█░ █░ ██░ █░ ██░ █░ █░ █░ ██░ ██░ █░ █░ █░ █░ ║ ║█░ █░ ███░ █░ █▀▀█░ █░ █░ █░ ███▄███░ █░ █░ █░ █░ ║ ║█░ █░ █░██░█░ ██░ █░ █░ ▀███▄ ▀███▄ ███░ █░███░█░ ██████░ █░ ███░ ║ ║█░ █░ █░ ███░ █▄▄█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║█░ █░ █░ ██░ ██░ ██░ █░ █░ █░ █░ ▀ █░ █░ █░ █░ █░ ║ ║████▀█░ █░ █░ █░ █░ ▀███▀ ▀███▀ ████░ █░ █░ █▀████░ █████░ ████░║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 35 ■ PRINT TRAVELER - ALT P Press Alt P or Alt T to print out a user defined Traveler report. Note, read more about Travelers in the configuration section of this manual. An option will appear requesting you to select from 1 of 2 Traveler types: ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ Bill of Materials (BOM) Browse & Maintenance ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █End Item: D Item: B Cost: 3.099 Type: █ █Description: 4-PKT BELLY BAG LEATHER LK Class: BB Last Date: 01/19/91█ █Per Qty: 23.000 Required: 23.000 WIP Qty: 7.000 Pos: 6.00 █ █Mfg PTD: 7.000 Mfg YTD: 7.000 Assembled: 0.000 █ █Hours: 3.430 Labor: 3.871 Labor1: 4.258 Labor2: 5.806 █ █Onhand: 0.000 Onorder: 12.000 Back Order: 4.000 █ █▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ █ ENDITEM DESC COST LEVEL1 █ █──────────────╥────────────────────────────────╥────────────╥───────────────█ █ D ║ ADULT BELLY BAGS ║ 9.297 ║ H █ █╔══════════════════════════════════════════════════════════════════════════╗█ █║ Select Traveler -> Traveler Type 1 ║█ █║ Traveler Type 2 ║█ █║ Exit ║█ █║ ║█ █╚══════════════════════════════════════════════════════════════════════════╝█ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ Esc (Exit) F1 (Help) F2 (Edit) F3 (Add/Define New ENDITEM and BOM) Ctrl N (Add) Ctrl U (Delete/Recall) Ctrl F10 (ReSort BOM) Alt F5 (Transfers) Alt F6 (Assemble) Alt F7 (UnAssemble) Alt P (Print) F5 (Find) F6 (Change Index) Current Index: ENDITEM ■ FIND BOM RECORD F5 Press F5 to find a BOM record based on the current index. ■ CURRENT INDEX - F6 Press F6 to select the current index. Note, there are 11 to select from. ╔════════════════════════════════════╗ ║ Select Index -> ENDITEM ║ ║ DESCRIPTION ║ ║ LEVEL1 ║ ║ LEVEL2 ║ ║ LEVEL3 ║ ║ LEVEL4 ║ ║ LEVEL5 ║ ║ LEVEL6 ║ ║ LEVEL7 ║ ║ LEVEL8 ║ ║ ENDITEM UNIQUE * ║ ╚════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 36 ■ REPORTS There are 21+ reports and routines in this section used to report or list ENDITEMS, Bill of Materials, Shop Orders, and Inventory Adjustments. ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █ MRP REPORTS/ROUTINES █ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ █ End Items List █ █ End Items Expanded #1 █ █ End Items Expanded #2 █ █ BOM ABBRE. Report █ █ BOM Report #1 █ █ BOM Report #2 █ █ BOM Report #3 █ █ BOM ALL (Like #1) █ █ BOM ALL (Like #2) █ █ BOM ALL (Like #3) █ █ BOM Requirements/Short █ █ Shop Order List █ █ Shop Order Expanded #1 █ █ Shop Order Expanded #2 █ █ Shop Order History #1 █ █▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ █ Scroll & Select Option █ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ ■ REPORTS/ROUTINES LISTING End Items List Shop Order List End Items Expanded #1 Shop Order Expanded #1 End Items Expanded #2 Shop Order Expanded #2 BOM ABBRE. Report Shop Order History #1 BOM Report #1 Shop Order History #2 BOM Report #2 MFG History (INVADJ.DBF) BOM Report #3 MFG History Single Item BOM ALL (Like #1) Component/Whereis Item BOM ALL (Like #2) View Reports On Screen BOM ALL (Like #3) Configuration Settings BOM Requirements/Short Printer Setup DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 37 ■ ENDITEMS LIST This report list all unique ENDITEMS to printer or file. An ENDITEM is the BOM record that starts a Bill of Material, and contains an empty LEVEL1 field. ╔═════════════════════════════[ ENDITEMS LIST ]═════════════════════════════╗ ║ ║ ║ This report lists all unique ENDITEMS (in ENDITEM order). ║ ║ Uses Report Form: EIRPT.FRM. Width: 80 characters. ║ ║ Includes Fields: ENDITEM, DESC, COST, LABOR & HOURS. ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EILIST.TXT ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ ENDITEMS LIST EXAMPLE Page No. 1 YOUR COMPANY, INC 01/19/91 ENDITEM LISTING ENDITEM DESCRIPTION COST LABOR HOURS ------------ ------------------------------ ---------- ---------- ---------- AKDK BIG CAR #2 4122.000 3.761 3.220 APSBH-2 FL NEON DELUXE FOAM WTR BOTTLE 16.520 3.782 3.260 BP0001 GATOR & FLORIDA PLASTIC MUGS 17.560 3.824 3.340 BP0003 GATOR COFFEE MUG WITH LID 18.590 3.776 3.250 BP2690A FLORIDA WATER BOTTLE 19.620 0.000 0.000 C3223 PALADINO NYLON 3-PKT BELLY BAG 4.130 3.803 3.300 D452 DOOR 122.000 3.839 3.370 E23444 HANDLE, DOOR 6.190 4.092 3.850 H23423 ADULT BELLY BAGS 9.290 3.908 3.500 I6346434 NEON ADULT-4 PKT BELLY BAGS 10.330 0.000 0.000 J346543 NEON ADULT-2 PKT BELLY BAG 11.360 3.992 3.660 JAR-1 JAR 0.000 3.755 3.210 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 38 ■ ENDITEMS EXPANDED REPORT #1 ╔══════════════════════[ ENDITEMS EXPANDED REPORT #1 ]═══════════════════════╗ ║ ║ ║ This report lists all unique ENDITEMS (in ENDITEM order). ║ ║ Uses Report Form: EIRPT1.FRM. Width: 131 characters. ║ ║ Includes Fields: ENDITEM, DESC, COST, LABOR, HOURS, FINISHED, PTD, YTD, ║ ║ DATE & LASTDATE ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EIRPT1.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ ENDITEMS EXPANDED REPORT #2 ╔══════════════════════[ ENDITEMS EXPANDED REPORT #2 ]═══════════════════════╗ ║ ║ ║ This report lists all unique ENDITEMS (in ENDITEM order). ║ ║ Uses Report Form: EIRPT2.FRM. Width: 131 characters. ║ ║ Includes Fields: ENDITEM, DESC, COST, LABOR, HOURS, FINISHED, ONHAND, ║ ║ BO, TYPE, CLASS, and a Comment Space ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EIRPT2.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 39 ■ ABBREVIATED BILL OF MATERIALS REPORT This Bill of Materials report is 80 characters wide and can be directed to printer or file. Like the rest of the BOM reports for a single ENDITEM, a browse of all unique ENDITEMS will appear to select from if you press enter on an empty prompt. ╔══════════════════[ ABBREVIATED BILL OF MATERIALS REPORT ]══════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ ║ ║ comprise the selected EndItem. Uses Report Form: FLOW.FRM. Width: 80 char.║ ║ ║ ║ ENDITEM DESC COST ║ ║ ═════════════╤════════════════════════════════╤══════════║ ║Select End Item -> A234333 │ BIG CAR │ 2.069║ ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 16.528║ ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 17.561║ ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 18.594║ ║ BP2690A │ FLORIDA WATER BOTTLE │ 19.627║ ║ Y45RR3 │ PALADINO NYLON 3-PKT BELLY BAG │ 4.132║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F5 (Find ENDITEM) F6 (Find DESC) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 40 Print options include number of lines per page. The file name (if the report is directed to a file), will consist of 'BA' and then the left 6 digits of the ENDITEM. ╔══════════════════[ ABBREVIATED BILL OF MATERIALS REPORT ]══════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ ║ ║ comprise the selected EndItem. Uses Report Form: FLOW.FRM. Width: 80 char.║ ║ ║ ║Enter End Item Number: E12345 ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 55 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BAE12345.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ ABBREVIATED BILL OF MATERIALS REPORT EXAMPLE Page No. 1 YOUR COMPANY, INC 01/19/91 ABBREVIATED BILL OF MATERIALS (BOM) REPORT ITEM DESCRIPTION PER QTY REQ QTY WIP QTY ------------ ------------------------------ ---------- ---------- ---------- D1234 DOOR 0.000 18.000 0.000 H25345 ADULT BELLY BAGS 12.000 20.000 0.000 YK90086 TRACKS KIDS TRI-COLOR NEON BB 9.000 22.000 0.000 A23455 BIG CAR 4.000 4.000 0.000 APSBH-1 FL GATOR DELUXE FOAM WTR BOTTL 10.000 10.000 10.000 APSBH-2 FL NEON DELUXE FOAM WTR BOTTLE 4.000 2.000 2.000 B234523 4-PKT BELLY BAG LEATHER LK 3.000 23.000 7.000 C54322 PALADINO NYLON 3-PKT BELLY BAG 4.000 24.000 0.000 YK90086 TRACKS KIDS TRI-COLOR NEON BB 5.000 31.000 0.000 YKEL1 TRACKS LEATHER LOOK BELLY BAG 6.000 26.000 1.000 YKEL2 TRACKS NYLON BELLY BAG 1.000 27.000 0.000 G23453 CHILDREN'S BELLY BAGS 8.000 28.000 0.000 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 41 ■ BOM FLOW CHART #1 This report prints the following fields/information about an ENDITEM: Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity, Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM, Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2. Every BOM item contains the following fields: Item Number, Description, Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Each, Date Added, Last Date Accessed, and Position/ranking in the BOM. At the end of the report, a summary of the costs, hours, and labor is printed. ╔═══════════════════════════[ BOM FLOW CHART #1 ]════════════════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ comprise the selected EndItem. This is Not a Report Form. Width: 131 char. ║ ║ ║ ║ ║ ║Enter End Item Number: E1234 ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BE1234.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #1 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 42 ■ BOM FLOW CHART #2 This report prints the following fields/information about an ENDITEM: Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity, Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM, Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2. Every BOM item contains the following fields: Item Number, Description, Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Extended for Required Quantity, Labor Extended for Required Quantity, and Hours Extended for Required Quantity. At the end of the report, a summary of the costs, hours, and labor is printed. ╔═══════════════════════════[ BOM FLOW CHART #2 ]════════════════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ comprise the selected EndItem. This is Not a Report Form. Width: 131 char. ║ ║ Includes the Required Extended COST, LABOR & HOURS fields for each line... ║ ║ ║ ║Enter End Item Number: E12334 ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 55 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BE12334.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #2 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 43 ■ BOM FLOW CHART #3 This report prints the following fields/information about an ENDITEM: Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity, Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM, Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2. Every BOM item contains the following fields: Item Number, Description, Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Extended for WIP Quantity, Labor Extended for WIP Quantity, and Hours Extended for WIP Quantity. At the end of the report, a summary of the costs, hours, and labor is printed. ╔═══════════════════════════[ BOM FLOW CHART #3 ]════════════════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ comprise the selected EndItem. This is Not a Report Form. Width: 131 char. ║ ║ Includes the WIP Extended COST, LABOR & HOURS fields for each line... ║ ║ ║ ║Enter End Item Number: E12344 ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 55 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BE12344.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #3 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 44 ■ ALL - BOM FLOW CHART #1 This report prints the following fields/information about every ENDITEM: Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity, Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM, Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2. Every BOM item contains the following fields: Item Number, Description, Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Each, Date Added, Last Date Accessed, and Position/ranking in the BOM. At the end of the report, a summary of the costs, hours, and labor is printed. ╔════════════════════════[ ALL - BOM FLOW CHART #1 ]═════════════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ comprise ALL EndItems. This is Not a Report Form. Width: 131 char. ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BOM1A.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #1 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 45 The progress of this report is displayed onto the screen: ╔═════════════════[ BOM FLOW CHART #1A, FOR ALL ENDITEMS ]═══════════════════╗ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #1 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ║ENDITEM PER QTY REQ QTY WIP QTY COST POSITION ║ ║ APSBH-2 20.000 0.000 0.000 16.528 4.00 ║ ║ B4332 230.000 0.000 0.000 3.099 5.00 ║ ║ C243432 240.000 0.000 0.000 4.132 6.00 ║ ║ YK90086 250.000 0.000 0.000 12.396 7.00 ║ ║ YKEL1 260.000 0.000 0.000 13.429 8.00 ║ ║ YKEL2 270.000 0.000 0.000 14.462 9.00 ║ ║ G324432 280.000 0.000 0.000 8.264 10.00 ║ ║ E23423 290.000 0.000 0.000 6.198 11.00 ║ ║C234324 10.000 190.000 0.000 4.132 0000000 ║ ║YK90086 11.000 209.000 0.000 12.396 0000001 ║ ║YKEL1 12.000 228.000 0.000 13.429 0000002 ║ ║YKEL2 13.000 247.000 0.000 14.462 0000003 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I print this report... Press Esc to Abort... DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 46 ■ ALL - BOM FLOW CHART #2A This report prints the following fields/information about every ENDITEM: Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity, Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM, Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2. Every BOM item contains the following fields: Item Number, Description, Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Extended for Required Quantity, Labor Extended for Required Quantity, and Hours Extended for Required Quantity. At the end of the report, a summary of the costs, hours, and labor is printed. ╔════════════════════════[ ALL - BOM FLOW CHART #2A ]════════════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ comprise ALL EndItems. This is Not a Report Form. Width: 131 char. ║ ║ Includes the Required Extended COST, LABOR & HOURS fields for each line... ║ ║ ║ ║ ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 55 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BOM2A.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #2 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 47 ■ ALL - BOM FLOW CHART #3A This report prints the following fields/information about every ENDITEM: Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity, Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM, Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2. Every BOM item contains the following fields: Item Number, Description, Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Extended for WIP Quantity, Labor Extended for WIP Quantity, and Hours Extended for WIP Quantity. At the end of the report, a summary of the costs, hours, and labor is printed. ╔════════════════════════[ ALL - BOM FLOW CHART #3A ]════════════════════════╗ ║ ║ ║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║ ║ comprise the all EndItems. This is Not a Report Form. Width: 131 char. ║ ║ Includes the WIP Extended COST, LABOR & HOURS fields for each line... ║ ║ ║ ║ ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 55 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BOM3A.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║ ║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║ ║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #3 ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 48 ■ BOM SHORTAGE REPORT Use this report to get the quantities not yet TRANSFERRED from the Inventory to WIP to meet the required quantity. The required quantity is the number of an item required to assemble all ENDITEMS that are to be built. ╔══════════════════════════[ BOM SHORTAGE REPORT ]═══════════════════════════╗ ║ ║ ║ This report lists the shortages for all BOM items for a selected ║ ║ EndItem. This is Not a Report Form. Width: 80 char. ║ ║ ║ ║ ║ ║ENDITEM Selected: D12312 ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BD12312.TXT ║ ║ ║ ║█▄██████░ ▄█████▄ ███░ ███░ S ███████░ ██░ ▄█████▄ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ████░ ████░ H ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░ ║ ║██░ ██░ ██░ ██░ ██▀████▀██░ O ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║██░ ██░ ██░ ██░ ██░▀██▀ ██░ R ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║████████░ ██░ ██░ ██░ ██░ ██░ T █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ██░ ██░ A ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║ ║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ G ██░ ██░ ██░ ██░ █████░ █████░ ║ ║█▀██████░ ▀█████▀ ██░ ██░ E ██░ ███████░ ▀█████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 49 ■ BOM SHORTAGE REPORT EXAMPLE BOM SHORTAGES for EndItem: <<< D12312 >>> Page 1 Date: 01/19/91 Time: 22:43:44 *Last Date: 01/19/91 (Level) Item Description Req-Qty Short 12345678----------- ------------------------------ ---------- ---------- D12312 DOOR 18.000 18.000 H23423 DOOR HANDLE 20.000 20.000 TRACKS23 TRACKS 22.000 22.000 A243 BIG CAR 42.000 2.000 APSBH-1 WHEELS 10.000 0.000 APSBH-2 INSURANCE 2.000 0.000 C23434 PALADINO NYLON KIT 24.000 2.000 YK90086 TRACKS KIDS TRI-COLOR NEON BB 31.000 1.000 YKEL1 TRACKS LEATHER LOOK BELLY BAG 26.000 6.000 YKEL2 TRACKS NYLON BELLY BAG 27.000 7.000 G234324 CHILDREN'S BELLY BAGS 28.000 28.000 E234423 HANDLE, DOOR 29.000 3.000 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Cost Per End Item: 2,309.788 Cost For Required: 2,445.111 Cost for WIP: 209.699 Cost for Finished: 0.000 Hours Per End Item: 853.480 Hours For Required: 894.480 Hours for WIP: 64.950 Hours for Finished: 0.000 Labor Per End Item: 961.521 Labor For Required: 1,007.892 Labor for WIP: 73.439 Labor for Finished: 0.000 Labor1 Per End Item: 1,057.688 Labor1 For Required: 1,108.696 Labor1 for WIP: 80.782 Labor1 for Finished: 0.000 Labor2 Per End Item: 1,442.234 Labor2 For Required: 1,511.791 Labor2 for WIP: 110.160 Labor2 for Finished: 0.000 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 50 ■ SHOP ORDERS LIST This report simply lists all your shop order records to printer or file. Unlike previous reports, you can select from 6 indexes (sorts). The FLAGS field will contain an 'A' if allocated, a 'P' if it has been printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO' would denote a shop order has been allocated, printed, and is still open. ╔════════════════════════════[ SHOP ORDERS LIST ]════════════════════════════╗ ║ ║ ║ This report is a listing of your Shop Orders. ║ ║ Uses Report Form: SOLIST.FRM. Width: 80 characters. ║ ║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED & FLAGS ║ ║ ║ ║ Select Index -> Shop Order Number ║ ║ Shop Order Comment ║ ║ ENDITEM ║ ║ ENDITEM Description ║ ║ Customer Number ║ ║ Invoice Number ║ ║ Exit ║ ║ ║ ║ ███████░ ████████░ ██░ ████░ ███████░ ████████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ███████░ ██░ ██░ ██░ ██░ ███████░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ███████░ ████████░ ███████░ ████░ ███████░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter/Return (Select) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 51 ■ SHOP ORDERS LIST EXAMPLE Page No. 1 YOUR COMPANY, INC 01/19/91 SHOP ORDER LISTING SHOP COMMENT ORDER ENDITEM DESCRIPTION QTY ASSEMBLED FLAG ------ ------------ ------------------------------ ---------- ---------- ---- ** Shop Order: 0 0 JAR-1 1.000 4.000 APO JAR 0 A 24 342423 4.000 0.000 APO BIG CAR ** Shop Order: 1 1 JAR-1 54 5.000 0.000 PO JAR 1 A 234 234 6.000 4.000 APO BIG CAR 1 C 23 4234 18.000 0.000 APO PALADINO NYLON 3-PKT BELLY BAG ** Shop Order: 2 2 A 345 345 8.000 1.000 APO BIG CAR 2 BP0003 234 23423 9.000 0.000 APO GATOR COFFEE MUG WITH LID 2 D 234 2 34234 23 1.000 0.000 APO DOOR ** Shop Order: 3 3 A 23423 10.000 0.000 O BIG CAR 3 BP0003 231 11.000 0.000 O GATOR COFFEE MUG WITH LID 3 BP0001 34534534 16.000 0.000 O GATOR & FLORIDA PLASTIC MUGS ** Shop Order: 4 4 A 234 23 12.000 0.000 PO BIG CAR ** Shop Order: 5 5 BP0001 345 13.000 0.000 O GATOR & FLORIDA PLASTIC MUGS DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 52 ■ SHOP ORDERS EXPANDED #1 This is an expanded report listing the following fields for every shop order record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED, Extended COST, HOURS, LABOR, FLAGS and DATE The FLAGS field will contain an 'A' if allocated, a 'P' if it has been printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO' would denote a shop order has been allocated, printed, and is still open. ╔════════════════════════[ SHOP ORDERS EXPANDED #1 ]═════════════════════════╗ ║ ║ ║ This report prints out Expanded Shop Order data. ║ ║ Uses Report Form: SOLIST1.FRM. Width: 131 characters. ║ ║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED ║ ║ Extended COST, HOURS, LABOR, FLAGS & DATE ║ ║ Index Selected: Shop Order Number ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: SOLIST11.TXT ║ ║ ║ ║ ████░▄███▄ ████░█░ █░█▄███░ █░ █░ █░█▄███░████░█▄███░ █░█░ ██░ ║ ║ █░ █░ █░ █░ █▄ ▄█░█░ █░ █▀█░ ██░ █░█░ █░█░ █░ █░ █░█░ █░ ║ ║ █░ █░ █░ █░ █▄█░ █░ █░ █░█░ ███ █░█░ █░█░ █░ █░ █████░ █░ ║ ║ ████░█░ █░ ███░ █░ █▀███░ █▄█░ █░███░█░ █░███░ █░ █░ █░█░ █░ ║ ║ █░█░ █░ █░ █▀█░ █░ █▀ ▀█░█░ ██░█░ █░█░ █░ █░ █████░ █░ ║ ║ █░█░ █░ █░ █▀ ▀█░█░ █░ █░█░ ▀█░█░ █░█░ █░ █░ █░█░ █░ ║ ║ ████░▀███▀ ████░█░ █░█░ █░ █░█░ █░█▀███░████░█▀███░ █░█░ ███░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 53 ■ SHOP ORDERS EXPANDED #2 This is an expanded report listing the following fields for every shop order record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED COST, FLAGS, DATE, DUEDATE, CUSTOMER, INVOICE and PRIORITY The FLAGS field will contain an 'A' if allocated, a 'P' if it has been printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO' would denote a shop order has been allocated, printed, and is still open. ╔════════════════════════[ SHOP ORDERS EXPANDED #2 ]═════════════════════════╗ ║ ║ ║ This report prints out Expanded Shop Order data. ║ ║ Uses Report Form: SOLIST1.FRM. Width: 131 characters. ║ ║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED COST ║ ║ FLAGS, DATE, DUEDATE, CUSTOMER, INVOICE & PRIORITY ║ ║ Index Selected: ENDITEM ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: SOLIST23.TXT ║ ║ ║ ║████░▄███▄ ████░█░ █░█▄███░ █░ █░ █░█▄███░████░█▄███░ █░█░ █████░║ ║█░ █░ █░ █░ █▄ ▄█░█░ █░ █▀█░ ██░ █░█░ █░█░ █░ █░ █░█░ █░║ ║█░ █░ █░ █░ █▄█░ █░ █░ █░█░ ███ █░█░ █░█░ █░ █░ █████░ █░║ ║████░█░ █░ ███░ █░ █▀███░ █▄█░ █░███░█░ █░███░ █░ █░ █░█░ ▄████░║ ║ █░█░ █░ █░ █▀█░ █░ █▀ ▀█░█░ ██░█░ █░█░ █░ █░ █████░ █░ ║ ║ █░█░ █░ █░ █▀ ▀█░█░ █░ █░█░ ▀█░█░ █░█░ █░ █░ █░█░ █░ ║ ║████░▀███▀ ████░█░ █░█░ █░ █░█░ █░█▀███░████░█▀███░ █░█░ █████░║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 54 ■ SHOP ORDERS HISTORY #1 This is an expanded report listing the following fields for every shop order history record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED, Extended COST, HOURS, LABOR, FLAGS and DATE The FLAGS field will contain an 'A' if allocated, a 'P' if it has been printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO' would denote a shop order has been allocated, printed, and is still open. All data in the database SOHIST.DBF can be printed out, or those records that fall between a start and ending date, or records for a specific customer number, a specific invoice number, a specific shop order number, or for a specific ENDITEM. ╔═════════════════════════[ SHOP ORDERS HISTORY #1 ]═════════════════════════╗ ║ ║ ║ This report prints out Expanded Shop Order History data. ║ ║ Uses Report Forms: SOHIST1x.FRM. Width: 131 characters. ║ ║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED ║ ║ Extended COST, HOURS, LABOR, FLAGS & DATE ║ ║ Select Option -> Report All ║ ║ Date Range ║ ║ Specific Customer Number ║ ║ Specific Invoice Number ║ ║ Specific Shop Order Number ║ ║ Specific ENDITEM ║ ║ Exit ║ ║ ║ ║████░ ▄███▄ 1 █░ █░ ███░ ████░ █████░ ▄███▄ █▄███░ █░ █░ █░█░ ██░ ║ ║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █▄ ▄█░ █░█░ █░ ║ ║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █████░ █░ ║ ║████░ █░ █░ █████░ █░ ████░ █░ █░ █░ █▄▄▄█░ ▀█▀ █░█░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░▀█░ █░ █████░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██░ █░ █░█░ █░ ║ ║████░ ▀███▀ █░ █░ ███░ ████░ █░ ▀███▀ █░ █░ █░ █░█░ ███░║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter/Return (Select) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 55 ■ SHOP ORDERS HISTORY #2 This is an expanded report listing the following fields for every shop order history record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED, COST EACH, FLAGS, DATE, DATE DUE, CUSTOMER, INVOICE and PRIORITY The FLAGS field will contain an 'A' if allocated, a 'P' if it has been printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO' would denote a shop order has been allocated, printed, and is still open. All data in the database SOHIST.DBF can be printed out, or those records that fall between a start and ENDING date, or records for a specific customer number, a specific invoice number, a specific shop order number, or for a specific ENDITEM. ╔═════════════════════════[ SHOP ORDERS HISTORY #2 ]═════════════════════════╗ ║ ║ ║ This report prints out Expanded Shop Order History data. ║ ║ Uses Report Forms: SOHIST2x.FRM. Width: 131 characters. ║ ║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED ║ ║ COST EACH, FLAGS, DATE, DATE DUE, CUSTOMER, INVOICE and PRIORITY ║ ║ Option Selected: Report All ║ ║ ║ ║ Index Selected: Shop Order Number ║ ║ ║ ║Enter Maximum Number of Lines Per Page: 66 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: SOHIST21.TXT ║ ║████░ ▄███▄ 2 █░ █░ ███░ ████░ █████░ ▄███▄ █▄███░ █░ █░ █░█░ ████░ ║ ║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █▄ ▄█░ █░█░ █░ ║ ║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █████░ █░ ║ ║████░ █░ █░ █████░ █░ ████░ █░ █░ █░ █▄▄▄█░ ▀█▀ █░█░ ▄▄▄█░ ║ ║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░▀█░ █░ █████░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██░ █░ █░█░ █░ ║ ║████░ ▀███▀ █░ █░ ███░ ████░ █░ ▀███▀ █░ █░ █░ █░█░ ████░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 56 ■ MANUFACTURING HISTORY REPORT This is a report of your inventory adjustments required for use in the MRP process. All records in the database INVADJ.DBF that contain the string 'MRP' in the comment field will be printed out that fall with the start and ending dates (inclusive) prompt. Fields included in the report: Item, Description, Qty Adjusted, Cost Each, Reason for the adjustment (which is computer generated in MRP), Date of the adjustment, and the Class Code. ┌────────────────────────────────────────────────────────┐ │ The Manufacturing History Report list all records │ │ from the inventory adjustments database (INVADJ.DBF) │ │ that have been created by DAYO MRP ("MRP"$REASON). │ │ Uses Report Form: MFG_HIST.FRM. (126 Wide) │ │ │ │ Start Date: 12/20/90 Ending Date: 01/19/91 │ │ │ │ Enter Heading: YOUR COMPANY, INC │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: MFG_HIST.TXT │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 57 ■ MANUFACTURING HISTORY FOR A SINGLE ITEM REPORT This is a report of your inventory adjustments required for use in the MRP process for a specific item. All records in the database INVADJ.DBF for the selected item, that contain the string 'MRP' in the comment field will be printed out that fall with the start and ending dates (inclusive) prompt. Fields included in the report: Item, Description, Qty Adjusted, Cost Each, Reason for the adjustment (which is computer generated in MRP), Date of the adjustment, and the Class Code. ┌────────────────────────────────────────────────────────┐ │ The Manufacturing History For A Single Item Report │ │ list all records from the inventory adjustments │ │ database (INVADJ.DBF) for a single Item that have │ │ been created by DAYO MRP ("MRP"$REASON). │ │ Uses Report Form: MFG_HIST.FRM. (126 Wide) │ │ │ │ Report History on Item Number: E │ │ │ │ Start Date: 12/20/90 Ending Date: 01/19/91 │ │ │ │ Enter Heading: YOUR COMPANY, INC │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: HE1234.TXT │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 58 ■ COMPONENT/WHEREIS ITEM REPORT This report lists all BOM records listing the component item and its corresponding ENDITEM. Useful in determining which ENDITEMs relate to a specific component item. ┌────────────────────────────────────────────────────────┐ │ The Component/Whereis Item Report lists all ENDITEMS │ │ that are related to a specific component Item. This │ │ report is indexed on the ITEM field in the database │ │ BOM.DBF. Uses Report Form: WHEREIS.FRM (80 Wide) │ │ │ │ Enter Heading: YOUR COMPANY, INC │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: WHEREIS.TXT │ │ │ └────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 59 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔════════════════════════════════════════════════════════════════════════╗ ║Use this option to view any report written to disk. ║ ║Press Enter/Return on an empty prompt to display all files with the ║ ║extension of '.TXT'. ║ ║File size limited to 32,000 bytes. ║ ║ ║ ║Enter Report File Name to View On Screen: ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 270 │ 06/14/90 ║ ║CONFIG.TXT │ 861 │ 06/17/90 ║ ║EI_RPT1.TXT │ 1097 │ 06/17/90 ║ ║EI_RPT2.TXT │ 1742 │ 06/17/90 ║ ║EI_RPT3.TXT │ 858 │ 06/17/90 ║ ║BOM_RPT1.TXT │ 2190 │ 06/17/90 ║ ║BOM_RPT2.TXT │ 3427 │ 06/17/90 ║ ┌────────────────────────┐ ║BOMSHORT.TXT │ 783 │ 06/17/90 ║ │ Highlight the Report │ ║HJAR-1.TXT │ 1 │ 06/13/90 ║ │ using the UP or Down │ ║BBOX.TXT │ 6263 │ 06/17/90 ║ │ arrow keys, then press │ ║BOM_ALL.TXT │ 0 │ 06/17/90 ║ │ Enter/Return. │ ║MFG_HIST.TXT │ 37089 │ 06/17/90 ║ └────────────────────────┘ ║HBOX.TXT │ 2181 │ 06/17/90 ║ ║BOM_XXX.TXT │ 24549 │ 06/13/90 ║ ║BBOX1.TXT │ 1535 │ 06/13/90 ║ ║BOM_ALL1.TXT │ 6127 │ 06/14/90 ║ ╚══════════════╧════════════╧═══════════╝ Esc (Exit/Abort) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 60 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYOMRP View Reports │ File Name: BOM_RPT2.TXT 06/17/90 Bill of Materials BOM Expanded Report (BOM2A. Subtotal on End Item Onhand Available Per Set Required End Item Item Description Qty Qty ------------ ------------ ------------------------------ ------- -------- ** End Item: BOX BOX JAR-1 Sample Item Description #1 2 0 BOX JAR-1 Sample Item Description #1 0 0 BOX LID Jar Lid 2 0 ** Subtotal ** 4 0 ** NEnd Item: JAR-1 JAR-1 JAR-3 Sample Item Description #3 2 0 JAR-1 LID Jar Lid 2 0 Esc (Exit) F1 (Help) 3/34 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 61 ■ CONFIGURATION STATUS REPORT All configuration options for DAYO MRP can be found in this report. ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOMRP.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CONFIGURATIONS SETTINGS REPORT +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + DAYO MATERIALS REQUIREMENT II PLANNING CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 01/19/91 22:46:42 Company Name: YOUR COMPANY, INC Address Line 1: Attn: Manufacturing Address Line 2: P.O. BOX 5555 City, State Zip: Anycity, ST 555555-5555 Telephone: 800-555-5555 Allow Browse Editing: Yes Use Unique MRP Class Codes: Yes Take From Inventory CLASS: MRP Finished goods CLASS: FIN WIP Put Back CLASS: WIP WIP Into MRP CLASS: TAK DisAssemble ENDITEM CLASS: DIS Inventory Database Location: \DAYOINV\ Current Database Location: Back Orders Location: \DAYOBO\ Shop Orders Type: STANDARD PRINTER Shade Laser Shop Orders: Yes Auto Print Shop Orders: Yes Shop Orders Copies: 1 Shop Orders Printer Port: LPT1 Last Shop Order Number: 4000 Print DueDate on Shop Order: No Travelers Type: STANDARD PRINTER Travelers Printer Port: LPT1 Last Traveler Number: 5521 Skip Page On Traveler: No Report Printer Type: STANDARD PRINTER Report Printer Port: LPT1 Visual Indexing: Yes Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 62 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change (mess with) the printer to get it to print correctly. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 63 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 64 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 65 ■ CONFIGURATION The Configuration Menu/Routine contains all the option settings for this application. To change any of the 30+ options, arrow down/up to it, then press enter. ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █ CONFIGURATION █ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ █ Company Name █ █ Company Address █ █ Company Telephone █ █ CLASS Codes for MRP █ █ Allow Browse Editing █ █ Inventory Location █ █ Back Orders Location █ █ Customers/AR Location █ █ POS Location █ █ Current Directory █ █ Report Printer Type █ █ Report Printer Port █ █ Visual Indexing █ █ Auto Daily Indexing █ █ Auto Print Shop Order █ █▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ █ Select Option █ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ ■ CONFIGURATION OPTIONS LISTING Company Name Visual Indexing Company Address Auto Daily Indexing Company Telephone Auto Print Shop Order CLASS Codes for MRP Shop Order Type Allow Browse Editing Print Duedate on SO Inventory Location Shop Order Copies Back Orders Location Shop Order Port Customers/AR Location Last Shop Order # POS Location Traveler Type Current Directory Traveler Port Report Printer Type Last Traveler # Report Printer Port Skip Page - Travelers Visual Indexing Traveler Setup Auto Daily Indexing Color Auto Print Shop Order High Intensity GL Location Automatic GL Posting DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 66 ■ COMPANY NAME ┌───────────────────────────────[ COMPANY NAME ]─────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY, INC │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ADDRESS ┌─────────────────────────────[ COMPANY ADDRESS ]────────────────────────────┐ │ Address Line 1: Attn: Manufacturing │ │ Address Line 2: P.O. BOX 5555 │ │ City, State ZIP: Anycity, ST 555555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY TELEPHONE ┌────────────────────────────[ COMPANY TELEPHONE ]───────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ MRP CLASS CODES Class Codes (CLASS fields) are used in conjunction with DAYO General Ledger. If you are not using General Ledger, then this routine need not be maintained... If DAYO GL is being used, you have the option of differentiating between the many types of inventory adjustments required in an MRP process. For example, inventory items taken from inventory and place into WIP will have a different CLASS Code (in the adjustments records), than from assembled ENDITEMS placed into inventory. ┌────────────────────────────[ MRP CLASS CODES ]────────────────────────────┐ │ The Materials Requirement Planning (MRP) process posts all its │ │ transactions of inventory adjustments to the file INVADJ.DBF. │ │ For General Ledger to work properly, these transactions must contain a │ │ valid CLASS code. │ │ │ │ The Options Are: │ │ 1. Make all categories of adjustments unique, ie: │ │ MRP - Taken from Inventory by MRP process │ │ FIN - Finished goods put into inventory after being manufactured │ │ WIP - Work in process items put back into inventory by adjustment │ │ TAK - Work in process items brought into MRP from inventory by │ │ Adjustment │ │ DIS - Disassembled ENDITEMs in BOM.DBF and/or INV.DBF │ │ or │ │ 2. CLASS Codes remain the same as in the Inventory Database (INV.DBF)│ │ │ │ The default is Option 1: Make all categories of adjustments unique using│ │ the CLASS Codes displayed on the above lines. │ │ │ │ Select Option -> CLASS Codes are unique (the default) │ │ CLASS Codes remain the same as in the Inventory │ └───────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 67 ■ ALLOW BROWSE EDITING ┌───────────────────────────[ ALLOW BROWSE EDITING ]─────────────────────────┐ │ To disable editing while in a browse screen, select N (NO) to this │ │ option. Default is to allow it. │ │ │ │ Allow Editing While In A Browse Screen? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY LOCATION/DIRECTORY ┌───────────────────────[ INVENTORY LOCATION/DIRECTORY ]─────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in the │ │ same drive/directory as DAYO MRP. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO MRP where to find │ │ the inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOINV\ │ │ The drive designation is optional (if same as DAYO MRP). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ BACK ORDERS LOCATION/DIRECTORY ┌──────────────────────[ BACK ORDERS LOCATION/DIRECTORY ]────────────────────┐ │ The location of the DAYO Back Orders (BO.DBF) does not have to be in the │ │ same drive/directory as DAYO MRP. If you have installed DAYO BO │ │ into a different directory, you need to tell DAYO MRP where to find │ │ the back orders database (BO.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOBO\ │ │ The drive designation is optional (if same as DAYO MRP). │ │ │ │ Enter Location: \DAYOBO\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CUSTOMERS (AR) LOCATION/DIRECTORY ┌────────────────────[ CUSTOMERS (AR) LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Customer database does not have to be in │ │ the same drive/directory as DAYO MRP. If you have installed DAYO AR │ │ into a different directory, you need to tell DAYO MRP where to find │ │ the customer database (CUSTOMER.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO MRP). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 68 ■ POINT OF SALE (POS) LOCATION/DIRECTORY ┌──────────────────[ POINT OF SALE (POS) LOCATION/DIRECTORY ]────────────────┐ │ The location of the DAYO POS Invoice database does not have to be in the │ │ same drive/directory as DAYO MRP. If you have installed DAYO POS │ │ into a different directory, you need to tell DAYO MRP where to find │ │ the invoice database (INVOICE.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO MRP). │ │ │ │ Enter Location: \DAYOPOS\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐ │ The location of DAYO General Ledger Databases does not have to be │ │ in the same drive/directory as this module. If you have installed DAYO GL │ │ into a different directory, you need to tell this module where to find │ │ the GL databases. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOGL\ │ │ The drive designation is optional (if same as this module). │ │ │ │ Enter Location: \DAYOGL\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CURRENT DIRECTORY DATABASE LOCATION ┌───────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]──────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOPOS\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌───────────────────────────[ REPORT PRINTER TYPE ]──────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌───────────────────────────[ REPORT PRINTER PORT ]──────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 69 ■ VISUAL INDEXING ┌─────────────────────────────[ VISUAL INDEXING ]────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATIC DAILY INDEXING ┌─────────────────────────[ AUTOMATIC DAILY INDEXING ]───────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO MRP will be recreated once daily. This will occur when the first │ │ DAYO MRP program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO MRP Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATICALLY PRINT SHOP ORDERS WHEN CREATED ┌───────────────[ AUTOMATICALLY PRINT SHOP ORDERS WHEN CREATED ]─────────────┐ │ If you want your Shop Orders to automatically print after creation, then│ │ change this option to Y (YES). │ │ Default is NOT to automatically print the Shop Orders. │ │ │ │ Automatically Print Shop Orders? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ SHOP ORDER PRINTER TYPE ┌─────────────────────────[ SHOP ORDER PRINTER TYPE ]────────────────────────┐ │ There are 3 types of DAYO Shop Orders: STANDARD, LASER, and DATA ONLY. │ │ The STANDARD Shop Order prints standard characters with headings. │ │ The LASER Shop Order prints small, but with more data onto a Hewlett │ │ Packard (tm) compatible laser printer. │ │ The DATA ONLY Shop Order is the same as the STANDARD with the exception │ │ of the headings (for use with pre-printed forms). │ │ │ │ Enter Your Shop Order Printer Type -> STANDARD │ │ LASER │ │ DATA ONLY │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 70 ■ SHOP ORDER PRINTER TYPE ┌─────────────────────────[ SHOP ORDER PRINTER TYPE ]────────────────────────┐ │ There are 3 types of DAYO Shop Orders: STANDARD, LASER, and DATA ONLY. │ │ The STANDARD Shop Order prints standard characters with headings. │ │ The LASER Shop Order prints small, but with more data onto a Hewlett │ │ Packard (tm) compatible laser printer. │ │ The DATA ONLY Shop Order is the same as the STANDARD with the exception │ │ of the headings (for use with pre-printed forms). │ │ │ │ Enter Your Shop Order Printer Type -> STANDARD │ │ LASER │ │ │ │ Do you wish to shade every other line item? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT DUEDATE ON SHOP ORDER ┌───────────────────────[ PRINT DUEDATE ON SHOP ORDER ]──────────────────────┐ │ If you wish to print the DUEDATE for each ENDITEM on the Shop Orders, │ │ then select Y (YES) to this option. The DUEDATE will print under the │ │ ENDITEM & VENDITEM. The default is not to print the DUEDATE... │ │ │ │ Do you wish to print the DUEDATE onto the Shop Order? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ NUMBER OF SHOP ORDER COPIES TO PRINT ┌───────────────────[ NUMBER OF SHOP ORDER COPIES TO PRINT ]─────────────────┐ │ This option determines the number of Shop Order copies to print at the │ │ time of printing. Default is to print one copy of the Shop Order. │ │ │ │ Enter Number of Shop Order Copies: 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ SHOP ORDER PRINTER PORT ┌─────────────────────────[ SHOP ORDER PRINTER PORT ]────────────────────────┐ │ Enter Your Shop Order Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST SHOP ORDER NUMBER ┌──────────────────────────[ LAST SHOP ORDER NUMBER ]────────────────────────┐ │ Enter Last Shop Order Number: 39 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 71 ■ TRAVELER PRINTER TYPE ┌──────────────────────────[ TRAVELER PRINTER TYPE ]─────────────────────────┐ │ There are 2 types of DAYO Travelers: STANDARD and LASER. │ │ │ │ The LASER Traveler prints sideways and with 10 CPI, onto a Hewlett │ │ Packard (tm) compatible laser printer. │ │ │ │ Enter Your Traveler Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ TRAVELER PRINTER PORT ┌──────────────────────────[ TRAVELER PRINTER PORT ]─────────────────────────┐ │ Enter Your Traveler Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST TRAVELER NUMBER ┌───────────────────────────[ LAST TRAVELER NUMBER ]─────────────────────────┐ │ Enter Last Traveler Number: 19 │ └────────────────────────────────────────────────────────────────────────────┘ ■ SKIP PAGE BETWEEN ENDITEMS ON THE TRAVELERS ┌───────────────[ SKIP PAGE BETWEEN ENDITEMS ON THE TRAVELERS ]──────────────┐ │ If you wish to start a new page for each ENDITEM on the Travelers, │ │ then select Y (YES). │ │ The default NOT to skip page. │ │ │ │ Skip Page Between ENDITEMS? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 72 ■ TRAVELER SETUP & DEFINITION Use this Configuration Option to define the 2 Traveler types. Travelers can contain as many fields that can print across your printer. ╔═══════════════════════[ TRAVELER SETUP & DEFINITION ]══════════════════════╗ ║ DAYO MRP has 2 styles of Travelers for each type (STANDARD and LASER). ║ ║ You define what fields are printed onto each. ║ ║ The number of fields is limited by the width of your paper, ie: ║ ║ Standard Traveler: Page Size 10 CPI 17.1 CPI ║ ║ 8.5x11 78 Width 130 Width ║ ║ 14 7/8x11 130 Width 190 Width ║ ║ Laser Traveler: 11/8.5 10 CPI ║ ║ 130 Width ║ ║ ║ ║ ║ ║ Select Option -> Setup & Define Traveler Type 1 ║ ║ Setup & Define Traveler Type 2 ║ ║ Exit ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ TRAVELER STYLE/TYPE You can define 2 Traveler (what gets printed onto them...) ╔═════════════[ TRAVELER SETUP & DEFINITION - TRAVELER STYLE #1 ]════════════╗ ║ Current Width: 72 ║ ║ Title Field Len Select ║ ║ Select Option -> Item ITEM 12 Yes ║ ║ VendorItem VENDITEM 12 No ║ ║ Description DESC 30 No ║ ║ LOC LOCATION 3 No ║ ║ Weight WEIGHT 8 No ║ ║ QTY QTY 10 No ║ ║ UOM UNIT 3 No ║ ║ PakQty PACKQTY 6 No ║ ║ UnitQty UNITQTY 7 No ║ ║ Labor LABOR 10 No ║ ║ Labor1 LABOR1 10 No ║ ║ Labor2 LABOR2 10 No ║ ║ Hours HOURS 10 No ║ ║ Cost COST 10 No ║ ║ Onhand ONHAND 10 No ║ ║ Vendor VENDOR 10 No ║ ║ PER QTY PER_QTY 10 Yes ║ ║ Required REQ_QTY 10 Yes ║ ║ Finished FINIS_QTY 10 No ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 73 ■ TRAVELER FIELDS The following fields are available to print on Travelers: Item ITEM 12 Yes VendorItem VENDITEM 12 No Description DESC 30 No LOC LOCATION 3 No Weight WEIGHT 8 No QTY QTY 10 No UOM UNIT 3 No PakQty PACKQTY 6 No UnitQty UNITQTY 7 No Labor LABOR 10 No Labor1 LABOR1 10 No Labor2 LABOR2 10 No Hours HOURS 10 No Cost COST 10 No Onhand ONHAND 10 No Vendor VENDOR 10 No PER QTY PER_QTY 10 Yes Required REQ_QTY 10 Yes Finished FINIS_QTY 10 No WIP QTY WIP_QTY 10 Yes LastTime LASTTIME 8 No LastDate LASTDATE 8 No LaborXPER LABOR*PER 10 Yes Labor1XPER LABOR1*PER 10 No Labor2XPER LABOR2*PER 10 No HoursXPER HOURS*PER 10 No CostXPER COST*PER 10 No LaborXREQ LABOR*REQ 10 No Labor1XREQ LABOR1*REQ 10 No Labor2XREQ LABOR2*REQ 10 No HoursXREQ HOURS*REQ 10 Yes CostXREQ COST*REQ 10 No LaborXWIP LABOR*WIP 10 No Labor1XWIP LABOR1*WIP 10 No Labor2XWIP LABOR2*WIP 10 No HoursXWIP HOURS*WIP 10 No CostXWIP COST*WIP 10 Yes Defined1 BLANK 8 No Defined2 BLANK 8 No Defined3 BLANK 8 No Defined4 BLANK 8 No Defined5 BLANK 8 No Defined6 BLANK 8 No Defined7 BLANK 8 No Defined8 BLANK 8 No Defined9 BLANK 8 No DefinedA BLANK 8 No DefinedB BLANK 8 No DefinedC BLANK 8 No DefinedD BLANK 8 No DefinedE BLANK 8 No DefinedF BLANK 8 No POS Position 7 No DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 74 ■ DEFINED FIELDS Defined fields print blank spaces with a title of your choice onto the travelers, as in the following Traveler report extract/example: TRAVELER YOUR COMPANY, INC Page 1 Type 1 Date: 01/19/91 Time 20:16:28 Item PER QTY Required WIP QTY Dept #1 Dept #2 Dept #3 ------------ ---------- ---------- ---------- -------- -------- -------- A24234 0.00 110.00 0.00 ________ ________ ________ APSBH-2 1.00 110.00 0.00 ________ ________ ________ APSBH-1 2.00 220.00 0.00 ________ ________ ________ ■ AUTOMATIC GL POSTING This Configuration routine was added to allow you to post your transactions (ie: Invoice Posting, Cash Receipts, and Credit Memos), automatically into General Ledger (GL). If this option is set to 'Y' (Yes), each time you adjust or edit key accounting fields (ie: COST, AMOUNT, SUBTOTAL, FREIGHT, ADJUST, QTY...), a GL transaction records will be created. This routine includes an option to browse, edit, add, and/or delete records in the General Ledger Class Code Table/Database (GLCLASS.DBF). ╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗ ║ If you are using General Ledger (GL), you can automatically update ║ ║ or create GL transactions every time you make an accounting adjustment. ║ ║ ║ ║ Do you want Automatic GL Posting? (Y/N) ║ ║ ║ ║ Default CLASS Code: AR Name: RECEIPTS ║ ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║ ║ Database: RECEIPTS.DBF Field: AMOUNT ║ ╟─────────────[ SELECT DEFAULT ACCOUNTS RECEIVABLE CLASS CODE ]──────────────╢ ║ CLASS NAME DEBIT CREDIT ║ ║──────────╥────────────────────────────────╥──────────────╥─────────────────║ ║ AR ║ Invoice Freight *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 1st Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 2nd Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Adjustments *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Paid/Collected *** ║ 10000-000000 ║ 40000-000000 ║ ║ REC ║ RECIPTS INTO INVENTORY ║ 91000-000000 ║ 20000-000000 ║ ║ INV ║ RECEIPTS INTO THE INVENTORY ║ 91000-000000 ║ 11000-000000 ║ ║ MRP ║ MRP/WIP ║ 10000-000000 ║ 20000-000000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 75 ■ EDIT CLASS CODE RECORD Press 'F2' to edit a Class Code record. Note, valid entries are crucial to making this posting process work correctly... ╔═════════════════════════[ EDIT CLASS CODE RECORD ]═════════════════════════╗ ║ CLASS Code: MRP ║ ║ Name: MRP/WIP ║ ║ Debit Account: 11000-000000 ║ ║ Credit Account: 10000-000000 ║ ║ Database (.DBF): INVADJ.DBF ║ ║ Field: COST*QTY ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) ■ ADD NEW CLASS CODE RECORD Press 'Ctrl N' to add a new CLASS code record. ╔═══════════════════════[ ADD NEW CLASS CODE RECORD ]════════════════════════╗ ║ CLASS Code: ║ ║ Name: ║ ║ Debit Account: 00000-000000 ║ ║ Credit Account: 00000-000000 ║ ║ Database (.DBF): INVADJ.DBF ║ ║ Field: ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 76 ■ FIND CLASS CODE Use the 'F5' through 'F9' keys to locate a desired CLASS code record Press 'F5' to locate a CLASS code record based on the CLASS field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS+DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to locate a CLASS code record based on the DEBIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 30000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to locate a CLASS code record based on the CREDIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 10000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to locate a CLASS code record based on the NAME field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to locate a CLASS code record based on the DATABASE field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ ■ COLOR MONITOR ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ The default is color, high intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 77 ■ MISCELLANEOUS ROUTINES - The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. █ █ ▄██▄ ███ █ █ ▀█▀ █████ █ █ ▄███ ▄█▄ █ █ █████ ▀█▀ ▄██▄ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ ██ █ █ █ █ ▀██▄ ██ █ █ █ █ █ ████ █ █▄█ █ █ █ █ █ █ ████ █ █ █ █ █ ▀█ █ █▀ █ █ █ █ █ █▀ ▀█ █ █ █ █ █ █ █ ██ █ ▀██▀ ▀██▀ ███ ▀█▀█▀ ▄█▄ █ █ █ ▀███ █ █ ▀██▀ █ ▄█▄ ▀██▀ █ █ ▄ USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO PERMANENTLY MESS THINGS UP! ■ MISC ROUTINES MENU: DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐ ╔════════════════════╗▀█ │S M T W T F S │ ║ MISC ROUTINES ║ █ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢─█ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│ ║ APPEND FROM ║ █ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│ ║ BROWSE DATABASES ║─█ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│ ║ COPY (.DBF) TO ║ █ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│ ║ CREATE DATABASE ║─█ █▀██▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │ ║ DELETE RECORDS ║ █ │ │ ║ ERASE FILE ║─█ └────────────────────┘ ║ EXIT TO DOS ║ █ ║ INDEX A DATABASE ║─█ ███▄ ▄███░ ║ LIST FIELDS ║ █ █████░ █████░ ███▄███████░ ║ PACK DATABASE ║██ ██████░ ██████░ ███░ ███░ ███▄███████░ ║ MODIFY DATABASE ║█ ███░██████░███░ ███░ ███░ ███░ ███░ ║ RECALL RECORDS ║ ███░ ████░ ███░ ███░ ███░ ███░ ███░ ║ RETURN TO MENU ║ ███░ ██░ ███░ ███████████░ ███░ ███░ ║ RUN (DOS COMMAND) ║ ███░ ██░ ███░ ███▀████░ ███▀███████░ ║ SIMPLE EDITOR ║▄▄▄▄▄▄▄▄▄▄ ███░ ▀▀ ███░ ███░ ▀███░ ███░ ║ SORT DATABASE ║ Size█ ███░ ███░ ███░ ▀███░ ███░ ║ TYPE (PRINT) FILE ║ 341148█ Materials ███░ ▀███░ ███░ ║ ZAP DATABASE ║ 439272█ Requirement ███░ ╟────────────────────╢ 3318931█ Planning ║ Select Option ║▀▀▀▀▀▀▀▀▀▀ ╚════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 78 ■ APPEND FROM - Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). - The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ - If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 79 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENT.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 80 ■ BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. - An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 81 - To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ - Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation - Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 82 ■ COPY (.DBF) TO - Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ - The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 83 - The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 84 - The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE - Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 85 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 86 ■ DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 87 ■ ERASE FILE - Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... - The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS - This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 88 ■ INDEX A DATABASE - You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 89 - At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS - List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 90 - The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ - A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 91 - The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 92 - The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE - Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 93 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 94 ■ RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU - Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 95 ■ SIMPLE EDITOR - A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. - If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 96 - Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE - This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 97 - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 98 - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 99 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 100 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌──────────────────────[ DAYOMRP HELP: DBEDIT, 0, ]──────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌────────────────────────[ DAYOMRP HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 101 - Editor help: ┌───────────────────────[ DAYOMRP HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 102 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐ ┌──────[ DAYO HELP Called by Program: DAYOMRP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOMRP. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 103 DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐ ┌───────[ DAYO HELP Called by Program: DAYOMRP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOMRP.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOMRP the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE: 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 104 ■ DATABASE STRUCTURES The following is the file structure, in dBase (tm) format for the 4 databases specific to DAYO MRP (BOM.DBF, SO.DBF, SOHIST.DBF, SO_NOTES.DBF) as of 21 January 1991. Note, you can add additional fields (use the MODIFY DATABASE option in MISC ROUTINES), but it is not recommended that existing fields be modified in length and especially type. ■ BOM.DBF STRUCTURE Field Field name Type Width Dec Start End ----- ---------- --------- ----- --- ----- ----- 1 ENDITEM Character 12 1 12 2 DESC Character 30 13 42 3 COST Numeric 10 3 43 52 4 LEVEL1 Character 12 53 64 5 LEVEL2 Character 12 65 76 6 LEVEL3 Character 12 77 88 7 LEVEL4 Character 12 89 100 8 LEVEL5 Character 12 101 112 9 LEVEL6 Character 12 113 124 10 LEVEL7 Character 12 125 136 11 LEVEL8 Character 12 137 148 12 FINIS_QTY Numeric 10 3 149 158 13 WIP_QTY Numeric 10 3 159 168 14 REQ_QTY Numeric 10 3 169 178 15 PER_QTY Numeric 10 3 179 188 16 PTD_QTY Numeric 10 3 189 198 17 YTD_QTY Numeric 10 3 199 208 18 DATE Date 8 209 216 19 LASTDATE Date 8 217 224 20 LASTTIME Character 8 225 232 21 HOURS Numeric 10 3 233 242 22 LABOR Numeric 10 3 243 252 23 LABOR1 Numeric 10 3 253 262 24 LABOR2 Numeric 10 3 263 272 25 OVERRIDE Logical 1 273 273 26 POSITION Character 7 274 280 ----- ---------- --------- ----- --- ----- ----- Total 281 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 105 ■ SO.DBF STRUCTURE Field Field name Type Width Dec Start End ----- ---------- --------- ----- --- ----- ----- 1 SO Numeric 6 1 6 2 COMMENT Character 30 7 36 3 ENDITEM Character 12 37 48 4 DESC Character 30 49 78 5 QTY Numeric 10 3 79 88 6 COST Numeric 10 3 89 98 7 ASSEMBLED Numeric 10 3 99 108 8 DATE Date 8 109 116 9 DUEDATE Date 8 117 124 10 LASTDATE Date 8 125 132 11 HOURS Numeric 10 3 133 142 12 LABOR Numeric 10 3 143 152 13 LABOR1 Numeric 10 3 153 162 14 LABOR2 Numeric 10 3 163 172 15 PRIORITY Numeric 3 173 175 16 OPEN Logical 1 176 176 17 ALLOCATED Logical 1 177 177 18 PRINTED Logical 1 178 178 19 CUSTOMER Numeric 6 179 184 20 INVOICE Numeric 6 185 190 ----- ---------- --------- ----- --- ----- ----- Total 191 ■ SOHIST.DBF STRUCTURE Field Field name Type Width Dec Start End ----- ---------- --------- ----- --- ----- ----- 1 SO Numeric 6 1 6 2 COMMENT Character 30 7 36 3 ENDITEM Character 12 37 48 4 DESC Character 30 49 78 5 QTY Numeric 10 3 79 88 6 COST Numeric 10 3 89 98 7 ASSEMBLED Numeric 10 3 99 108 8 DATE Date 8 109 116 9 DUEDATE Date 8 117 124 10 LASTDATE Date 8 125 132 11 HOURS Numeric 10 3 133 142 12 LABOR Numeric 10 3 143 152 13 LABOR1 Numeric 10 3 153 162 14 LABOR2 Numeric 10 3 163 172 15 PRIORITY Numeric 3 173 175 16 OPEN Logical 1 176 176 17 ALLOCATED Logical 1 177 177 18 PRINTED Logical 1 178 178 19 CUSTOMER Numeric 6 179 184 20 INVOICE Numeric 6 185 190 ----- ---------- --------- ----- --- ----- ----- Total 191 DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 106 ■ SO_NOTES.DBF STRUCTURE Field Field name Type Width Dec Start End ----- ---------- --------- ----- --- ----- ----- 1 SO Numeric 6 1 6 2 NOTES Memo 10 7 16 3 COST Numeric 12 3 17 28 4 DATE Date 8 29 36 ----- ---------- --------- ----- --- ----- ----- Total 37 ■ DATA DICTIONARY Field Name Type Len Dec Database Comments ----------- ---- ---- --- -------------- ---------------------------------- ALLOCATED L 1 0 SOHIST.DBF Flag to denote whether this shop SO.DBF order record has been allocated. Allocating is the process of updating the REQ_QTY in the database BOM.DBF with the increase in item quantity that will be required to assemble the ENDITEMS ASSEMBLED N 10 3 SOHIST.DBF Assembled ENDITEMS through the MRP SO.DBF process. Items finished/built COMMENT C 30 0 SOHIST.DBF Any user inputted comment or notes SO.DBF specific to a shop order or an ENDITEM for a shop order COST N 10 3 SO.DBF Cost each for an ENDITEM COST N 12 3 SO_NOTES.DBF Cost each for an ENDITEM or COST N 10 3 SOHIST.DBF component item BOM.DBF CUSTOMER N 6 0 SOHIST.DBF Customer number that the shop order SO.DBF was created for. Its use is optional DATE D 8 0 BOM.DBF Date record was created SOHIST.DBF SO.DBF SO_NOTES.DBF DESC C 30 0 BOM.DBF Description of the ENDITEM or SOHIST.DBF component item SO.DBF DUEDATE D 8 0 SO.DBF Date the shop order is due to be SOHIST.DBF completed. Use this field to schedule shop order/assembly ENDITEM C 12 0 SO.DBF Number for an assembled item. An SOHIST.DBF ENDITEM is defined as one made from BOM.DBF other items in the inventory DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 107 DATA DICTIONARY CONTINUED... Field Name Type Len Dec Database Comments ----------- ---- ---- --- -------------- ---------------------------------- FINIS_QTY N 10 3 BOM.DBF Finished/Assembled quantity. Needs to be returned to the inventory so that it can be later invoiced or used in further MRP processes HOURS N 10 3 SOHIST.DBF Total hours per item required to SO.DBF assemble it BOM.DBF INVOICE N 6 0 SOHIST.DBF Invoice number that the shop order SO.DBF was created for. Its use is optional LABOR N 10 3 BOM.DBF Total labor cost per item SO.DBF SOHIST.DBF LABOR1 N 10 3 SOHIST.DBF Alternate labor cost per item SO.DBF BOM.DBF LABOR2 N 10 3 SOHIST.DBF Alternate labor cost per item BOM.DBF SO.DBF LASTDATE D 8 0 SOHIST.DBF Date of last access BOM.DBF SO.DBF LASTTIME C 8 0 BOM.DBF Time of last access LEVEL1 C 12 0 BOM.DBF BOM level 1 item number LEVEL2 C 12 0 BOM.DBF BOM level 2 item number LEVEL3 C 12 0 BOM.DBF BOM level 3 item number LEVEL4 C 12 0 BOM.DBF BOM level 4 item number LEVEL5 C 12 0 BOM.DBF BOM level 5 item number LEVEL6 C 12 0 BOM.DBF BOM level 6 item number LEVEL7 C 12 0 BOM.DBF BOM level 7 item number LEVEL8 C 12 0 BOM.DBF BOM level 8 item number NOTES M 10 0 SO_NOTES.DBF Shop order expanded notes or comments. Use this routine to save any amount of information about a shop order. Note, the first 21 lines of the notes is printed onto the shop orders OPEN L 1 0 SOHIST.DBF Flag to denote whether shop order SO.DBF is open (.T., not yet assembled) or closed (.F.) OVERRIDE L 1 0 BOM.DBF Not used... PER_QTY N 10 3 BOM.DBF Quantity required to make 1 unit for use in the Bill of Materials for an ENDITEM POSITION C 7 0 BOM.DBF The position of a component item in a Bill of Materials PRINTED L 1 0 SO.DBF Flag to denote whether a shop order SOHIST.DBF has been printed DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 108 DATA DICTIONARY CONTINUED... Field Name Type Len Dec Database Comments ----------- ---- ---- --- -------------- ---------------------------------- PRIORITY N 3 0 SO.DBF Priority flag to denote a priority SOHIST.DBF of a shop order. User defined... PTD_QTY N 10 3 BOM.DBF Period to date quantity of items used in MRP QTY N 10 3 SO.DBF Quantity of items to be assembled SOHIST.DBF or built per shop order ENDITEM REQ_QTY N 10 3 BOM.DBF Required quantity to be taken from the inventory in order that the required number of ENDITEMS be built SO N 6 0 SO_NOTES.DBF Shop order number SOHIST.DBF SO.DBF WIP_QTY N 10 3 BOM.DBF Work In Process quantity. This is a 'physical' record of the numbers of items moved from the inventory into work in process. This quantity is accountable, and will be used to create/assemble/build the ENDITEM YTD_QTY N 10 3 BOM.DBF Year to date quantity of items used in MRP DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 109 ■ DAYO MRP MAINTENANCE & QUIRKS - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - On many networks, you must load the program SHARE or its replacement at boot up time on the server in order to make files sharable. - Backups of your data and configuration files should take place daily! You have no doubt heard many 'scare' stories about losing data. They are all true! The key files that need to be backed up all have the extension of .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files are notes/memos. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. If you do use it (as we do), use it with caution and check frequently to insure no damage has been done! - If you must use dBase (tm) with DAYO MRP, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... - To clear the Period to Date (PTD_QTY) and/or Year to Date (YTD_QTY) fields in the BOM database (BOM.DBF), use a routine in the Smart Reports. DAYO MRP VERSION 3.0, TJS LAB Orlando, Florida Page: 110 ■ TJS 'Computer' LAB TJS LAB produces customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (ie: A/R, A/P, G/L). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are very reasonably priced! Custom/contract programming is available. We make program enhancements and changes very quickly; usually within 24 hours! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Call us for a quote or just for more information! Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858 Or call us, 08:00am to 11:00pm Mon-Sat Voice Mail between 11:00pm to 08:00am: (407) 291-3960/6987 ┌──────────────────────────────────────────────────────────────────────┐ │ Note that TJS LAB will not accept/take any support calls for │ │ UNregistered products! │ └──────────────────────────────────────────────────────────────────────┘