ProfitPress Mega CDROM2 Shareware Freeware (MSDOS)(1992)(Eng)

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

/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / APPS / DAYO / DAYOJE.ZIP / DAYOJE.EXE / DAYOJOB.DOC < prev next >

Wrap

Text File | 1991-09-10 | 501.1 KB | 6,418 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ████░ ▄████▄ ██▄████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ███████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ▀████▀ ██▀████░ ║ ║ ║ ║ ▄█████░ ▄████▄ █████░ ██████░ ████░ ██░ ██░ ███████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░██░ ██░ ║ ║ ██░ ██░ ██░ █████░ ██░ ██░ ███████░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░████░ ██░ ███░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀█████░ ▀████▀ █████░ ██░ ████░ ██░ ██░ ███████░ ║ ║ ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc ■ 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 purchase or registration. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 292-4708111 - 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 JOB COSTING, TJS LAB, Inc Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 2......SETUP 3......MAIN MENU 3......AUTOMATIC INDEXING 4......EXIT PROGRAM 4......PASSWORD/NAME 5......WORK ORDER ROUTINES 6......INITIATE WORK ORDER 6......NON-STANDARD WORK ORDERS 7......FULL SCREEN EDIT 8......ADD A NEW RECORD - FULL SCREEN EDIT 8......EDIT/VIEW CUSTOMER NOTES 9......FIND CUSTOMER FOR NEW WORK ORDER 10......EDIT OF INITIATED WORK ORDER 11......BROWSE WORK ORDERS 12......FULL SCREEN EDIT 13......CLOSE WORK ORDER 14......CREATE NEW ITEM FROM WORK ORDER NUMBER 15......CREATE BILL OF MATERIALS (BOM) WITH WORK ORDER 15......APPENDING WORK ORDER INTO BOM 16......EDIT/VIEW WORK ORDER NOTES 16......RESET WORK ORDER 16......CREATE WORK ORDER INVOICE - EDIT HEADER 17......ITEM SELECTION 17......SELECT ITEMS FROM INVENTORY 18......EDIT SELECTED ITEMS 19......IMPORT EXISTING BILL OF MATERIAL (BOM) 20......EDIT EXPANDED ITEM INFORMATION 20......EDIT INVOICE NOTES 21......FIND ITEM 21......FINISHED WITH THE WORK ORDER INVOICE 22......EXAMPLE OF WORK ORDER INVOICE 23......FIND WORK ORDER - F5 23......SELECT ACTIVE INDEX 24......EXAMPLE OF WORK ORDER MASTER SUMMARY - INVENTORY 24......INVENTORY SUMMARY 25......LABOR SUMMARY CONTINUED... 26......WORK ORDER MASTER SUMMARY CONTINUED... 27......ISSUE ITEMS BROWSE 28......FULL SCREEN EDIT - WORK ORDER INVOICE 28......ISSUE ITEMS DAYO JOB COSTING, TJS LAB, Inc Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 30......ISSUE ITEMS POST 30......ISSUE FORM/INVOICE COPIES 31......EXAMPLE OF ITEM ISSUE FORM/INVOICE 32......BILL OF MATERIALS BROWSE 33......FULL SCREEN EXIT - BOM 34......CREATE A NEW BILL OF MATERIALS (BOM) 35......ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM) 36......ADD ITEM FROM INVENTORY FOR CURRENT BOM 37......DELETE BOM RECORD 37......RESORT A BOM 38......RESET ITEM FIELD 38......PRINT TRAVELER 38......FIND BOM RECORD F5 38......CURRENT INDEX - F6 39......VIEW INVENTORY 40......FULL SCREEN VIEW - INVENTORY 41......FASTFIND - INVENTORY 42......FIND ITEM - INVENTORY 43......VIEW CUSTOMERS 44......FULL SCREEN VIEW - CUSTOMERS 45......CUSTOMER PROFILE 46......FIND CUSTOMER 47......FASTFIND - CUSTOMER 48......MAINTAIN/BROWSE WORK ORDER/JOB TYPES 49......LABOR 50......FULL SCREEN EDIT 51......DAILY LABOR ENTRY 53......WEEKLY LABOR ENTRY 53......BROWSE HOURLOG DETAIL RECORDS 54......FULL SCREEN EDIT - LABOR 55......FIND HOURLOG RECORD 56......ADD NEW EMPLOYEE RECORD 57......FIND EMPLOYEE 58......REPORTS 59......WORK ORDER ABBREVIATED REPORT 61......EXAMPLE OF WORK ORDER ABBREVIATED REPORT 62......WORK ORDER EXPANDED REPORT 64......LABOR REPORT - GENERAL 66......LABOR REPORT - SPECIFIC EMPLOYEE 67......LABOR REPORT - SPECIFIC WORK ORDER 68......LABOR REPORT - SPECIFIC CLASS 69......LABOR REPORT - SPECIFIC TYPE 70......CONFIGURATION STATUS/REPORT 71......EXAMPLE OF THE CONFIGURATION STATUS/REPORT 72......VIEW REPORTS ON SCREEN DAYO JOB COSTING, TJS LAB, Inc Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 73......REPORT VIEWING SCREEN 74......REPORT VIEWING SCREEN EXAMPLE... 75......CONFIGURATION 75......COMPANY NAME 76......COMPANY ADDRESS 76......COMPANY TELEPHONE 76......AUTOMATICALLY PRINT INVOICES 76......INVOICE PRINTER PORT 76......INVOICE COPIES 77......DEFAULT SHIPPER/METHOD OF SHIPMENT 77......DEFAULT COMMENT 77......DEFAULT OVERHEAD FACTOR 77......LAST WORK ORDER NUMBER 78......LAST CUSTOMER NUMBER 78......LAST INVOICE NUMBER 78......TAX WORK ORDERS IF CUSTOMER IS TAXABLE 78......CLASS CODE TYPES 79......BROWSE THE WORKING CLASS CODES TABLE/DATABASE (CLASS.DBF) 79......EDIT WORKING CLASS CODE 80......WORK ORDER FORMAT 80......DEFAULT WORK ORDER TYPE 80......OVERRIDE REQUIRED QUANTITY 81......ALLOW EDIT OF WORK ORDER NUMBER (WO) 81......INVENTORY LOCATION/DIRECTORY 81......CUSTOMER DATABASE LOCATION/DIRECTORY 82......INVOICE DATABASE (POS) LOCATION/DIRECTORY 82......MRP (BOM) DATABASE LOCATION/DIRECTORY 82......PAYROLL DATABASE LOCATION/DIRECTORY 83......GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY 83......CURRENT DIRECTORY DATABASE LOCATION 83......REPORT PRINTER PORT 84......AUTOMATIC GL POSTING 85......EDIT CLASS CODE RECORD 85......ADD NEW CLASS CODE RECORD 87......FIND CLASS CODE 87......VISUAL INDEXING 88......AUTOMATIC DAILY INDEXING 88......COLOR MONITOR 88......COLOR INTENSITY 89......MISCELLANEOUS ROUTINES 89......MISC Routines Menu: 90......APPEND FROM 92......BROWSE DATABASES 94......COPY (.DBF) TO DAYO JOB COSTING, TJS LAB, Inc Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 96......CREATE DATABASE 98......DELETE RECORDS 99......ERASE FILE 99......EXIT TO DOS 100......INDEX A DATABASE 101......LIST FIELDS 104......MODIFY DATABASE 105......PACK DATABASE 106......RECALL RECORDS 106......RETURN TO MENU 106......RUN (DOS COMMAND) 107......SIMPLE EDITOR 108......SORT DATABASE 109......TYPE (PRINT) FILE 110......ZAP DATABASE 112......HELP SCREENS 113......EXPANDED HELP 114......USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 115......VIEW DOCUMENTATION ONSCREEN 116......DATABASE STRUCTURE 116......DATABASE - BOM.DBF 116......DATABASE - CLASS.DBF 117......DATABASE - CUSTOMER.DBF 118......DATABASE - HOURLOG.DBF 118......DATABASE - INOTES.DBF 119......DATABASE - INV.DBF 120......DATABASE - INV2.DBF 120......DATABASE - INVADJ.DBF 120......DATABASE - NEXTWO.DBF 121......DATABASE - PAY.DBF 122......DATABASE - SHIPPER.DBF 122......DATABASE - TYPE.DBF 123......DATABASE - WO.DBF 124......DATABASE - WOD.DBF 124......DATABASE - WOH.DBF 125......DATABASE - WOLOG.DBF 125......DATABASE - WONOTES.DBF 126......DATA DICTIONARY 134......DAYO JOB COSTING MAINTENANCE & QUIRKS 136......TJS 'Computer' LAB DAYO JOB COSTING, TJS LAB, Inc Page: 1 ■ INTRODUCTION DAYO Job Costing tracks all 'costs' related to a job, project, task, or work order. It is by default a multiuser system, allowing almost unlimited numbers of users to have the ability to simultaneously access this program on a PC based LAN/Network. It can however, be run (like all DAYO products) as a 'standalone' application. Features are many and include: Multiuser (ie: Novell, LANtastic), Work Orders, Data Entry Validation, Databases are dBase (tm) compatible, Many Configuration Settings/Options, Work Order Types, Passwords (with DAYO Passwords), Printer Setup, Work Order Abbreviated, Work Order Expanded, Labor Report Summary Date Range, Labor Report - Specific Employee, Labor Report - Specifc Work Order, Labor Report - Specific Class, Labor Report - Specific Type, Config Status Report, View Reports On Screen, Auto Print Item Issue Form/Invoice, Multiple Printer Ports, Overhead Factor, Add & Maintenance Customer Records, Tax Work Orders, Class Code Types, Working Class Codes, Multiple Work Order Formats, Integration with other DAYO modules (ie: Inventory, Payroll, Customers, POS, MRP), Visual Indexing, Auto Daily Indexing, Record of Labor, Travelers, Item Issue, and Work Order Master Summary. This system is based upon Work Orders. A Work Order is defined as a record of inventory and labor required to produce an enditem, product, project or task. This system provides a system of recording both inventory and labor. All inventory, when issued is related to a specific Work Order. Labor is recorded as direct and indirect, and is also related to a specific Work Order. When a Work Order is finished, it is closed and a Master Work Order Summary is printed which sums up the total inventory, direct labor, indirect labor, and includes an overhead factor. This Master Work Order Summary is the COST for the 'Job'. The finished/closed Work Order can be added to the inventory as a new item, and/or added (with all its components) to a Bill of Materials database (to be used later as a template). Other DAYO Products: DAYO Inventory DAYO Returns & Refunds DAYO POS DAYO Return Management System DAYO Billing & Invoicing DAYO Price Books DAYO Quotes DAYO Look Up DAYO AR DAYO MRP DAYO AP DAYO Payroll DAYO EOP DAYO General Ledger (GL) DAYO Passwords DAYO Bar Code DAYO Smart Reports DAYO Rental POS DAYO Index DAYO Order Entry DAYO Back Orders DAYO Shipping Log DAYO Menu DAYO Time & Billing DAYO Little POS DAYO Membership DAYO Simple POS DAYO JOB COSTING, TJS LAB, Inc Page: 2 ■ 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 Job Costing software, documentation, and source codes. Authorization to distribute Demonstration Versions is granted. ■ 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 Job Costing. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO Job Costing, use the SETUP program supplied on the MENU or Update & Conversion diskette, or copy the contents of the DAYO Job Costing floppy disk(s) into a directory on your hard disk (ie: \DAYOJOB), then 'uncompress' (ie: PKunzip ) the programs. When running DAYO Job Costing for the first time, it will create all the database, index, and configuration files it requires for operation. If other DAYO modules are being used, be sure to enter the location of these databases into the DAYO Job Costing configuration. Type and enter 'DAYOJOB' at the DOS prompt to run the program. DAYO JOB COSTING, TJS LAB, Inc Page: 3 ■ MAIN MENU After a few moments and possibly a reindex, the main menu will appear: DAYO Job Costing Version 1.18 TJS LAB, INC. ┌────[August 1991]───┐ Copyright (c) 1991 All Rights Reserved │S M T W T F S │ ╓────────────────────╖ ├────────────────────┤ ║ 1 WORK ORDERS ║ ████▄ ▄█▄ █░ █░ ▄███▄ │ 1 2 3│ ╟────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 4 5 6 7 8 9 10│ ║ 2 LABOR ║ █░ █░ █░█░ ▀█░██░ █░ █░ │11 12 13 14 15 16 17│ ╟────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │18 19 20 21 22 23 24│ ║ 3 REPORTS ║ █░ █░ █░ █░ █░ █░ █░ │25 26 27 28 29 30 31│ ╟────────────────────╢ ████▀ █░ █░ █░ ▀███▀ │ │ ║ 4 CONFIGURATION ║ └────────────────────┘ ╟────────────────────╢ ████░ ▄████▄ ██▄████░ Reindex (Alt F9) ║ 5 MISC ROUTINES ║ ██░ ██░ ██░ ██░ ██░ ╟────────────────────╢ ██░ ██░ ██░ ██░ ██░ ║ 6 EXIT ║ ██░ ██░ ██░ ███████░ ╚════════════════════╝ ██░ ██░ ██░ ██░ ██░ Select Option ██░ ██░ ██░ ██░ ██░ ██░ ██████░ ▀████▀ ██▀████░ ███ █ ██ █ ███ ███ █ █ █ █ █ █ █ █ ▄███░ ▄██▄ ████░ █████░ ███░ █░ █░ ████░ █ █ ██ █ ███ ███ █░ █░ █░ █░ █░ █░ ██░█░ █░ █ █ █ █ █ █ █ █ █░ █░ █░ ████░ █░ █░ ████░ █░▐█░ █ ██ ██ ██ █ █ ███ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ ▀███░ ▀██▀ ████░ █░ ███░ █░ █░ ████░ View-Adjust-Create Work Orders ■ AUTOMATIC INDEXING Every day each index must be indexed, and this usually happens when the first user accesses the system. All databases accessed will have their related indexes reindexed, ie: ┌──────────────────────────────────────────────────────────┐ │ Database Name: WO.DBF │ │ Index Name: WO.NTX │ │ Index Key: WO │ │ Number of Records: 25 │ │ ┌──────────────────────────────────────────────────┐ │ │ │██████████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 4 ■ EXIT PROGRAM There exists 4 ways to exit this program; reboot computer, turn it off, press 'Alt C', or select the EXIT option (the recommended way), from the main menu of DAYO Job Costing, ie: ╔═══════════════╗ ║╔═════════════╗║ ║║╔═══════════╗║║ ║║║QUIT? (Y/N)║║║ ║║╚═══════════╝║║ ║╚═════════════╝║ ╚═══════════════╝ ■ PASSWORD/NAME From the main menu, after entering your name or password, you can enter any of the menu options. ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: TJ ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 5 ■ WORK ORDER ROUTINES From this sub menu, you can initiate a new Work Order, browse existing Work Orders, issue items for a Work Order, view/edit bill of materials, view the inventory, view the customers, and view/edit Work Order types. ╔════════════════════════╗ ║ WORK ORDER ROUTINES ║ ╟────────────────────────╢ ║ INITIATE WORK ORDER ║ ║ WORK ORDER BROWSE ║ ║ ITEM ISSUE ║ ║ BILL OF MATERIALS ║ ║ VIEW INVENTORY ║ ║ VIEW CUSTOMERS ║ ║ WORK ORDER TYPES ║ ║ ║ ║ ║ ║ ║ ╟────────────────────────╢ ║ Select Option ║ ╚════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 6 ■ INITIATE WORK ORDER The first thing to be done is to initiate a Work Order. This simply means that you enter information specific to the job to be accomplished, ie: Work Order Number, Customer's Number & Purchase Order Number, and dates. Since all Work Orders are 'tied' to a customer/customer number, the selection of a customer is required, ie: ╔══════════════[ NEXT WORK ORDER: 121 - INITIATE WORK ORDER ]══════════════╗ ║ Bill To: Ship To: ║ ║ GEORGE MOONILAL ║ ║ 13 WEST COLONIAL ║ ║ ║ ║ ORLANDO, FL 32802 , ║ ║ Customer # Type Salesper Terms Shipper ║ ║ 100 REG LT CASH PICKUP ║ ║ Phone Attn Balance Lastdate ║ ║ (407) 292-4708 RICH LAROSSA 1453.00 08/19/91 ║ ╟────────────────────────────[ SELECT CUSTOMER ]─────────────────────────────╢ ║ CUSTOMER NAME ATTN ║ ║──────────╥────────────────────────────────╥────────────────────────────────║ ║ 100 ║ GEORGE MOONILAL ║ RICH LAROSSA ║ ║ 117 ║ ENERGYVISION & SUNROOFS ║ ║ ║ 164 ║ GENE SZARA III ║ SALLY ║ ║ 188 ║ DAVE NICKERSON INC. ║ DICK ║ ║ 292 ║ JOHNSON'S MOBILE HOMES ║ JOSE ║ ║ 294 ║ ABLE GLASS COMPANY ║ DYMAN JONES ║ ║ 333 ║ BLALOCK ALUMINUM PROD. ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc(Exit) F1(Help) Enter(Select) F2(Edit) Ctrl N(Add) Alt N(Notes) Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code) During the browse selection of a customer, you can edit, add, view/edit customer notes, or find a customer record with many search options. ■ NON-STANDARD WORK ORDERS Note, if a Work Order is not 'tied' to a customer, you can add a 'dummy' customer record with a name like 'INTERNAL WORK ORDER', or 'FOR INTERNAL USE ONLY', or 'NON-STANDARD WORK ORDER'... The selection of this 'non-standard' customer will thus produce a 'non-standard' Work Order. DAYO JOB COSTING, TJS LAB, Inc Page: 7 ■ FULL SCREEN EDIT As in many browse routines, you can press 'F2' to edit the currently highlighted record. Note, very little validation of the data is performed in this routine, so be very careful while editing. Note, if more than 42 fields exist, they will appear on 'page 2' of the Full Screen Edit... ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ CUSTOMER: 100 LASTDATE: 08/19/91 │ │ NAME: GEORGE MOONILAL TYPE: REG │ │ ATTN: RICH LAROSSA CLASS: AR │ │ ADDR1: 13 WEST COLONIAL PBM: 20.000 │ │ ADDR2: PBL: 0.000 │ │ CITY: ORLANDO SALESPTD: 1289.28 │ │ STATE: FL SALESYTD: 12354.32 │ │ ZIP: 32802 DUE: 1453.00 │ │ SHIPNAME: PAID_PURC: 1235.00 │ │ SHIPADDR1: LIMIT: 999999.00 │ │ SHIPADDR2: ACTIVE: T │ │ SHIPCITY: TAXCODE: AXB │ │ SHIPSTATE: FAX: (407) 295-2171 │ │ SHIPZIP: SHIPPHONE: (407) 291-3960 │ │ PHONE: (407) 292-4708 FOB: ORLANDO │ │ SALESPER: LT PRICEX: 0 │ │ RATE: 3.000 CREDCARD: │ │ TAXRATE: 0.0600 TAXRATE2: 0.00000 │ │ TERMS: CASH CUSCODE: │ │ SHIPPER: PICKUP │ │ DATE: 05/22/91 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO JOB COSTING, TJS LAB, Inc Page: 8 ■ ADD A NEW RECORD - FULL SCREEN EDIT You can add a new customer record by pressing 'Ctrl N'. This will append a new/blank record to the customer database, and assign it the next available customer number. The default fields will be filled in, ie: CLASS, SHIPPER, TAXRATE, and DATE. ┌──────────────────[ ADD A NEW RECORD - FULL SCREEN EDIT ]───────────────────┐ │ CUSTOMER: 10324 LASTDATE: 08/25/91 │ │ NAME: New Customer Name TYPE: 1 │ │ ATTN: CLASS: AR │ │ ADDR1: PBM: 0.000 │ │ ADDR2: PBL: 0.000 │ │ CITY: SALESPTD: 0.00 │ │ STATE: SALESYTD: 0.00 │ │ ZIP: DUE: 0.00 │ │ SHIPNAME: PAID_PURC: 0.00 │ │ SHIPADDR1: LIMIT: 999999.00 │ │ SHIPADDR2: ACTIVE: T │ │ SHIPCITY: TAXCODE: │ │ SHIPSTATE: FAX: │ │ SHIPZIP: SHIPPHONE: │ │ PHONE: FOB: │ │ SALESPER: PRICEX: 0 │ │ RATE: 0.000 CREDCARD: │ │ TAXRATE: 0.0000 TAXRATE2: 0.00000 │ │ TERMS: CUSCODE: │ │ SHIPPER: PICKUP │ │ DATE: 08/25/91 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ EDIT/VIEW CUSTOMER NOTES Press 'Alt N' to edit and/or just view the notes for the currently highlighted customer. Many pages of information can be inputted here. Press the 'F1' key for further information about the special function keys while in the edit mode... ╔════════════════════════[ EDIT/VIEW Customer Notes ]════════════════════════╗ ║Date: 06/28/91 - Sold Rich some green sheets of Item: 393-91-REG-GR ║ ║ ║ ║Rich asked if we could find him some missles without fuses. Needs them for ║ ║immediate overseas shipment! ║ ║ ║ ║Send Rich a fax with info on missiles, LT... ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 9 ■ FIND CUSTOMER FOR NEW WORK ORDER There are 5 indexes for the customer database, and are accessed via the 'F5/F6/F7/F8/F9' keys. Press 'F5' to find a customer based on the customer's number. ┌─────────────────────────────────────────────────────────────┐ │ Enter CUSTOMER: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to find a customer based on the customer's name. ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to find a customer based on the customer's ship to name. ┌─────────────────────────────────────────────────────────────┐ │ Enter SHIPNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to find a customer based on the customer's last four digits of their telephone number. ┌─────────────────────────────────────────────────────────────┐ │ Enter right 4 digits Phone: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to find a customer based on the customer's zip code. ┌─────────────────────────────────────────────────────────────┐ │ Enter ZIP: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO JOB COSTING, TJS LAB, Inc Page: 10 ■ EDIT OF INITIATED WORK ORDER Press 'Enter' on the selected customer, and then respond to the prompts for the Purchase Order, Release Number, Quote Number & Date, Tax Rate, Issue Date, Completion Date, CLASS Code, Overhead Factor, and TYPE Code. Note, a unique Work Order is required... ╔══════════════[ NEXT WORK ORDER: 121 - INITIATE WORK ORDER ]══════════════╗ ║ Bill To: Ship To: ║ ║ GEORGE MOONILAL ║ ║ 13 WEST COLONIAL ║ ║ ║ ║ ORLANDO FL 32802 ║ ║ Customer # Type Salesper Terms Shipper ║ ║ 100 REG LT CASH PICKUP ║ ║ Phone Attn Balance Lastdate ║ ║ (407) 292-4708 RICH LAROSSA 1453.00 08/19/91 ║ ╟─────────────────────[ EDIT WORK ORDER MASTER RECORD ]──────────────────────╢ ║ Extended Fields Input By: sdf ║ ║ Work Order: 121 ║ ║ Customer PO: Issue Date: 08/25/91 ║ ║ Release Number: Completion Date: / / ║ ║ ║ ║ Quote/Proposal Number: 0 Class Code: AR ║ ║ Quote/Proposal Date: / / Overhead Factor: 0.00000 ║ ║ Tax Rate: 0.06000 Type Code: 1 ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) F1 (Help) PgUp/PgDn (Save & Exit) (Use the Up Arrow Key to edit fields on top of screen...) 128/137 DAYO JOB COSTING, TJS LAB, Inc Page: 11 ■ BROWSE WORK ORDERS The second menu option in the Work Order Routines is the browse of all open and closed Work Order 'Master' records. This record contains the vital data/information for a Work Order, ie: the customer name, address, ship to address, inventory costs, labor costs, freight subtotals, tax subtotals, adjustments, dates, and more. Note, much of this data is maintained by the computer. ╔═══════════════════════════[ BROWSE WORK ORDERS ]═══════════════════════════╗ ║ Bill To: Ship To: ║ ║ GEORGE MOONILAL ║ ║ 12 WEST COLONIAL ║ ║ ║ ║ ORLANDO, FL , ║ ║ Customer # Type Class Rep By Shipper ║ ║ 100 REG AR TW SAJ PICKUP ║ ║ Phone Attn Date LastDate Issued ║ ║ (407) 292-4708 RICH LAROSSA 06/29/91 08/17/91 06/29/91 ║ ║ Customer PO Release # Comment ║ ║ 833-3837A 833-3837A-1 MOTOR, WITH RED BEARINGS # 4004 ║ ║ Total Total Wip Labor Overhead ║ ║ 4424.21 2344.18 2687.06 0.00 <COMPLETED: 08/25/91> ║ ╟───[ Work Order: 91-REG36 ]────────────────────────────────────────────╢ ║ WO CUSTOMER NAME ║ ║────────────────────╥──────────╥────────────────────────────────────────────║ ║ 35 ║ 188 ║ DAVE NICKERSON ENT. ║ ║ 36 ║ 100 ║ GEORGE MOONILAL ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) F3 (Close) Alt N (WO Notes) Ctrl F1(Reset) Alt I(Invoice) Alt P(Print) F5 (Find) F6 (Set Index) Current Index: WO 2/29 DAYO JOB COSTING, TJS LAB, Inc Page: 12 ■ FULL SCREEN EDIT If necessary, you can edit the Work Order 'Master' record by pressing the 'F2' key, ie: ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ CUSTOMER: 100 QUOTE_DATE: 12/05/90 │ │ NAME: GEORGE MOONILAL SALESPER: TW │ │ ATTN: RICH LAROSSA SHIPPER: PICKUP │ │ ADDR1: 12 WEST COLONIAL DATE: 06/29/91 │ │ ADDR2: LASTDATE: 08/17/91 │ │ CITY: ORLANDO BY: SAJ │ │ STATE: FL TYPE: REG │ │ ZIP: CLASS: AR │ │ PHONE: (407) 292-4708 TAXRATE: 0.06000 │ │ SHIPNAME: TOTAL: 4424.21 │ │ SHIPADDR1: TOTAL_WIP: 2344.18 │ │ SHIPADDR2: DIR_LABOR: 2344.34 │ │ SHIPCITY: IND_LABOR: 342.72 │ │ SHIPSTATE: FREIGHT: 379.35 │ │ SHIPZIP: ADJUST: 173.78 │ │ SHIPPHONE: (407) 291-3960 TAXES: 0.00 │ │ CUST_PO: 833-3837A FACTOR: 0.01245 │ │ RELEASE: 833-3837A-1 OVERHEAD: 0.00 │ │ ISSUE_DATE: 06/29/91 COMMENT: MOTOR, WITH RED BEAR│ │ COMPLETED: 08/25/91 OPEN: T │ │ QUOTE: 39393 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit Note, very little data validation is done in this routine, so be careful! DAYO JOB COSTING, TJS LAB, Inc Page: 13 ■ CLOSE WORK ORDER When a Work Order is finished, you should 'close' it. This process (if performed), will change the field 'OPEN' to .F. (false), and enter the COMPLETED date. ╔═══[ Work Order: 91-REG36 ]═════════════════════════════════════════════════╗ ║ ║ ║ Close this Work Order? (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ▄████░ ██░ ▄████▄ █████░ █████░ ██░ ██░ ▄████▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██▄ █░ ▄██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ █████░ ████░ ██░███░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ███▀███░ ██░ ██░ ║ ║ ▀████░ █████░ ▀████▀ █████░ █████░ ██░██░ ■ ▀████▀ ■ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) F3 (Close) Alt N (WO Notes) Ctrl F1(Reset) Alt I(Invoice) Alt P(Print) F5 (Find) F6 (Set Index) Current Index: WO 2/29 DAYO JOB COSTING, TJS LAB, Inc Page: 14 ■ CREATE NEW ITEM FROM WORK ORDER NUMBER If you respond 'Y' (yes) to the prompt: 'Create a new ITEM number consisting of the work order number? (Y/N)', you will be given the option to edit the key fields for the new item. Note, the new item will default to the Work Order number, but must be unique (not already in the inventory database). Note, the only required field is a valid item number, and something in the 'DESC' (description) field. The COST field is the TOTAL_WIP field value from the Work Order Master record. The PRICE and RETAIL default to double the COST. ╔═════════════════[ CREATE NEW ITEM FROM WORK ORDER NUMBER ]═════════════════╗ ║ Item: 91-RG36 ║ ║ VendItem: RG36 ║ ║ Desc: MOTOR WITH RED BEARINGS ║ ║ ║ ║ Class: AR ║ ║ Type: REG ║ ║ Vendor: TJSLAB ║ ║ Onhand: 1.00000 ║ ║ Cost: 2344.18 ║ ║ Retail: 4688.36 ║ ║ Price: 4688.36 ║ ║ Taxable: Y ║ ║ Serial Number: N ║ ║ Weight: 394.00 ║ ║ Unit: EA ║ ║ Location: B ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO JOB COSTING, TJS LAB, Inc Page: 15 ■ CREATE BILL OF MATERIALS (BOM) WITH WORK ORDER This option lets you create a new (and unique) bill of materials in the database 'BOM.DBF' from the components of this Work Order. Note, only the components that were issued items will be added to the new BOM, and the field 'PER_QTY' will contain the quantity of items issued (WIP_QTY). ╔═══[ Work Order: 91-REG36 ]═════════════════════[ Item: 91-RG36 ]══════╗ ║ ║ ║ Close this Work Order? (Y/N) ║ ║ ║ ║ Create a new ITEM number consisting of the work order number? (Y/N) ║ ║ ║ ║ Create a Bill of Materials (BOM) with this Work Order? (Y/N) ║ ║ ║ ║ ▄████░ ██░ ▄████▄ █████░ █████░ ██░ ██░ ▄████▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██▄ █░ ▄██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ █████░ ████░ ██░███░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ███▀███░ ██░ ██░ ║ ║ ▀████░ █████░ ▀████▀ █████░ █████░ ██░██░ ■ ▀████▀ ■ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) F3 (Close) Alt N (WO Notes) Ctrl F1(Reset) Alt I(Invoice) Alt P(Print) F5 (Find) F6 (Set Index) Current Index: WO 2/29 ■ APPENDING WORK ORDER INTO BOM The progress of the creation of the new BOM is scrolled upon the screen, ie: ╔═══[ Work Order: 91-REG36 ]═════════════════════[ Item: 91-RG36 ]══════╗ ║ ║ ║ Close this Work Order? (Y/N) ║ ║ ║ ║ Create a new ITEM number consisting of the work order number? (Y/N) ║ ║ ║ ║ Create a Bill of Materials (BOM) with this Work Order? (Y/N) ║ ║ Item Description Per Qty ║ ║ 91-RG36 MOTOR WITH RED BEARINGS 0.000 ║ ║ A-B128-2 XT SUB SYS-DTK-CASE-MB-PS-10MZ 10.000 ║ ║ A-B1MBSIMM-1 SIMM - 1MB x 9/100 NS 500.000 ║ ║ WHSE-GLEN WAREHOUSE SYSTEM - GLEN 5.000 ║ ║ A-B-MI48625I MB - 80486I/25 -MICRONICS ISA 1.000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby while I create a Bill of Material! New ENDITEM: 91-RG36 DAYO JOB COSTING, TJS LAB, Inc Page: 16 ■ EDIT/VIEW WORK ORDER NOTES Press 'Alt N' to edit or just view the notes for the currently highlighted Work Order. Press the 'F1' (Help) key for information on the special function/edit keys. ╔═══════════════════════[ EDIT/VIEW WORK ORDER NOTES ]═══════════════════════╗ ║ ║ ║ ║ ║ ║ ║ Type in anything pertinent to this work order in this space! ║ ║ ║ ║ ║ ║ Approximately 18 pages of information! ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) 7/39 ■ RESET WORK ORDER If ever in doubt about the subtotals (ie: TOTAL_WIP, DIR_LABOR, IND_LABOR, and TAXES), press 'Ctrl F1' to initiate the process of summing up each of the subtotals. The progress is displayed on the bottom of the screen, and can take a few minutes (depending on the size of your Work Order), ie: Reset TOTAL, TOTAL_WIP, TAXES, DIR_LABOR & IND_LABOR 12345.12 ■ CREATE WORK ORDER INVOICE - EDIT HEADER Items are issued for a Work Order, so at least one (1) Work Order Invoice must be created so that items can be issued. Press 'Alt I' to create a new Work Order Invoice. The following prompts will appear: ╔════════════════[ CREATE WORK ORDER INVOICE - EDIT HEADER ]═════════════════╗ ║ Next Invoice Number: 213 By: tj ║ ║ ────────────────────────────────────────────────────────────────────── ║ ║ ║ ║ Comment: New Invoice ║ ║ Issued To: Frank LaRossa Type: REG Class: AR ║ ║ Freight: 0.00 Adjustment: 0.00 ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 17 ■ ITEM SELECTION After initiating the new Work Order Invoice, a selection of the inventory items for the Work Order must take place. The items can be selected from the inventory, or from an existing bill of materials (BOM). ╔═══════════════════════════[ BROWSE WORK ORDERS ]═══════════════════════════╗ ║ Bill To: ║ Item Qty Extended║ ║ GEORGE MOONILAL ║ ║ ║ 12 WEST COLONIAL ║ ║ ║ ║ ║ ║ ORLANDO, FL ║ ║ ║ Customer # Type Class Rep By ║ ║ ║ 100 REG AR TW SAJ ║ ║ ║ Phone Attn ║ ║ ║ (407) 292-4708 RICH LAROSSA ╚═════════════════════════════════════╝ ╔════════[ CREATE WORK ORDER INVOICE - SELECT ITEMS FROM INVENTORY ]═════════╗ ║ Item: ACB-DTK3588 Desc: MB - 8058/10 - 34K Onhand: 1030.00000║ ║ ITEM DESC ONHAND ║ ║────────────────────╥────────────────────────────────╥──────────────────────║ ║ ACB-336S520 ║ MB - 80586SX/20 - 3CS ║ 1003.00000 ║ ║ ACB-DTK3588 ║ MB - 8058/10 - 34K ║ 1030.00000 ║ ║ ACB-ECS35625 ║ MB - 80586/25 - ECS ║ 1300.00000 ║ ║ ACB-ECS33533 ║ MB - 80586/33 - 34K CACHE-DCS ║ 1300.00000 ║ ║ ACB-ECS32535 ║ MB - 80586SX/16 - DCS ║ 3300.00000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter (Select) F2 (Edit Selections) Ctrl N (Add) F3 (Import BOM) Alt I (Item Info) Alt N (Invoice Notes) Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type) 12/1417 ■ SELECT ITEMS FROM INVENTORY The default method of adding items to a Work Order Invoice is to select them from the inventory. Use the arrow keys and/or the Find keys (F5-F9) to find a desired item. Press 'Enter' to add the item, ie: ╔════════[ CREATE WORK ORDER INVOICE - SELECT ITEMS FROM INVENTORY ]═════════╗ ║ Item: A-B-DTK8088 Desc: MB - 8088/10 - DTK Onhand: 1000.00000║ ║ ║ ║ ║ ║Item: ACB-DTK5088 Desc: MB - 8058/10 - 34K Cost: 245.00 ║ ║ Onhand: 1000.00000 ABC:C Pack Qty: 3/5 ║ ║OnOrder: 3.00000 Type: RET Class: Unit: EA Unit Qty: 0 ║ ║Vendor: DTK Vendor Item: ACB-DTK5088 BOM:F Wt: 0.00 Loc: ║ ║ Enter Invoice Quantity: 1.00000 WIP/Pick Quantity: 0.00000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) (Use the Up Arrow to edit the two description fields) 12/1417 DAYO JOB COSTING, TJS LAB, Inc Page: 18 In this edit screen you can edit the descriptions, Invoice Quantity, and the WIP/Pick Quantity. The Invoice Quantity is the number of items to be eventually issued to this Work Order. The WIP/Pick Quantity is the actual number of items issued at this time. Note the WIP/Pick Quantity can NEVER exceed the Invoice Quantity... Also note, changing/editing of the descriptions only affect the description fields in the Work Order detail record (not in the inventory database). ■ EDIT SELECTED ITEMS Press 'F2' to emulate a browse selection routine of all items selected so far. ╔═════════════════════════[ EDIT SELECTED ITEMS ]════════════════════════════╗ ║ A-B-ECS38625 MB - 80386/25 - ECS 1000.00000║ ║ ITEM ┬ DESCRIPTION ┬ QTY ┬ WIP ║ ║ ACB-DTK8088 │ MB - 8058/10 - D34 │ 1.00000 │ 0.00000 ║ ║ ACB-ECS38625 │ MB - 80586/25 - DCS │ 1.00000 │ 0.00000 ║ ║ ACB-ECS386SX │ MB - 80586SX/16 - CRS │ 1.00000 │ 0.00000 ║ ║ ACB-MI48625I │ MB - 80586I/25 -MDSFONICS CRT │ 1.00000 │ 0.00000 ║ ║ ACB-SIC286 │ MB - 80586/12 - CRT │ 1.00000 │ 0.00000 ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter (Select/Edit) Ctrl U (Delete) Arrow down to the desired item, then press 'Enter' to edit it. ie: ╔══════[ EDIT ITEM ]════════════════════════════════════════╗ ║ Item: ACB-3CS38625 Desc: MB - 80586/25 - DCS ║ ║ Onhand: 1000.00000 ║ ║ Quantity: 1.00000 WIP Quantity: 0.00000 ║ ╚═══════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 19 ■ IMPORT EXISTING BILL OF MATERIAL (BOM) If the Work Order is to be comprised of items very similar to an Enditem, then press 'F3' to import the bill of materials for that Enditem as a template for this Work Order. A browse selection of all unique Enditem numbers will be presented. If selected, all components will be added to the Work Order. ╔═════════════════[ IMPORT EXISTING BILL OF MATERIAL (BOM) ]═════════════════╗ ║ ENDITEM DESC COST LEVEL1 ║ ║──────────────╥────────────────────────────────╥────────────╥───────────────║ ║ 31-REG36 ║ MOTOR, REGULAR 3HP ║ 136.000 ║ ║ ║ 34-RRK ║ MOTOR, REGULAR 5HP ║ 157.300 ║ ║ ║ 36-R-TJ ║ MOTOR ASSEMBLY STARTER PACK 1 ║ 246.000 ║ ║ ║ 51-REG36 ║ MOTOR ASSEMBLY STARTER PACK 2 ║ 246.000 ║ ║ ║ 91-3REG36 ║ MOTOR ASSEMBLY, #34 ║ 346.000 ║ ║ ║ 91-R-36 ║ MOTOR ASSEMBLY, #45 ║ 346.000 ║ ║ ║ 91-REG24 ║ MOTOR, SPECIAL, GRN ║ 434.000 ║ ║ ║ 91-REG36 ║ MOTOR, SPECIAL, IRELAND ║ 423.000 ║ ║ ║ 91-RG36 ║ MOTOR WITH RED BEARINGS ║ 644.180 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter (Select) DAYO JOB COSTING, TJS LAB, Inc Page: 20 ■ EDIT EXPANDED ITEM INFORMATION Press 'Alt I' to edit/view notes for the currently highlighted item, ie: ╔═══════════[ Edit Expanded Item Information ]═════════════╗ ║ ║ ║ ███░ █▄ ▄█░ █▄██░ █░ █░ █░ █▄██░ ███░ █▄██░ ║ ║ █░ █▄█░ █░ █░ █▀█░ ██░█░ █░ █░ █░ █░ █░ ║ ║ ██░ █░ ████░ █▄█░ ████░ █░ █░ ██░ █░ █░ ║ ║ █░ █▀█░ █░ █▀ ▀█░ █░██░ █░ █░ █░ █░ █░ ║ ║ ███░ █▀ ▀█░ █░ █░ █░ █░ █░ █▀██░ ███░ █▀██░ ║ ║ Item: A-1MB-100 DRAM - 1MB/100 NS ║ ║ ┌─ Up to 4 lines of anything you ─┐ The first 4 lines ║ ║ │ write into this space will │ will print onto ║ ║ │ print onto purchase orders... │ Purchase Orders ║ ║ └─ ─┘ & Work Orders! ║ ║ Note, you can use more than ║ ║ just 4 lines though... ║ ║ ║ ║ ║ ║ ║ ║ ███░ █████░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ ║ ║ █░ █░ █░ ██░██░ █░ ██░█░ █░ █░█░ ║ ║ █░ █░ ██░ █████░ █░ ████░ ██░ █░█░ ║ ║ █░ █░ █░ █░█░█░ █░ █░██░ █░ █░█░ ║ ║ ███░ █░ ███░ █░ █░ ███░ █░ █░ █░ ███░ ║ ╚══════════════════════════════════════════════════════════╝ ■ EDIT INVOICE NOTES Press 'Alt N' to edit the invoice notes, ie: ╔═══════════════════════════[ EDIT INVOICE NOTES ]═══════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ Type in anything pertinent to this Work Order Invoice. ║ ║ ║ ║ ║ ║ Approximately 18 pages of text... ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) 3/0 DAYO JOB COSTING, TJS LAB, Inc Page: 21 ■ FIND ITEM Use the 'F5' through 'F9' keys to find a desired item, ie: Press 'F5' to find an item based on it's number: ┌─────────────────────────────────────────────────────────────┐ │ Enter ITEM: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to find an item based on it's description: ┌─────────────────────────────────────────────────────────────┐ │ Enter DESC: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to find an item based on it's Vendor number: ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDOR+DESC: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to find an item based on it's Vendor/Mfg item number: ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDITEM: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to find an item based on it's TYPE code: ┌─────────────────────────────────────────────────────────────┐ │ Enter TYPE: │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FINISHED WITH THE WORK ORDER INVOICE When finished adding items to the Work Order Invoice, press 'Esc', and the following options will be displayed: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Select Option -> Continue (Post) ║ ║ Return To Item Selection ║ ║ Abort ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 22 ■ EXAMPLE OF WORK ORDER INVOICE WO Invoice: 213 Page 1 Work Order: 91-REG36 YOUR COMPANY, INC Invoiced: 08/25/91 Customer: 100 Attn: Accounts Receivable Time: 15:00:31 P.O. BOX 5555 Printed: 08/25/91 Anycity, ST 555555-5555 800-555-5555 ------------------------------------------------------------------------------ Bill To Ship To GEORGE MOONILAL 12 WEST COLONIAL ORLANDO, FL , (407) 292-4708 Attn: RICH LAROSSA (407) 291-3960 ------------------------------------------------------------------------------ Sales Person: TW Operator: tj Issued To: Frank LaRossa Type: REG Class: AR Shipper: PICKUP Customers PO: 833-3837A Release: 833-3837A-1 Comment: New Invoice ------------------------------------------------------------------------------ # Item Description Req Qty WIP Qty Cost - ------------ ------------------------------ ---------- ---------- ---------- 1 435-D4K8088 MB - 8088/18 - DTP 1.00000 0.00000 100.00 40.00 0.00 2 A5B-E4538625 MB - 80586/25 - CRT 1.00000 0.00000 100.50 44.50 0.00 3 A5B-ECS3463X MB - 80586SX/16 - CRT 1.00000 0.00000 100.00 95.00 0.00 4 A5B-M465625I MB - 80586I/25 -OKIDATA SCSI 1.00000 0.00000 600.50 1675.00 0.00 5 A5B-SIC2444 MB - 80586/12 - CRT 1.00000 0.00000 200.50 75.00 0.00 6 A5B-S6448625 MB - 80586I/25 -FUMLICK SCSI 1.00000 0.00000 100.50 2100.63 0.00 ------------------------------------------------------------------------------ Sub Total Req: 1202.00 Sub Total WIP: 0.00 --------- Freight: 0.00 Adjustment: 0.00 Taxes: 0.00 --------- Required Total: 4720.63 WIP Total: 0.00 Variance: 4720.63 DAYO JOB COSTING, TJS LAB, Inc Page: 23 ■ FIND WORK ORDER - F5 Press 'F5' to find a work order based on the current index, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter WO: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ SELECT ACTIVE INDEX There are ten (10) indexes for the Work Order Invoice header record: ╔══════════════════════[ SELECT ACTIVE INDEX ]════════════════════════╗ ║ Select Active Index -> Work Order Number (Default) ║ ║ Customer Number ║ ║ Customer Name ║ ║ Ship To Name ║ ║ Customer PO ║ ║ Release Number ║ ║ Quote/Proposal Number ║ ║ Sales Person Number ║ ║ Work Order Type ║ ║ Work Order Class ║ ╚═════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 24 ■ EXAMPLE OF WORK ORDER MASTER SUMMARY - INVENTORY At any time, or when the Work Order is completed, a Work Order Master Summary report can be printed. This contains a detailed record of all inventory and labor relating to the Work Order. It comes in 3 parts; Inventory, Labor and Totals, ie: ■ INVENTORY SUMMARY Work Order: 91-REG105 WORK ORDER MASTER SUMMARY Page 1 *** INVENTORY *** YOUR COMPANY, INC Customer: 100 Attn: Accounts Receivable Printed: 08/25/91 P.O. BOX 5555 Opened: 07/12/91 Anycity, ST 555555-5555 800-555-5555 ----------------------------------------------------------------------------- Customer Bill To Customer Ship To GEORGE MOONILAL 5104 N. OBT STE #200 ORLANDO, FL 32810 , (407) 292-4708 Attn: RICH LAROSSA ----------------------------------------------------------------------------- Customers PO: 1234 Release: 124 Type: REG Class: AR Shipper: PICKUP Sales Person: DF Operator: Frank Comment: ----------------------------------------------------------------------------- Item Description Loc Cls Typ Qty Ext Cost ------------ ------------------------------ --- --- --- ---------- ---------- 6-40A16 24X24X15 VEN 0.00000 0.00 abcd sdfafd 0.00000 0.00 ---------- 0.00 TRIPCHARGE TRIP CHARGE INT 3.00000 12589.50 ---------- 12589.50 A3AB-15 TAPE & ADAPTER BOARD KIT - PS2 RET 4.00000 15746.88 A3ADLIB AD-LIB MUSIC SYNTHESIZER CARD RET 0.00000 0.00 A3ADLIB AD-LIB MUSIC SYNTHESIZER CARD RET 8.00000 32932.56 A3ADLIB-PLUS ADLIB MUSIC SYSTEM RET 1.00000 3776.85 A3AMD287-10 CP - AMD - 80587/10 - OEM RET 33.00000 125295.39 A3AST-RAM512 RAM CARD - AST RAMP. PLUS-512K RET 4.00000 15826.80 A3ATI-256 VGA CARD - EGAWONDER+256 RET 3.00000 11450.46 A3ATI2400EX MODEM - 9600 INT - ATI RET 0.00000 0.00 A3ATMIO CC - IDE H5/FD/2S/1P - SYNCOMP RET 4.00000 15906.72 A3B-DTK8088 MB - 8058/10 - DTK RET 0.00000 0.00 ---------- 220935.66 DAYO JOB COSTING, TJS LAB, Inc Page: 25 ■ LABOR SUMMARY CONTINUED... Work Order: 91-REG105 WORK ORDER MASTER SUMMARY Page 5 *** LABOR *** YOUR COMPANY, INC Customer: 100 Attn: Accounts Receivable Printed: 08/25/91 P.O. BOX 5555 Opened: 07/12/91 Anycity, ST 555555-5555 800-555-5555 ------------------------------------------------------------------------------ Customer Bill To Customer Ship To GEORGE MOONILAL 5104 N. OBT STE #200 ORLANDO, FL 32810 , (407) 292-4708 Attn: RICH LAROSSA ------------------------------------------------------------------------------ Customers PO: 1234 Release: 124 Type: REG Class: AR Shipper: PICKUP Sales Person: DF Operator: Frank Comment: ------------------------------------------------------------------------------ Employee Class Description Cls Typ Hours Rate Extended -------- ------------------------------ --- --- ---------- -------- ---------- 000003 Gauge Assembly GA M 300.000 10.0000 3000.00 000003 Gauge Assembly GA M 300.000 10.0000 3000.00 000003 Gauge Assembly GA M 300.000 10.0000 3000.00 000003 Gauge Assembly GA M 300.000 10.0000 3000.00 ---------- InDirect 14323.13 000003 Holiday - Mfg HL M 43.000 10.0000 430.00 000003 Holiday - Mfg HL M 43.000 10.0000 430.00 000003 Holiday - Mfg HL M 43.000 10.0000 430.00 ---------- InDirect 860.00 ---------- Direct 430.00 XXXXXX Maintenance & Indirect MT M 8.000 0.0000 0.00 000003 Sick Time - Eng SKE E 8.100 13.1250 106.31 000003 Sick Time - Eng SKE E 8.100 13.1250 106.31 ---------- InDirect 106.31 ---------- Direct 106.31 DAYO JOB COSTING, TJS LAB, Inc Page: 26 ■ WORK ORDER MASTER SUMMARY CONTINUED... Item Type -> : 0.00 Item Type -> INT: 12589.50 Item Type -> RET: 220935.66 ---------- Total Inventory: 233525.16 ---------- Direct InDirect ---------- ---------- Labor Class -> AD : 271.25 0.00 Labor Class -> DC : 885.96 0.00 Labor Class -> GA : 14323.13 0.00 Labor Class -> HL : 860.00 430.00 Labor Class -> MT : 0.00 0.00 Labor Class -> SKE: 106.31 106.31 Labor Class -> SW : 0.00 0.00 Labor Class -> TE : 348.30 0.00 ---------- ---------- Total Direct Labor: 16794.95 ---------- Total InDirect Labor: 536.31 ---------- Overhead Total: 1679.49 (Factor: 0.10000) ---------- * * * Total Cost: 252535.92 DAYO JOB COSTING, TJS LAB, Inc Page: 27 ■ ISSUE ITEMS BROWSE The third menu option of the Work Order Routines is the routine that lets you issue items. This option consists of Work Order header records that are linked to the 'line' items for a Work Order. ╔════════════════[ BROWSE WORK ORDER INVOICES - ISSUE ITEMS ]════════════════╗ ║ Bill To: Ship To: ║ ║ GEORGE MOONILAL ║ ║ 12 WEST COLONIAL ║ ║ ║ ║ ORLANDO, FL , ║ ║ Customer # Type Class Rep By Shipper ║ ║ 100 REG AR TW tj PICKUP ║ ║ Phone Attn Date LastDate Issued ║ ║ (407) 292-4708 RICH LAROSSA 08/25/91 08/25/91 06/29/91 ║ ║ Customer PO Release # Comment ║ ║ 833-3837A 833-3837A-1 New Invoice ║ ║ Total Total Wip Freight Adjust Taxes ║ ║ 4720.63 0.00 0.00 0.00 0.00 ║ ╟───[ Invoice: 213 ]───────────────────────[ Work Order: 91-REG36 ]─────╢ ║ INVOICE WO COMMENT ║ ║───────────╥────────╥───────────────────────────────────────────────────────║ ║ 212 ║ 104 ║ Special Mortar for 1st Cav ║ ║ 213 ║ 36 ║ New Invoice ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Enter (Issue) Alt B (Browse Detail) Ctrl F1 (Reset) Alt P (Print) Alt N (WO Notes) Alt I (Invoice Notes) Find: F5(WO) F6(Cust) F7(Issued) F8(Type) F9(Class) F10(Invoice) 61/61 DAYO JOB COSTING, TJS LAB, Inc Page: 28 ■ FULL SCREEN EDIT - WORK ORDER INVOICE Press 'F2' to edit the Work Order invoice header record, ie: ┌─────────────[ FULL SCREEN EDIT - INVOICE: 213 WO: 91-REG36 ]─────────────┐ │ COMMENT: New Invoice │ │ DATE: 08/25/91 │ │ LASTDATE: 08/25/91 │ │ CUSTOMER: 100 │ │ ISSUED_TO: Frank LaRossa │ │ TYPE: REG │ │ CLASS: AR │ │ TOTAL: 4720.63 │ │ TOTAL_WIP: 0.00 │ │ FREIGHT: 0.00 │ │ ADJUST: 0.00 │ │ TAXES: 0.00 │ │ BY: tj │ │ OPEN: T │ │ PRINTED: T │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit Note, very little data validation take place in this routine... ■ ISSUE ITEMS Press 'Enter' to select the currently highlighted item. A prompt will appear requesting the name of the person receiving the issue. Note, this prompt must be filled with something... ╔══════════════════════════════[ ISSUE ITEMS ]═══════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ Items Are To Be Issued To: Sam Smith ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══[ Work Order: 91-REG36 ]══════════════════════════[ Invoice: 213 ]═══════╝ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 29 The next screen displays a browse of all items for the Work Order. Note, you may see items from another Work Order, but you can not access them... ╔═══════════════════════[ ITEMS ISSUED TO SAM SMITH ]════════════════════════╗ ║ INVOICE ITEM REQ_QTY WIP_QTY ║ ║──────────╥────────────────────────────────╥───────────────╥────────────────║ ║ 213 ║ A-B-DTK8088 ║ 1.00000 ║ 0.00000 ║ ║ 213 ║ A-B-ECS38625 ║ 1.00000 ║ 0.00000 ║ ║ 213 ║ A-B-ECS386SX ║ 1.00000 ║ 0.00000 ║ ║ 213 ║ A-B-MI48625I ║ 1.00000 ║ 0.00000 ║ ║ 213 ║ A-B-SIC286 ║ 1.00000 ║ 0.00000 ║ ║ 213 ║ A-B-SYN48625 ║ 1.00000 ║ 0.00000 ║ ║ ║ ║ ║ ╚═══[ Work Order: 91-REG36 ]══════════════════════════[ Invoice: 213 ]═══════╝ Esc (Exit) F1 (Help) Enter (Select) 220/224 Press 'Enter' on the item(s) you want issued. The following screen is displayed, requesting the Issue Quantity: ┌───────────────────────────────[ ISSUE ITEM ]───────────────────────────────┐ │ │ │ Item: A-B-DTK8088 Description: MB - 8088/10 - DTK │ Required Quantity: 1.00000 WIP Qty: 0.00000 Onhand: 1000.00000 │ │ │ │ Quantity Remaining To Be Issued: 1.00000 │ │ │ │ Issue Quantity: 1.00000 │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO JOB COSTING, TJS LAB, Inc Page: 30 ■ ISSUE ITEMS POST When done with the issue process for the Work Order, press 'Esc', then respond 'Y' (Yes) to the prompt to post. While the posting of the issued items takes place, the progress is displayed onto the screen, ie: ╔═════════════════════════[ ISSUE ITEMS POST ]══════════════════════════╗ ║ ║ ║ Work Order: 91-REG36 ] ║ ║ Invoice: 213 ║ ║ Total Cost: 870.00 ║ ║Items Issued To: Frank ║ ║ ║ ║Post This Issue? (Y/N) * ║ ║ ║ ║POSTING! DO NOT DISTURB! ║ ╟───────────────────────────────────────────────────────────────────────╢ ║Item │ Description │ Issue Qty │ Ext. Cost║ ║A-B-ECS386SX │ MB - 80386SX/16 - ECS │ 1.00000 │ 295.00║ ║A-B-ECS38625 │ MB - 80386/25 - ECS │ 1.00000 │ 530.00║ ║A-B-DTK8088 │ MB - 8088/10 - DTK │ 1.00000 │ 45.00║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) F1 (Help) ■ ISSUE FORM/INVOICE COPIES After posting, a prompt will appear for the number of copies of the Item Issue Form/Invoice, ie: ╔═════════════════════════[ ISSUE ITEMS POST ]══════════════════════════╗ ║ ║ ║ Work Order: 91-REG36 ] ║ ║ Invoice: 213 ║ ║ Total Cost: 870.00 ║ ║Items Issued To: Frank ║ ║ ║ ║Post This Issue? (Y/N) * ║ ║ ║ ║Issue Form/Invoice Copies: 1 ║ ╟───────────────────────────────────────────────────────────────────────╢ ║Item │ Description │ Issue Qty │ Ext. Cost║ ║A-B-ECS386SX │ MB - 80386SX/16 - ECS │ 1.00000 │ 295.00║ ║A-B-ECS38625 │ MB - 80386/25 - ECS │ 1.00000 │ 530.00║ ║A-B-DTK8088 │ MB - 8088/10 - DTK │ 1.00000 │ 45.00║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 31 ■ EXAMPLE OF ITEM ISSUE FORM/INVOICE Issue Number: 9 * ITEM ISSUE INVOICE * Page 1 Work Order: 91-REG36 Issued: 08/25/91 WO Invoice: 213 YOUR COMPANY, INC Printed: 08/25/91 Customer: 100 Time: 16:14:13 ------------------------------------------------------------------------------- Issued To: Frank By: gdfs ------------------------------------------------------------------------------- Sales Person: TW Operator: tj Type: REG Class: AR Shipper: PICKUP Cust PO: 833-3837A Release: 833-3837A-1 ------------------------------------------------------------------------------- Comment: New Invoice ------------------------------------------------------------------------------- # Item Description Issue Qty Ext. Cost --- ------------ ------------------------------ ---------- ---------- 1 A-B-DTK8088 MB - 8088/10 - DTK 1.00000 45.00 2 A-B-ECS38625 MB - 80386/25 - ECS 1.00000 530.00 3 A-B-ECS386SX MB - 80386SX/16 - ECS 1.00000 295.00 ------------------------------------------------------------------------------- Total: 870.00 DAYO JOB COSTING, TJS LAB, Inc Page: 32 ■ BILL OF MATERIALS BROWSE This option lets you view and/or edit bill of materials (BOMs) created in the DAYO MRP module or from Work Orders that have been closed and 'moved' into the bill of materials database (BOM.DBF). A bill of materials is defined as a collection of component items or materials that are assembled or bundled together to create another item, enditem, project, task or job. DAYO defines an item as anything with an inventory record, ie: parts, goods, products, services, time... ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ Bill of Materials (BOM) Browse & Maintenance ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █End Item: 91-RG36 Item: ACB128-2 Cost: 259.780 Type: RET █ █Description: XT SUB SYS-DTK-CASE-MB-PS-10MZ Class: Last Date: 08/25/91█ █Per Qty: 10.000 Required: 0.000 WIP Qty: 0.000 Pos: █ █Mfg PTD: 0.000 Mfg YTD: 0.000 Assembled: 0.000 █ █Hours: 0.000 Labor: 0.000 Labor1: 0.000 Labor2: 0.000█ █Onhand: 990.000 Onorder: 0.000 Back Order: 0.000 █ █▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ █ ENDITEM DESC COST LEVEL1 █ █──────────────╥────────────────────────────────╥────────────╥───────────────█ █ 91-RG36 ║ XT SUB SYS-DTK-CASE ║ 259.780 ║ ACB128-2 █ █ 91-RG36 ║ SIMM - 1MB x 9/100 NS ║ 279.770 ║ ACB1MBSI █ █ 91-RG36 ║ MB - 80286 SYSTEM ║ 319.730 ║ ACB-286 █ █ 91-RG36 ║ MB - 80586I/25 -MICRONICS ISA ║ 739.380 ║ ACB-MI48625I █ █ 91-RG36 ║ MB - 80586I/25 -PCTRONICS ISA ║ 759.370 ║ ACB-PC48625I █ █ 91-RG36 ║ MB - 80586/12 - C&T ║ 779.350 ║ ACB-SIC286 █ █ 91-RG36 ║ CC - ZDE HARD DRIVE ONLY ║ 799.330 ║ ACB-ST07A █ █ 91-RG36 ║ AD LIB MUSIC SYNTHESIZER CARD ║ 899.250 ║ ACADLIB █ ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ 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 P (Print) F5 (Find) F6 (Change Index) Current Index: ENDITEM DAYO JOB COSTING, TJS LAB, Inc Page: 33 ■ FULL SCREEN EXIT - BOM Press 'F2' to edit all records for the currently highlighted BOM record. Since very little data validation takes place, be careful with your editing. ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ ENDITEM: 91-RG36 LABOR: 0.000 │ │ DESC: XT SUB SYS-DTK-CASE- LABOR1: 0.000 │ │ LEVEL1: A-B128-2 LABOR2: 0.000 │ │ LEVEL2: OVERRIDE: F │ │ LEVEL3: POSITION: │ │ LEVEL4: │ │ LEVEL5: │ │ LEVEL6: │ │ LEVEL7: │ │ LEVEL8: │ │ ITEM: A-B128-2 │ │ FINIS_QTY: 0.000 │ │ WIP_QTY: 0.000 │ │ REQ_QTY: 0.000 │ │ PER_QTY: 10.000 │ │ PTD_QTY: 0.000 │ │ YTD_QTY: 0.000 │ │ DATE: 08/25/91 │ │ LASTDATE: 08/25/91 │ │ LASTTIME: 14:21:33 │ │ HOURS: 0.000 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO JOB COSTING, TJS LAB, Inc Page: 34 ■ CREATE A NEW BILL OF MATERIALS (BOM) 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 JOB COSTING, TJS LAB, Inc Page: 35 ■ 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) The Per Quantity is the basic number/quantity of each item that is required to build one (1) ENDITEM. This number/quantity must be greater than than an ENDITEM or SUB ENDITEM. ╔═════════════════════════════════════════════════════════════════════╗ ║ Enter Per Quantity: 10 . ║ ╚═════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 36 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 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 JOB COSTING, TJS LAB, Inc Page: 37 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 ]═════════════════╗ ║ This 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 Press 'Ctrl U' to mark a record for deletion. ■ RESORT A BOM This option resets and rebuilds the PRIORITY field in the database BOM.DBF. ┌─────────────────────────────────┐ │ Standby, Doing A ReSort! 1.00 │ └─────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 38 ■ 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 ■ PRINT TRAVELER Press 'Alt P' to print out a user defined Traveler report. Note, read more about Travelers in the configuration section of the DAYO MRP manual... An option will appear requesting you to select from 1 of 2 Traveler types: ╔══════════════════════════════════════════════════════════════════════════╗ ║ Select Traveler -> Traveler Type 1 ║ ║ Traveler Type 2 ║ ║ Exit ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ■ 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 eleven to select fr ╔════════════════════════════════════╗ ║ Select Index -> ENDITEM ║ ║ DESCRIPTION ║ ║ LEVEL1 ║ ║ LEVEL2 ║ ║ LEVEL3 ║ ║ LEVEL4 ║ ║ LEVEL5 ║ ║ LEVEL6 ║ ║ LEVEL7 ║ ║ LEVEL8 ║ ║ ENDITEM UNIQUE * ║ ╚════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 39 ■ VIEW INVENTORY To speed up simple inventory searches, this routine was added to Job Costing. All data in the inventory is available for viewing only, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║Item: 12345 Desc: VERY SPECIAL HOSE Type: INT Class: ║ ║VendItem: HOSE-SPC Vendor: TJSLAB ║ ║Onhand: 1000.000 Allocated: 0.000 BO: 0.000 OnOrder: 0.000║ ║ Price: 0.000 Retail: 0.000 PTD: 0.00 YTD: 0.00║ ║Price1: 2939.280 Cost: 1959.520 Date: 04/30/91 Accessed: / / ║ ║Price2: 2743.330 AVG Cost: 0.000 Stock: 04/30/91 Location: ║ ║Price3: 2547.380 Real Cost: 9999.990 BOM: No ║ ║Price4: 2351.420 Taxable: Yes Serialized: No ║ ║Price5: 2155.470 Wt: 0.000 Unit: EA UnitQty: 1 PackQty: 3/5 ║ ╟════════════════════════[ VIEW INVENTORY DATABASE ]═════════════════════════╢ ║ITEM DESC ONHAND ONORDER ║ ║────────────╥────────────────────────────────╥───────────────╥──────────────║ ║VOICEMAIL-XT║ VOICE MAIL ANS.MACH - COMP. XT ║ 1000.00000 ║ 0.00000║ ║WHSE-GOLD ║ WAREHOUSE SYSTEM - GOLD ║ 1000.00000 ║ 0.00000║ ║WHSE-DAYODEM║ WAREHOUSE SYSTEM - DAYO DEMO ║ 1000.00000 ║ 34.00000║ ║WHSE-DAYOPOS║ WAREHOUSE SYSTEM - DAYO POS ║ 1000.00000 ║ 0.00000║ ║WHSE-DAYOWHS║ WAREHOUSE SYSTEM - DAYO WHSE ║ 1000.00000 ║ 0.00000║ ║WHSE-YELLOW ║ WAREHOUSE SYSTEM - YELLOW ║ 995.00000 ║ 0.00000║ ║12345 ║ VERY SPECIAL HOSE ║ 1000.00000 ║ 0.00000║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Full Screen View) Alt F (Fast Find) Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type) 1316/1417 DAYO JOB COSTING, TJS LAB, Inc Page: 40 ■ FULL SCREEN VIEW - INVENTORY Press the 'F2' key to view (only) all fields in the inventory database (INV.DBF), ie: ╔═════════════════════════════[ FULL SCREEN VIEW ]═══════════════════════════╗ ║ITEM: 12345 LOCATION: XXX ║ ║DESC: VERY SPECIAL HOSE ALLOCATED: 0.00000 ║ ║ONHAND: 1000.00000 PRICE1: 2939.28 ║ ║ONORDER: 0.00000 PRICE2: 2743.33 ║ ║BO: 0.00000 PRICE3: 2547.38 ║ ║SOLDPTD: 0.00000 PRICE4: 2351.42 ║ ║SOLDYTD: 0.00000 PRICE5: 2155.47 ║ ║VENDITEM: HOSE-SPC TI: F ║ ║VENDOR: TJSLAB DESC2: ║ ║DATE: 04/30/91 NS: F ║ ║LASTDATE: / / UNITQTY: 1.00000 ║ ║RETAIL: 0.00 PACKQTY: 3/5 ║ ║PRICE: 0.00 BOM: F ║ ║STOCKLEVEL: 0.00000 MAX: 0.00000 ║ ║MIN: 0.00000 ABC: A ║ ║TYPE: INT VOLUME: 0.00 ║ ║CLASS: ║ ║TAXABLE: T ║ ║SERIALNO: F ║ ║WEIGHT: 0.00 ║ ║UNIT: EA ║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... DAYO JOB COSTING, TJS LAB, Inc Page: 41 ■ FASTFIND - INVENTORY This special record search routine allows you to find an inventory item or record based on 'strings'. A string is any part of the item description or item number. Note, you can even enter more than one string to ensure a more specific search. The more strings you use, the faster the search... *** Separate strings with a space, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ INVENTORY FAST FIND ║ ║ Part Description #1 Description #2 ║ ║ CA-905B BOOT, SZ 16 #24 BROWN ║ ║ CA-905S BOOT, SZ 16 #34 BROWN ║ ║ CA-905U BOOT, SZ 16 #44 BROWN ║ ║ CA-920C BOOT, SZ 16 #234 BROWN ║ ║ CA-34U BOOT, SZ 16 #234 BROWN ║ ║ CA-C44-W BOOT, SZ 16 #334 BROWN ║ ║ F-8501-3 BOOT, SZ 16 #434 BROWN ║ ║ F-8503-6 BOOT, SZ 16 #534 BROWN ║ ║ S-9303 BOOT, SZ 16 #634 BROWN ║ ║ 3-300SDB3-A BOOT, SZ 16 #734 BROWN ║ ║ F-8501-1 BOOTS, PUMPS, MENS, SZ 16 PURPLE ║ ║ CA-43MI2 BOOTS, QUEEN SIZE, SZ 16 GREEN ║ ║ CA-I2041 BOOTS, ZEBRA, SZ 16 YELLOW ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Enter String(s): BOOT SZ 16 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Select) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 42 ■ FIND ITEM - INVENTORY Use the 'F5' through 'F9' keys to find a desired item, ie: Press 'F5' to find an item based on it's number: ┌─────────────────────────────────────────────────────────────┐ │ Enter ITEM: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to find an item based on it's description: ┌─────────────────────────────────────────────────────────────┐ │ Enter DESC: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to find an item based on it's Vendor number: ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDOR+DESC: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to find an item based on it's Vendor/Mfg item number: ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDITEM: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to find an item based on it's TYPE code: ┌─────────────────────────────────────────────────────────────┐ │ Enter TYPE: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO JOB COSTING, TJS LAB, Inc Page: 43 ■ VIEW CUSTOMERS This option will allow you to view all of the customer's data. This includes the customer's record, and all detail sales/purchases (profile). Note, NO editing of the customer record is allowed in this routine... ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ GEORGE MOONILAL ║ ║ 13 WEST COLONIAL ║ ║ ║ ║ ORLANDO, FL 32802 , ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 100 REG LT CASH PICKUP ║ ║ PHONE ATTN LASTDATE ║ ║ (407) 292-4708 RICH LAROSSA 12354.32 08/19/91 ║ ╚═══════════════[ VIEW CUSTOMER DATA & PROFILE/SALES HISTORY ]═══════════════╝ CUSTOMER NAME ATTN ───────────╥────────────────────────────────╥───────────────────────────────── 100 ║ GEORGE MOONILAL ║ RICH LAROSSA 117 ║ ENERGYVISION ║ 164 ║ GENE SZARA ║ sdff 188 ║ DAVE NICKERSON ENT. ║ 292 ║ JOHNSON'S MOBILE HOME REPAIR ║ 294 ║ ABLE GLASS ║ 333 ║ BLALOCK ALUMINUM PRODUCTS ║ 342 ║ MIKE BERRY ║ Esc (Exit) F1 (Help) F2 (Full Screen View) F3 (Profile) Find: F5(Customer) F6(Name) F7(ShipTo) F8(Phone) F9(Zip) Alt F(Fastfind) 128/137 DAYO JOB COSTING, TJS LAB, Inc Page: 44 ■ FULL SCREEN VIEW - CUSTOMERS Press 'F2' to view all data on the customer's record, ie: ╔═════════════════════════════[ FULL SCREEN VIEW ]═══════════════════════════╗ ║CUSTOMER: 100 LASTDATE: 08/19/91 ║ ║NAME: GEORGE MOONILAL TYPE: REG ║ ║ATTN: RICH LAROSSA CLASS: AR ║ ║ADDR1: 13 WEST COLONIAL PBM: 20.000 ║ ║ADDR2: PBL: 0.000 ║ ║CITY: ORLANDO SALESPTD: 1289.28 ║ ║STATE: FL SALESYTD: 12354.32 ║ ║ZIP: 32802 DUE: 1453.00 ║ ║SHIPNAME: PAID_PURC: 1235.00 ║ ║SHIPADDR1: LIMIT: 999999.00 ║ ║SHIPADDR2: ACTIVE: T ║ ║SHIPCITY: TAXCODE: AXB ║ ║SHIPSTATE: FAX: (407) 295-2171 ║ ║SHIPZIP: SHIPPHONE: (407) 291-3960 ║ ║PHONE: (407) 292-4708 FOB: ORLANDO ║ ║SALESPER: LT PRICEX: 0 ║ ║RATE: 3.000 CREDCARD: ║ ║TAXRATE: 0.0600 TAXRATE2: 0.00000 ║ ║TERMS: CASH CUSCODE: ║ ║SHIPPER: PICKUP ║ ║DATE: 05/22/91 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... DAYO JOB COSTING, TJS LAB, Inc Page: 45 ■ CUSTOMER PROFILE The customer's profile is a display of everything they ever purchased (and was posted into DAYO AR). Press 'F3' to display the profile, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║Customer Name: SHERRY JOHNSON Invoice: 3504 Date: 04/30/91║ ║Customer PO: Taxable: Yes SalesPer: GEO ║ ║ INVOICE ITEM DESC QTY ║ ║──────────╥──────────────╥────────────────────────────────╥─────────────────║ ║ 321 ║ 1051232P1 ║ 1051232P1 LAMP ║ 131.00000 ║ ║ 322 ║ 1051232P1 ║ 1051232P1 LAMP ║ 159.00000 ║ ║ 330 ║ 1051232P1 ║ 1051232P1 LAMP ║ 177.00000 ║ ║ 3452 ║ 1051232P1 ║ 1051232P1 LAMP ║ 189.00000 ║ ║ 3504 ║ 1051232P1 ║ 1051232P1 LAMP ║ 289.00000 ║ ║ 331 ║ 10X1HXB ║ BRZ 10 X 1 HEX HEAD SCREWS ║ 180.00000 ║ ║ 331 ║ 10X1SZ ║ ZINC 10 X 1 SCRULOX SCREWS ║ 181.00000 ║ ║ 331 ║ 10X1TKB516 ║ BRZ 10 X 1 5/16 TEK SCREWS ║ 182.00000 ║ ║ 320 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 108.00000 ║ ║ 321 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 132.00000 ║ ║ 322 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 136.00000 ║ ║ 322 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 160.00000 ║ ║ 330 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 178.00000 ║ ║ 3452 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 190.00000 ║ ║ 3504 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 290.00000 ║ ║ 321 ║ 1246G1 ║ A2251246G1 REGISTER ASSEMBLY ║ 133.00000 ║ ║Move around with PgUp/PgDn and/or Arrow Keys Press Esc to Exit... ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 46 ■ FIND CUSTOMER There are 5 indexes for the customer database, and are accessed via the 'F5/F6/F7/F8/F9' keys. Press 'F5' to find a customer based on the customer's number. ┌─────────────────────────────────────────────────────────────┐ │ Enter CUSTOMER: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to find a customer based on the customer's name. ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to find a customer based on the customer's ship to name. ┌─────────────────────────────────────────────────────────────┐ │ Enter SHIPNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to find a customer based on the customer's last four digits of their telephone number. ┌─────────────────────────────────────────────────────────────┐ │ Enter right 4 digits Phone: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to find a customer based on the customer's zip code. ┌─────────────────────────────────────────────────────────────┐ │ Enter ZIP: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO JOB COSTING, TJS LAB, Inc Page: 47 ■ FASTFIND - CUSTOMER This special record search routine allows you to find a customer record based on 'strings'. A string is any part of the customer's name, telephone number or zip code. Note, you can even enter more than one string to insure a more specific search. The more strings you use, the faster the search... *** Separate strings with a space, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ [ CUSTOMER FAST FIND ] ║ ║ Cust# Name Phone Zip Code ║ ║ 1028 CUSTOM SCREENS & HOME IMP.,INC (407)277-1028 32810 ║ ║ 6466 CUSTOM WINDOWS & EXT. DESIGN (407)260-6466 32804 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Enter String(s): CUSTOM 407 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Select) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 48 ■ MAINTAIN/BROWSE WORK ORDER/JOB TYPES This routine was added to allow you to enter Work Order/Job TYPE codes. ╔════════[ MAINTAIN/BROWSE WORK ORDER/JOB TYPES ]═══════════╗ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██▄ ▄▄ ▄██░ ▄██████▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██▄ ▄██▄ ▄██░ ██░ ██░ ║ ║ ███▀██▀███░ ██░ ██░ ║ ║ ██░██░██░ ▀██████▀ ║ ║ ║ ║ ║ ║ ██████████░ ██░ ██░ ██▄████░ ██████░ ██████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██▄▄██░ ███████░ █████░ ██████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██████░ ██████░ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════════╝ ╔════════[ MAINTAINT/BROWSE WORK ORDER/JOB TYPES ]══════════╗ ║ TYPE NAME DIRECT ║ ║ ──────╥────────────────────────────────╥───────── ║ ║ 0 ║ Research & Development ║ F ║ ║ 1 ║ Manufacturing I ║ T ║ ║ 2 ║ Manufacturing II ║ T ║ ║ 3 ║ Manufacturing III ║ F ║ ║ 4 ║ Manufacturing IV ║ T ║ ║ 5 ║ Special Projects ║ T ║ ║ 6 ║ NASA ║ T ║ ║ 7 ║ Sales Projects ║ F ║ ║ 8 ║ Shop Maintenance ║ F ║ ║ 9 ║ Administrative Projects ║ F ║ ║ A10 ║ Misc ║ F ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════════╝ Esc (Esc) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) 1/11 DAYO JOB COSTING, TJS LAB, Inc Page: 49 ■ LABOR This menu option provides you with routines to record labor relating to a Work Order/Job. DAYO Job Costing can be integrated with DAYO Payroll to access the employee payroll database or create your own modified employee database. All options for this menu are accessed from the browse screen of all employees, ie: ╔════════════════════[ SELECT EMPLOYEE FOR LABOR ENTRY ]═════════════════════╗ ║ Number: 000003 Name: DEBORAH D. DOWDY <Not Active> ║ ║ Marital Status: M Sex: F SSN: 166-45-5642 DOB: 11/21/24 DOH: / / ║ ║ Status: DDF Department: SAL Type: FUL Class: DC Paid: Weekly ║ ║ Address: 2332 MARTIN BRANCH RD SUMTER, SC 29150 ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NUMBER NAME SSN ║ ║───────────────────╥────────────────────────────────╥───────────────────────║ ║ 100003 ║ DEBORAH D. DOWDY ║ 166-45-5642 ║ ║ 100004 ║ RALPH MORGAN ║ 234-53-4747 ║ ║ 100005 ║ JENNY F. MORGAN ║ 233-61-3811 ║ ║ 100006 ║ MACY M. MORGAN ║ 243-74-2938 ║ ║ 100007 ║ JEROMY CARTER ║ 541-86-1105 ║ ║ 100008 ║ DAVID J. HALL ║ 551-97-0230 ║ ║ 100009 ║ MARION MORGAN ║ 242-02-1036 ║ ║ 100010 ║ MICHAEL C. CARTER ║ 234-15-2249 ║ ║ 100011 ║ TOMMY CUSTOINOI ║ 243-27-3550 ║ ║ 100012 ║ GREGORY A. PECK ║ 323-36-4757 ║ ║ 100013 ║ CHARLES D. DICKERSON ║ 340-44-5165 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Enter (Daily Input) F3 (Weekly Input) Alt B (Browse Hour Log) Ctrl N (Add) Ctrl U (Del) Find F5 (Employee Number) F6 (Name) F7 (SSN) F8 (Phone) F9 (Dept) 3/37 DAYO JOB COSTING, TJS LAB, Inc Page: 50 ■ FULL SCREEN EDIT To edit the employee's record, press 'F2', ie: ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ NUMBER: 100003 OTHER: 0.00 │ │ NAME: HERMAN MUNSTER WITHHOLD: T │ │ SSN: 236-35-5555 EXEMPTIONS: 0 │ │ ADDR1: 3920 WEIRD WILLY ROAD CLASS: DC │ │ ADDR2: THE_GROSS: 0.00 │ │ CITY: AIKEN NEXT_KIN: │ │ STATE: SC DATE: / / │ │ ZIP: 29843 PARTTIME: F │ │ PHONE: 8035555555 ACTIVE: F │ │ TYPE: FUL DEFTOTHR: 4.039 │ │ STATUS: HRL DEFOTHR: 3.000 │ │ DEPARTMENT: SLS DEFREGHR: 4.000 │ │ SEX: F DEBIT: │ │ MARITAL: M CREDIT: │ │ DOB: 01/21/09 │ │ DOH: / / │ │ RATE: 13.1250 │ │ PAYPERIOD: W │ │ REG_HOURS: 40.000 │ │ OT_HOURS: 0.000 │ │ P_HOURS: 0.000 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO JOB COSTING, TJS LAB, Inc Page: 51 ■ DAILY LABOR ENTRY Press 'Enter' to input labor for the currently highlighted employee. The following prompts will be for the Supervisor, Work Order Number, Work Class, ie: ┌───────────────[ DAILY LABOR ENTRY FOR: DEBORAH D. DOWDY ]─────────────────┐ │ Use this routine to input labor hours, with the option to designate │ │ the Work Order Type and Work Order Class Code. │ │ │ │ ┌─ Supervisor: TOM │ │ │ Work Order: 105 ( Enter '0' to DEBIT & CREDIT ) │ │ └─ Work Class: DC │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 52 The next prompts will be for the date of the payroll period 'week ending', today's date, starting time, ending time, Regular Hours, Over-time Hours, Double Time Hours, Zero Cost Hours, Total Hours Worked, and Rate. * Note, only the 'Week Ending', 'Total Hours Worked' and the 'Rate' are used in the calculations of the labor totals for the Work Order. The others are 'just for the record'... ┌────────────────[ DAILY LABOR ENTRY FOR: DEBORAH D. DOWDY ]─────────────────┐ │ Use this routine to input labor hours, with the option to designate │ │ the Work Order Type and Work Order Class Code. │ │ │ │ Enter Week Ending: 08/12/91 Monday │ │ Date: 08/12/91 Monday │ │ From: 08:00:00 │ │ To: 16:00:00 │ │ │ │ Hours Worked For This Date (08/12/91): 80.234 Week: 140.234 │ │ Regular Hours: 4.000 │ │ Over-time Hours: 3.000 │ │ Double Time Hours: 0.000 │ │ Zero Cost Hours: 0.000 │ │ Total Hours Worked: 4.039 │ │ Rate: 3.99000 │ │ │ │ ┌─ 91-REG105 GEORGE MOONILAL │ │ │ Work Order: 105 ( Enter '0' to DEBIT & CREDIT ) │ │ └─ Work Class: DC Documentation Type: E Dir │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 53 ■ WEEKLY LABOR ENTRY Press 'F3' to input labor on a weekly basis. Note this option is almost identical to the 'DAILY LABOR ENTRY' routine discuss above... ┌────────────────[ WEEKLY LABOR ENTRY FOR: DEBORAH D. DOWDY ]────────────────┐ │ Use this routine to input labor hours for the entire week, with the │ │ option to designate the Work Order Type and Work Order Class Code. │ │ │ │ Enter Week Ending: 08/12/91 Monday │ │ │ │ │ │ │ │ Hours Worked For This Week (08/12/91): 144.273 │ │ Regular Hours: 4.000 │ │ Over-time Hours: 3.000 │ │ Double Time Hours: 0.000 │ │ Zero Cost Hours: 0.000 │ │ Total Hours Worked: 7.000 │ │ Rate: 3.99000 │ │ │ │ ┌─ 91-REG105 GEORGE MOONILAL │ │ │ Work Order: 105 ( Enter '0' to DEBIT & CREDIT ) │ │ └─ Work Class: DC Documentation Type: E Dir │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) ■ BROWSE HOURLOG DETAIL RECORDS Press 'Alt B' to view/edit the detail records for the labor entry. The database containing the data is named 'HOURLOG.DBF'. ╔═════════════════════════════[ BROWSE DETAIL ]══════════════════════════════╗ ║ NUMBER WO ENDWEEK DATE STARTTIME ENDTIME TOT_HOURS ║ ║─────────╥────────╥──────────╥──────────╥───────────╥──────────╥────────────║ ║ 100003 ║ 105 ║ 07/25/91 ║ 07/19/91 ║ 08:00:00 ║ 16:00:00 ║ 1.000 ║ ║ 100003 ║ 105 ║ 07/25/91 ║ 07/19/91 ║ 08:00:00 ║ 16:00:00 ║ 1.000 ║ ║ 100003 ║ 105 ║ 07/25/91 ║ 07/19/91 ║ 08:00:00 ║ 16:00:00 ║ 10.000 ║ ║ 100003 ║ 105 ║ 07/25/91 ║ 07/19/91 ║ 08:00:00 ║ 16:00:00 ║ 10.000 ║ ║ 100003 ║ 105 ║ 07/11/91 ║ 07/20/91 ║ 08:00:00 ║ 16:00:00 ║ 3.000 ║ ║ 100003 ║ 105 ║ 07/11/91 ║ 07/20/91 ║ 08:00:00 ║ 16:00:00 ║ 3.000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl U (Delete) Ctrl N (Add) Find: F5 (Number) F6 (WO) F7 (EndWeek) F8 (Class) F9 (Type) DAYO JOB COSTING, TJS LAB, Inc Page: 54 ■ FULL SCREEN EDIT - LABOR Press 'F2' to edit a record in the database 'HOURLOG.DBF', ie: ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ NUMBER: 100003 │ │ WO: 105 │ │ ENDWEEK: 07/25/91 │ │ DATE: 07/19/91 │ │ STARTTIME: 08:00:00 │ │ ENDTIME: 16:00:00 │ │ TOT_HOURS: 10.000 │ │ REG_HOURS: 3.000 │ │ OT_HOURS: 3.000 │ │ DT_HOURS: 0.000 │ │ ZERO_HOURS: 0.000 │ │ RATE: 13.1250 │ │ DIRECT: T │ │ CLASS: GA │ │ TYPE: M │ │ SUPERVISOR: 234 │ │ DEBIT: │ │ CREDIT: │ │ CDATE: 07/20/91 │ │ BY: DFG │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO JOB COSTING, TJS LAB, Inc Page: 55 ■ FIND HOURLOG RECORD There are five (5) indexes available to aid you in finding a specific record in the database 'HOURLOG.DBF'. Press 'F5' to find a record based on the employee's number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NUMBER+DTOC(DATE): │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to find a record based on the Work Order Number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter STR(WO,6,0)+CLASS: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to find a record based on the date it was created, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DTOC(DATE): │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to find a record based on the CLASS, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS+DTOC(DATE): │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to find a record based on the TYPE, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter TYPE+DTOC(DATE): │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO JOB COSTING, TJS LAB, Inc Page: 56 ■ ADD NEW EMPLOYEE RECORD Press 'Ctrl N' to add a new employee record, ie: ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ NUMBER: 100344 OTHER: 0.00 │ │ NAME: NEW EMPLOYEE WITHHOLD: T │ │ SSN: EXEMPTIONS: 0 │ │ ADDR1: CLASS: │ │ ADDR2: THE_GROSS: 0.00 │ │ CITY: NEXT_KIN: │ │ STATE: DATE: / / │ │ ZIP: PARTTIME: F │ │ PHONE: ACTIVE: F │ │ TYPE: DEFTOTHR: 0.000 │ │ STATUS: DEFOTHR: 0.000 │ │ DEPARTMENT: DEFREGHR: 0.000 │ │ SEX: DEBIT: │ │ MARITAL: CREDIT: │ │ DOB: / / │ │ DOH: / / │ │ RATE: 0.0000 │ │ PAYPERIOD: W │ │ REG_HOURS: 0.000 │ │ OT_HOURS: 0.000 │ │ P_HOURS: 0.000 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO JOB COSTING, TJS LAB, Inc Page: 57 ■ FIND EMPLOYEE There are five (5) indexes available for searching for employee records. Press 'F5' to find an employee based on the employee's number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NUMBER: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to find an employee based on the employee's name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to find an employee based on the employee's right four (4) digits of the social security number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter RIGHT(SSN,4): │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to find an employee based on the employee's right four (4) digits of the telephone number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter right 4 digits Phone: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to find an employee based on the employee's department, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEPARTMENT+NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO JOB COSTING, TJS LAB, Inc Page: 58 ■ REPORTS This routines provides you with a collection of reports, all with multiple options, that will report data on your work orders and labor. Common options include multiple indexes, date ranges, and the option to print to the printer or to a file. Reports 'written' to a file can later be viewed in this routine on screen, or exported/sent to other computers via modem or disk... DAYO Job Costing Version 2.03 TJS LAB, INC. ┌──[September 1991]──┐ ╔═══════════════════════════════════════╗ │S M T W T F S │ ║ DAYO JOB COSTING REPORTS ║ ├────────────────────┤ ║ Printer Setup ║░ █░ ▄███▄ │ 1 2 3 4 5 6 7│ ║ Work Order Abbreviated ║░ █░ █░ █░ │ 8 9 10 11 12 13 14│ ║ Work Order Expanded ║█░██░ █░ █░ │15 16 17 18 19 20 21│ ║ Work Order Shortage ║▀█▀ █░ █░ │22 23 24 25 26 27 28│ ║ Work Order Price & Cost Compare ║ █░ █░ █░ │29 30 │ ║ Labor Report Summary Date Range ║ █░ ▀███▀ │ │ ║ Labor Report - Specifc Employee ║ └────────────────────┘ ║ Labor Report - Specifc Work Order ║███▄ ██▄████░ Reindex (Alt F9) ║ Labor Report - Specifc Class ║░ ██░ ██░ ██░ ║ Labor Report - Specifc Type ║░ ██░ ██░ ██░ ║ Config Status ║░ ██░ ███████░ ║ View Reports On Screen ║░ ██░ ██░ ██░ ║ ║░ ██░ ██░ ██░ ║ ║███▀ ██▀████░ ║ ║ ║ ║▄██▄ ████░ █████░ ███░ █░ █░ ████░ ║ ║█░ █░ █░ █░ █░ ██░█░ █░ ║ ║█░ █░ ████░ █░ █░ ████░ █░▐█░ ║ ║█░ █░ █░ █░ █░ █░██░ █░ █░ ║ SELECT REPORT OR ROUTINE ║▀██▀ ████░ █░ ███░ █░ █░ ████░ ╚═══════════════════════════════════════╝ Esc (Exit) Enter/Return (Select Report Option) DAYO JOB COSTING, TJS LAB, Inc Page: 59 ■ WORK ORDER ABBREVIATED REPORT This report was created to allow you to print basic information about your Work Orders to the printer or to a file. The first prompt is for 1 of 10 indexes, ie: ╔═════════════════════════[ WORK ORDER ABBREVIATED ]═════════════════════════╗ ║ ║ ║ This report lists key information about the work order. ║ ║ Use Report Form: JOBABBR.FRM (80 characters wide). ║ ║ ║ ║ Select the Index -> Work Order ║ ║ Customer Number ║ ║ Customer Name ║ ║ Ship To Name ║ ║ Customer Purchase Order ║ ║ Release Number ║ ║ Quote Number ║ ║ Sales Person Number ║ ║ Work Order TYPE ║ ║ Work Order CLASS ║ ║ ║ ║ ██ ██ ▄████▄ ██▄███ ██ ██ ▄████▄ ██▄███ ██▄███ █████ ██▄███ █████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ████ ██ ██ ██████ ██ ██ ████ ██████ █████ ║ ║ ████████ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ▀████▀ ██ ██ ██ ██ ▀████▀ ██ ██ ██▀███ █████ ██ ██ █████ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 60 The remaining prompts are to include 'Closed' Work Orders (Work Orders no longer active), a starting & ending date, a report heading (defaults to your company name), and to direct the output to a printer or to a file (you select the name/path), ie: ╔═════════════════════════[ WORK ORDER ABBREVIATED ]═════════════════════════╗ ║ ║ ║ This report lists key information about the work order. ║ ║ Use Report Form: JOBABBR.FRM (80 characters wide). ║ ║ ║ ║ Select the Index -> Work Order ║ ║ ║ ║ Include Closed Work Orders? (Y/N) ║ ║ ║ ║ Enter Start Date: 08/25/90 Ending Date: 08/25/91 ║ ║ ║ ║ Enter Report Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: JOBABBR.TXT ║ ║ ║ ║ ██ ██ ▄████▄ ██▄███ ██ ██ ▄████▄ ██▄███ ██▄███ █████ ██▄███ █████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ████ ██ ██ ██████ ██ ██ ████ ██████ █████ ║ ║ ████████ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ▀████▀ ██ ██ ██ ██ ▀████▀ ██ ██ ██▀███ █████ ██ ██ █████ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 61 ■ EXAMPLE OF WORK ORDER ABBREVIATED REPORT Page No. 1 YOUR COMPANY, INC 08/25/91 ABBREVIATED WORK ORDER REPORT WO CUST# TYP CLS TOTAL REQ TOTAL WIP DIR LABOR IND LABOR OVERHEAD ------ ------ --- --- ---------- ---------- ---------- ---------- ---------- 23 292 REG 123 1141282.60 609853.15 0.00 0.00 0.00 * 24 164 REG 124 0.00 0.00 0.00 0.00 0.00 * 25 164 REG 124 1439187.31 580516.24 0.00 0.00 100.00 35 188 REG 0.00 0.00 0.00 0.00 0.00 * 36 100 REG AR 920249.12 1147316.07 0.00 0.00 400.00 37 0 REG 124 340172.89 107197.76 0.00 0.00 0.00 101 588 REG 0.0 22517.00 17366.50 0.00 0.00 0.00 102 1105 REG AR 234.00 234.00 0.00 0.00 0.00 103 1755 REG AR 46366.67 32603.96 0.00 0.00 0.00 104 1060 REG 0.0 10534.85 6990.00 0.00 0.00 0.00 105 100 REG AR 117330.22 233525.16 16794.95 536.31 2500.92 106 100 REG AR 0.00 0.00 0.00 0.00 0.00 107 100 REG ewr 0.00 0.00 0.00 0.00 0.00 108 100 4 234 0.00 0.00 0.00 0.00 0.00 109 100 4 AR 0.00 0.00 0.00 0.00 0.00 110 100 3 AR 0.00 0.00 0.00 0.00 0.00 111 96 2 124 0.00 0.00 0.00 0.00 0.00 112 96 6 124 0.00 0.00 0.00 0.00 0.00 113 100 2 AR 0.00 0.00 0.00 0.00 0.00 114 10314 REG AR 0.00 0.00 0.00 0.00 0.00 115 100 7 AR 0.00 0.00 0.00 0.00 0.00 116 117 1 124 0.00 0.00 0.00 0.00 0.00 117 164 1 124 0.00 0.00 0.00 0.00 0.00 118 96 1 124 0.00 0.00 0.00 0.00 0.00 119 9295 1 0.0 0.00 0.00 0.00 0.00 0.00 120 100 1 AR 0.00 0.00 0.00 0.00 0.00 121 100 1 AR 0.00 0.00 0.00 0.00 0.00 122 100 1 AR 0.00 0.00 0.00 0.00 0.00 2344 96 1 124 0.00 0.00 0.00 0.00 0.00 *** Total *** 4037874.66 2735602.84 16794.95 536.31 3000.92 * Note, the asterisk '*' designates the Work Order as being Closed! DAYO JOB COSTING, TJS LAB, Inc Page: 62 ■ WORK ORDER EXPANDED REPORT This report lists as much vital information about the work order as can be printed on a report with the width of 158 characters. The first prompt is for 1 of 10 indexes, ie: ╔══════════════════════════[ WORK ORDER EXPANDED ]═══════════════════════════╗ ║ ║ ║ This report lists key information about the work order. ║ ║ Use Report Form: JOBEXP.FRM (158 characters wide). ║ ║ ║ ║ Select the Index -> Work Order ║ ║ Customer Number ║ ║ Customer Name ║ ║ Ship To Name ║ ║ Customer Purchase Order ║ ║ Release Number ║ ║ Quote Number ║ ║ Sales Person Number ║ ║ Work Order TYPE ║ ║ Work Order CLASS ║ ║ ║ ║ ██ ██ ▄████▄ ██▄███ ██ ██ ▄████▄ ██▄███ ██▄███ █████ ██▄███ █████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ████ ██ ██ ██████ ██ ██ ████ ██████ █████ ║ ║ ████████ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ▀████▀ ██ ██ ██ ██ ▀████▀ ██ ██ ██▀███ █████ ██ ██ █████ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 63 The remaining prompts are to include 'Closed' Work Orders (Work Orders no longer active), a starting & ending date, a report heading (defaults to your company name), and to direct the output to a printer or to a file (you select the name/path), ie: ╔══════════════════════════[ WORK ORDER EXPANDED ]═══════════════════════════╗ ║ ║ ║ This report lists key information about the work order. ║ ║ Use Report Form: JOBEXP.FRM (158 characters wide). ║ ║ ║ ║ Select the Index -> Quote Number ║ ║ ║ ║ Include Closed Work Orders? (Y/N) ║ ║ ║ ║ Enter Start Date: 08/25/90 Ending Date: 08/25/91 ║ ║ ║ ║ Enter Report Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: JOBEXP.TXT ║ ║ ║ ║ ██ ██ ▄████▄ ██▄███ ██ ██ ▄████▄ ██▄███ ██▄███ █████ ██▄███ █████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ████ ██ ██ ██████ ██ ██ ████ ██████ █████ ║ ║ ████████ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ▀████▀ ██ ██ ██ ██ ▀████▀ ██ ██ ██▀███ █████ ██ ██ █████ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 63.1 ■ WORK ORDER SHORTAGE REPORT This report lists shortages for your Work Orders. The report is has a width of 158 characters. Options include printing for all Work Orders, specific Work Order, Specific Work Order Invoice, index and output to printer or file. ╔═══════════════════════[ WORK ORDER SHORTAGE REPORT ]═══════════════════════╗ ║ ║ ║ This report lists shortages for all or a specific Work Order. ║ ║ Use Report Form: SHORTAGE.FRM (158 characters wide). ║ ║ ║ ║ Print Report for ALL Work Orders (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ Select the Index -> Description (* Subtotals) ║ ║ ║ ║ Enter Report Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: SHORTAGE.TXT ║ ║ ║ ║ ██ ██ ▄████▄ ██▄███ ██ ██ ▄████▄ ██▄███ ██▄███ █████ ██▄███ █████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ████ ██ ██ ██████ ██ ██ ████ ██████ █████ ║ ║ ████████ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ▀████▀ ██ ██ ██ ██ ▀████▀ ██ ██ ██▀███ █████ ██ ██ █████ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 63.2 ■ WORK ORDER PRICE & COST COMPARISON REPORT This report lists the required quantity (REQ_QTY), work in process (WIP) quantity (WIP_QTY), extended required price, extended required cost, extended WIP price and extended WIP cost. The report is 150 characters wide. Options include printing for all Work Orders, specific Work Order, Specific Work Order Invoice, index and output to printer or file. ╔═══════════════[ WORK ORDER PRICE & COST COMPARISON REPORT ]════════════════╗ ║ ║ ║ This report lists both the price and cost for Work Order components. ║ ║ Use Report Form: COMPARE.FRM (158 characters wide). ║ ║ ║ ║ Print Report for ALL Work Orders (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ Select the Index -> Item Number * (* Subtotals) ║ ║ ║ ║ Enter Report Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: COMPARE.TXT ║ ║ ║ ║ ██ ██ ▄████▄ ██▄███ ██ ██ ▄████▄ ██▄███ ██▄███ █████ ██▄███ █████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ████ ██ ██ ██████ ██ ██ ████ ██████ █████ ║ ║ ████████ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██ ██ ▀████▀ ██ ██ ██ ██ ▀████▀ ██ ██ ██▀███ █████ ██ ██ █████ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 64 ■ LABOR REPORT - GENERAL This is a general purpose report of data found in the database 'HOURLOG.DBF'. There are 5 indexes to choose from, ie: ╔══════════════════════════════[ LABOR REPORT ]══════════════════════════════╗ ║ ║ ║ This report lists Labor information about the work order, and/or ║ ║ employee. Use Report Forms: LABORx.FRM (154 characters wide). ║ ║ ║ ║ Select the Index -> Employee Number ║ ║ Work Order + Class ║ ║ Date ║ ║ Class ║ ║ Type ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██░ ███░ ██▄████░ ▄████▄ ██▄███░ ║ ║ ██░ ██▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░██░ ███████░ ██░ ██░ ██████░ ║ ║ ██░ ███▄███░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ █████░ ██░ ██░ ██▀████░ ▀████▀ ██░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 65 The remaining prompts are for a starting & ending date, a report heading (defaults to your company name), and to direct the output to a printer or to a file (you select the name/path), ie: ╔══════════════════════════════[ LABOR REPORT ]══════════════════════════════╗ ║ ║ ║ This report lists Labor information about the work order, and/or ║ ║ employee. Use Report Forms: LABORx.FRM (154 characters wide). ║ ║ ║ ║ Select the Index -> Employee Number ║ ║ ║ ║ Enter Start Date: 08/25/90 Ending Date: 08/25/91 ║ ║ ║ ║ Enter Report Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: LABOR.TXT ║ ║ ║ ║ ║ ║ ██░ ███░ ██▄████░ ▄████▄ ██▄███░ ║ ║ ██░ ██▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░██░ ███████░ ██░ ██░ ██████░ ║ ║ ██░ ███▄███░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ █████░ ██░ ██░ ██▀████░ ▀████▀ ██░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 66 ■ LABOR REPORT - SPECIFIC EMPLOYEE This report is identical to the general labor report (described above), but prints only information for a specific employee (employee number). The first prompt is for the employee number, ie: ╔════════════════════[ LABOR REPORT - SPECIFIC EMPLOYEE ]════════════════════╗ ║ ║ ║ This report lists Labor information about the work order, and/or ║ ║ employee. Use Report Forms: LABORx.FRM (154 characters wide). ║ ║ ║ ║ Enter Employee Number: 100003 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██░ ███░ ██▄████░ ▄████▄ ██▄███░ ║ ║ ██░ ██▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░██░ ███████░ ██░ ██░ ██████░ ║ ║ ██░ ███▄███░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ █████░ ██░ ██░ ██▀████░ ▀████▀ ██░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 67 ■ LABOR REPORT - SPECIFIC WORK ORDER This report is identical to the general labor report (described above), but prints only information for a specific Work Order. The first prompt is for the Work Order Number, ie: ╔═══════════════════[ LABOR REPORT - SPECIFIC WORK ORDER ]═══════════════════╗ ║ ║ ║ This report lists Labor information about the work order, and/or ║ ║ employee. Use Report Forms: LABORx.FRM (154 characters wide). ║ ║ ║ ║ Enter Work Order (999999): 105 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██░ ███░ ██▄████░ ▄████▄ ██▄███░ ║ ║ ██░ ██▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░██░ ███████░ ██░ ██░ ██████░ ║ ║ ██░ ███▄███░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ █████░ ██░ ██░ ██▀████░ ▀████▀ ██░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 68 ■ LABOR REPORT - SPECIFIC CLASS This report is identical to the general labor report (described above), but prints only information for a specific CLASS code. The first prompt is for the CLASS code, ie: ╔═════════════════════[ LABOR REPORT - SPECIFIC CLASS ]══════════════════════╗ ║ ║ ║ This report lists Labor information about the work order, and/or ║ ║ employee. Use Report Forms: LABORx.FRM (154 characters wide). ║ ║ ║ ║ Enter CLASS Code: XXX ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██░ ███░ ██▄████░ ▄████▄ ██▄███░ ║ ║ ██░ ██▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░██░ ███████░ ██░ ██░ ██████░ ║ ║ ██░ ███▄███░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ █████░ ██░ ██░ ██▀████░ ▀████▀ ██░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 69 ■ LABOR REPORT - SPECIFIC TYPE This report is identical to the general labor report (described above), but prints only information for a specific TYPE code. The first prompt is for the TYPE code, ie: ╔══════════════════════[ LABOR REPORT - SPECIFIC TYPE ]══════════════════════╗ ║ ║ ║ This report lists Labor information about the work order, and/or ║ ║ employee. Use Report Forms: LABORx.FRM (154 characters wide). ║ ║ ║ ║ Enter TYPE Code: XXX ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██░ ███░ ██▄████░ ▄████▄ ██▄███░ ║ ║ ██░ ██▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░██░ ███████░ ██░ ██░ ██████░ ║ ║ ██░ ███▄███░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ █████░ ██░ ██░ ██▀████░ ▀████▀ ██░ ██░ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 70 ■ CONFIGURATION STATUS/REPORT This report lists all your current configuration settings for DAYO Job Costing. It is a VERY good idea to print and save this report should your DAYO Job Costing configuration file (DAYOJOB.CFG) 'get lost'... ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOJOB.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 71 ■ EXAMPLE OF THE CONFIGURATION STATUS/REPORT ++++++++++++++++++++++++++++++++++++++++++++++++++++++ + DAYO JOB COSTING CONFIGURATION REPORT + ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 08/25/91 17:18:00 Company Name: TJS LAB, Inc. Address Line 1: Attn: Operations Address Line 2: 5104 N. OBT, #200 City, State Zip: Orlando, FL 32810 Telephone: (407) 292-4708 Auto Print Invoice: Yes Invoice Printer Port: LPT1 Invoice Copies: 1 Default Shipper/Shipment: PICKUP Default Invoice Comment: Thank You! Default Overhead Factor: 0.03350 Last Work Order Number: 122 Last Customer Number: 0 Last Invoice Number: 200 Tax Work Orders: Yes Class Code Types: M E A A O Work Order Format: 8 Default W.O. Type: 1 Override Issue Required Qty: Yes Allow Edit Of W.O.: Yes Inventory Database Location: \DAYOINV\ Customer/AR Database Location: \DAYOAR\ POS Database Location: \DAYOPOS\ MRP Database Location: \DAYOMRP\ Payroll Database Location: \DAYOPAY\ General Ledger Directory: \DAYOGL\ Current Directory: Report Printer Port: LPT1 Automatic GL Posting: No Visual Indexing: Yes Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes DAYO JOB COSTING, TJS LAB, Inc Page: 72 ■ 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. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 73 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 │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║LIABIL.TXT │ 1987 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ ■ 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. DAYO JOB COSTING, TJS LAB, Inc Page: 74 ■ REPORT VIEWING SCREEN EXAMPLE... DAYOJOB View Reports │ File Name: COA.TXT Page No. 1 07/27/90 INVENTORY ITEM LISTING Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2" GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO JOB COSTING, TJS LAB, Inc Page: 75 ■ CONFIGURATION This routine contains all the configuration settings for DAYO Job Costing. ╔════════════════════════╗ ║ CONFIGURATION ║ ╟────────────────────────╢ ║ Tax Work Orders ║ ║ Class Code Types ║ ║ Working Class Codes ║ ║ Work Order Format ║ ║ Default W.O. Type ║ ║ Override Issue Req. ║ ║ Allow Edit Of W.O. ║ ║ Inventory Location ║ ║ Customer Location ║ ║ POS Location ║ ║ MRP (BOM) Location ║ ║ Payroll Location ║ ║ Current Directory ║ ║ Report Printer Port ║ ║ Visual Indexing ║ ║ Auto Daily Indexing ║ ║ Color ║ ║ High Intensity ║ ╟────────────────────────╢ ║ Select Option ║ ╚════════════════════════╝ ■ COMPANY NAME Enter your company name, as you want it to appear when printed on reports, forms, and Work Orders. ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY, INC │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 76 ■ COMPANY ADDRESS Enter your company address, ie: ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Accounts Receivable │ │ Address Line 2: P.O. BOX 5555 │ │ City, State ZIP: Anycity, ST 555555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY TELEPHONE Enter your company telephone number, ie: ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATICALLY PRINT INVOICES ┌──────────────────────[ AUTOMATICALLY PRINT INVOICES ]──────────────────────┐ │ If you want your invoices to automatically print after creating them, │ │ then change this option to Y (YES). │ │ Default is to automatically print the invoice(s). │ │ │ │ Automatically Print Invoices? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE PRINTER PORT ┌──────────────────────────[ INVOICE PRINTER PORT ]──────────────────────────┐ │ Enter Your Invoice Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE COPIES ┌─────────────────────────────[ INVOICE COPIES ]─────────────────────────────┐ │ This option determines the number of invoice copies to print at the │ │ time of invoicing. Default is to print one copy of the invoice. │ │ │ │ Enter Number of Invoice Copies: 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 77 ■ DEFAULT SHIPPER/METHOD OF SHIPMENT ┌───────────────────[ DEFAULT SHIPPER/METHOD OF SHIPMENT ]───────────────────┐ │ This selection is placed on new invoices if the Customer's SHIPPER/ │ │ METHOD OF SHIPMENT can not be determined. SHIPPERS/METHOD OF SHIPMENT │ │ selections are maintained in the shipper database (SHIPPER.DBF). │ │ Use the MISC Routines in the POS module to edit the records in this │ │ database. │ │ │ │ Select The Default Shipper -> PICKUP │ │ DELIVER │ │ US MAIL │ │ UPS GROUND │ │ UPS BLUE │ │ UPS RED │ │ AIRBORNE │ │ FEDERAL EXPRESS │ │ TRUCK │ │ SPECIAL DELIVERY │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT COMMENT ┌────────────────────────────[ DEFAULT COMMENT ]─────────────────────────────┐ │ This is the default comment to be printed onto every Invoice. │ │ │ │ Enter Default Comment: Thank You! │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT OVERHEAD FACTOR ┌────────────────────────[ DEFAULT OVERHEAD FACTOR ]─────────────────────────┐ │ This is the default factor used to compute the Manufacturing Overhead. │ │ │ │ Enter Default Overhead Factor: 0.00000 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST WORK ORDER NUMBER ┌─────────────────────────[ LAST WORK ORDER NUMBER ]─────────────────────────┐ │ This number plus 1 will be the next work order number when │ │ a new work order is created. │ │ │ │ Enter Last Work Order Number: 122 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 78 ■ LAST CUSTOMER NUMBER ┌──────────────────────────[ LAST CUSTOMER NUMBER ]──────────────────────────┐ │ This number plus 1 will be the next customer number when │ │ a new customer record is added. │ │ │ │ Enter Last Customer Number: 10324 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST INVOICE NUMBER ┌──────────────────────────[ LAST INVOICE NUMBER ]───────────────────────────┐ │ This number plus 1 will be the next invoice number when │ │ a new invoice is created. │ │ │ │ Enter Last Invoice Number: 213 │ └────────────────────────────────────────────────────────────────────────────┘ ■ TAX WORK ORDERS IF CUSTOMER IS TAXABLE ┌─────────────────[ TAX WORK ORDERS IF CUSTOMER IS TAXABLE ]─────────────────┐ │ If you wish to compute/include tax based on your customer's TAXRATE, │ │ and if the item is taxable, then change this option to Y (YES). │ │ Default is NOT to compute/include tax for work orders. │ │ │ │ Tax Work Orders? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ CLASS CODE TYPES ┌────────────────────────────[ CLASS CODE TYPES ]────────────────────────────┐ │ Many Work Order Reports are based on the CLASS, type of CLASS, and │ │ the DIRECT/INDIRECT cost. IE: 'M' for manufacturing │ │ The CLASS field is located in the inventory database (INV.DBF) │ │ │ │ Enter the 1st Class Type: M │ │ 2nd Class Type: E │ │ 3rd Class Type: A │ │ 4th Class Type: A │ │ 5th Class Type: O │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 79 ■ BROWSE THE WORKING CLASS CODES TABLE/DATABASE (CLASS.DBF) This routine lets you view/edit the database containing the Working CLASS codes (CLASS.DBF). ┌───────[ BROWSE THE WORKING CLASS CODES TABLE/DATABASE (CLASS.DBF) ]────────┐ │ CLASS NAME TYPE DIRECT DATE │ │───────────╥────────────────────────────────╥──────╥────────╥───────────────│ │ EL ║ Electrical Assembly ║ M ║ T ║ 06/29/91 │ │ GA ║ Gauge Assembly ║ M ║ T ║ 06/29/91 │ │ PH ║ Pneumatic Controller Assembly ║ M ║ T ║ 06/29/91 │ │ SI ║ System Integration & Test ║ M ║ T ║ 06/29/91 │ │ TP ║ Tool Positioner Assembly ║ M ║ T ║ 06/29/91 │ │ DC ║ Documentation ║ E ║ T ║ 06/29/91 │ │ SU ║ Start Up and Runoff ║ M ║ T ║ 06/29/91 │ │ RS ║ Repair - Service ║ M ║ T ║ 06/29/91 │ │ RW ║ Repair - Warranty ║ M ║ T ║ 06/29/91 │ │ EE ║ Electrical Engineering ║ E ║ T ║ 06/29/91 │ │ GE ║ Gauge Engineering ║ E ║ T ║ 06/29/91 │ │ PE ║ Pneumatic Engineering ║ E ║ T ║ 06/29/91 │ │ SW ║ Software Engineering ║ E ║ T ║ 06/29/91 │ │ TE ║ Tool Positioner Engineering ║ E ║ T ║ 06/29/91 │ │ PK ║ Packaging & Shipping ║ M ║ T ║ 06/29/91 │ │ RD ║ Research & Development ║ E ║ F ║ 06/29/91 │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) 1/26 ■ EDIT WORKING CLASS CODE Press 'F2' to edit the currently highlighted record, ie: ╔══════════════════════════════[ EDIT ]═══════════════════════════════╗ ║ Class: GE ║ ║ Name: Gauge Engineering ║ ║ Type: E ║ ║ Direct: Y ║ ╚═════════════════════════════════════════════════════════════════════╝ Press 'Ctrl N' to add a new record; 'Ctrl U' to delete the currently highlighted record. DAYO JOB COSTING, TJS LAB, Inc Page: 80 ■ WORK ORDER FORMAT ┌───────────────────────────[ WORK ORDER FORMAT ]────────────────────────────┐ │ The Work Order Number is a numeric, up to 6 digit number, but with │ │ this option, you can define/determine the format of the Work Order │ │ Number when it is printed on any printout, ie: reports & invoices. │ │ │ │ Select Option -> 1 Work Order Number Only, ie: 123456 │ │ 2 Year and Work Order Number, ie: 91-123456 │ │ 3 Type & Work Order Number, ie: XXX-123456 │ │ 4 Year, Type & Work Order Number, ie: 91-XXX-123456 │ │ 5 Year and Work Order Number, ie: 91123456 │ │ 6 Type & Work Order Number, ie: XXX123456 │ │ 7 Year, Type & Work Order Number, ie: 91XXX123456 │ │ 8 Year, Type & Work Order Number, ie: 91-XXX123456 │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT WORK ORDER TYPE The TYPE code on new Work Orders will default to this setting. ┌────────────────────────[ DEFAULT WORK ORDER TYPE ]─────────────────────────┐ │ │ │ Enter Default Work Order Type: 1 │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ OVERRIDE REQUIRED QUANTITY ┌────────────────────────────────────────────────────────────────────────────┐ │ If you want the ability to override the required QTY at time of issuing │ │ items, then select 'Y' (Yes) to this option. │ │ │ │ Do you want the ability to OVERRIDE the Required Qty? (Y/N) │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 81 ■ ALLOW EDIT OF WORK ORDER NUMBER (WO) ┌────────────────────────────────────────────────────────────────────────────┐ │ If you wish to override the computer generated Work Order Number (WO), │ │ then select 'Y' (Yes) to this option. Default is NOT to allow edit. │ │ │ │ Do you want the ability to edit the Work Order Number? (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 JOB. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO JOB 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 JOB). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CUSTOMER DATABASE LOCATION/DIRECTORY ┌──────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]──────────────────┐ │ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │ │ in the same drive/directory as DAYO JOB. If you have installed the DAYO │ │ Customer Database (CUSTOMER.DBF), into a different directory, you need │ │ to tell DAYO JOB where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO JOB). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 82 ■ INVOICE DATABASE (POS) LOCATION/DIRECTORY ┌───────────────[ INVOICE DATABASE (POS) LOCATION/DIRECTORY ]────────────────┐ │ The location of the DAYO Invoice databases does not have to be in the │ │ same drive/directory as DAYO JOB. If you have installed the DAYO POS │ │ or DAYO Billing & Invoicing, into a different directory, you need │ │ to tell DAYO JOB where to find the module. Default is nil (current │ │ directory). Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO JOB). │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ MRP (BOM) DATABASE LOCATION/DIRECTORY ┌─────────────────[ MRP (BOM) DATABASE LOCATION/DIRECTORY ]──────────────────┐ │ The location of the DAYO MRP databases does not have to be in the │ │ same drive/directory as DAYO JOB. If you have installed the DAYO MRP │ │ module into a different directory, you need to tell DAYO JOB where to │ │ find the module. Default is nil (current directory). Be sure to │ │ include the rightmost slash, ie: \DAYOMRP\ │ │ The drive designation is optional (if same as DAYO JOB). │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ PAYROLL DATABASE LOCATION/DIRECTORY ┌──────────────────[ PAYROLL DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Payroll databases does not have to be in the │ │ same drive/directory as DAYO JOB. If you have installed the DAYO Payroll │ │ module into a different directory, you need to tell DAYO JOB where to │ │ find the module. Default is nil (current directory). Be sure to │ │ include the rightmost slash, ie: \DAYOPAY\ │ │ The drive designation is optional (if same as DAYO JOB). │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 83 ■ 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: C:\DAYOJOB\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 84 ■ AUTOMATIC GL POSTING This Configuration routine was added to allow you to post your transactions (ie: Inventory Adjustments), automatically into General Ledger (GL). If this option is set to 'Y' (Yes), each time you adjust or edit key accounting fields (ie: COST, 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 inventory adjustment. ║ ║ ║ ║ Do you want Automatic GL Posting? (Y/N) ║ ║ ║ ║ Default CLASS Code: MRP Name: JOB COST ADJ ║ ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║ ║ Database: INVADJ.DBF Field: COST*QTY ║ ╟─────────────────[ SELECT DEFAULT JOB COSTING 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 ║ ║ AR ║ RECEIPTS ║ 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) 20/20 DAYO JOB COSTING, TJS LAB, Inc Page: 85 ■ 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: JOB COSTING ADJ ║ ║ 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 Inventory, TJS LAB Page: 86 DAYO JOB COSTING, TJS LAB, Inc Page: 87 ■ 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───┘ ■ VISUAL INDEXING ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 88 ■ AUTOMATIC DAILY INDEXING ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO JOB will be recreated once daily. This will occur when the first │ │ DAYO JOB program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO JOB Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low 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 JOB COSTING, TJS LAB, Inc Page: 89 ■ 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 MESS THINGS UP PERMANENTLY! ■ MISC Routines Menu: DAYO Job Costing Version 1.18 TJS LAB, INC. ┌────[August 1991]───┐ ╔════════════════════╗l Rights Reserved │S M T W T F S │ ║ MISC ROUTINES ║ ├────────────────────┤ ╟────────────────────╢╔══════════════════════════════════════════════════════╗ ║ APPEND FROM ║║ This menu option provides you with a multitude of ║ ║ BROWSE DATABASES ║║ database management tools and functions, but also ║ ║ COPY (.DBF) TO ║║ can be a source of significant problems! ║ ║ CREATE DATABASE ║║ ║ ║ DELETE RECORDS ║║ Miscellaneous Routines was provided to give you a ║ ║ ERASE FILE ║║ 'back door' to DAYO, but if used incorrectly, it ║ ║ EXIT TO DOS ║║ can damage or destroy your data! ║ ║ INDEX A DATABASE ║║ ║ ║ LIST FIELDS ║║ Adding records to databases, packing, appending, ║ ║ PACK DATABASE ║║ editing records and modify databases can ║ ║ MODIFY DATABASE ║║ corrupt the indexes related to the database(s)! ║ ║ RECALL RECORDS ║║ You must know to reindex (Alt F9) if you do any ║ ║ RETURN TO MENU ║║ of these operations... ║ ║ RUN (DOS COMMAND) ║║ ║ ║ SIMPLE EDITOR ║║ When modifying a database, the rule is to NEVER ║ ║ SORT DATABASE ║║ change an existing field; only to add new fields... ║ ║ TYPE (PRINT) FILE ║║ ║ ║ ZAP DATABASE ║║ Remember that 'ZAP' means to remove (permanently) ║ ╟────────────────────╢║ all records in the selected database! ║ ║ Select Option ║╚══════════════════════════════════════════════════════╝ ╚════════════════════╝ DAYO JOB COSTING, TJS LAB, Inc Page: 90 ■ 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 JOB COSTING, TJS LAB, Inc Page: 91 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 are 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: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 92 ■ BROWSE DATABASES Used to edit/view records in a database. Enter the database name you wish 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 JOB COSTING, TJS LAB, Inc Page: 93 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 JOB COSTING, TJS LAB, Inc Page: 94 ■ 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 JOB COSTING, TJS LAB, Inc Page: 95 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 copying 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 JOB COSTING, TJS LAB, Inc Page: 96 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 JOB COSTING, TJS LAB, Inc Page: 97 * * * 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. Pressing 'Esc' will 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 JOB COSTING, TJS LAB, Inc Page: 98 ■ DELETE RECORDS Delete selected records from databases. The first prompt is for the name of the database you in which 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 JOB COSTING, TJS LAB, Inc Page: 99 ■ 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 JOB COSTING, TJS LAB, Inc Page: 100 ■ 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 JOB COSTING, TJS LAB, Inc Page: 101 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 JOB COSTING, TJS LAB, Inc Page: 102 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 JOB COSTING, TJS LAB, Inc Page: 103 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 JOB COSTING, TJS LAB, Inc Page: 104 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 JOB COSTING, TJS LAB, Inc Page: 105 *** Be sure to Press: 'Ctrl W' when you are finished and satisfied. Pressing 'Esc' will 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 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 JOB COSTING, TJS LAB, Inc Page: 106 ■ 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 │ └───────────────────────────────────────────────────────────────────────────┘ 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:\DAYOJOB>EXIT DAYO JOB COSTING, TJS LAB, Inc Page: 107 ■ 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 JOB COSTING, TJS LAB, Inc Page: 108 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 JOB COSTING, TJS LAB, Inc Page: 109 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: DAYOERR.TXT │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO JOB COSTING, TJS LAB, Inc Page: 110 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, 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 JOB COSTING, TJS LAB, Inc Page: 111 ┌────┐ │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 JOB COSTING, TJS LAB, Inc Page: 112 ■ 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: ┌──────────────────────[ DAYOJOB 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: ┌───────────────────────[ DAYOJOB 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 JOB COSTING, TJS LAB, Inc Page: 113 - Editor help: ┌──────────────────────[ DAYOJOB 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 JOB COSTING, TJS LAB, Inc Page: 114 ■ 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 JOB Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌──────[ DAYO HELP Called by Program: DAYOJOB 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 DAYOJOB. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ 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 JOB COSTING, TJS LAB, Inc Page: 115 DAYO JOB Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌───────[ DAYO HELP Called by Program: DAYOJOB 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, DAYOJOB.DOC, DAYOPAY.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 DAYOJOB 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 JOB COSTING, TJS LAB, Inc Page: 116 ■ DATABASE STRUCTURE ■ DATABASE - BOM.DBF 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 ITEM Character 12 149 160 13 FINIS_QTY Numeric 10 3 161 170 14 WIP_QTY Numeric 10 3 171 180 15 REQ_QTY Numeric 10 3 181 190 16 PER_QTY Numeric 10 3 191 200 17 PTD_QTY Numeric 10 3 201 210 18 YTD_QTY Numeric 10 3 211 220 19 DATE Date 8 221 228 20 LASTDATE Date 8 229 236 21 LASTTIME Character 8 237 244 22 HOURS Numeric 10 3 245 254 23 LABOR Numeric 10 3 255 264 24 LABOR1 Numeric 10 3 265 274 25 LABOR2 Numeric 10 3 275 284 26 OVERRIDE Logical 1 285 285 27 POSITION Character 7 286 292 ────────── ───── Total 293 ■ DATABASE - CLASS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CLASS Character 3 1 3 2 NAME Character 30 4 33 3 TYPE Character 1 34 34 4 DIRECT Logical 1 35 35 5 DATE Date 8 36 43 ────────── ───── Total 44 DAYO JOB COSTING, TJS LAB, Inc Page: 117 ■ DATABASE - CUSTOMER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CUSTOMER Numeric 6 1 6 2 NAME Character 30 7 36 3 ATTN Character 30 37 66 4 ADDR1 Character 30 67 96 5 ADDR2 Character 30 97 126 6 CITY Character 22 127 148 7 STATE Character 2 149 150 8 ZIP Character 10 151 160 9 PHONE Character 14 161 174 10 SHIPNAME Character 30 175 204 11 SHIPADDR1 Character 30 205 234 12 SHIPADDR2 Character 30 235 264 13 SHIPCITY Character 22 265 286 14 SHIPSTATE Character 2 287 288 15 SHIPZIP Character 10 289 298 16 SHIPPHONE Character 14 299 312 17 SALESPER Character 3 313 315 18 TAXRATE Numeric 7 5 316 322 19 TAXRATE2 Numeric 7 5 323 329 20 TERMS Character 20 330 349 21 SHIPPER Character 20 350 369 22 FOB Character 20 370 389 23 DATE Date 8 390 397 24 LASTDATE Date 8 398 405 25 TYPE Character 3 406 408 26 CLASS Character 3 409 411 27 PBM Numeric 6 3 412 417 28 PBL Numeric 6 3 418 423 29 SALESPTD Numeric 10 2 424 433 30 SALESYTD Numeric 10 2 434 443 31 DUE Numeric 10 2 444 453 32 PAID_PURC Numeric 10 2 454 463 33 LIMIT Numeric 10 2 464 473 34 ACTIVE Logical 1 474 474 35 FAX Character 14 475 488 36 PRICEX Numeric 1 489 489 37 CREDCARD Character 20 490 509 38 TAXCODE Character 3 510 512 ────────── ───── Total 513 DAYO JOB COSTING, TJS LAB, Inc Page: 118 ■ DATABASE - HOURLOG.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NUMBER Character 6 1 6 2 WO Numeric 6 7 12 3 ENDWEEK Date 8 13 20 4 DATE Date 8 21 28 5 STARTTIME Character 8 29 36 6 ENDTIME Character 8 37 44 7 TOT_HOURS Numeric 7 3 45 51 8 REG_HOURS Numeric 7 3 52 58 9 OT_HOURS Numeric 7 3 59 65 10 DT_HOURS Numeric 7 3 66 72 11 ZERO_HOURS Numeric 7 3 73 79 12 RATE Numeric 10 4 80 89 13 DIRECT Logical 1 90 90 14 CLASS Character 3 91 93 15 TYPE Character 3 94 96 16 SUPERVISOR Character 10 97 106 17 CDATE Date 8 107 114 18 DEBIT Character 12 115 126 19 CREDIT Character 12 127 138 20 BY Character 10 139 148 ────────── ───── Total 149 ■ DATABASE - INOTES.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 NOTES Memo 10 7 16 ────────── ───── Total 17 DAYO JOB COSTING, TJS LAB, Inc Page: 119 ■ DATABASE - INV.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 DESC Character 30 13 42 3 DESC2 Character 30 43 72 4 ONHAND Numeric 7 73 79 5 ALLOCATED Numeric 7 80 86 6 ONORDER Numeric 7 87 93 7 BO Numeric 7 94 100 8 SOLDPTD Numeric 7 101 107 9 SOLDYTD Numeric 7 108 114 10 VOLUME Numeric 10 2 115 124 11 VENDITEM Character 12 125 136 12 VENDOR Character 10 137 146 13 DATE Date 8 147 154 14 LASTDATE Date 8 155 162 15 COST Numeric 10 2 163 172 16 AVGCOST Numeric 10 2 173 182 17 REALCOST Numeric 10 2 183 192 18 RETAIL Numeric 10 2 193 202 19 PRICE Numeric 10 2 203 212 20 PRICE1 Numeric 10 2 213 222 21 PRICE2 Numeric 10 2 223 232 22 PRICE3 Numeric 10 2 233 242 23 PRICE4 Numeric 10 2 243 252 24 PRICE5 Numeric 10 2 253 262 25 STOCKLEVEL Numeric 7 263 269 26 MIN Numeric 7 270 276 27 TYPE Character 3 277 279 28 CLASS Character 3 280 282 29 TAXABLE Logical 1 283 283 30 SERIALNO Logical 1 284 284 31 WEIGHT Numeric 8 2 285 292 32 UNIT Character 3 293 295 33 UNITQTY Numeric 7 296 302 34 PACKQTY Character 6 303 308 35 BOM Logical 1 309 309 36 NS Logical 1 310 310 37 TI Logical 1 311 311 38 LOCATION Character 3 312 314 ────────── ───── Total 315 DAYO JOB COSTING, TJS LAB, Inc Page: 120 ■ DATABASE - INV2.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 DATE Date 8 13 20 3 NOTES Memo 10 21 30 ────────── ───── Total 31 ■ DATABASE - INVADJ.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 VENDITEM Character 12 13 24 3 QTY Numeric 7 25 31 4 COST Numeric 10 2 32 41 5 PRICE Numeric 10 2 42 51 6 RETAIL Numeric 10 2 52 61 7 DOLLARS Numeric 10 2 62 71 8 REASON Character 30 72 101 9 LOC Character 10 102 111 10 CLASS Character 3 112 114 11 TRANSACT Character 12 115 126 12 BY Character 30 127 156 13 DATE Date 8 157 164 ────────── ───── Total 165 ■ DATABASE - NEXTWO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 WO Numeric 6 1 6 ────────── ───── Total 7 DAYO JOB COSTING, TJS LAB, Inc Page: 121 ■ DATABASE - PAY.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NUMBER Character 6 1 6 2 NAME Character 30 7 36 3 SSN Character 11 37 47 4 ADDR1 Character 30 48 77 5 ADDR2 Character 30 78 107 6 CITY Character 20 108 127 7 STATE Character 2 128 129 8 ZIP Character 10 130 139 9 PHONE Character 14 140 153 10 CLASS Character 3 154 156 11 TYPE Character 3 157 159 12 STATUS Character 3 160 162 13 DEPARTMENT Character 3 163 165 14 SEX Character 1 166 166 15 MARITAL Character 1 167 167 16 DOB Date 8 168 175 17 DOH Date 8 176 183 18 RATE Numeric 10 4 184 193 19 PAYPERIOD Character 1 194 194 20 WEEK_HOURS Numeric 7 3 195 201 21 REG_HOURS Numeric 7 3 202 208 22 OT_HOURS Numeric 7 3 209 215 23 P_HOURS Numeric 7 3 216 222 24 OTHER Numeric 10 2 223 232 25 SICK_PAY Numeric 10 2 233 242 26 VAC_PAY Numeric 10 2 243 252 27 WITHHOLD Logical 1 253 253 28 EXEMPTIONS Numeric 2 254 255 29 SICK_DAYS Numeric 7 3 256 262 30 SICK_USED Numeric 7 3 263 269 31 SICK_PER Numeric 7 3 270 276 32 VAC_DAYS Numeric 7 3 277 283 33 VAC_USED Numeric 7 3 284 290 34 VAC_PER Numeric 7 3 291 297 35 THE_GROSS Numeric 10 2 298 307 36 NEXT_KIN Character 50 308 357 37 DEFREGHR Numeric 7 3 358 364 38 DEFOTHR Numeric 7 3 365 371 39 DEFTOTHR Numeric 7 3 372 378 40 DATE Date 8 379 386 41 PARTTIME Logical 1 387 387 42 DEBIT Character 12 388 399 43 CREDIT Character 12 400 411 44 ACTIVE Logical 1 412 412 ────────── ───── Total 413 DAYO JOB COSTING, TJS LAB, Inc Page: 122 ■ DATABASE - SHIPPER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 SHIPPER Character 20 1 20 ────────── ───── Total 21 ■ DATABASE - TYPE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TYPE Character 3 1 3 2 NAME Character 30 4 33 3 DIRECT Logical 1 34 34 ────────── ───── Total 35 DAYO JOB COSTING, TJS LAB, Inc Page: 123 ■ DATABASE - WO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 WO Numeric 6 1 6 2 CUSTOMER Numeric 6 7 12 3 NAME Character 30 13 42 4 ATTN Character 30 43 72 5 ADDR1 Character 30 73 102 6 ADDR2 Character 30 103 132 7 CITY Character 22 133 154 8 STATE Character 2 155 156 9 ZIP Character 10 157 166 10 PHONE Character 14 167 180 11 SHIPNAME Character 30 181 210 12 SHIPADDR1 Character 30 211 240 13 SHIPADDR2 Character 30 241 270 14 SHIPCITY Character 22 271 292 15 SHIPSTATE Character 2 293 294 16 SHIPZIP Character 10 295 304 17 SHIPPHONE Character 14 305 318 18 CUST_PO Character 15 319 333 19 RELEASE Character 15 334 348 20 ISSUE_DATE Date 8 349 356 21 COMPLETED Date 8 357 364 22 QUOTE Numeric 6 365 370 23 QUOTE_DATE Date 8 371 378 24 SALESPER Character 3 379 381 25 SHIPPER Character 20 382 401 26 DATE Date 8 402 409 27 LASTDATE Date 8 410 417 28 BY Character 30 418 447 29 TYPE Character 3 448 450 30 CLASS Character 3 451 453 31 TAXRATE Numeric 7 5 454 460 32 TOTAL Numeric 10 2 461 470 33 TOTAL_WIP Numeric 10 2 471 480 34 DIR_LABOR Numeric 10 2 481 490 35 IND_LABOR Numeric 10 2 491 500 36 FREIGHT Numeric 10 2 501 510 37 ADJUST Numeric 10 2 511 520 38 TAXES Numeric 10 2 521 530 39 FACTOR Numeric 10 5 531 540 40 OVERHEAD Numeric 10 2 541 550 41 COMMENT Character 50 551 600 42 OPEN Logical 1 601 601 ────────── ───── Total 602 DAYO JOB COSTING, TJS LAB, Inc Page: 124 ■ DATABASE - WOD.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 ITEM Character 12 7 18 3 REQ_QTY Numeric 10 3 19 28 4 WIP_QTY Numeric 10 3 29 38 5 COST Numeric 10 3 39 48 6 DESC Character 30 49 78 7 DESC2 Character 30 79 108 8 WO Numeric 6 109 114 9 CUSTOMER Numeric 6 115 120 10 DATE Date 8 121 128 11 LASTDATE Date 8 129 136 12 TYPE Character 3 137 139 13 CLASS Character 3 140 142 ────────── ───── Total 143 ■ DATABASE - WOH.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 WO Numeric 6 7 12 3 COMMENT Character 50 13 62 4 DATE Date 8 63 70 5 LASTDATE Date 8 71 78 6 CUSTOMER Numeric 6 79 84 7 ISSUED_TO Character 30 85 114 8 TYPE Character 3 115 117 9 CLASS Character 3 118 120 10 TOTAL Numeric 10 2 121 130 11 TOTAL_WIP Numeric 10 2 131 140 12 FREIGHT Numeric 10 2 141 150 13 ADJUST Numeric 10 2 151 160 14 TAXES Numeric 10 2 161 170 15 BY Character 30 171 200 16 PRINTED Logical 1 201 201 17 OPEN Logical 1 202 202 ────────── ───── Total 203 DAYO JOB COSTING, TJS LAB, Inc Page: 125 ■ DATABASE - WOLOG.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NUMBER Numeric 6 1 6 2 INVOICE Numeric 6 7 12 3 ITEM Character 12 13 24 4 QTY Numeric 10 3 25 34 5 COST Numeric 10 3 35 44 6 DESC Character 30 45 74 7 WO Numeric 6 75 80 8 CUSTOMER Numeric 6 81 86 9 DATE Date 8 87 94 10 TYPE Character 3 95 97 11 CLASS Character 3 98 100 12 ISSUED_TO Character 30 101 130 ────────── ───── Total 131 ■ DATABASE - WONOTES.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 WO Numeric 6 1 6 2 NOTES Memo 10 7 16 ────────── ───── Total 17 DAYO JOB COSTING, TJS LAB, Inc Page: 126 ■ DATA DICTIONARY Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── ACTIVE L 1 0 CUSTOMER.DBF Flag to denote customer or employee PAY.DBF as being active ADDR1 C 30 0 CUSTOMER.DBF Address line 1 PAY.DBF " WO.DBF " ADDR2 C 30 0 WO.DBF Address line 2 CUSTOMER.DBF " PAY.DBF " ADJUST N 10 2 WO.DBF Adjustment amount WOH.DBF " ALLOCATED N 7 0 INV.DBF Allocated quantity ATTN C 30 0 WO.DBF Attention or contact name CUSTOMER.DBF " AVGCOST N 10 2 INV.DBF Average cost BO N 7 0 INV.DBF Back order (to your customers) quantity BOM L 1 0 INV.DBF Flag to denote item as being an ENDITEM (has a bill of material) BY C 30 0 WO.DBF User/operator that created the WOH.DBF record currently highlighted BY C 10 0 HOURLOG.DBF " BY C 30 0 INVADJ.DBF " CDATE D 8 0 HOURLOG.DBF Date labor record was created CITY C 20 0 PAY.DBF Employee's city CITY C 22 0 CUSTOMER.DBF Customer's city WO.DBF " CLASS C 3 0 WO.DBF Class code used with General Ledger INV.DBF " CUSTOMER.DBF " WOH.DBF " WOLOG.DBF " WOD.DBF " INVADJ.DBF " PAY.DBF " CLASS.DBF " HOURLOG.DBF " COMMENT C 50 0 WO.DBF Work Order Comment WOH.DBF " COMPLETED D 8 0 WO.DBF Date Work Order was completed or closed (OPEN=.F.) DAYO JOB COSTING, TJS LAB, Inc Page: 127 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── COST N 10 3 WOLOG.DBF Cost of item issued BOM.DBF Cost of item COST N 10 2 INVADJ.DBF " INV.DBF " COST N 10 3 WOD.DBF " CREDCARD C 20 0 CUSTOMER.DBF Credit card name & number CREDIT C 12 0 HOURLOG.DBF General Ledger Credit Account Number PAY.DBF " CUSTOMER N 6 0 WOLOG.DBF Customer Number WOD.DBF " WO.DBF " CUSTOMER.DBF " WOH.DBF " CUST_PO C 15 0 WO.DBF Customer's purchase order number DATE D 8 0 HOURLOG.DBF Date record was added to database WOH.DBF " BOM.DBF " PAY.DBF " CUSTOMER.DBF " INV.DBF " INVADJ.DBF " WOD.DBF " WO.DBF " CLASS.DBF " WOLOG.DBF " INV2.DBF " DEBIT C 12 0 PAY.DBF General Ledger Debit Account Number HOURLOG.DBF " DEFOTHR N 7 3 PAY.DBF Default OTHER hours DEFREGHR N 7 3 PAY.DBF Default REGULAR hours DEFTOTHR N 7 3 PAY.DBF Default TOTAL hours DEPARTMENT C 3 0 PAY.DBF Employee's department DESC C 30 0 INV.DBF Item description WOD.DBF " WOLOG.DBF " BOM.DBF " DESC2 C 30 0 WOD.DBF Item's second description INV.DBF " DIRECT L 1 0 TYPE.DBF Flag to denote TYPE as being DIRECT HOURLOG.DBF labor CLASS.DBF " DIR_LABOR N 10 2 WO.DBF Direct Labor Total DOB D 8 0 PAY.DBF Employee's date of birth DOH D 8 0 PAY.DBF Employee's date of hire DOLLARS N 10 2 INVADJ.DBF Total value of inventory adjustment DAYO JOB COSTING, TJS LAB, Inc Page: 128 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── DT_HOURS N 7 3 HOURLOG.DBF Double Time hours DUE N 10 2 CUSTOMER.DBF Amount customer owes you ENDITEM C 12 0 BOM.DBF Item with a bill of materials, has component items ENDTIME C 8 0 HOURLOG.DBF Time employee ended his/her work ENDWEEK D 8 0 HOURLOG.DBF Week Ending date (payroll date) EXEMPTIONS N 2 0 PAY.DBF Number of exemptions for employee FACTOR N 10 5 WO.DBF Overhead factor used with the total direct labor amount FAX C 14 0 CUSTOMER.DBF Customer's FAX number FINIS_QTY N 10 3 BOM.DBF Amount of finished/assembled ENDITEMS awaiting transfer into the inventory FOB C 20 0 CUSTOMER.DBF Freight on Board FREIGHT N 10 2 WOH.DBF Freight amount WO.DBF " HOURS N 10 3 BOM.DBF Hours required for ENDITEM or component item in the bill of materials database (BOM.DBF) IND_LABOR N 10 2 WO.DBF Indirect Labor Total INVOICE N 6 0 WOLOG.DBF Item Issue/Invoice number WOH.DBF " INOTES.DBF " WOD.DBF " ISSUED_TO C 30 0 WOH.DBF Name of person that item(s) were WOLOG.DBF issued to ISSUE_DATE D 8 0 WO.DBF Date items were issued ITEM C 12 0 BOM.DBF Item/Product/Part Number WOLOG.DBF " INV2.DBF " INV.DBF " WOD.DBF " INVADJ.DBF " LABOR N 10 3 BOM.DBF Amount of labor required for the ENDITEM or component in the bill of materials database (BOM.DBF) LABOR1 N 10 3 BOM.DBF Total Direct Labor for ENDITEM or component in the bill of materials database (BOM.DBF) LABOR2 N 10 3 BOM.DBF Total In-Direct Labor for ENDITEM or component in the bill of materials database (BOM.DBF) LASTDATE D 8 0 BOM.DBF Date of last access WOH.DBF " WOD.DBF " CUSTOMER.DBF " INV.DBF " WO.DBF " DAYO JOB COSTING, TJS LAB, Inc Page: 129 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── LASTTIME C 8 0 BOM.DBF Time last accessed LEVEL1 C 12 0 BOM.DBF Level 1 item number, use in the bill of materials LEVEL2 C 12 0 BOM.DBF Level 2 item number, use in the bill of materials LEVEL3 C 12 0 BOM.DBF Level 3 item number, use in the bill of materials LEVEL4 C 12 0 BOM.DBF Level 4 item number, use in the bill of materials LEVEL5 C 12 0 BOM.DBF Level 5 item number, use in the bill of materials LEVEL6 C 12 0 BOM.DBF Level 6 item number, use in the bill of materials LEVEL7 C 12 0 BOM.DBF Level 7 item number, use in the bill of materials LEVEL8 C 12 0 BOM.DBF Level 8 item number, use in the bill of materials LIMIT N 10 2 CUSTOMER.DBF Customer's credit limit LOC C 10 0 INVADJ.DBF Warehouse/Location number LOCATION C 3 0 INV.DBF Item location in inventory or warehouse MARITAL C 1 0 PAY.DBF Employee's marital status MIN N 7 0 INV.DBF Minimum stockage quantity NAME C 30 0 CUSTOMER.DBF Customer's name CLASS.DBF CLASS code name WO.DBF Customer's name PAY.DBF Employee's name TYPE.DBF TYPE code name NEXT_KIN C 50 0 PAY.DBF Employee's next of kin NOTES M 10 0 WONOTES.DBF Work Order notes INOTES.DBF " INV2.DBF " NS L 1 0 INV.DBF Flag to denote item as being a non-standard item NUMBER C 6 0 PAY.DBF Employee's payroll number NUMBER N 6 0 WOLOG.DBF " NUMBER C 6 0 HOURLOG.DBF " ONHAND N 7 0 INV.DBF Quantity ONHAND in the inventory ONORDER N 7 0 INV.DBF Quantity onorder with your vendors OPEN L 1 0 WO.DBF Flag to denote Work Order as being WOH.DBF open (OPEN=.T.) or closed (OPEN=.F.) OTHER N 10 2 PAY.DBF Amount of OTHER pay for employee OT_HOURS N 7 3 PAY.DBF Total Overtime hours HOURLOG.DBF " OVERHEAD N 10 2 WO.DBF Overhead amount DAYO JOB COSTING, TJS LAB, Inc Page: 130 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── OVERRIDE L 1 0 BOM.DBF Not used PACKQTY C 6 0 INV.DBF User defined PAID_PURC N 10 2 CUSTOMER.DBF Amount of goods purchased by the customer PARTTIME L 1 0 PAY.DBF Flag to denote employee as being parttime PAYPERIOD C 1 0 PAY.DBF Valid entries are: 'W' Weekly 'M' Monthly 'A' Annually PBL N 6 3 CUSTOMER.DBF Amount of Retail or List discount to be applied to inventory items when invoicing (in POS or Billing and Invoicing) PBM N 6 3 CUSTOMER.DBF Amount of Margin discount to be applied to inventory items when invoicing (in POS or Billing and Invoicing) PER_QTY N 10 3 BOM.DBF Number of component items required to assemble/build/produce one (1) ENDITEM PHONE C 14 0 CUSTOMER.DBF Customer's telephone number WO.DBF " PAY.DBF Employee's telephone number POSITION C 7 0 BOM.DBF Component item position in a bill of materials PRICE N 10 2 INV.DBF Item price INVADJ.DBF " PRICE1 N 10 2 INV.DBF Item's 1st alternate price PRICE2 N 10 2 INV.DBF Item's 2nd alternate price PRICE3 N 10 2 INV.DBF Item's 3rd alternate price PRICE4 N 10 2 INV.DBF Item's 4th alternate price PRICE5 N 10 2 INV.DBF Item's 5th alternate price PRICEX N 1 0 CUSTOMER.DBF Used to designate which of the 5 PRICEx fields to default to PRINTED L 1 0 WOH.DBF Flag to denote Work Order header as being printed PTD_QTY N 10 3 BOM.DBF Period to Date quantity used P_HOURS N 7 3 PAY.DBF Total Premium hours QTY N 7 0 INVADJ.DBF Number of items in the inventory adjustment QTY N 10 3 WOLOG.DBF Number of items issued QUOTE N 6 0 WO.DBF Quote number QUOTE_DATE D 8 0 WO.DBF Date Work Order was quoted RATE N 10 4 HOURLOG.DBF Employee's rate PAY.DBF " REALCOST N 10 2 INV.DBF Real cost (ie: includes labor & freight) DAYO JOB COSTING, TJS LAB, Inc Page: 131 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── REASON C 30 0 INVADJ.DBF Reason for the inventory adjustment REG_HOURS N 7 3 PAY.DBF Total Regular hours HOURLOG.DBF " RELEASE C 15 0 WO.DBF Customer's purchase order release number REQ_QTY N 10 3 WOD.DBF Estimated number of component items it will take to complete a Work Order BOM.DBF Number of component items required to build, assemble, or produce a number of ENDITEMs RETAIL N 10 2 INVADJ.DBF Retail or List price of an item INV.DBF " SALESPER C 3 0 WO.DBF Sales Person number/code CUSTOMER.DBF " SALESPTD N 10 2 CUSTOMER.DBF Total Period to Date sales SALESYTD N 10 2 CUSTOMER.DBF Total Year to Date sales SERIALNO L 1 0 INV.DBF Flag to denote item as having serial numbers SEX C 1 0 PAY.DBF Employee's sex (ie: 'M', 'F', or 'O') SHIPADDR1 C 30 0 WO.DBF Ship To address line 1 CUSTOMER.DBF " SHIPADDR2 C 30 0 WO.DBF Ship To address line 2 CUSTOMER.DBF " SHIPCITY C 22 0 WO.DBF Ship To city CUSTOMER.DBF " SHIPNAME C 30 0 WO.DBF Ship To name CUSTOMER.DBF " SHIPPER C 20 0 CUSTOMER.DBF Shipper or method of shipment SHIPPER.DBF " WO.DBF " SHIPPHONE C 14 0 CUSTOMER.DBF Ship To telephone WO.DBF " SHIPSTATE C 2 0 WO.DBF Ship To state CUSTOMER.DBF " SHIPZIP C 10 0 WO.DBF Ship To zip code CUSTOMER.DBF " SICK_DAYS N 7 3 PAY.DBF Total Sick Days accrued SICK_PAY N 10 2 PAY.DBF Total Sick Pay SICK_PER N 7 3 PAY.DBF Number of Sick Pay days accrued for each pay period SICK_USED N 7 3 PAY.DBF Number of Sick Pay days used/paid SOLDPTD N 7 0 INV.DBF Period to Date quantity of items invoiced or used in bill of materials or Job Costing DAYO JOB COSTING, TJS LAB, Inc Page: 132 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── SOLDYTD N 7 0 INV.DBF Period to Date quantity of items invoiced or used in bill of materials or Job Costing SSN C 11 0 PAY.DBF Employee's social security number STARTTIME C 8 0 HOURLOG.DBF Start time of pay period STATE C 2 0 CUSTOMER.DBF Customer's state WO.DBF " PAY.DBF Employee's state STATUS C 3 0 PAY.DBF Employee's status (user defined) STOCKLEVEL N 7 0 INV.DBF Inventory stockage level SUPERVISOR C 10 0 HOURLOG.DBF Name of employee's supervisor TAXABLE L 1 0 INV.DBF Flag to denote item as being taxable TAXCODE C 3 0 CUSTOMER.DBF Tax code for customer (used in some Tax reports) TAXES N 10 2 WO.DBF Taxes amount WOH.DBF " TAXRATE N 7 5 WO.DBF Customer's tax rate CUSTOMER.DBF " TAXRATE2 N 7 5 CUSTOMER.DBF Second (2nd) tax rate TERMS C 20 0 CUSTOMER.DBF Customer's payment terms, ie: Net 30 THE_GROSS N 10 2 PAY.DBF Employee's total gross wages TI L 1 0 INV.DBF Flag to denote item as being a 'time' item TOTAL N 10 2 WOH.DBF Estimated total inventory amount WO.DBF for Work Order TOTAL_WIP N 10 2 WOH.DBF Total inventory amount used in WO.DBF Work Order. This is the quantity of items transferred/issued to the Work Order; placed into the Work In Process (WIP) for the Work Order TOT_HOURS N 7 3 HOURLOG.DBF Total labor hours TRANSACT C 12 0 INVADJ.DBF General Ledger transaction number that designates inventory adjustment as having been posted into General Ledger (GL) TYPE C 3 0 WO.DBF TYPE code WOD.DBF " HOURLOG.DBF " TYPE.DBF " INV.DBF " PAY.DBF " TYPE C 1 0 CLASS.DBF " TYPE C 3 0 WOLOG.DBF " CUSTOMER.DBF " WOH.DBF " UNIT C 3 0 INV.DBF Unit of issue, ie: 'EA', 'DZ', 'BOX' DAYO JOB COSTING, TJS LAB, Inc Page: 133 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── UNITQTY N 7 0 INV.DBF Unit quantity used with purchase orders to designate that the item is ordered from vendors in units of this amount/quantity VAC_DAYS N 7 3 PAY.DBF Total Vacation days acrued VAC_PAY N 10 2 PAY.DBF Total Vacation days pay VAC_PER N 7 3 PAY.DBF Number of Vacation days acrued each pay period VAC_USED N 7 3 PAY.DBF Number of Vacation days used/paid VENDITEM C 12 0 INV.DBF Vendor's or Manufacturer's product INVADJ.DBF number VENDOR C 10 0 INV.DBF Vendor or Manufacturer's account number VOLUME N 10 2 INV.DBF Total dollar value used for a specified period/date range WEEK_HOURS N 7 3 PAY.DBF Total hours worked in a week WEIGHT N 8 2 INV.DBF Item weight WIP_QTY N 10 3 BOM.DBF Number of component items WOD.DBF transferred from the inventory into the bill of materials or Job Costing WIP WITHHOLD L 1 0 PAY.DBF Flag to denote that withholding of federal and/or state payroll taxes will occur WO N 6 0 WOH.DBF Work Order Number WONOTES.DBF " WOLOG.DBF " HOURLOG.DBF " WO.DBF " WOD.DBF " NEXTWO.DBF " YTD_QTY N 10 3 BOM.DBF Year to Date quantity of component items used to build/assemble/ produce ENDITEMs ZERO_HOURS N 7 3 HOURLOG.DBF Total Zero (0) cost hours used ZIP C 10 0 CUSTOMER.DBF Customer's zip code WO.DBF " PAY.DBF Employee's zip code DAYO JOB COSTING, TJS LAB, Inc Page: 134 ■ DAYO JOB COSTING MAINTENANCE & QUIRKS After using DAYO Job Costing for a any period of time, you will need to 'clean out' deleted records. This task can be accomplished with the PACK routine in the MISC ROUTINES option. * Note, PACKing will remove all records that are marked as deleted, but the process corrupts the indexes, so a full index should be done after a PACK ('Alt F9' from the main menu). On occasion (maybe an under statement), index files will get corrupted, especially on networks. To 'fix' a corrupted index requires that everyone 'get out of' the DAYO databases, and then perform a reindexing (actually a recreation of the indexes). The reindex is accomplished by running the DAYO Job Costing program with a parameter of 'INDEX' (or using DAYOX). ie: C:\>DAYOJOB INDEX 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 novell network. Use the 'ATTRIB' command for other network systems. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW Indexes are recreated once every day. This is automatically performed by the first user to run DAYO Job Costing. This process will take more time as your files get larger. This process should take place daily, but you can run it at night with a batch file that waits until after midnight, or a with most scheduling programs. All other users and computers must be out of the databases, or the procedure will not occur properly. Remember to 'flag' the files sharable, readable and writable. Backups of your data and configuration files should take place daily! You have no doubt heard many scare stories. They are all true! The key files that need to be backed up all have the extension of .DBF, and .CFG. The .DBF files are your databases. The .CFG file(s) contain your configuration information (as seen in the Configuration module). DAYO JOB COSTING, TJS LAB, Inc Page: 135 If you are on a network, it is HIGHLY recommended that you DO NOT 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 must use dBase (tm) with DAYO Job Costing, 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'! DAYO JOB COSTING, TJS LAB, Inc Page: 136 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce 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 (A/R, A/P). 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 inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $35.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (8:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered Shareware products. TJS LAB, Computer Division In an effort to provide the 'total solution', TJS LAB now offers personal computer systems, printers, software and accessories at a much discounted price. All equipment is warranted by the manufacturer for at least one year. Call or write us for more information...