Shareware 1 2 the Maxx

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

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

Wrap

Text File | 1991-09-10 | 295KB | 3,662 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ███████▒░ ▄█████▄ █▄████▄ ║ ║ ██▒░ ██▒░ ██▒░ ██▒ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒ ██▒░ ║ ║ █████▒░ ██▒░ ██▒░ ██▀████▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███████▒░ ▀█████▀ ██▒░ ║ ║ ░░░░░░░░ ░░░░░ ░░░░ ║ ║ ║ ║ ║ ║ ║ ║ END OF PERIOD POST & INVENTORY FOR THE DAYO MODULES ║ ║ ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ 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 ▄▄▄▄▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 1 year after date of registration or purchase. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO EOP, TJS LAB Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 1......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 2......SETUP 3......MAIN MENU 3...... PASSWORD/NAME 4......PHYSICAL INVENTORY 4...... PHYSICAL INVENTORY MENU 5...... INITIALIZATION 6...... PHYSICAL INVENTORY DATA ENTRY 7...... EDIT/BROWSE THE PHYSICAL INVENTORY DATABASE (PHYINV.DBF) 9...... FULL SCREEN EDIT 9...... FIND 10...... COUNT SHEET 10...... VARIANCE REPORT 12...... EXAMPLE OF VARIANCE REPORT TOTALS 12...... PHYSICAL INVENTORY POST 15......ACCOUNTS RECEIVABLES POST & PACK 17......ACCOUNTS PAYABLE POST & PACK 19......CLEANUP DAYO REPORT FILES 22......REPORTS 22...... REPORTS MENU 23...... POS HEADER REPORTS 24...... POS DETAIL REPORTS 25...... PURCHASE ORDER HEADER REPORT 25...... PURCHASE ORDER DETAIL REPORT 26...... RECEIVING REPORT 26...... ACCOUNTS RECEIVABLE AGEING SUMMARY REPORT 27...... ACCOUNTS PAYABLE HEADER REPORT 27...... ACCOUNTS PAYABLE DETAIL REPORT 28...... ACCOUNTS PAYABLE SUMMARY REPORT 28...... ACCOUNTS PAYABLE CHECKS REPORT 29...... DEPOSITS REPORT 29...... MISCELLANEOUS EXPENSES REPORT 30...... EXPANDED INVENTORY REPORT 30...... WAREHOUSE REPORT 31...... REORDER REPORT 31...... INVENTORY ADJUSTMENTS 32...... INVENTORY MOVEMENT 32...... VENDORS REPORT 33...... CASH RECEIPTS 33...... CUSTOMER EXPANDED REPORT 34...... CONFIGURATION STATUS REPORT 34...... EXAMPLE OF THE CONFIGURATION STATUS REPORT DAYO EOP, TJS LAB Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 35...... PRINTER DRIVER (SETUP) 35...... PRINTER DRIVER OPTIONS 36...... CHANGE DEFAULT PRINTER 37...... FULL SCREEN EDIT - F2 37...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 38......CONFIGURATION 38...... CONFIGURATION LISTING 39...... COMPANY NAME, ADDRESS & TELEPHONE 39...... INVENTORY LOCATION/DIRECTORY 39...... POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY 40...... CUSTOMER (AR) DATABASE LOCATION/DIRECTORY 40...... ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY 40...... QUOTES DATABASE LOCATION/DIRECTORY 41...... BACKORDERS DATABASE LOCATION/DIRECTORY 41...... PRICE BOOK DATABASE LOCATION/DIRECTORY 41...... SMART REPORTS LOCATION/DIRECTORY 42...... REPORT PRINTER TYPE 42...... REPORT PRINTER PORT 42...... COLOR MONITOR 42...... COLOR INTENSITY 43......MISCELLANEOUS ROUTINES 43...... MISC ROUTINES MENU: 44...... APPEND FROM 46...... BROWSE DATABASES 48...... COPY (.DBF) TO 50...... CREATE DATABASE 52...... DELETE RECORDS 53...... ERASE FILE 53...... EXIT TO DOS 54...... INDEX A DATABASE 55...... LIST FIELDS 58...... MODIFY DATABASE 59...... PACK DATABASE 60...... RECALL RECORDS 60...... RETURN TO MENU 60...... RUN (DOS COMMAND) 61...... SIMPLE EDITOR 62...... SORT DATABASE 63...... TYPE (PRINT) FILE 64...... ZAP DATABASE 66......HELP SCREENS 67...... EXPANDED HELP 68...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 69...... VIEW DOCUMENTATION ONSCREEN 70......DATABASE STRUCTURE 70......DATA DICTIONARY 71......DAYO EOP MAINTENANCE & QUIRKS 72......TJS 'Computer' LAB DAYO EOP, TJS LAB Page: 1 ■ INTRODUCTION DAYO EOP (End of Period Pack & Inventory) contains routines that are normally run at the end of a reporting period (ie: Month). DAYO EOP allows you to permanently remove deleted records from the Accounts Receivable (AR), and Accounts Payable (AP) databases, and to erase old report text files. There is also a routine for performing a Physical Inventory. Many reports are included (ie: AR Ageing, AP Summary, Inventory Movement). DAYO EOP is by default a multiuser system, however the AR, AP, and Report Cleanup processes must have exclusive access to the DAYO databases and files. Some of the DAYO EOP highlights are: Multiuser (ie: Novell) Data Entry Validation Databases are dBase (tm) compatible 15 Configuration Settings Passwords (with DAYO Passwords) Over 20 Reports Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sales Billing & Invoicing DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO BO Back Orders DAYO Smart Reports A variety of reports pertaining to the above modules DAYO Passwords Password protect your DAYO system DAYOX Network/LAN Index Maintenance Utility ■ 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 EOP software, documentation, and source codes. DAYO EOP, TJS LAB Page: 2 ■ 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 EOP. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO EOP, copy the contents of the DAYO EOP floppy disk into a directory on your hard disk (ie: \DAYOEOP). If this is the Shareware Version, you need to UnZip/UnArc the files here. When running DAYO EOP for the first time, it will create all the database, index, and configuration files it requires for operation. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO EOP configuration. Type and enter 'DAYOE' at the DOS prompt to run the program (ie: C:\DAYOE ). *** Your CONFIG.SYS file must have the buffers set to a minimun of 10, and your files must have a minimun setting of 55! Failure to edit the CONFIG.SYS file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is created if there is a problem detected, in the directory that this DAYO module is being run in. You may copy this file into your root/boot drive. Refer to your DOS manual for more information on the CONFIG.SYS file! DAYO EOP, TJS LAB Page: 3 ■ MAIN MENU After a few moments and possibly a reindex, the main menu will appear (the left side of the screen is the actual main menu): DAYO EOP Version 3.0 TJS LAB ┌───[February 1991]──┐ ╓──────────────────────╖ │S M T W T F S │ ║ 1 EOP INVENTORY ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟──────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2│ ║ 2 AR POST & PURGE ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│ ╟──────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│ ║ 3 AP POST & PURGE ║ █░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│ ╟──────────────────────╢ █▀██▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 │ ║ 4 REPORT CLEANUP ║ │ │ ╟──────────────────────╢ Copyright (c) 1990-1991 └────────────────────┘ ║ 5 REPORTS ║ ╟──────────────────────╢ ████░ █░ █░ █▄██▄ ▄███▄ ████░ ║ 6 CONFIGURATION ║ █░ ██░ █░ █░ █░ █░ █░ █░ ╟──────────────────────╢ ███░ ███░█░ █░ █░ █░ █░ ████░ ║ 7 MISC ROUTINES ║ █░ █▀███░ █░ █░ █░ █░ █░ ╟──────────────────────╢ █░ █░▀██░ █░ █░ █░ █░ █░ ║ 8 EXIT ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░ ╚══════════════════════╝ Date Last Posted: 04/01/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄ Time Last Posted: 12:06:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ Number of Lines: 1 █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░ Number of pieces: 3 █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░ Value of Last Post: 3.00 █░ █░ █░ ▀█░ █░ █░ █░ █░ █░ Posted By: fgd █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀ End of Period Physical Inventory ■ PASSWORD/NAME From the main menu you can enter any of the routines/options, but not until you enter your name (or password if using DAYO Passwords): ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 4 ■ PHYSICAL INVENTORY The process of physically counting your inventory (actually seeing it...), is called your Physical Inventory. What DAYO Inventory 'says' you have (onscreen or report), is called your Perpetual Inventory. DAYO EOP provides you this Physical Inventory routine to identify and reconcile your '2' inventories. DAYO Physical Inventory allows you to data entry ITEM counts, edit them, print variance reports, and subsequently post the Physical Inventory counts to the Perpetual Inventory (INV.DBF & WAREHOUS.DBF). ■ PHYSICAL INVENTORY MENU The Physical Inventory Menu gives you 6 options to select from: Data Entry to Physical Inventory Database (PHYINV.DBF) Print Inventory List (Count Sheet) Print Variance Report Edit/Browse the Physical Inventory Database Post to the Inventory Database (INV.DBF) Initialize your Physical Inventory Database DAYO EOP Version 3.0 TJS LAB ╔═══════════════════════════[ Physical Inventory ]═══════════════════════════╗ ║This routine is used to perform a physical inventory (count) of all items ║ ║that should be recorded in your inventory databases (INV.DBF & WAREHOUS.DBF)║ ║This process (End of Period Physical Inventory) can be performed as often as║ ║you wish, however, the amount of time and effort increases with the quantity║ ║of items in inventory... ║ ║Posting the data entered/inputted with this routine will REPLACE the current║ ║ONHAND field in the inventory database (INV.DBF), and the LOCxxx field in ║ ║the warehouse database (WAREHOUS.DBF) ║ ║MAKE A BACKUP OF YOUR INVENTORY DATABASES BEFORE PERFORMING THIS ROUTINE! ║ ║ Select Option -> Data Entry to Physical Inventory Database (PHYINV.DBF) ║ ║ Print Inventory List (Count Sheet) ║ ║ Print Variance Report ║ ║ Edit/Browse the Physical Inventory Database ║ ║ Post to the Inventory Database (INV.DBF) - (Finished!) ║ ║█▄███░█░█░█░ █░███░███░██░ █░ █░ ███░█░ █░█░█░██░█░ █░███░▄█▄ ███░█░ █░║ ║█░ █░█░█░█▄ ▄█░█░ █░ █░ █▀█░ █░ █░ ██░█░█░█░█░ ██░█░ █░ █░█░█░█░█░ █░║ ║█░ █░█░█░ █░█░ █░ █░ █░ █░█░ █░ █░ ██░█░█░█░█░ ██░█░ █░ █░█░█░█░▀█░█▀ ║ ║█▀██▀ ███░ █▄█░ ███░ █░ █░ ███░ █░ █░ ████░█░█░██░████░ █░ █░█░██▀ █▄█░ ║ ║█░ █░█░ █░ █░ █░ █░ █▀ ▀█░█░ █░ █░██░█░█░█░ █░██░ █░ █░█░███░ █░ ║ ║█░ █░█░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░▀█▀ █░ █░ █░ █░ █░█░█ █░ █░ ║ ║█░ █░█░ █░ ███░███░██░█░ █░██░ ███░█░ █░ █░ ██░█░ █░ █░ ▀█▀ █ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO EOP, TJS LAB Page: 5 ■ INITIALIZATION If this is the initial entry into Physical Inventory, or you are about to start an inventory, you need to INITIALIZE the Physical Inventory database. Initialization means the removal of all records (ZAPPING) from the database PHYINV.DBF. Be very careful with this option; you do not want to ZAP all your counts DURING an inventory! DAYO EOP Version 3.0 TJS LAB ╔═══════════════════════════[ Physical Inventory ]═══════════════════════════╗ ║Before starting a Physical Inventory. You will need to initialize the ║ ║database: PHYINV.DBF. 'Initializing' is simply removing ALL records from the║ ║Physical Inventory database (PHYINV.DBF). ║ ║BE VERY CAREFUL YOU DO NOT INITIALIZED THE DATABASE AFTER YOU HAVE STARTED A║ ║NEW PHYSICAL INVENTORY! RECORDS ARE NOT RECOVERABLE! ║ ╟─────────────────[ INITIALIZE PHYSICAL INVENTORY DATABASE ]─────────────────╢ ║ ║ ║ ║ ║ Do you wish to Initialize your Physical Inventory Database? (Y/N) ║ ║ ║ ║ Are you really sure? (Y/N) ║ ║ ║ ║ ║ ║█▄███░█░█░█░ █░███░███░██░ █░ █░ ███░█░ █░█░█░██░█░ █░███░▄█▄ ███░█░ █░║ ║█░ █░█░█░█▄ ▄█░█░ █░ █░ █▀█░ █░ █░ ██░█░█░█░█░ ██░█░ █░ █░█░█░█░█░ █░║ ║█░ █░█░█░ █░█░ █░ █░ █░ █░█░ █░ █░ ██░█░█░█░█░ ██░█░ █░ █░█░█░█░▀█░█▀ ║ ║█▀██▀ ███░ █▄█░ ███░ █░ █░ ███░ █░ █░ ████░█░█░██░████░ █░ █░█░██▀ █▄█░ ║ ║█░ █░█░ █░ █░ █░ █░ █▀ ▀█░█░ █░ █░██░█░█░█░ █░██░ █░ █░█░███░ █░ ║ ║█░ █░█░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░▀█▀ █░ █░ █░ █░ █░█░█ █░ █░ ║ ║█░ █░█░ █░ ███░███░██░█░ █░██░ ███░█░ █░ █░ ██░█░ █░ █░ ▀█▀ █ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) If the indexes for the Physical Inventory database (PHYINV.DBF) are not current or missing, they will be reindexed at this time... ┌──────────────────────────────────────────────────────────┐ │ Database Name: PHYINV.DBF │ │ Index Name: PHYVENDI.NTX │ │ Number of Records: 0 │ │ ┌──────────────────────────────────────────────────┐ │ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 6 ■ PHYSICAL INVENTORY DATA ENTRY After initializing the Physical Inventory, you can start the data entry. You must first select the warehouse or location you are 'counting'. You will be presented with a selection of your main inventory (the ONHAND field in the database INV.DBF), and all the other warehouses (the LOCxxx fields found in the database WAREHOUS.DBF). DAYO EOP Version 3.0 TJS LAB ╔════════════════════[ SELECT WAREHOUSE FOR DATA ENTRY ]═════════════════════╗ ║This routine provides a data entry screen for the input of inventory counts.║ ║Physical Inventory counts must be grouped by the warehouse. The primary ║ ║warehouse is the Main Warehouse, which is ONHAND field in the database ║ ║INV.DBF. The other warehouses are found in the database WAREHOUS.DBF, which ║ ║have field names that begin with 'LOC', ie: LOC1, LOC2, LOC3,... ║ ║Note, the number of warehouses is determined by you. The default is 7. ║ ║ ║ ║ ║ ║ Select Warehouse -> MAIN Warehouse! ║ ║ LOC1 - Warehouse #1 RETURN TO VENDOR ║ ║ LOC2 - Warehouse #2 INTERNAL/OFFICE USE ║ ║ LOC3 - Warehouse #3 DISCONTINUED ║ ║ LOC4 - Warehouse #4 DAMAGED ║ ║ LOC5 - Warehouse #5 BUILDING # 1001 ║ ║ LOC6 - Warehouse #6 IN USE, SHOP FLOOR ║ ║ LOC7 - Warehouse #7 OUT ON LOAN ║ ║ LOC8 - Warehouse #8 ║ ║ LOC9 - Warehouse #9 ║ ║ LOC10 - Warehouse #10 ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO EOP, TJS LAB Page: 7 After defining the warehouse, you will be prompted to enter a location code, the ITEM, and the quantity. If you do not know the ITEM, or make an error entering the ITEM, a browse of the inventory will appear onto the screen. Find the ITEM you desire, then press Enter/Return to select it: DAYO EOP Version 3.0 TJS LAB ╔══════════════════[ Physical Inventory (Manual Version) ]═══════════════════╗ ║ Warehouse: MAIN Warehouse! ║ ║ Location: 453 ║ ║ Last Item: JAR-1 - Sample Item Description - AJ-123456 ║ ║ Last Quantity: 3 ║ ║ Total Records: 1 ║ ╟─────────────────[ DATA ENTRY FOR THE PHYSICAL INVENTORY ]──────────────────╢ ║ ║ ║ Location: AAA ║ ║ ║ ║ Item: ║ ║ ║ ║ Quantity: 0 ║ ║ ║ ╟──────────────────────────[ Select a Valid Item! ]──────────────────────────╢ ║ ITEM VENDITEM DESC VENDOR ║ ║──────────────╥──────────────╥────────────────────────────────╥─────────────║ ║ BLUE-383 ║ JP-2344 ║ PAINT, BLUE GREEN ║ JP PAINTS ║ ║ CYAN-3093 ║ JP-3039 ║ PAINT, CYAN TINT 3 ║ JP PAINTS ║ ║ MAGNENTA-3 ║ JP-3939 ║ PAINT, MAGENTA TINT A4 ║ JP PAINTS ║ ║ RED-39 ║ JP-0388 ║ PAINT, DARK RED ║ JP PAINTS ║ ║ WHITE-303 ║ JP-0382 ║ PAINT, PLAIN WHITE ENAMEL ║ JP PAINTS ║ Esc (Exit) F1(Help) F5(Item) F6(Desc) F7(Vendor) F8(VendItem) F9(Type) 1/3 ■ EDIT/BROWSE THE PHYSICAL INVENTORY DATABASE (PHYINV.DBF) Should you have any reason to edit the Physical Inventory count records, you can do so with this routine. Note, it is not recommended you do this without good and obvious reason.... DAYO EOP, TJS LAB Page: 8 DAYO EOP Version 3.0 TJS LAB ╔═══════════════════════════[ Physical Inventory ]═══════════════════════════╗ ║This routine is used to perform a physical inventory (count) of all items ║ ║that should be recorded in your inventory databases (INV.DBF & WAREHOUS.DBF)║ ║This process (End of Period Physical Inventory) can be performed as often as║ ║you wish, however, the amount of time and effort increases with the quantity║ ║of items in inventory... ║ ╟───────────────────[ EDIT/BROWSE THE PHYSICAL INVENTORY ]───────────────────╢ ║ CONTROLNO ITEM DESC QTY ║ ║──────────────╥──────────────╥────────────────────────────────╥─────────────║ ║ 1 ║ JAR-1000 ║ JAR, BIG ONE ║ 43 ║ ║ 1 ║ JAR-23S-AV ║ JAR, MOON ║ 5 ║ ║ 1 ║ JAR-35 ║ JAR, RED TYPE A ║ 8 ║ ║ 1 ║ JAR-56 ║ JAR, GREEN TYPE A ║ 70 ║ ║ 1 ║ JAR-67 ║ JAR, GREEN/RED TYPE A ║ 9 ║ ║ 1 ║ JAR-69 ║ JAR, BLUE TYPE B ║ 9 ║ ║ 1 ║ JAR-697A ║ JAR, 0LD STYLE 738 ║ 3 ║ ║ 1 ║ JAR-7347 ║ VASE, PORC. WHITE ON GREEN ║ 44 ║ ║ 1 ║ JAR-7777 ║ JAR, TEST - PLASTIC ║ 1 ║ Esc (Exit) F1 (Help) F2 (Edit) Find: F5(Item) F6(Desc) F7(Vendor) F8(VendItem) F9(Controlno) F10(Location) 1/1 Remember that there are more fields to the right of the screen. Press Ctrl End to get to the rightmost field/screen. Press F1 (Help) for more information on keys... DAYO EOP Version 3.0 TJS LAB ╔═══════════════════════════[ Physical Inventory ]═══════════════════════════╗ ║This routine is used to perform a physical inventory (count) of all items ║ ║that should be recorded in your inventory databases (INV.DBF & WAREHOUS.DBF)║ ║This process (End of Period Physical Inventory) can be performed as often as║ ║you wish, however, the amount of time and effort increases with the quantity║ ║of items in inventory... ║ ╟───────────────────[ EDIT/BROWSE THE PHYSICAL INVENTORY ]───────────────────╢ ║TIME COST WAREHOUSE LOCATION POSTED POSTDATE POSTTIME║ ║─────────╥────────────╥────────────╥──────────╥────────╥──────────╥─────────║ ║11:06:58 ║ 3455.02 ║ MAIN Wareh ║ AAA ║ F ║ / / ║ ║ ║11:11:08 ║ 566.06 ║ MAIN Wareh ║ AAA ║ F ║ / / ║ ║ ║11:36:28 ║ 451.00 ║ MAIN Wareh ║ AAB ║ F ║ / / ║ ║ ║11:46:56 ║ 51.60 ║ MAIN Wareh ║ DDE ║ F ║ / / ║ ║ Esc (Exit) F1 (Help) F2 (Edit) Find: F5(Item) F6(Desc) F7(Vendor) F8(VendItem) F9(Controlno) F10(Location) 1/1 DAYO EOP, TJS LAB Page: 9 ■ FULL SCREEN EDIT Like many DAYO Browse routines, you can press F2 to bring up a full screen data entry screen. This sometimes makes editing easier... DAYO EOP Version 3.0 TJS LAB ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ CONTROLNO: 1 │ │ ITEM: 1900001 │ │ DESC: CARDBOARD, BULK SHEETS 4 PLY │ │ QTY: 3 │ │ VENDITEM: 344123456 │ │ VENDOR: BOBO │ │ DATE: 02/01/90 │ │ TIME: 13:06:58 │ │ COST: 231.30 │ │ WAREHOUSE: MAIN Wareh │ │ LOCATION: AAA │ │ POSTED: F │ │ POSTDATE: / / │ │ POSTTIME: │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ FIND There are 6 find/search/index keys: F5 Item F6 Desc F7 Vendor F8 VendItem F9 Controlno F10 Location) ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter ITEM: JAR-99 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO EOP, TJS LAB Page: 10 ■ COUNT SHEET To facilitate the Physical Inventory, you can print out an inventory count sheet to use as a worksheet. It will look something like: Physical Inventory List/Report/Worksheet Page: 1 DISCOUNT MISSLES, INTERNATIONAL 04/01/90 11:27:02 Item VendItem Description Cost Count ------------ ------------ ----------------------------- ---------- ----- MISSLE-04 A3-3 MISSLE, HAND CARRIED 3000.00 _____ MISSLE-054 30393-293 MISSLE, TOWED 54 KT 3889.00 _____ MISSLE-074 43IKK30 MISSLE, ARMOR PERI 48004.00 _____ MISSLE-078 4310303 MISSLE, ARMOR RDD 103886.00 _____ MISSLE-089 49DL-DK MISSLE, PINKEYE 8999.00 _____ MISSLE-095 HERCU030 MISSLE, THOR 70000.00 _____ MISSLE-59 KILLEM93 MISSLE, LANCER 48955.00 _____ MISSLE-59S NUKEM939 MISSLE, ATOMIC SATCHEL 199001.01 _____ MISSLE-59Z BLAST93 MISSLE, STUN TEST - A 741.00 _____ MISSLE-59ZA 3A3-33 MISSLE, MOON/SPACE DEVICE 56377.00 _____ ■ VARIANCE REPORT Before posting the Physical Inventory, it will need to be reconciled. Reconciling variances between the Physical Inventory and the Perpetual Inventory is done with the Variance Report that will list any/all variances between the '2' inventories. The Variance Report has many print format options, (ie: Specific Warehouse, Index, Variances only, to Printer or File). This report can be run as often as you desire... DAYO EOP, TJS LAB Page: 11 DAYO EOP Version 3.0 TJS LAB ╔═══════════════════════════[ Physical Inventory ]═══════════════════════════╗ ║Use this report to print out and reconcile any variances between your ║ ║Physical ('what you count') and Perpetual ('what the inventory database says║ ║you have') databases. ║ ║This report should be kept on file to document any variances found. ║ ╟───────────────────[ PHYSICAL INVENTORY VARIANCE REPORT ]───────────────────╢ ║ ║ ║ Selected Warehouse -> ALL ║ ║ ║ ║ Selected Index -> ITEM ║ ║ ║ ║ Print only the variances? (Y/N) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: VARIANCE.TXT ║ ║Item Desc Physical Perpetual Variance Cost║ ║JAR-1 JAR-090A 1 1 0 .00║ ║JAR-2 JAR-0992 0 1 -1 -2.44║ ║JAR-3 JAR-0992D 3 2 1 397.89║ ║JAR-4 JAR-09922 3 3 0 .00║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby While I Print This Report! Press Esc to Abort The Variance report is printed in 4 parts: Part 1 of 4 (items found in inventory) Part 2 of 4 (inventory items not found) Part 3 of 4 (warehouse items not found) Part 4 of 4 (Totals) DAYO EOP, TJS LAB Page: 12 ■ EXAMPLE OF VARIANCE REPORT TOTALS The following is an example of the Variance Report Totals/Summary (Part 4 of 4): Main Inventory Main Positive/Gain Dollar Variance: $ 0.00 Main Negative/Loss Dollar Variance: $ -4.00 Combined Main Dollar Variance: $ -4.00 Physical Main Inventory Count: 3 Perpetual Main Inventory Count: 4 Main Inventory Count Variance: -1 Warehouse Inventories Whse Positive/Gain Dollar Variance: $ 0.00 Whse Negative/Loss Dollar Variance: $ -397.00 Combined Whse Dollar Variance: $ -397.00 Physical Warehouse Inventory Count: 0 Perpetual Warehouse Inventory Count: 400 Warehouse Inventory Count Variance: -400 Summary Total Positive/Gain Dollar Variance: $ 0.00 Total Negative/Loss Dollar Variance: $ -401.00 Combined Total Dollar Variance: $ -401.00 Total Physical Inventory Count: 3 Total Perpetual Inventory Count: 404 Combined Count Variance: -401 ■ PHYSICAL INVENTORY POST When you are finished counting and reconciling your Physical Inventory, you will POST it to the Perpetual Inventory (Replace the Perpetual with the Physical). This FINAL PROCESS should be accomplished after a backup of the databases INV.DBF and WAREHOUS.DBF. DAYO EOP, TJS LAB Page: 13 If for some reason you attempt to RePost the Physical to the Perpetual Inventory, you will be alerted the the fact, and be requested to verify that you wish to continue... DAYO EOP Version 3.0 TJS LAB ╔════════════════════════[ PHYSICAL INVENTORY POST ]═════════════════════════╗ ║This routine is the final step to the Physical Inventory Process. Run this ║ ║option after all inventory items have been counted and you are satisfied ║ ║with the variances (the Variance Report). The ONHAND field in the database ║ ║INV.DBF and the LOCxxx fields in the database WAREHOUS.DBF will be zeroed ║ ║out, then replaced with the quantities from the Physical Inventory database.║ ║Be sure to backup your inventory databases before continuing... ║ ║ ║ ║ This file appears to have been posted already! ║ ║ ║ ║ Date Last Posted: 04/01/90 ║ ║ Time Last Posted: 12:06:34 ║ ║ Number of Lines: 325 ║ ║ Number of pieces: 2355 ║ ║ Value of Last Post: 23003.32 ║ ║ Posted By: Laura Morgan ║ ║ ║ ║ Do you still want to continue? (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO EOP, TJS LAB Page: 14 For your entertainment, the Posting process is graphically illustrated. The Posting process comprises 3 phases, the zeroing of the Main Warehouse INV.DBF, the zeroing of the Other Warehouses (WAREHOUS.DBF), and then the replacement of quantities in these 2 databases from the physical count (in the database PHYINV.DBF). DAYO EOP Version 3.0 TJS LAB ╔════════════════════════[ PHYSICAL INVENTORY POST ]═════════════════════════╗ ║This routine is the final step to the Physical Inventory Process. Run this ║ ║option after all inventory items have been counted and you are satisfied ║ ║with the variances (the Variance Report). The ONHAND field in the database ║ ║INV.DBF and the LOCxxx fields in the database WAREHOUS.DBF will be zeroed ║ ║out, then replaced with the quantities from the Physical Inventory database.║ ║Be sure to backup your inventory databases before continuing... ║ ║Zero Inventory (Set OHNAND = 0) ║ ║╓─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─╖ ║ ║║███████████████████████████████████████████████████████████████████████║ ║ ║╙─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─╜ ║ ║0% 25% 50% 75% Done!║ ║Zero Warehouses (Set LOCxxx = 0) ║ ║╓─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─╖ ║ ║║███████████████████████████████████████████████████████████████████████║ ║ ║╙─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─╜ ║ ║0% 25% 50% 75% Done!║ ║Posting Physical Inventory (Replace ONHAND & LOCxxx with PHYINV.DBF Qty) ║ ║╓─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─┬─┬─╥─┬─┬─┬─┬─┬─┬─┬─╖ ║ ║║███████████████████████████████████████████████████████████████████████║ ║ ║╙─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─┴─┴─╨─┴─┴─┴─┴─┴─┴─┴─╜ ║ ║0% 25% 50% 75% Done!║ ╚════════════════════════════════════════════════════════════════════════════╝ Total Inventory Value: $******23432.32 Note the value of the Physical Inventory is briefly displayed onto the screen! DAYO EOP, TJS LAB Page: 15 ■ ACCOUNTS RECEIVABLES POST & PACK This option permanently removes deleted records from the Accounts Receivable databases: INVOICE APPLIED DETAIL BO TYPE SERIALNO TAXCODE RECEIPTS TERMS TOPCUS SHIPPER QUOTES CUSTOMER QUOTESD CUSTMEMO REGISTER SALESPER PB ARH SALESPER ARD TEMPLATE It is highly recommended that you create backups of all these databases before starting this process. Be sure that nothing interrupts/disturbs this process while it is processing... DAYO EOP Version 3.0 TJS LAB ╔═════════════════════[ Accounts Receivables Post & Pack ]═══════════════════╗ ║ This routine is used to permanently remove deleted records from the ║ ║ Accounts Receivable Databases. A full backup of all your databases ║ ║ should be accomplished prior to running this routine! Also note, that ║ ║ this routine is NOT Multiuser! This routine will access the following ║ ║ databases exclusively: INVOICE, DETAIL, TYPE, TAXCODE, TERMS, SHIPPER, ║ ║ CUSTOMER, CUSTMEMO, SALESPER, ARH, ARD, APPLIED, BO, SERIALNO, RECEIPTS, ║ ║ TOPCUS, QUOTES, QUOTESD, REGISTER, PB, SALESPER, TEMPLATE. ║ ║ ║ ║ It is highly recommended that ALL databases be reindexed after this PACK! ║ ║ ║ ║ Do you wish to start the AR Pack? (Y/N) ║ ║ ║ ║ Are you sure? (Y/N) ║ ║ ║ ║ ██░ ██▄████░ ██▄████░ ██░ ▄█████░ ██░ ██░ ║ ║ ████░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ ██░ ██░ ███████░ ██▀████░ ██░ ██░ ██░ ████░ ║ ║ ▄████████▄ ██▀██▄ ██░ ▄████████▄ ██░ ██▀██░ ║ ║ ██▀ ▀██░ ██░ ██▄ ██░ ██▀ ▀██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ▀█████░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO EOP, TJS LAB Page: 16 The progress of the DAYO AR PACK is display/scrolled upon the screen: ╔══════════════════════════════════════════════╗ ║Packing \DAYOPOS\SERIALNO.dbf ║ ║Packing \DAYOBO\BO.dbf ║ ║Packing \DAYOPOS\DETAIL.dbf ║ ║Packing \DAYOPOS\INVOICE.dbf ║ ║Packing \DAYOAR\CUSTOMER.DBF ║ ╚══════════════════════════════════════════════╝ After the pack is finished, you will be prompted to print the AR Pack Log. Note, the AR Pack routine creates a report/text file with the name of ARPACK.LOG. ╔════════════════════════════════════════════════╗ ║ ║ ║ Do you wish to print the AR Pack Error Log ║ ║ and Report? (Y/N) ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════╝ The AR Pack log file will look something like: 04/01/90 Accounts Receivable Pack Log/Report 13:12:13 PACK FAILED for \DAYOPOS\INVOICE PACK FAILED for \DAYOPOS\TERMS PACK FAILED for \DAYOQUO\QUOTES PACK FAILED for \DAYOAR\CUSTOMER DAYO EOP, TJS LAB Page: 17 ■ ACCOUNTS PAYABLE POST & PACK This option permanently removes deleted records from the Accounts Payable databases: INV VENDORS POH REC POD DEPOSITS APH ACCOUNTS APD EXPENSES INVADJ CHECKS WAREHOUS CFORMAT WARENAME RECHECK It is highly recommended that you create backups of all these databases before starting this process. Be sure that nothing interrupts/disturbs this process while it is processing... DAYO EOP Version 3.0 TJS LAB ╔══════════════════════[ Accounts Payables Post & Pack ]═════════════════════╗ ║ This routine is used to permanently remove deleted records from the ║ ║ Accounts Payable Databases. A full backup of all your databases ║ ║ should be accomplished prior to running this routine! Also note, that ║ ║ this routine is NOT Multiuser! This routine will access the following ║ ║ databases exclusively: INV, POH, POD, APH, APD, INVADJ, WAREHOUS, ║ ║ WARENAME, VENDORS, REC, DEPOSITS, ACCOUNTS, EXPENSES, CHECKS, ║ ║ CFORMAT, RECHECK. ║ ║ ║ ║ It is highly recommended that ALL databases be reindexed after this PACK! ║ ║ ║ ║ Do you wish to start the AP Pack? (Y/N) ║ ║ ║ ║ Are you sure? (Y/N) ║ ║ ║ ║ ██░ ██▄████░ ██▄████░ ██░ ▄█████░ ██░ ██░ ║ ║ ████░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ║ ║ ██░ ██░ ██▀████░ ██▀████░ ██░ ██░ ██░ ████░ ║ ║ ▄████████▄ ██░ ██░ ▄████████▄ ██░ ██▀██░ ║ ║ ██▀ ▀██░ ██░ ██░ ██▀ ▀██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ▀█████░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO EOP, TJS LAB Page: 18 The progress of the DAYO AP PACK is display/scrolled upon the screen: ╔════════════════════════════════════════════════╗ ║Packing \DAYOINV\POH.dbf ║ ║Packing \DAYOINV\INVADJ.dbf ║ ║Packing \DAYOINV\WARENAME.dbf ║ ║Packing \DAYOINV\WAREHOUS.dbf ║ ║Packing \DAYOINV\INV.dbf ║ ╚════════════════════════════════════════════════╝ After the pack is finished, you will be prompted to print the AP Pack Log. Note, the AP Pack routine creates a report/text file with the name of APPACK.LOG. ╔════════════════════════════════════════════════╗ ║ ║ ║ Do you wish to print the AP Pack Error Log ║ ║ and Report? (Y/N) ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════╝ The AP Pack log file will look something like: 04/01/90 Accounts Payable Pack Log/Report 13:12:13 PACK FAILED for \DAYOINV\INV PACK FAILED for \DAYOINV\VENDORS PACK FAILED for \DAYOINV\POD PACK FAILED for \DAYOAP\DEPOSITS DAYO EOP, TJS LAB Page: 19 ■ CLEANUP DAYO REPORT FILES All DAYO Modules have the option of printing reports to disk. This can cut down on paper since you can view/read your reports with your favorite editor/word processor. This process can also create a problem; lack of disk space! DAYO Cleanup is the module you can use periodically to 'cleanup' (delete) all unnecessary DAYO Report Files. DAYO EOP Version 3.0 TJS LAB ╔════════════════════════[ Cleanup DAYO Report Files ]═══════════════════════╗ ║ This routine is used to permanently remove & erase all DAYO report files. ║ ║ Report files are assumed to have the extension of '.TXT', ie: ARPACK.TXT.║ ║ ║ ║ IT IS A GREAT IDEA TO MAKE A FULL BACKUP BEFORE USING THIS ROUTINE! ║ ║ ║ ║ DO NOT RUN THIS ROUTINE IF YOU HAVE ANY FILES WITH THE EXTENSION OF .TXT ║ ║ THAT YOU WISH TO KEEP! ║ ║ ║ ║ IF IN DOUBT, DO NOT USE THIS ROUTINE! ║ ║ ║ ║ Do you wish to start the Report Cleanup? (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ ▄█████░ ██░ █████░ ██░ ██░ ██░ ██░ ██░ ██▄████░ ║ ║ ██░ ██░ ██░ ████░ ███░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ █░ █░ ████▄██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ████░ ▄████▄ ██▀████░ ██░ ██░ ██▀████░ ║ ║ ██░ ██░ ██░ ██▀▀██░ ██░████░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ██░ ║ ║ ▀█████░ █████░ █████░ ██░ ██░ ██░ ██░ ▀████▀ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) This routine will delete only those files that have the extension of '.TXT', and reside in a DAYO directory. Use the CONFIGURATION routine (from the Main Menu), to edit the locations of the many DAYO modules that create reports... DAYO EOP, TJS LAB Page: 20 DAYO EOP Version 3.0 TJS LAB ╔════════════════════════[ Cleanup DAYO Report Files ]═══════════════════════╗ ║ Files with the extension of '.TXT' will be erased from the following ║ ║ drives/directories: ║ ║ Inventory Directory: \DAYOINV\ ║ ║ POS Directory: \DAYOPOS\ ║ ║ AR Directory: \DAYOAR\ ║ ║ AP Directory: \DAYOAP\ ║ ║ BackOrder Directory: \DAYOBO\ ║ ║ Price Book Directory: \DAYOPB\ ║ ║ Quotes Directory: \DAYOQUO\ ║ ║ Reports Directory: \DAYORPT\ ║ ║ Current Directory... ║ ║ ║ ║ Are you sure? (Y/N) ║ ║ ║ ║ ▄█████░ ██░ █████░ ██░ ██░ ██░ ██░ ██░ ██▄████░ ║ ║ ██░ ██░ ██░ ████░ ███░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ █░ █░ ████▄██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ████░ ▄████▄ ██▀████░ ██░ ██░ ██▀████░ ║ ║ ██░ ██░ ██░ ██▀▀██░ ██░████░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ██░ ║ ║ ▀█████░ █████░ █████░ ██░ ██░ ██░ ██░ ▀████▀ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) You have the option of deleting ALL files with the extension of '.TXT', or to confirm each one! Please be careful with the ALL option! The progress of the DAYO AR PACK is display/scrolled upon the screen: ╔════════════════════════════════════════════════╗ ║Delete? (Y/N) ║ ║Erasing File: \DAYOPOS\REGISTER.TXT ║ ║Not Erasing File: \DAYOPOS\REG.TXT ║ ║Erasing File: \DAYOINV\WAREHOUS.TXT ║ ║ ║ ╚════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 21 After the cleanup is completed, you will be prompted to print the Cleanup Log. Note, the Cleanup routine creates a report/text file with the name of CLEANUP.LOG. ╔════════════════════════════════════════════════╗ ║ ║ ║ Do you wish to print the Cleanup Log ║ ║ and Report? (Y/N) ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════╝ The Cleanup log file will look something like: 04/01/90 DAYO End of Period Cleanup of DAYO Report Files 13:13:52 Erasing File: \DAYOINV\WAREHOUS.TXT Not Erasing File: \DAYOPOS\REG.TXT Not Erasing File: \DAYOPOS\REGISTER.TXT DAYO EOP, TJS LAB Page: 22 ■ REPORTS There are 20+ DAYO EOP reports and routines, some having many options. The Reports menu: POS Header Inventory Expanded AP Header POS Detail Warehouse Quantities AP Detail PO Header ReOrder Deposits PO Detail Inventory Adjustments Configuration Settings Receiving Inventory Movement Printer Setup/Drivers AR Ageing Vendors Misc Expenses AP Summary Cash Receipts AP Check Register Customer Expanded DAYO EOP uses 36+ Dbase (tm) compatible Report Forms, ie: INVADJ.FRM RECEIPTS.FRM DETREGTM.FRM MISCX.FRM EXPANDED.FRM CUSXPAND.FRM DETREGTY.FRM POH3.FRM WAREHOUS.FRM REGTERMS.FRM DETAIL.FRM APH2.FRM REORDER.FRM REGTYPE.FRM DETITEM.FRM POH1.FRM MOVEMENT.FRM TERMS.FRM DETVEND.FRM APH.FRM POH.FRM TYPE.FRM DETSALP.FRM APH3.FRM POD.FRM SALESPER.FRM DETCUST.FRM POH2.FRM VENDORS.FRM INVCUST.FRM CHECKS.FRM APH1.FRM REC.FRM INVOICE.FRM DEPOSITS.FRM APD.FRM ■ REPORTS MENU DAYO EOP Version 3.0 TJS LAB REPORTS ┌───[February 1991]──┐ ╔═════════════════════════╗ │S M T W T F S │ ║ EOP REPORTS ║█▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟─────────────────────────╢█░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ POS Header ║█░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ POS Detail ║█░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ PO Header ║█░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ PO Detail ║█▀██▀ █░ █░ █░ ▀███▀ │29 30 │ ║ Receiving ║ │ │ ║ AR Ageing ║ └────────────────────┘ ║ AP Summary ║ ║ AP Check Register ║ ████░ █░ █░ █▄██▄ ▄███▄ ████░ ║ Deposits ║ █░ ██░ █░ █░ █░ █░ █░ █░ ║ Misc Expenses ║ ███░ ███░█░ █░ █░ █░ █░ ████░ ║ Inventory Expanded ║ █░ █▀███░ █░ █░ █░ █░ █░ ║ Warehouse Quantities ║ █░ █░▀██░ █░ █░ █░ █░ █░ ║ ReOrder ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░ ║ Inventory Adjustments ║ ║ Inventory Movement ║/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄ ║ Vendors ║:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ Cash Receipts ║ █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░ ╟─────────────────────────╢ █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░ ║ Select Option ║ █░ █░ █░ ▀█░ █░ █░ █░ █░ █░ ╚═════════════════════════╝ █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀ DAYO EOP, TJS LAB Page: 23 ■ POS HEADER REPORTS ╔═══════════════════════════════════════════════════════╗ ║The Point of Sale (POS) Header Reports derive their ║ ║data from the database: INVOICE.DBF. ║ ║Creation of a temporary index is required for all but ║ ║the last two reports (by Customer and/or Invoice). ║ ║ ║ ║Select Report -> Register by Terms ║ ║ Register by Type ║ ║ Invoice Terms ║ ║ Invoice Type ║ ║ Sales Person ║ ║ Customer Number ║ ║ Invoice Number ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ╔═════════════════════════════════════════════════════╗ ║The Point of Sale (POS) Header Reports derive their ║ ║data from the database: INVOICE.DBF. ║ ║Creation of a temporary index is required for all but║ ║the last two reports (by Customer and/or Invoice). ║ ║ ║ ║Select Report -> Invoice Type ║ ║ ║ ║Print All? (Y/N) ║ ║( N -> prompts for specific Type ) ║ ║ ║ ║Enter Type Code: AAA ║ ║ ║ ║Start Date: 04/01/90 Ending Date: 04/01/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: Type.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ╚═════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 24 ■ POS DETAIL REPORTS ╔═══════════════════════════════════════════════════════╗ ║The Point of Sale (POS) Detail Reports derive their ║ ║data from the databases: DETAIL.DBF, INVOICE.DBF, ║ ║and INV.DBF. Creation of a temporary index is ║ ║required for all but the Invoice and Item Reports. ║ ║ ║ ║Select Report -> Register by Terms ║ ║ Register by Type ║ ║ Invoice ║ ║ Item ║ ║ Vendor Item ║ ║ Sales Person ║ ║ Customer ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ╔═══════════════════════════════════════════════════════╗ ║The Point of Sale (POS) Detail Reports derive their ║ ║data from the databases: DETAIL.DBF, INVOICE.DBF, ║ ║and INV.DBF. Creation of a temporary index is ║ ║required for all but the Invoice and Item Reports. ║ ║ ║ ║Select Report -> Register by Terms ║ ║ ║ ║Print All? (Y/N) ║ ║( N -> prompts for specific Register ) ║ ║ ║ ║Enter Register Number: 1 ║ ║ ║ ║Start Date: 04/01/90 Ending Date: 04/01/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: Register.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ╚═══════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 25 ■ PURCHASE ORDER HEADER REPORT ╔════════════════════════════════════════════════════════╗ ║ The Purchase Order (PO) Header Report lists all Open ║ ║ and/or Closed POH.DBF records. ║ ║ ║ ║ The name of the PO Header Report Form is POH.FRM. ║ ║ ║ ║ Select the Index -> PURCHASE ORDER (PO) ║ ║ VENDOR NAME (NAME) ║ ║ VENDOR CODE (VENDOR) ║ ║ ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: POHEADER.TXT ║ ║ ║ ║ Select the Option ->Open POs ║ ║ Closed POs ║ ║ All POs ║ ║ Start Date: 04/02/85 Ending Date: 04/01/90 ║ ╚════════════════════════════════════════════════════════╝ ■ PURCHASE ORDER DETAIL REPORT ╔════════════════════════════════════════════════════════╗ ║ The Purchase Order (PO) Detail Report lists all Open ║ ║ and/or Closed POD.DBF records. ║ ║ ║ ║ The name of the PO Detail Report Form is POD.FRM. ║ ║ ║ ║ Select the Index -> PURCHASE ORDER (PO) ║ ║ ITEM (ITEM) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> T ║ ║ ║ ║ Enter File Name: PODETAIL.TXT ║ ║ ║ ║ Select the Option ->Open POs (Received <> Ord ║ ║ Closed POs (Received = Order ║ ║ All POs ║ ║ Start Date: 04/02/85 Ending Date: 04/01/90 ║ ╚════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 26 ■ RECEIVING REPORT ╔════════════════════════════════════════════════════════╗ ║ The Receiving Report is a printout of your Receivers; ║ ║ all receipts of your Items. ║ ║ ║ ║ The name of the Receiving Report Form is REC.FRM. ║ ║ ║ ║ Select the Index -> RECEIVER (KEY ║ ║ PURCHASE ORDER (PO) ║ ║ ITEM (ITEM) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> T ║ ║ ║ ║ Enter File Name: REC.TXT ║ ║ ║ ║ ║ ║ Start Date: 04/02/85 Ending Date: 04/01/90 ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ ACCOUNTS RECEIVABLE AGEING SUMMARY REPORT ╔═══════════════════════════════════════════════════════╗ ║The Ageing Summary Report prints all customers with ║ ║an Outstanding Receivables Balance (DUE<>0). ║ ║Includes sum of invoices (INVOICE.DBF), and cash ║ ║receipts (RECEIPTS.DBF). ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: AGESUM.TXT ║ ║ ║ ║Print Only Non-Zero Balance Customers? (Y/N) ║ ║ ║ ║Print Only Past Due Accounts? (Y/N) ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 27 ■ ACCOUNTS PAYABLE HEADER REPORT ╔════════════════════════════════════════════════════════╗ ║ The AP (Payables) Header Report lists all Open ║ ║ and/or Closed APH.DBF records. Multiple Indexes. ║ ║ ║ ║ The name of the AP Header Report Form is POHx.FRM. ║ ║ ║ ║ Select the Index -> WORK ORDER (WO) ║ ║ ║ ║ ║ ║ ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> T ║ ║ ║ ║ Enter File Name: APHEADER.TXT ║ ║ ║ ║ Select the Option ->Open Payable ║ ║ Closed Payab ║ ║ All Payables ║ ║ Start Date: 06/24/86 Ending Date: 06/23/91 ║ ╚════════════════════════════════════════════════════════╝ ■ ACCOUNTS PAYABLE DETAIL REPORT ╔════════════════════════════════════════════════════════╗ ║ The AP (Payables) Detail Report lists all Open ║ ║ and/or Closed APD.DBF records. Multiple Indexes. ║ ║ ║ ║ The name of the AP Detail Report Form is POD.FRM. ║ ║ ║ ║ Select the Index -> PURCHASE ORDER (PO) ║ ║ ITEM (ITEM) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> T ║ ║ ║ ║ Enter File Name: APDETAIL.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Start Date: 06/24/86 Ending Date: 06/23/91 ║ ╚════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 28 ■ ACCOUNTS PAYABLE SUMMARY REPORT ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ ║ ║ The Accounts Payable Summary is a 4 part report: ║ ║ 1. Accounts Payable ║ ║ 2. Deposits ║ ║ 3. Checks ║ ║ 4. Accounts Balances ║ ║ 5. Expenses ║ ║ ║ ║ Start Date: 03/02/90 Ending Date: 04/01/9 ║ ║ ║ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> T ║ ║ ║ ║ Enter File Name: APSUM.txt ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ ACCOUNTS PAYABLE CHECKS REPORT ╔═══════════════════════════════════════════════════════╗ ║The AP Checks Report is a listing of all your checks. ║ ║Supports a date range... ║ ║ ║ ║ ║ ║ ║ ║Enter Checking Account: ALL ║ ║ ║ ║Start Date: 03/02/90 Ending Date: 04/01/90 ║ ║ ║ ║Select Index -> Journal # ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CHECKS.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 29 ■ DEPOSITS REPORT ╔═══════════════════════════════════════════════════════╗ ║The Deposits Report is a list of all your checking ║ ║account deposits for a selected date range. Default ║ ║range is the past 30 days. You can select 1 or ALL ║ ║checking accounts. ║ ║ ║ ║Enter Checking Account: ALL ║ ║ ║ ║Start Date: 03/02/90 Ending Date: 04/01/90 ║ ║ ║ ║Select Index -> Account # ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: DEPOSITS.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ MISCELLANEOUS EXPENSES REPORT ╔═══════════════════════════════════════════════════════╗ ║The Miscellaneous Expenses Report lists all MISC ║ ║expenses for a selected date range. Default range ║ ║is the past 30 days. ║ ║ ║ ║Start Date: 03/02/90 Ending Date: 04/01/90 ║ ║ ║ ║Select Index -> Expense # ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: MISCX.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 30 ■ EXPANDED INVENTORY REPORT ╔════════════════════════════════════════════════════════╗ ║ The Default Expanded Inventory Report (EXPANDED.FRM) ║ ║ contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VENDOR ║ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ Enter Heading: EXPANDED REPORT ║ ║ Send Output to Printer? (Y/N) ( No -> To F ║ ║ Enter File Name: EXPANDED.TXT ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ WAREHOUSE REPORT ╔════════════════════════════════════════════════════════╗ ║ The Warehouse Report is used to report all quantities ║ ║ in the databases: INV.DBF & WAREHOUS.DBF ║ ║ ║ ║ The following fields/variables are contained in the ║ ║ Default Warehouse Report Form (WAREHOUS.FRM): ║ ║ ITEM LOC1 LOC5 ║ ║ VENDITEM LOC2 LOC6 ║ ║ DESC LOC3 LOC7 ║ ║ ONHAND LOC4 TOTAL ║ ║ Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ Enter Heading: TJS LAB ║ ║ Send Output to Printer? (Y/N) ( No -> To F ║ ║ Enter File Name: WAREHOUS.TXT ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 31 ■ REORDER REPORT ╔════════════════════════════════════════════════════════╗ ║ The ReOrder Report is used to alert you to shortages ║ ║ in the inventory database (INV.DBF). ║ ║ This report can be used as an Excess Report. ║ ║ The following fields/variables are contained in the ║ ║ ReOrder Report Form (REORDER.FRM): ║ ║ ITEM ONORDER EXTENDED COST ║ ║ VENDITEM STOCKLEVEL ║ ║ DESC REORDER ║ ║ ONHAND COST ║ ║ Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ Enter Heading: TJS LAB ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: REORDER.TXT ║ ║ Include Negative ReOrder Quantities? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ INVENTORY ADJUSTMENTS ╔════════════════════════════════════════════════════════╗ ║ This report prints out all recorded inventory ║ ║ adjustments for a given date range. ║ ║ The Report Form Name is INVADJ.FRM and reports ║ ║ the following fields (from the INVADJ.DBF): ║ ║ ITEM VENDITEM QTY ║ ║ COST PRICE RETAIL ║ ║ DOLLARS REASON DATE ║ ║ ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To F ║ ║ ║ ║ Enter File Name: ADJUST.TXT ║ ║ ║ ║ ║ ║ Start Date: 03/02/90 Ending Date: 04/01/90 ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 32 ■ INVENTORY MOVEMENT ╔════════════════════════════════════════════════════════╗ ║ The Movement Report tells you what items are selling/ ║ ║ moving in the inventory database (INV.DBF). ║ ║ Requires input of all sales (for each Item), into the ║ ║ SOLDPTD field, or the use of DAYO POS. ║ ║ The following fields/variables are contained in the ║ ║ Movement Report Form (MOVEMENT.FRM): ║ ║ ITEM COST SOLDPTD ║ ║ VENDITEM PRICE SOLDYTD ║ ║ DESC ONHAND ║ ║ VENDOR ONORDER ║ ║ Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ Enter Heading: TJS LAB ║ ║ Send Output to Printer? (Y/N) ( No -> To Fi ║ ║ Enter File Name: MOVEMENT.TXT ║ ║ Include Zero SOLDPTD Items? (Y/N) ║ ╚════════════════════════════════════════════════════════╝ ■ VENDORS REPORT ╔════════════════════════════════════════════════════════╗ ║ The Vendors Report is a printout of your Vendors.dbf. ║ ║ ║ ║ The name of the Vendors Report Form is VENDORS.FRM. ║ ║ ║ ║ ║ ║ Select the Index -> VENDOR CODE (VENDOR) ║ ║ VENDOR NAME (NAME) ║ ║ ║ ║ ║ ║ Enter Heading: TJS LAB ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> T ║ ║ ║ ║ Enter File Name: VENDORS.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 33 ■ CASH RECEIPTS ╔════════════════════════════════════════════════════════╗ ║ The Cash Receipts Report is a printout of all Cash ║ ║ Receipts records in the database RECEIPTS.DBF. ║ ║ ║ ║ Option to select from 3 indexes; Journal #, ║ ║ Customer #, or Invoice #. ║ ║ ║ ║ Report Form RECEIPTS.FRM. ║ ║ ║ ║ Select Index -> Journal Number ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To F ║ ║ ║ ║ Enter File Name: RECEIPTS.TXT ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ CUSTOMER EXPANDED REPORT ╔════════════════════════════════════════════════════════╗ ║ The Customer Expanded Report contains as much data ║ ║ for each customer that can fit onto a 132 character ║ ║ wide printout. ║ ║ ║ ║ Report Form Name: CUSXPAND.FRM. ║ ║ ║ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To F ║ ║ ║ ║ Enter File Name: CUSXPAND.TXT ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO EOP, TJS LAB Page: 34 ■ CONFIGURATION STATUS REPORT ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOEOP.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CONFIGURATION STATUS REPORT DEFAULT CONFIGURATION SETTINGS +++++++++++++++++++++++++++++++++++++++++++ + DAYO END OF PERIOD CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++ 04/01/90 14:43:11 Company Name: YOUR COMPANY, INC Address Line 1: Attn: Management Address Line 2: P.O. BOX 5555 City, State Zip: ANYCITY, ST 55555-5555 Telephone: 800-555-5555 Inventory Database Location: \DAYOINV\ Customer Database Location: \DAYOAR\ Quotes Database Location: \DAYOQUO\ BackOrder Database Location: \DAYOBO\ PriceBook Database Location: \DAYOPB\ POS Database Location: \DAYOPOS\ AP Database Location: \DAYOAP\ Smart Reports Location: \DAYORPT\ Report Printer Type: STANDARD Report Printer Port: LPT1 Color: Yes High Intensity: Yes DAYO EOP, TJS LAB Page: 35 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change (mess with) the printer to get it to print correctly. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO EOP, TJS LAB Page: 36 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO EOP, TJS LAB Page: 37 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO EOP, TJS LAB Page: 38 ■ CONFIGURATION The configurations settings (15 of them), are all accessed from within the CONFIGURATION menu (option 6 from the main menu). DAYO EOP Version 3.0 TJS LAB CONFIG ┌───[February 1991]──┐ ╔════════════════════════╗ │S M T W T F S │ ║ CONFIGURATION ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ Company Name ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ Company Address ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ Company Telephone ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ Inventory Location ║ █▀██▀ █░ █░ █░ ▀███▀ │29 30 │ ║ POS Location ║ │ │ ║ Customer (AR) Location ║ └────────────────────┘ ║ AP Location ║ ║ Quotes Location ║ ████░ █░ █░ █▄██▄ ▄███▄ ████░ ║ Back Orders Location ║ █░ ██░ █░ █░ █░ █░ █░ █░ ║ Price Book Location ║ ███░ ███░█░ █░ █░ █░ █░ ████░ ║ Smart Reports Location ║ █░ █▀███░ █░ █░ █░ █░ █░ ║ Report Printer Type ║ █░ █░▀██░ █░ █░ █░ █░ █░ ║ Report Printer Port ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░ ║ Color ║ ║ High Intensity ║1/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄ ╟────────────────────────╢6:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ Select Option ║ █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░ ╚════════════════════════╝ █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░ Value of Last Post: 3.00 █░ █░ █░ ▀█░ █░ █░ █░ █░ █░ Posted By: TLJ █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀ ■ CONFIGURATION LISTING Company Name Back Orders Location Company Address Price Book Location Company Telephone Smart Reports Location Inventory Location Report Printer Type POS Location Report Printer Port Customer (AR) Location Color AP Location High Intensity Quotes Location DAYO EOP, TJS LAB Page: 39 ■ COMPANY NAME, ADDRESS & TELEPHONE Each field for this option is limited to 30 characters, 14 for the telephone... ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY, INC │ └────────────────────────────────────────────────────────────────────────────┘ ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Accounting │ │ Address Line 2: P.O. BOX 5555 │ │ City, State ZIP: ANYCITY, ST 55555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ 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 EOP. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO EOP 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 EOP). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ┌────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]────────────┐ │ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be │ │ in the same drive/directory as DAYO EOP. If you have installed the │ │ DAYO POS Databases, into a different directory, you need to tell DAYO │ │ EOP where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO End of Period). │ │ │ │ Enter Location: \DAYOPOS\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 40 ■ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ┌───────────────[ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ]────────────────┐ │ The location of the DAYO Customer and other AR databases does not have to │ │ be in the same drive/directory as DAYO EOP. If you have installed the │ │ DAYO Customer/AR Databases, into a different directory, you need to tell │ │ DAYO End of Period where to find them. Default is nil (current │ │ directory). Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO EOP). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY ┌─────────────[ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY ]──────────────┐ │ The location of the DAYO AP files (ie: APH.DBF) does not have to be │ │ in the same drive/directory as DAYO EOP. If you have installed the │ │ DAYO AP Databases, into a different directory, you need to tell DAYO │ │ EOP where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAP\ │ │ The drive designation is optional (if same as DAYO EOP). │ │ │ │ Enter Location: \DAYOAP\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ QUOTES DATABASE LOCATION/DIRECTORY ┌───────────────────[ QUOTES DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Quotes Database (QUOTES.DBF) does not have to be │ │ in the same drive/directory as DAYO EOP. If you have installed DAYO │ │ Quotes into a different directory, you need to tell DAYO EOP where to │ │ find the quotes database (QUOTES.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOQUO\ │ │ The drive designation is optional (if same as DAYO EOP). │ │ │ │ Enter Location: \DAYOQUO\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 41 ■ BACKORDERS DATABASE LOCATION/DIRECTORY ┌─────────────────[ BACKORDERS DATABASE LOCATION/DIRECTORY ]─────────────────┐ │ The location of the DAYO BackOrder Database (BO.DBF) does not have to │ │ be in the same drive/directory as DAYO EOP. If you have installed DAYO │ │ BO into a different directory, you need to tell DAYO EOP where to find │ │ the BackOrder database (BO.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOBO\ │ │ The drive designation is optional (if same as DAYO EOP). │ │ │ │ Enter Location: \DAYOBO\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRICE BOOK DATABASE LOCATION/DIRECTORY ┌─────────────────[ PRICE BOOK DATABASE LOCATION/DIRECTORY ]─────────────────┐ │ The location of the DAYO Price Book Database (PB.DBF) does not have to be │ │ in the same drive/directory as DAYO EOP. If you have installed DAYOPB │ │ into a different directory, you need to tell DAYO EOP where to find │ │ the price book database (PB.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPB\ │ │ The drive designation is optional (if same as DAYO EOP). │ │ │ │ Enter Location: \DAYOPB\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ SMART REPORTS LOCATION/DIRECTORY ┌────────────────────[ SMART REPORTS LOCATION/DIRECTORY ]────────────────────┐ │ The location of the DAYO Smart Reports program does not have to be in the │ │ same drive/directory as DAYO End of Period. If you have installed DAYO │ │ Smart Reports into a different directory, you need to tell DAYO EOP where │ │ to find the Smart Reports. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYORPT\ │ │ The drive designation is optional (if same as DAYO EOP). │ │ │ │ Enter Location: \DAYORPT\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 42 ■ REPORT PRINTER TYPE ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR To activate a color change, you must completely exit DAYO EOP, then reenter. ┌─────────────────────────────[ 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 EOP, TJS LAB Page: 43 ■ 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 EOP Version 3.0 TJS LAB ┌───[February 1991]──┐ ╔════════════════════╗─╖ │S M T W T F S │ ║ MISC ROUTINES ║ ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢─╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ BROWSE DATABASES ║─╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ CREATE DATABASE ║─╢ █▀██▀ █░ █░ █░ ▀███▀ │29 30 │ ║ DELETE RECORDS ║ ║ │ │ ║ ERASE FILE ║─╢ └────────────────────┘ ║ EXIT TO DOS ║ ║ ║ INDEX A DATABASE ║─╢ ████░ █░ █░ █▄██▄ ▄███▄ ████░ ║ LIST FIELDS ║ ║ █░ ██░ █░ █░ █░ █░ █░ █░ ║ PACK DATABASE ║─╢ ███░ ███░█░ █░ █░ █░ █░ ████░ ║ MODIFY DATABASE ║ ║ █░ █▀███░ █░ █░ █░ █░ █░ ║ RECALL RECORDS ║─╢ █░ █░▀██░ █░ █░ █░ █░ █░ ║ RETURN TO MENU ║ ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░ ║ RUN (DOS COMMAND) ║═╝ ║ SIMPLE EDITOR ║04/01/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄ ║ SORT DATABASE ║12:06:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ TYPE (PRINT) FILE ║1 █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░ ║ ZAP DATABASE ║3 █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░ ╟────────────────────╢3.00 █░ █░ █░ ▀█░ █░ █░ █░ █░ █░ ║ Select Option ║TLJ █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀ ╚════════════════════╝ DAYO EOP, TJS LAB Page: 44 ■ 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 EOP, TJS LAB Page: 45 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENT.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 46 ■ BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. - An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO EOP, TJS LAB Page: 47 - 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 EOP, TJS LAB Page: 48 ■ 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 EOP, TJS LAB Page: 49 - The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 50 - 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 EOP, TJS LAB Page: 51 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO EOP, TJS LAB Page: 52 ■ DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... DAYO EOP, TJS LAB Page: 53 ■ 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 EOP, TJS LAB Page: 54 ■ 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 EOP, TJS LAB Page: 55 - 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 EOP, TJS LAB Page: 56 - 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 EOP, TJS LAB Page: 57 - 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 EOP, TJS LAB Page: 58 - 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 EOP, TJS LAB Page: 59 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 60 ■ RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU - Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO EOP, TJS LAB Page: 61 ■ 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 EOP, TJS LAB Page: 62 - 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 EOP, TJS LAB Page: 63 - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 64 - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO EOP, TJS LAB Page: 65 ┌────┐ │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 permanantly) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO EOP, TJS LAB Page: 66 ■ 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: ┌──────────────────────[ DAYOEOP 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: ┌───────────────────────[ DAYOEOP 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 EOP, TJS LAB Page: 67 - Editor help: ┌──────────────────────[ DAYOEOP 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 EOP, TJS LAB Page: 68 ■ 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 EOP Version 3.0 TJS LAB REPORTS ┌───[February 1991]──┐ ┌──────[ DAYO HELP Called by Program: DAYOEOP 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 DAYOEOP. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ 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 EOP, TJS LAB Page: 69 DAYO EOP Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌───────[ DAYO HELP Called by Program: DAYOEOP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOEOP.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 DAYOEOP 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 EOP, TJS LAB Page: 70 ■ DATABASE STRUCTURE Database: PHYINV.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CONTROLNO Numeric 8 1 8 2 ITEM Character 12 9 20 3 DESC Character 30 21 50 4 QTY Numeric 7 51 57 5 VENDITEM Character 12 58 69 6 VENDOR Character 10 70 79 7 DATE Date 8 80 87 8 TIME Character 8 88 95 9 COST Numeric 10 2 96 105 10 WAREHOUSE Character 10 106 115 11 LOCATION Character 3 116 118 12 POSTED Logical 1 119 119 13 POSTDATE Date 8 120 127 14 POSTTIME Character 8 128 135 ────────── ───── Total 136 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── CONTROLNO N 8 0 PHYINV.DBF Control Number COST N 10 2 " Cost of each ITEM DATE D 8 0 " Date counted DESC C 30 0 " Description of the ITEM ITEM C 12 0 " ITEM/Part/Product Number LOCATION C 3 0 " Location Code (BIN) for an ITEM POSTDATE D 8 0 " Date Posted to the Perpetual Inventory Databases (INV.DBF & WAREHOUS.DBF) POSTED L 1 0 " Posted to Perpetual (True/False) POSTTIME C 8 0 " Time Posted to the Perpetual Inventory QTY N 7 0 " Quantity counted TIME C 8 0 " Time record was created VENDITEM C 12 0 " Vendor/Manufacture's number for an ITEM VENDOR C 10 0 " Vendor Number WAREHOUSE C 10 0 " Warehouse quantity belongs to (ie: Main, LOCxxx ...) DAYO EOP, TJS LAB Page: 71 ■ DAYO EOP MAINTENANCE & QUIRKS - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Backups of your data and configuration files should take place daily! You have no doubt heard many 'scare' stories about losing data. They are all true! The key files that need to be backed up all have the extension of .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files are notes/memos. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. - If you must use dBase (tm) with DAYO EOP, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO EOP, TJS LAB Page: 72 ■ 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...