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

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

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

Wrap

Text File | 1991-09-10 | 533.1 KB | 6,903 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ██▄██████░ ▄███████▄ ▄██████▄ ║ ║ ██░ ██░ ██░ ██░ ▄██▀ ║ ║ ██░ ██░ ██▀ ▀██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██▀██████░ ██░ ██░ ▀█████▄ ║ ║ ██░ ██░ ██░ ▀██░ ║ ║ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ║ ║ ██░ ██▄ ▄██░ ▄██░ ║ ║ ██░ ██░ ██░ ▄██▀ ║ ║ ██░ ▀███████▀ ███████▀ ║ ║ ║ ║ ║ ║ POINT OF SALE ║ ║ ║ ║ BILLING AND INVOICING FOR THE DAYO MODULES ║ ║ ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO POS, 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: (407) 292-4708 - U.S. Mail: TJS LAB, Inc., 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 POS, TJS LAB Table of Contents Page Description ──── ─────────────────────────────────────────────────────── 1......INTRODUCTION 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 2......SETUP 3......MAIN MENU 3...... PASSWORD/NAME 4......OPEN REGISTER 5...... CREATING ADDITIONAL REGISTERS 5...... CLOSE REGISTER 7......BILLING & INVOICING 7......KEY INVOICE CONFIGURATION SETTINGS 8......KEY INVENTORY & CUSTOMER FIELDS 10......INVOICE INITIAL SCREEN 10......CREATE INVOICE 10...... INVOICE FROM WAREHOUSES 11...... SELECT CUSTOMER, IMPORT QUOTE, OR IMPORT ORDER 12...... IMPORT OPTIONS 13...... ADD CUSTOMER - CTRL N 13...... INVOICE DETAIL SCREEN 13...... ADD INVENTORY ITEM - CTRL N 13...... DISPLAY HISTORY OF SALES FOR SELECTED CUSTOMER - F10 *** 14...... SELECT DETAIL ITEM 15...... MULTIPLE PRICING 15...... ASSEMBLE/BUILD ENDITEMS (MRP) 16...... ENTERING SERIAL NUMBERS 16...... EDITING SELECTED DETAIL ITEMS 16...... RECALL A TEMPLATE 17...... COLLECT PAYMENT IN ADVANCE OF BACKORDERS 18...... FINAL INVOICE EDIT SCREEN 18...... CREDIT CARDS 19...... MULTIPLE TERMS 20...... MULTIPLE SHIPTOS 21...... FREIGHT PERCENTAGE 22...... LAST CHANCE TO ABORT INVOICE 23...... ENTER INVOICE NUMBER 23...... INVOICE/WORK ORDER NOTES 24...... DATABASE POSTING 25...... EXAMPLE OF STANDARD INVOICE 26...... EXAMPLE OF RECEIPT INVOICE 27...... BILL OF MATERIAL WORKSHEET 27...... EXAMPLE OF BILL OF MATERIAL WORKSHEET 28......BROWSE HEADER INVOICE RECORDS 28...... EDIT HEADER INVOICE RECORDS DAYO POS, TJS LAB Table of Contents Page Description ──── ─────────────────────────────────────────────────────── 29...... ADD A BLANK INVOICE HEADER RECORD 29...... DELETE INVOICE HEADER RECORD 30......BROWSE DETAIL INVOICE RECORDS 31...... ADD A BLANK INVOICE DETAIL RECORD 31...... DELETE INVOICE DETAIL RECORD 31......TEMPLATES 33...... CREATE NEW TEMPLATE 33...... DELETE TEMPLATE ITEM 33......REPRINT AN INVOICE (OR WORK ORDER) 34...... ADD COMMENTS TO WORK ORDER OR INVOICE 34......OPEN CASH DRAWER 35......VIEW INVENTORY 36...... FULL SCREEN VIEW - F2 37......VIEW CUSTOMER 38...... FULL SCREEN VIEW - F2 39...... CUSTOMER PROFILE/HISTORY 40......CUSTOMERS 41...... CUSTOMER FULL SCREEN EDIT 42......CONFIGURATION 43...... CONFIGURATION DEFAULT SETTINGS 44...... CONFIGURATION MENU 45...... COMPANY NAME, ADDRESS & TELEPHONE 45...... LAST CUSTOMER ACCOUNT NUMBER 45...... AUTOMATICALLY PRINT THE INVOICE 45...... LAST INVOICE NUMBER 46...... INVOICE PRINTER TYPE 46...... INVOICE PRINTER PORT 46...... INVOICE COPIES 46...... DEFAULT TAX CODE 47...... DEFAULT INVOICE TYPE 47...... OVERRIDE ONHAND 48...... POST RETURNS/REFUNDS 48...... CREATE BACKORDERS 48...... ALLOW BROWSE EDITING 48...... ALLOW INVENTORY ADD 49...... ALLOW CUSTOMER ADD 49...... USE CREDIT LIMIT 49...... OPEN/CLOSE REGISTERS 49...... DISPLAY COST FIELD WHILE INVOICING 50...... DEFAULT SHIPPER/METHOD OF SHIPMENT 50...... DEFAULT TERMS 50...... INVENTORY DATABASE LOCATION 51...... CUSTOMER DATABASE LOCATION 51...... QUOTES DATABASE LOCATION 51...... BACK ORDERS DATABASE LOCATION DAYO POS, TJS LAB Table of Contents Page Description ──── ─────────────────────────────────────────────────────── 52...... MRP - BILL OF MATERIALS DATABASE LOCATION/DIRECTORY 52...... ORDER ENTRY DATABASE LOCATION/DIRECTORY 52...... CURRENT DIRECTORY DATABASE LOCATION 53...... PRICE BOOK DATABASE LOCATION 53...... GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY 53...... CASH DRAWER SERIAL 53...... CASH DRAWER SERIAL PORT 53...... PARALLEL CASH DRAWER 54...... PARALLEL CASH DRAWER PORT 54...... PARALLEL CASH DRAWER PRINTER SETUP CODE 54...... REPORT PRINTER TYPE 54...... REPORT PRINTER PORT 55...... VISUAL INDEXING 55...... AUTOMATIC DAILY INDEXING 55...... AUTO PRINT PACKING LIST 56...... PACKING LIST PRINTER PORT 56...... PRINT PRICE ON PACKING LIST 56...... WORK ORDER COPIES 56...... WORK ORDER PRINTER TYPE 56...... WORK ORDER PRINTER PORT 57...... WORK ORDER NOTES PHRASE 57...... ALLOCATE WORK ORDERS 57...... DEFAULT COMMENT 57...... SHOW RETAIL/LIST PRICE ON STANDARD INVOICE 58...... PRINT INVENTORY PRICE OR RETAIL IF 'SHOW RETAIL' IS SET TO Y 58...... PRE-SELECT THE SHIP TO ADDRESS PRIOR TO INVOICING DETAIL LIN 58...... TAX THE ADJUSTMENT FIELD ON THE INVOICE 58...... USE WAREHOUSES - INVOICE FROM WAREHOUSES 59...... DEFAULT FREIGHT PERCENTAGE 59...... SHOW/DISPLAY CUSTOMER NOTES ONTO SCREEN AT INVOICE TIME 59...... TAX THE FREIGHT FIELD ON THE INVOICE 60...... PRINT INVOICE/WORK ORDER COMMENTS ON THE INVOICE 60...... PRINT BACK ORDER PRICE EXTENSION ON INVOICE/WORK ORDER 60...... USE MULTIPLE PRICES - MULTIPLE PRICE TABLES 61...... MANUFACTURE ENDITEMS - BILL OF MATERIALS 61...... USE THE ORDERED FIELD - RECORD CUSTOMER'S ORDER QUANTITY 61...... OVERRIDE INVOICE NUMBER 62...... PRINT CONTROL NUMBER ONTO INVOICE 62...... USE 2ND TAX 63...... PRINT CREDIT CARD & AUTHORIZATION NUMBER ON INVOICE 63...... PRINT BILL OF MATERIAL WORKSHEET FOR ASSEMBLED ITEMS 63...... BILL OF MATERIAL WORKSHEET PRINTER PORT 63...... MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE DAYO POS, TJS LAB Table of Contents Page Description ──── ─────────────────────────────────────────────────────── 64...... AUTOMATIC GL POSTING 65...... EDIT CLASS CODE RECORD 65...... ADD NEW CLASS CODE RECORD 66...... FIND CLASS CODE 67...... COLOR MONITOR 67...... COLOR INTENSITY 68......REPORTS 68...... REPORTS MENU SCREEN 69...... PRINTER DRIVER (SETUP) 69...... PRINTER DRIVER OPTIONS 70...... CHANGE DEFAULT PRINTER 71...... FULL SCREEN EDIT - F2 71...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 72...... REGISTER STATUS/SUMMARY 73...... EXAMPLE OF A REGISTER STATUS/SUMMARY REPORT 74...... ABBREVIATED OPEN ORDER REPORT 75...... EXPANDED OPEN ORDER REPORT 76...... POS DETAIL, HEADER & TEMPLATE REPORTS 77...... POS HEADER REPORTS 78...... POS DETAIL REPORTS 78...... OPEN ORDER - DETAIL - REPORT 79...... CUSTOMER SHIP TO ADDRESS LABELS 79...... GRAPH, LAST 12 MONTHS SALES 81...... GRAPH, LAST 12 WEEKS SALES 82...... TEMPLATES ALL REPORT 83...... DATABASE STATUS REPORT 84...... CONFIGURATION STATUS REPORT 85...... AN EXAMPLE OF A CONFIGURATION STATUS REPORT 86...... VIEW REPORTS ON SCREEN 87...... REPORT VIEWING SCREEN 88......MISCELLANEOUS ROUTINES 88...... MISC Routines Menu: 89...... APPEND FROM 91...... BROWSE DATABASES 93...... COPY (.DBF) TO 95...... CREATE DATABASE 97...... DELETE RECORDS 98...... ERASE FILE 98...... EXIT TO DOS 99...... INDEX A DATABASE 100...... LIST FIELDS 103...... MODIFY DATABASE 104...... PACK DATABASE 105...... RECALL RECORDS 105...... RETURN TO MENU DAYO POS, TJS LAB Table of Contents Page Description ──── ─────────────────────────────────────────────────────── 105...... RUN (DOS COMMAND) 106...... SIMPLE EDITOR 107...... SORT DATABASE 108...... TYPE (PRINT) FILE 109...... ZAP DATABASE 111......HELP SCREENS 112...... EXPANDED HELP 113...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 114...... VIEW DOCUMENTATION ONSCREEN 115......DATABASE STRUCTURE 115...... DATABASE - BO.DBF 116...... DATABASE - CUSTOMER.DBF 117...... DATABASE - CUSTMEMO.DBF 117...... DATABASE - DAYOFORM.DBF 117...... DATABASE - DETAIL.DBF 118...... DATABASE - INV.DBF 119...... DATABASE - INVOICE.DBF 120...... DATABASE - PB.DBF 120...... DATABASE - REGISTER.DBF 120...... DATABASE - SALESPER.DBF 121...... DATABASE - SERIALNO.DBF 121...... DATABASE - SHIPPER.DBF 121...... DATABASE - SHIPTOS.DBF 122...... DATABASE - TAXCODE.DBF 122...... DATABASE - TEMPLATE.DBF 122...... DATABASE - TERMS.DBF 122...... DATABASE - TYPE.DBF 123...... DATABASE - QUOTES.DBF 123...... DATABASE - QUOTESD.DBF 124...... DATABASE - WAREHOUS.DBF 124...... DATABASE - WO_NOTES.DBF 125......DATA DICTIONARY 131......DAYO POS MAINTENANCE & QUIRKS 133......TJS 'Computer' LAB DAYO POS, TJS LAB Page: 1 ■ INTRODUCTION DAYO POS (Point of Sale) is a Billing and Invoicing application for any size business. It is by default a multiuser system, allowing almost unlimited numbers of users to have the ability to simultaneously invoice using this one program on a PC based LAN/Network. It can however, be run (like all DAYO products) as a 'standalone' application. Hundreds of features abound, with more being added almost daily! Some of the DAYO POS highlights are: Multiuser (ie: Novell) Registers Quote Interface (to DAYO Quotes) Templates Back Orders Work Orders Data Entry Validation Cash Drawers (Serial or Parallel) Databases are dBase (tm) compatible HP Laser Special Invoices Preprinted Invoices Standard Invoices Packing/Shipping Lists Customer Ship To/Mailing Address Labels Sales Graphs Special Customer Pricing (interfaces with DAYO PriceBook) Margin Discount Off List Fixed 60+ Configuration Settings Sales Tax Codes Terms Codes Invoice Type Codes Shippers/Method of Shipment Codes Credit Limits Passwords (with DAYO Passwords) Reports Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving 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 EOP End Of Period Posting DAYO Passwords Password protect your DAYO system DAYO Smart Reports A variety of reports pertaining to the above modules DAYOX Network/LAN Index Maintenance Utility DAYO POS, TJS LAB Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO POS software, documentation, and source codes. Authorization to distribute Demonstration Versions is granted. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO POS. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO POS, use the SETUP program supplied on the MENU or Update & Conversion diskette, or copy the contents of the DAYO POS floppy disks into a directory on your hard disk (ie: \DAYOPOS), then 'uncompress' (ie: PKunzip ) them. When running DAYOPOS for the first time, it will create all the database, index, and configuration files it requires for operation. If other DAYO modules are being used, be sure to enter the location of these databases into the DAYO POS configuration. Type and enter 'DAYOP' at the DOS prompt to run the program (ie: C:\DAYOP ). DAYO POS, TJS LAB Page: 3 ■ MAIN MENU After a few moments and possibly a reindex, the main menu will appear: DAYO POS Version 3.0 TJS LAB ┌───[February 1991]──┐ Copyright (c) 1989-1991 All Rights Reserved │S M T W T F S │ ╓────────────────────╖ ├────────────────────┤ ║ 1 REGISTER ║ ████▄ ▄█▄ █░ █░ ▄███▄ │ 1 2│ ╟────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 3 4 5 6 7 8 9│ ║ 2 INVOICE - ║ █░ █░ █░█░ ▀█░██░ █░ █░ │10 11 12 13 14 15 16│ ╟────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │17 18 19 20 21 22 23│ ║ 3 CUSTOMERS ║ █░ █░ █░ █░ █░ █░ █░ │24 25 26 27 28 │ ╟────────────────────╢ ████▀ █░ █░ █░ ▀███▀ │ │ ║ 4 CONFIGURATION ║ └────────────────────┘ ╟────────────────────╢ ╓────────────────────────────────────────────────╖ ║ 5 REPORTS ║ ║ DAYO POS STATISTICS Register Open ║ ╟────────────────────╢ ╟────────────────────────────────────────────────╢ ║ 6 MISC ROUTINES ║ ║ DATABASE NAME RECORDS SIZE ║ ╟────────────────────╢ ╟────────────────────────────────────────────────╢ ║ 7 EXIT ║ ║ INV.DBF Inventory 138 44K ║ ╚════════════════════╝ ║ INVOICE.DBF Invoice Header 3 3K ║ Select Option ║ DETAIL.DBF Invoice Detail 28 4K ║ ████▄ ▄███▄ ▄██▄ ║ CUSTOMER.DBF Customers 309 154K ║ █░ █░ █░ █░ █░ ║ SERIALNO.DBF Serial Numbers 6 1K ║ ████▀ █░ █░ █▄ ║ SALESPER.DBF Sales Persons 1 1K ║ █░ █░ █░ ▀█▄ ║ TEMPLATE.DBF Templates 1 0K ║ █░ █░ █░ █░ ║ REGISTER.LOG Register Log 762 67K ║ █░ ▀███▀ ███▀ ╚════════════════════════════════════════════════╝ Open, ReOpen, or Close Your Register The left side of the screen is the actual main menu. The calendar and logos are just 'art'. The DAYO POS STATISTICS box (bottom right) contains the number of records and size (in kilo bytes) of the main databases (there are many others!). ■ PASSWORD/NAME From the main menu, after entering your name or password, you can enter any of the modules. ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: TOM JOHNSON ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 4 ■ OPEN REGISTER Before entering the INVOICE option, you must open/reopen a register. Opening a register means the recording of the amount of money you start with at the beginning of the day (period). Subsequent invoices will be 'posted' to this register thus creating a reliable means of auditing your daily sales. You are required to close this register at the end of day (or period). It is recommended (and common sense) that you reconcile your register at this time. Note there are various Register Reports that can aid you in your audit. Select the REGISTER option from the main menu to open a register. You will then be prompted to open (or reopen) a register. ┌───────────────────[ OPEN/CLOSE REGISTER ]──────────────┐ │ │ │ Select the Register you wish to Open, Re-open, or │ │ Close. You can not create an invoice unless you │ │ open a Register first! │ │ Select Register to OPEN/RE-OPEN/CLOSE... │ │ │ │ Register Open Open Date Close Date Start $ │ │──────────╥──────╥───────────╥────────────╥─────────────│ │ 1 ║ F ║ 12/28/89 ║ 12/28/89 ║ 100.00 │ │ 2 ║ T ║ 12/26/89 ║ / / ║ 0.00 │ │ ║ ║ ║ ║ │ └────────────────────────────────────────────────────────┘ DAYO POS starts off with only one register (1), but others may be created. You can have many registers, but you can not open a register on more than one machine at a time. When you open the register, it prompts you to enter the amount of money you wish to start with at the beginning of the day. ┌─────────────────────[ OPEN REGISTER 1 ]────────────────┐ │ │ │ Select the Register you wish to Open, Re-open, or │ │ Close. You can not create an invoice unless you │ │ open a Register first! │ │ Select Register to OPEN/RE-OPEN/CLOSE... │ │ │ │ │ │ │ │ Enter Starting Register Amount: 100.00 │ │ [ Press Esc to Abort ] │ │ │ └────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 5 The file is 'locked' when a register is opened/reopened, preventing another machine/CPU from opening it. ■ CREATING ADDITIONAL REGISTERS To create additional registers, go into the MISC ROUTINES and select the BROWSE DATABASES option. At the prompt for database, press Enter/Return to bring up a list of the databases in the current directory. Select the REGISTER.DBF. Press 'Ctrl N' simultaneously to add another record. The record number of that new record becomes the register number. ■ CLOSE REGISTER At the end of the day or period, you should close the register. Do this by entering the REGISTER option off the main menu. You will be given a a prompt to input the amount of money in the register/cash drawer. ┌───────────────────[ CLOSE REGISTER 1 ]─────────────────┐ │ │ │ Select the Register you wish to Open, Re-open, or │ │ Close. You can not create an invoice unless you │ │ open a Register first! │ │ │ │ │ │ │ │ │ │ Enter Ending Register Amount: 10493.00 │ │ [ Press Esc to Abort ] │ │ │ └────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 6 After entering in your closing balance, a window will appear informing you of the differences (if any) between what you ended with, and what the register calculates you should have (starting amount plus received payments amount). DAYO POS Version 3.0 TJS LAB REGISTER ┌───[February 1991]──┐ Copyright (c) 1989-199┌──────────────────[ CLOSE REGISTER 1 ]────────────────┐ ╓────────────────────╖│ │ ║ 1 REGISTER ║│ Select the Register you wish to Open, Re-open, or │ ╟────────────────────╢│ Close. You can not create an invoice unless you │ ║ 2 INVOICE - ║│ open a Register first! │ ╟────────────────────╢│ │ ║ 3 CUSTOMERS ║│ │ ╟──┌──────────────────────────────────┐ │ ║ 4│ │ │ ╟──│ Started With: 25.00 │Register Amount: 5025.05 │ ║ 5│ Ended With: 5025.05 │o Abort ] │ ╟──│ Difference: 5000.05 │ │ ║ 6│ Invoice Receipts: 5000.05 │──────────────────────────────────────┘ ╟──│ ────────────────- ────────- │────────────────────────────────────╢ ║ 7│ Variance: 0.00 │ Inventory 74 14K ║ ╚══└──────────────────────────────────┘ Invoice Header 29 11K ║ Select Option ║ DETAIL.DBF Invoice Detail 398 34K ║ ████▄ ▄███▄ ▄██▄ ║ CUSTOMER.DBF Customers 18 9K ║ █░ █░ █░ █░ █░ ║ SERIALNO.DBF Serial Numbers 182 12K ║ ████▀ █░ █░ █▄ ║ SALESPER.DBF Sales Persons 2 1K ║ █░ █░ █░ ▀█▄ ║ TEMPLATE.DBF Templates 9 1K ║ █░ █░ █░ █░ ║ REGISTER.LOG Register Log 538 47K ║ █░ ▀███▀ ███▀ ╚════════════════════════════════════════════════╝ Press any key to continue... DAYO POS, TJS LAB Page: 7 ■ BILLING & INVOICING To access any of the INVOICE menu options (listed below), opened or reopened a register. Read the section on REGISTERs for more information. Once a register is open, you can enter the INVOICE module. ╔════════════════════════╗ ║ INVOICE ROUTINES ║ ╟────────────────────────╢ ║ CREATE INVOICE ║ ║ BROWSE INVOICE HEADERS ║ ║ BROWSE INVOICE DETAIL ║ ║ BROWSE/CREATE TEMPLATE ║ ║ REPRINT INVOICE ║ ║ OPEN CASH DRAWER ║ ╟────────────────────────╢ ║ Select Option ║ ╚════════════════════════╝ Invoices are created by optionally selecting a warehouse, then selecting a customer, detail line items, recalling/adding a template to the line items, and/or recalling a previously created quote (DAYO Quotes). ■ KEY INVOICE CONFIGURATION SETTINGS Many configurations can be made that affect the invoicing process. The following configuration settings are the most essential. These settings should be determined and set prior to any invoicing! Be sure you understand each one before starting your invoicing. The default settings may not be what is required! Auto Print Invoice - Prints invoice automatically after completion. Defaults to 'Y' Last Invoice Number - Your invoice numbers will start (default) at '1' unless you change this Invoice Printer Type - You can select 1 of 3 invoice printout types: Standard, HP Laser, or Pre Printed Defaults to STANDARD Invoice Printer Port - Defaults to LPT1 Invoice Copies - Defaults to 1 Override Onhand - If set to 'Y', DAYO POS will allow the invoicing of items even if they do not exist in the inventory. Defaults to 'N' Use Credit Limit - Alerts DAYO POS to consider credit limits in the processing of invoices. Defaults to 'N' DAYO POS, TJS LAB Page: 8 Create BackOrders - If you wish DAYO POS to create a back order record for items not onhand (available), then set this setting to 'Y'. Requires DAYO BO. Defaults to 'N' Allow Inventory Add - Allows the adding of new item records to the inventory file at invoicing time. Defaults to 'Y' Allow Customer Add - Allows the creation of new customers from the DAYO POS module (Recommend that the DAYO AR module be used). Defaults to 'Y' Default Tax Code - Customers with no TAXRATE will receive the sales tax rate associated with this tax code. Defaults to '1' Default Invoice Type - Becomes the default TYPE (ie: REG), for customers with no TYPE field entered in their customer records. Defaults to 'REG' Default Shipper - The default Shipper/Method of Shipment for customers who do not have it entered on their records. Defaults to PICKUP Default Terms - The default Terms (ie: CASH, NET 30), for customers who do not have it entered on their records. Defaults to CASH Cash Drawer - If you have a Cash Drawer that opens with a signal from a serial port connection, then set this to 'Y'. Defaults to 'N' Cash Drawer Port - The serial port (ie COM1), that the Cash Drawer is attached to. Defaults to COM1 Print Packing List - Defaults to 'N' Packing List Port - Defaults to LPT1 Inventory Location - Defaults to current drive/directory, but may reside in the \DAYOINV\ directory... Customer Location - Defaults to current drive/directory, but may reside in the \DAYOAR\ directory... Quotes Location - Defaults to current drive/directory, but may reside in the \DAYOQUO\ directory... Price Book Location - Defaults to current drive/directory, but may reside in the \DAYOPB\ directory... Back Orders Location - Defaults to current drive/directory, but may reside in the \DAYOBO\ directory... Use Warehouses - If you wish to invoice from the warehouses ■ KEY INVENTORY & CUSTOMER FIELDS To make it possible for you to create an invoice, you must have at least one customer and one item in your inventory. Key fields in each of these records greatly affect the invoicing process. For instance, the inventory database (INV.DBF) has the following key fields: The ONHAND field (and the BO field) of the inventory file determine the quantity of goods AVAILABLE for invoicing. The use of the BO (Back Orders) field is optional. DAYO POS, TJS LAB Page: 9 The PRICE field determines what is to be charged the customer/client. The only exception to this is the DAYO Price Book pricing methods. Inventory items may/may not be TAXABLE. Inventory items are flagged (SERIALNO) alerting the POS operator to enter serial numbers. These serial numbers are later printed onto the invoice. Besides the obvious benefit of having the customers name and address, the customer database (CUSTOMER.DBF) also has its important invoicing fields: The tax rate field (TAXRATE) field determines the sales tax rate charged to the customer/client. The TERMS field determines how the customer/client will pay (or not to pay) for the invoiced items. For example, a CASH terms customer will pay 'on the spot', whereas a customer with terms of 'NET 30' has thirty days to make payment for the invoiced items. The SHIPPER field alerts you to how the customer wants the items shipped. The TYPE field is probably the most important. It is this field that determines how the invoiced data will be posted to many databases. DAYO POS defaults to 8 invoice types, but more can be added. It is imperative that these default TYPE entries are NOT altered. Any additional TYPE entries will be handled (posted), exactly like the REG (Regular Sale) type. REG - REGULAR SALE Ret - RETURN Ref - REFUND DIR - DIRECT SHIPMENT SPC - SPECIAL LON - LOANED EXC - EXCHANGE TRN - TRANSFER VOD - VOIDED The PBM (Price Book Margin) and PBL (Price Book List) fields work with DAYO Price Book to provide special pricing to the customer. The LIMIT field is the Credit limit placed by you on the customer. This amount field minus the DUE (amount due) field determine the amount of available credit for a 'terms' customer. Note, the use of credit limits is a configurable option. DAYO POS, TJS LAB Page: 10 ■ INVOICE INITIAL SCREEN DAYO POS Version 3.0 TJS LAB INVOICE ┌───[February 1991]──┐ ╔════════════════════════╗ll Rights Reserved │S M T W T F S │ ║ INVOICE ROUTINES ║ ├────────────────────┤ ╟────────────────────────╢ ████▄ ▄█▄ █░ █░ ▄███▄ │ 1 2│ ║ CREATE INVOICE ║ █░ █░ █░█░ █░ █░ █░ █░ │ 3 4 5 6 7 8 9│ ║ BROWSE INVOICE HEADERS ║ █░ █░ █░█░ ▀█░██░ █░ █░ │10 11 12 13 14 15 16│ ║ BROWSE INVOICE DETAIL ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │17 18 19 20 21 22 23│ ║ BROWSE/CREATE TEMPLATE ║ █░ █░ █░ █░ █░ █░ █░ │24 25 26 27 28 │ ║ REPRINT INVOICE ║ ████▀ █░ █░ █░ ▀███▀ │ │ ║ OPEN CASH DRAWER ║ └────────────────────┘ ║ BACK ORDERS ║ ╓────────────────────────────────────────────────╖ ║ VIEW INVENTORY ║ ║ DAYO POS STATISTICS Register Open ║ ║ VIEW CUSTOMERS ║ ╟────────────────────────────────────────────────╢ ╟────────────────────────╢ ║ DATABASE NAME RECORDS SIZE ║ ║ Select Option ║ ╟────────────────────────────────────────────────╢ ╚════════════════════════╝ ║ INV.DBF Inventory 138 44K ║ ╚════════════════════╝ ║ INVOICE.DBF Invoice Header 3 3K ║ Select Option ║ DETAIL.DBF Invoice Detail 28 4K ║ ████▄ ▄███▄ ▄██▄ ║ CUSTOMER.DBF Customers 309 154K ║ █░ █░ █░ █░ █░ ║ SERIALNO.DBF Serial Numbers 6 1K ║ ████▀ █░ █░ █▄ ║ SALESPER.DBF Sales Persons 1 1K ║ █░ █░ █░ ▀█▄ ║ TEMPLATE.DBF Templates 1 0K ║ █░ █░ █░ █░ ║ REGISTER.LOG Register Log 762 67K ║ █░ ▀███▀ ███▀ ╚════════════════════════════════════════════════╝ ■ CREATE INVOICE Okay, time to create an invoice! ■ INVOICE FROM WAREHOUSES If the 'Use Warehouses' option is set to Y (Yes) in the Configuration menu, then you will be presented with the following screen prompting you to select the warehouse you wish to invoice from. Warehouses are maintained in the DAYO Inventory module. The default to NOT to see this screen, and if it has been 'turned on', to default to the Main Warehouse, with is the ONHAND field in the inventory database (INV.DBF). DAYO POS, TJS LAB Page: 11 ╔════════════════════[ INVOICE FROM WAREHOUSES ]═════════════════════╗ ║ ║ ║ █▒ █▒ █▒ █▄██▒ ███▒ █▒ █▒ ▄██▄ █▒ █▒ ▄██▄ ███▒ ▄██▄ ║ ║ █▒ █▒ █▒ █▀█▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ ║ ║ █▒ █▒ █▒ █▒█▒ █▄▄█▒ ██▒ ████▒ █▒ █▒ █▒ █▒ ▀██▄ ██▒ ▀██▄ ║ ║ █▒█▀█▒█▒ ▄█▄█▄ █▀█▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ █▒ ║ ║ ▀█▀ ▀█▀ █▒ █▒ █▒▀█▒ ███▒ █▒ █▒ ▀██▀ ▀██▀ ▀██▀ ███▒ ▀██▀ ║ ╟────────────────────────────────────────────────────────────────────╢ ║ ║ ║ Select Warehouse -> Warehouse --- ONHAND <Main Warehouse> ║ ║ Warehouse: LOC1 Truck 1 ║ ║ Warehouse: LOC2 Truck 2 ║ ║ Warehouse: LOC3 Truck 3 ║ ║ Warehouse: LOC4 Truck 4 ║ ║ Warehouse: LOC5 Broken, Scrap ║ ║ Warehouse: LOC6 Returned to Vendors ║ ║ Warehouse: LOC7 Internal Use ║ ╚════════════════════════════════════════════════════════════════════╝ After selecting the INVOICE option, the initial invoice screen will appear (below). Much of the customer information is printed atop the screen. All other customer records/data is accessible by simply 'browsing' through the customer database; ie: typing in a customer number, using one of the FIND function keys (F5,F6,F7,F8,F9) or by using the right/left/PgUp/PgDn arrow keys. There are more fields to the right of the initial screen! Press F1 (for Help) if you want more information about the special keys involved in a browse screen. ■ SELECT CUSTOMER, IMPORT QUOTE, OR IMPORT ORDER Select (highlight) a customer you wish to invoice and press Enter/Return, or press 'F2' to import a quote or order. Quotes are created with the DAYO Quotes module. Orders are created with DAYO Order Entry. A box will appear showing you the status of this customers credit if the CREDIT LIMIT configuration is in effect For example, nothing (0) due: ╔═══════════════════════════════════════╗ ║ Credit Limit: 1233.00 ║ ║ Amount Due: 0.00 ║ ║ Avalable Credit: 1233.00 ║ ║ Press any key to continue... ║ ╚═══════════════════════════════════════╝ For example, $838.44 due: ╔═══════════════════════════════════════╗ ║ Credit Limit: 1233.00 ║ ║ Amount Due: 838.44 ║ ║ Avalable Credit: 394.56 ║ ║ Press any key to continue... ║ ╚═══════════════════════════════════════╝ DAYO POS, TJS LAB Page: 12 ■ IMPORT OPTIONS Press F2 to import a quote or order. The following appears onto the screen: ┌───────────────────────────────────────────────────────────────────────────┐ │ │ │ This routine will create an invoice out of a previously created Quote or │ │ Order (from Order Entry). │ │ Select Option -> Import Quote From DAYO Quotes │ │ Import Order From DAYO Order Entry │ │ Exit │ └───────────────────────────────────────────────────────────────────────────┘ After selecting one of the options, a prompt will appear for the quote or order number. Press enter on a '0' prompt to bring up a browse of the quotes or orders database. Use the arrow keys or the find keys (F5,F6,F7) to find the desired quote or order, ie: ╔════════════════════════[ SELECT ORDER FOR INVOICING ]════════════════════════ ║ ORDER CUSTOMER SHIPNAME ║─────────────────────╥──────────╥───────────────────────────────────────────── ║ 10933 ║ 1002 ║ John Smith ║ 10934 ║ 1820 ║ Salley Morgan ║ 10935 ║ 2399 ║ Brenda Davidson ║ 10936 ║ 2340 ║ Lorraine Turner ║ 10937 ║ 2435 ║ Anthony Arcuri ║ 10938 ║ 7550 ║ Frank LaRossa ║ 10939 ║ 5770 ║ Stacy Cromer ║ 10940 ║ 1214 ║ Daywne E. McCalister ║ 10941 ║ 1134 ║ Shirley James ║ 10942 ║ 4934 ║ Oscar Lyle Johnson ╚══════════════════════════════════════════════════════════════════════════════ Esc (Exit) Enter (Select) Find: F5 (Order) F6 (Name) F7 (Customer) DAYO POS, TJS LAB Page: 13 ■ ADD CUSTOMER - CTRL N It is not displayed, but you can add/create a new customer record by pressing Ctrl N if the 'Allow Customer Add' option is set to Y (Yes) in the Configurations menu. ■ INVOICE DETAIL SCREEN The next screen remains the same ONLY in that the customers Bill To address remains on the screen (top left). The little box on the upper right of the screen will contain a scrolling list of selected detail items, as well as a total cost of the detail items and the number of detail lines. The center of the screen contains key information about the currently highlighted inventory item. ■ ADD INVENTORY ITEM - CTRL N Though not displayed on the screen, you can press Ctrl N to add an item to the inventory by pressing Ctrl N and having the 'Add Inventory Item' option set to Y (Yes). ■ DISPLAY HISTORY OF SALES FOR SELECTED CUSTOMER - F10 *** To display the history of all sales for the selected customer, press F10. If no history is present (found in the database ARD.DBF), then nothing changes on the screen. DAYO POS, TJS LAB Page: 14 DAYO POS Version 3.0 TJS LAB INVOICE ╔══════════════════════════════════════╦══[ Detail Items ]═══════════════════╗ ║ BILL TO: ║ Subtotal: 75.76 Lines: 2 ║ ║ JOE MORGAN ║ Item Qty Extended ║ ║ PO BOX 2343 ║ 1000 10 55.56 ║ ║ ║ 324233-A 1 20.20 ║ ║ LAKE HAVEN, GA 30909 ║ ║ ╠═══[ Item Info ]══════════════════════╩═════════════════════════════════════╣ ║ Item Vendor Item Vendor Description Type ║ ║ 1232 ABC-1232 ABC # 45 BOLT R ║ ║ Onhand OnOrder Cost Retail Price Adj. Price PB Method ║ ║ 10 0 1.00 3.00 2.00 2.00 DEF **.***║ ╚═══════════════[ Select The Inventory Items To Be Invoiced ]════════════════╝ ITEM DESC ONHAND ONORDER BO ──────────────╥────────────────────────────────╥─────────╥─────────╥────────── 1212 ║ # 12 BOLT ║ 10 ║ 0 ║ 0 1214 ║ # 32 BOLT ║ 10 ║ 0 ║ 0 1216 ║ # 33 BOLT ║ 10 ║ 7 ║ 0 1217 ║ # 40 BOLT ║ 10 ║ 3 ║ 0 1219 ║ # 42 BOLT ║ 10 ║ 0 ║ 0 1232 ║ # 45 BOLT ║ 10 ║ 12 ║ 7 1245 ║ RED ALUMINUM SIDING TYPE 3 ║ 10 ║ 0 ║ 0 Esc (Exit) Enter (Select) F1 (Help) F2 (Edit) F3 (Template) F4 (Mfg) Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type) 18/74 ■ SELECT DETAIL ITEM To select an inventory item for addition to an invoice, highlight the item and press Enter/Return. The lower center of the screen will clear and a prompt will appear allowing you to alter key fields, ie: PRICE and the quantity to be invoiced... There are up to 7 prompts at this stage. To edit any of them, use the up arrow key to highlight the desired option, then press Enter/Return. A value in Margin or List Discount will change/recompute the Price field/prompt. You have the option to change the main description, and even to add a second description or comment specific to this line item. ╚═══════════════════════════[ Add Item To Order ]════════════════════════════╝ Margin: 0.000 List Discount: 0.000 Description: SUNGLASS/BARRETTE SET 2nd Description: Example of 2nd Descr Cost: 4440.88 Price: 1.00 Quantity: 1.00 Special messages can also appear to the right of the Quantity prompt: 'Only 0 in the inventory!' - You are about to invoice something that is not recorded in the inventory. '1 will be BackOrdered!' - You have elected to create backOrders, and will be creating 1 for this line item. DAYO POS, TJS LAB Page: 15 ■ MULTIPLE PRICING There are 6 price fields in the inventory database (INV.DBF) that will be presented/displayed onto the screen for selection IF you have the multiple pricing flag 'turned on' (in Configuration) AND any of the price fields (PRICE1 to PRICE5) have a value not equal to zero... ╔════════════════════════════════════╗ ║Select From Multiple Pricing ║ ║ 0 to 4: 31.150║ ║ 5 to 9: 32.730║ ║ 10 to 14: 33.230║ ║ 15 to 43: 34.180░ ║ 44 to 46: 35.330║ ║ More Than 46: 36.200║ ╚════════════════════════════════════╝ The PRICEX field in the customer database (CUSTOMER.DBF) will override the quantity values if it contains a number between 1 and 5. If the PRICEX field equals 0, then the highlighted price is determined by the quantity ordered. If the PRICEX field is greater than 6, then the first price (the default) will always be highlighted. Read more on multiple pricing in the Configuration section... ■ ASSEMBLE/BUILD ENDITEMS (MRP) This routine provides a method of assembling or building items (called ENDITEMS), from other items (called components), in the inventory database (INV.DBF). A bill of materials must exist in the MRP database BOM.DBF, and the Item/ENDITEM must have the field 'BOM' set to true (.T.) which denotes the Item/ENDITEM as a manufactured item. DAYO POS Version 3.0 TJS LAB INVOICE ╔════════════════════════[ ASSEMBLE CURRENT ENDITEM ]════════════════════════╗ ║ This routine will determine the maximum number that can be assembled for ║ ║ this ENDITEM. ║ ║ Inventory Adjustment records (INVADJ.DBF) will be created. ║ ║ ║ ║ ENDITEM: JAR-1 Desc: TRACKS NYLON BELLY BAG Cost: 2.069║ ║ YKEL2 Desc: BIG CAR List: 4.132║ ║ Desc2: 222-BIG CAR POS: 0.00 ║ ║ ║ ║ 328.000 of ENDITEM (JAR-1) can be Assembled! ║ ║ ║ ║ Enter Final Quantity To Be Assembled: 328.000 ■ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════[ Assemble: 328.000 ]═══════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO POS, TJS LAB Page: 16 ■ ENTERING SERIAL NUMBERS If the selected detail item is flagged to record serial numbers, another prompt will appear onto the screen asking for serial numbers to be entered. This prompt will remain until the number of serial numbers equal the quantity on the invoice (or you press 'Esc'). ╚═══════════════════════════[ Add Item To Order ]════════════════════════════╝ Price: 313.13 This Item Requires Input of Quantity: 5 Serial Numbers Enter Serial Number (1 of 5) 1230002-A0D0332 ■ EDITING SELECTED DETAIL ITEMS Any time during the item selection process you can edit items already selected by pressing the 'F2' key. This will bring up a 'browse' screen of items previously selected, ie: Item Description Qty Price Extended 145355 BIG WIDE MOUTH JAR #45 10 31.00 310.00 154242-12 LITTLE JAR 1 20.20 20.20 457823 SMALL JAR 1 55.56 55.56 654555 BIG NOSE JAR 1 323.23 323.23 745745 JAR 1 100.01 100.01 856566-YOI GREEN JAR 10 0.00 0.00 Esc (Abort/Exit) Enter/Return (Edit) Ctrl N (Add) Ctrl U (Delete) Pressing Enter/Return again lets you change the PRICE and/or quantity of the currently highlighted detail item. 'Ctrl N' allows you add (if so set in the configuration module) an item to this invoice and to the inventory database. 'Ctrl U' removes the detail line item from the invoice. Exit this screen by pressing Esc. ╔═══════════════════════════════════════════════════════════════════════╗ ║╔═════════════════════════════════════════════════════════════════════╗║ ║║ ──────────────────────────────────────────────────────────── ║║ ║║ Are you finished adding items to this invoice? (Y/N)* ║║ ║║ ──────────────────────────────────────────────────────────── ║║ ║╚═════════════════════════════════════════════════════════════════════╝║ ╚═══════════════════════════════════════════════════════════════════════╝ ■ RECALL A TEMPLATE If you have created templates, you can recall them from the INVOICE DETAIL screen by pressing 'F3' and then entering in the template number, ie: Enter Template Number: 50 Note, templates are created in another INVOICE routine... DAYO POS, TJS LAB Page: 17 ■ COLLECT PAYMENT IN ADVANCE OF BACKORDERS Once finished with the invoice detail, press 'Esc'. If configured to create backorders, and if any exist in the invoice, or if the invoice is to be a return/refund, the following messages and prompts will appear on the screen: ╔═══════════════════════════════[ BackOrder ]════════════════════════════════╗ ║ You have items on this invoice that are not available for invoicing! ║ ║ If you wish to charge the customer/client for the items (collect ║ ║ payment in advance), then respond Y (YES) to this option. The ║ ║ default is not to bill the customer for items not onhand in ║ ║ your inventory. *** Press R if this is a refund or return... ║ ║ ║ ║ Bill For Items Not Available or Onhand In Inventory? (Y/N/R) ║ ║ (Collect Payment in Advance...) Refund (R) Return ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ╔═══════════════════════════════[ BackOrder ]════════════════════════════════╗ ║ ║ ║ Some of the items you have selected are not available. ║ ║ ║ ║ Do you wish to Bill/Invoice/Ship Complete? (Y/N) (N -> Partial). ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Respond accordingly... DAYO POS, TJS LAB Page: 18 ■ FINAL INVOICE EDIT SCREEN When all invoice detail items have been selected, press 'Esc' (once) to bring up the final invoice edit screen. This screen gives you the chance to change the key invoice header information. Note, the total order weight is displayed to the left of the Freight prompt, and the total amount due by the customer is displayed to the left of the Terms prompt. Customer Number 1330 Bill To Name Tim Johnson Edit/Alter Invoice Header Ship To Name Johnson Air Conditioning Address 1 737 Teays Valley Road Address 2 City Winfield State WV Zip 22020-2020 Phone (800) 555-5555 Type REG (1202.16) Terms COD Shipper UPS GROUND Sales Person TJ Tax Rate 0.060 Customer PO Adjustment 0.00 (383.03) Freight 10.00 Amount Paid 0.00 Taxes 2.04 Detail Subtotal 442.99 Comment Thank You! Esc (Exit) Enter/Return (Edit/Alter) ■ CREDIT CARDS Any terms field (ie: VISA *) that contains an asterick in it, is assumed to be a credit card. Upon exiting the Final Edit screen, a prompt will appear requesting the credit card number (defaulting the the credit card number in the customer record). DAYO POS, TJS LAB Page: 19 To edit any of the header fields (except customer number and Bill To name), highlight the field, and press Enter/Return. You will be given the opportunity to edit the field or select from a list of choices. The 'Type', 'Terms', 'Shipper', and 'Tax Rate' fields will bring up a list of only the valid choices, ie: TYPE: TERMS: ┌─────────────────────────────────────┐ ┌────────────────────┐ │ Select Type │ │ Select Terms │ │REG - REGULAR SALE │ │COD │ │Ret - RETURN │ │CASH │ │Ref - REFUND │ │MASTERCARD * │ │SPC - SPECIAL │ │VISA * │ │LON - LOANED │ │DISCOVER * │ │EXC - EXCHANGE │ │NET 7 │ │TRN - TRANSFER │ │NET 10 │ │VOD - VOIDED │ │NET 15 │ │DIR - DIRECT SHIPMENT │ │NET 30 │ └─────────────────────────────────────┘ │NET 60 │ └────────────────────┘ SHIPPER: ┌────────────────────┐ │ Select Shipper │ │DELIVER │ TAXCODE/TAXRATE: │UPS GROUND │ ┌──────────────────┐ │UPS BLUE │ │ Select Tax Rate │ │UPS RED │ │0 - 0.000 │ │AIRBORNE │ │1 - 0.060 │ │FEDERAL EXPRESS │ │2 - 0.065 │ │TRUCK │ └──────────────────┘ │SPECIAL DELIVERY │ │US MAIL │ │PICKUP │ └────────────────────┘ ■ MULTIPLE TERMS The capability exists for 2 term types. If for instance a customer wants to pay half on credit card, and the balance with cash, then select the MULTIPLE TERMS option at the Terms prompt. The MULTIPLE TERMS option will always be the last Terms options... DAYO POS, TJS LAB Page: 20 ┌────────────────────┐ │ Select Terms │ │NET 7 │ │NET 10 │ │NET 15 │ │NET 30 │ │NET 60 │ │NET 90 │ │MONEY ORDER │ │CASHIER CHECK │ │SPECIAL CREDIT │ │MULTIPLE TERMS *****│ └────────────────────┘ After selecting the MULTIPLE TERMS option, you will be prompted to select the first terms and its amount. You will then be prompted to select the second terms type. The balance of the invoice will be applied to this second terms type. ╔════════════════════════════════════════════╗ ║ Select 1st Terms -> CASH ║ ║ ║ ║ Enter the Amount: 10.00 ║ ║ ║ ║ Select 2nd Terms -> CASH ║ ║ CHECK ║ ║ COD ║ ║ AMERICAN EXPRESS * ║ ╚════════════════════════════════════════════╝ ■ MULTIPLE SHIPTOS If a customer has multiple Ship To addresses, highlight and press enter on the Ship To Name and a selection window will appear onto the screen with all the Ship Tos for that customer. Adding records to the ShipTos is done automatically whenever a change is made or a unique one is typed in at this stage. Use the maintenance (browse) routine in DAYO AR to add them in bulk. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Select the Ship To Address & Data ║ ╠════════════════════════════════════════════════════════════════════════════╣ ║1 JOE SPAULDING PO BOX 45386 NOPLACE, USE 33243 ║ ║2 MARY COSMETICS 1928 WEST MAPLE ROAD TROY, MI 93939 ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO POS, TJS LAB Page: 21 ■ FREIGHT PERCENTAGE Pressing enter/return on the Freight field/prompt with bring up a selection window like the following: ╔═══════════════════════════════════╗ ║ Select Freight Option ║ ╟───────────────────────────────────╢ ║User Input Freight Amount... ║ ║0.0400% of SUBTOTAL ║ ║0.0400% of SUBTOTAL+ADJUST ║ ║0.0400% of SUBTOTAL+ADJUST+TAXES ║ ║XX% of SUBTOTAL ║ ║XX% of SUBTOTAL+ADJUST ║ ║XX% of SUBTOTAL+ADJUST+TAXES ║ ╚═══════════════════════════════════╝ The first option in the selection is to enter ANY freight amount. The next 3 options will automatically compute a freight value based on the value of the default freight percentage (set in the configurations menu). This default value is multipled against either the SUBTOTAL, the sum of the SUBTOTAL+ADJUST, or the sum of the SUBTOTAL+ADJUST+TAXES. The remaining options will compute the freight based on a value you input. ╔═══════════════════════════════════╗ ║ Select Freight Option ║ ╟───────────────────────────────────╢ ║ ║ ║(SUBTOTAL+ADJUST+TAXES) * FACTOR ║ ║ ║ ║Example: 4% entered as '0.0400' ║ ║ ║ ║Enter Percentage Factor: 000.100 ║ ║ ║ ╚═══════════════════════════════════╝ DAYO POS, TJS LAB Page: 22 It is very important that you select the 'Amount Paid' field if you are to collect any payment from the customer/client. The amount defaults to zero if the terms type is 'NET' or 'COD', otherwise, it becomes the invoice total (Adjustments+Freight+Taxes+Subtotal), ie: Sales Person TJ Tax Rate 0.060 Customer PO Adjustment 0.00 Freigh╔═══════════════════════════════════╗ Amount Pai║ Receive From Customer: 432.99 ║ Taxe╚═══════════════════════════════════╝ Detail Subtotal 432.99 Comment Thank You! ■ LAST CHANCE TO ABORT INVOICE Press 'Esc' when finished with the final invoice screen. If you have a Cash Drawer configured and attached, it will open at this time. If you have the Credit Limit option set on, and this invoice exceeds the customers credit limit, you will get the following message, alerting you to the fact that this invoice can not be created: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Amount Due: 0.00 ║ ║ Amount Due this Invoice: 1500.00 ║ ║ Subtotal: 1500.00 ║ ║ Credit Limit: 0.00 ║ ║ ║ ║ This Customer will exceed the credit limit. No invoice can be created! ║ ║ ║ ║ Press any key to continue... ║ ╚════════════════════════════════════════════════════════════════════════════╝ The following box will appear onto the screen giving you the option to Print and Post the invoice, Print and Post a Work Order (to be printed as an invoice later), Redo the final invoice screen (maybe change the terms...), or to quit (abort!). Note, if the customer exceeds his credit limit, the option to continue (Print Invoice) will not be available... ╔══════════════════════════════════════╗ ║ Order Total: 615.96 ║ ║ ║ ║ Total Due: 615.96 ║ ║ ──────────────────────────────────── ║ ║ Select Option -> Print Invoice ║ ║ Print Work Order ║ ║ Redo ║ ║ Abort ║ ╚══════════════════════════════════════╝ DAYO POS, TJS LAB Page: 23 ■ ENTER INVOICE NUMBER If you have the option to override the invoice number turned on, the following prompt will appear onto the screen requesting the invoice number. The default is to automatically assign one and NOT to display the following prompt: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Enter Invoice Number: 1000 ■■■ (Invoice Number Override!) ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ INVOICE/WORK ORDER NOTES If you select the Work Order option, you will next be prompted to enter any comments/notes that you want printed onto the work order. ╔═════════════════════════════════════════════════════════════════════╗ ║ Do you wish to add any comments to the Invoice/Work Order? (Y/N)║ ╚═════════════════════════════════════════════════════════════════════╝ You can enter up to 22 lines. BE SURE TO PRESS CTRL W WHEN FINISHED. Pressing Ctrl W will save the Work Order notes. Pressing Esc will abort the Work Order note. ───────────────────────[ INVOICE/WORK ORDER COMMENTS ]──────────────────────── Ship only the red ones if no green ones are available. Alert Joe that they are the way AFTER they are picked up by UPS! ────────────────────────────────────────────────────────────────────────────── Esc (Exit) Ctrl W (SAVE & Exit) F1 (Help) 1/0 DAYO POS, TJS LAB Page: 24 ■ DATABASE POSTING Database posting means the updating of all databases affected by the creation of an invoice. DAYO POS will post to 7 databases (depending on the type of invoice and configuration). The databases that are involved in the post are displayed on the top right of the screen, ie: ╔═[ Posting Progress ]════╗ ║ Invoice Header ║ ║ Invoice Detail ║ ║ Inventory Database ║ ║ Customer Database ║ ║ Salesper Database ║ ║ Serial Number Database ║ ║ BackOrder Database ║ ╚═════════════════════════╝ Database Name File Name Fields Remarks ────────────────────── ──────────────── ────────────── ─────────────────── Invoice Header INVOICE.DBF All Invoice Detail DETAIL.DBF All Inventory Database INV.DBF ONHAND Onhand Quantity BO BackOrdered Quantity LASTDATE Date of Last Access SOLDPTD Period to Date Sold SOLDYTD Year to Date Sold Customer Database CUSTOMER.DBF ACTIVE LASTDATE Date of Last Access SALESPTD Period to Date Sales SALESYTD Year to Date Sales PAID_PURC Total Paid DUE Total Due Salesper Database SALESPER.DBF SALESPTD Period to Date Sales SALESYTD Year to Data Sales LASTDATE Date of Last Access Serial Number Database SERIALNO.DBF All If Any... BackOrder Database BO.DBF All If Any... DAYO POS, TJS LAB Page: 25 ■ EXAMPLE OF STANDARD INVOICE Invoice: 13234 Original Page 1 Ron's Specials Invoiced: 07/13/90 Customer: 340090 Attn: Accounts Receivable Time: 16:33:48 P.O. BOX 585366 Printed: 07/13/90 Rep: Atlanta, Georiga 30093-5222 Time: 16:34:26 404-555-5555 Register: ---------------------------------------------------------------------------- Bill To Ship To Ron Davidson Same 4409 Beaumont Drive Nowhere, CA 32808 ---------------------------------------------------------------------------- Type: REG Terms: NET 30 Shipper: TRUCK Customers PO: Taxable Tax Rate: 0.000 Comment: Original Invoice:5000 ---------------------------------------------------------------------------- # Item Description Qty Price Extended ---------------------------------------------------------------------------- 1 JAR-2 Jar #2, Clear /c Blue Tip 96 34.00 3264.00 ---------------------------------------------------------------------------- Special Instructions Subtotal: 3264.00 Tax Subtotal: 0.00 Adjustment: 22.00 Freight: 34.00 ------------------------ Totals: 3320.00 - Paid: 0.00 ------------------------------ ------------------------ Signature Due: 3320.00 TJS Form DAYOPOS-ST DAYO POS, TJS LAB Page: 26 ■ EXAMPLE OF RECEIPT INVOICE The following is an example of a Receipt Type Invoice. The page eject option can be turned on/off in the Configuration menu. No printing of the customer name and address will take place if the name of the customer is 'CASH'. Invoice: 3474 Date: 03/22/91 Account: 100 Time: 23:57:58 Sherry Johnson 3962 Georgy Drive North Augusta, SC 29841 Phone: 803 278-5555 Type: REG Shipper: PICKUP FOB: None Terms: CASH PO: N/A Rep: GM -------- ------------ -------------- Qty Item Extended Price -------- ------------ -------------- 1.00 DRESS-19292 20.00 Dress, blue, split, long #2 (Surplus) 0.00 010-0800/06 10.00 Socks, blue, Sz 18 1.00 010-0800/20 10.00 Socks, red, Sz 18 ---------- Subtotal: 40.00 Adjustment: 1.00 Taxes: 1.12 Freight: 1.00 ---------- *** Total: 43.12 ---------- - Credit: 43.12 ---------- Due: 0.00 Thank You! DAYO POS, TJS LAB Page: 27 ■ BILL OF MATERIAL WORKSHEET If you have the 'Print BOM Worksheet' configuration option set to 'Yes', have installed the DAYO MRP module, and have created bill of materials for some of your items, the following prompt will appear just after printing or reprinting an invoice: ╔═════════════════════════════════════════════════════════════════════════╗ ║ █▄███ ▄███▄ █ █ █ █ ▄███▄ █▄██ █ █ ████ █ █ ████ ████ █████ ║ ║ █ █ █ █ ██ ██ █ █ █ █ █ █ █ █▀ █ █ █ █ █ █ ║ ║ █████ █ █ █████ ▀█ █ █▀ █ █ ████ ███ ▀██▄ ████ ███ ███ █ ║ ║ █ █ █ █ █ █ █ ▀███▀ █ █ █ █ █ █▄ █ █ █ █ █ █ ║ ║ █▀███ ▀███▀ █ ▀ █ █ █ ▀███▀ █ ██ █ █ ████ █ █ ████ ████ █ ║ ║ ║ ║ EndItem: X-AXLIB Desc: AX MUSIC SYNTHESIZER ║ ║ ║ ║ Do you want to print a Bill of Material for this item! (Y/N) ║ ║ ║ ╚═════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF BILL OF MATERIAL WORKSHEET BILL OF MATERIAL WORKSHEET FOR ENDITEM: X-AXLIB Date: 05/18/91 Cost: 290.00 AX MUSIC SYNTHESIZER Price: 329.00 Type: RET Class: MRP Location: B3 Retail: 549.95 Hours: 2.00 Labor: 35.50 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Item Description Required Onhand Notes ------------ ------------------------------ ---------- ---------- ---------- X-XMT2 MODEM - 2400 EXT - AMT DISKLES 200.000 230.000 __________ X-B-386SX MB - 80586SX/16 200.000 55.000 __________ X-B-ECS386 MB - 80586SX/16 2300.000 23.000 __________ X-B-TANG MB - 80586/12 3400.000 32.000 __________ X-V105 CC - XT FDC 200.000 29.000 __________ X-V109 PRINTER CARD 10000.000 43322.000 __________ X-V128-2 XT SUB SYS-DIR-CASE-Mb-AT-13MZ 100.000 553.000 __________ X-V158P MB - 8084/11 - PHOENIX 300.000 230.000 __________ X-V1MBSIP-80 SIPP - 1MB x 3/80 NS 3200.000 3456.000 __________ X-V227 MB - 80586/12 - G22CX 200.000 552.000 __________ X-Y239 CC - IDE HD/FD /KL 100.000 2341.000 __________ Y-GLUE SUPER BLUE GLUE 3.560 441.621 __________ DAYO POS, TJS LAB Page: 28 ■ BROWSE HEADER INVOICE RECORDS The second INVOICE menu option (BROWSE INVOICE HEADERS) creates a browse screen of all invoice header records. Key information about the customer and the invoice is printed on the top of the screen, ie: DAYO POS Version 3.0 TJS LAB INVOICE ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ Sam Space Sam Space Warehouse #45 ║ ║ PO Box 5555 91003 East Hollywood Blvd ║ ║ 1300 Beaumont St. Door #5 ║ ║ LA, CA 91010 L.A., CA 55555-5555 ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 1 REG JD CASH US MAIL ║ ║ PHONE ATTN CREDIT LASTDATE ║ ║ (800) 555-5555 Norman H. 0.00 12/28/89 ║ ╚═══════════════════════[ Browse the Invoice Headers ]═══════════════════════╝ INVOICE CUSTOMER SHIPNAME ─────────────────────╥──────────╥───────────────────────────────────────────── 5 ║ 1 ║ TJS LAB 5 ║ 1 ║ TJS LAB 6 ║ 1 ║ TJS LAB 7 ║ 1 ║ TJS LAB 8 ║ 1 ║ TJS LAB 10 ║ 1 ║ TJS LAB 11 ║ 23 ║ JOE MORGAN INC 12 ║ 1 ║ TJS LAB Esc (Exit) F2 (Edit) F3 (Detail) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (Invoice) F6 (Ship To Name) F7 (Customer) 11/87 ■ EDIT HEADER INVOICE RECORDS Press 'F2' to bring up the full screen edit option. Note, this capability can be removed with the 'Allow Browse Edit' configuration setting. DAYO POS, TJS LAB Page: 29 Example of a Full Screen Edit of the invoice header record: DAYO POS Version 3.0 TJS LAB INVOICE ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ INVOICE: 7 FREIGHT: 2.00 │ │ CUSTOMER: 1 SUBTOTAL: 10.00 │ │ SHIPNAME: GUTTER KING OPEN: T │ │ SHIPADDR1: PO BOX 555 PAID: 171.66 │ │ SHIPADDR2: COMMENT: │ │ SHIPCITY: MARIETTA PRINTED: F │ │ SHIPSTATE: GA │ │ SHIPZIP: 32858-5366 │ │ PHONE: (800) 555-5555 │ │ TYPE: REG │ │ TERMS: COD │ │ SHIPPER: UPS GROUND │ │ DATE: 12/10/89 │ │ TIME: 13:17:31 │ │ REG: 1 │ │ BY: Jose Jargen │ │ SALESPER: JJ │ │ CUST_PO: │ │ TAXRATE: 0.060 │ │ TAXES: 1.32 │ │ ADJUST: 1.00 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ ADD A BLANK INVOICE HEADER RECORD If so configured ('Allow Browse Edit'), you can add invoice header records by pressing 'Ctrl N'. Note, this is highly NOT recommended! ■ DELETE INVOICE HEADER RECORD If so configured ('Allow Browse Edit'), you can mark invoice header records for deletion by pressing 'Ctrl U'. Note, it is recommended that you use the DAYO AR module to remove, archive, and/or void invoices (both header and detail records). DAYO POS, TJS LAB Page: 30 ■ BROWSE DETAIL INVOICE RECORDS The third INVOICE menu option (BROWSE INVOICE DETAIL) is a browse screen of all invoice detail records. Key information about the customer is printed on the top of the screen, ie: DAYO POS Version 3.0 TJS LAB INVOICE ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ Tim Johnson Tim Johnson ║ ║ PO Box 5555 PO Box 5555 ║ ║ 893 Last Street 893 Last Street ║ ║ Marylboro, MA 39393-2333 Marylboro, MA 39393-2333 ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 1 REG FGH NET 90 TRUCK ║ ║ PHONE ATTN TAXRATE LASTDATE ║ ║ (800) 555-5555 Salli 0.050 01/23/90 ║ ╚═════════════──────────[ Browse the Invoice Detail ]─────────═══════════════╝ INVOICE ITEM DESC QTY PRICE ────────╥──────────────╥────────────────────────────────╥─────────╥─────────── 7 ║ 12343 ║ 20 Bond Paper, Ream ║ 455 ║ 20.00 7 ║ 12444 ║ 18 Bond Paper, Ream ║ 56 ║ 15.66 7 ║ 22344 ║ Cardboard Sheets 8x12 " ║ 55 ║ 4.70 7 ║ 34444 ║ Cardboard Sheets 3x4 " ║ 4 ║ 1.36 7 ║ 37658 ║ Binder, Red #1 ║ 88 ║ 1.36 7 ║ 43466 ║ Binder, Green #1 ║ 61 ║ 1.36 7 ║ 45786 ║ Binder, Red #3 ║ 23 ║ 3.56 7 ║ 75487-3A ║ Loose Leaf Paper, 500 Pack ║ 230 ║ 6.17 8 ║ 950000 ║ Loose Leaf Paper, 100 Pack ║ 2344 ║ 2.10 Esc (Exit) 22/332 Press 'F2' to bring up the full screen edit option. Note, this capability can be removed with the 'Allow Browse Edit' configuration setting. Example of a Full Screen Edit of the invoice detail record: DAYO POS Version 3.0 TJS LAB INVOICE ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ INVOICE: 1200 │ │ ITEM: YOULM-7800 │ │ DESC: CHAIN SAW, 98" BLADE │ │ QTY: 10 │ │ PRICE: 1293.70 │ │ COST: 893.63 │ │ TAXABLE: T │ │ DATE: 12/27/89 │ │ │ │ │ DAYO POS, TJS LAB Page: 31 ■ ADD A BLANK INVOICE DETAIL RECORD If so configured ('Allow Browse Edit'), you can add invoice detail records by pressing 'Ctrl N'. Note, this is highly NOT recommended! ■ DELETE INVOICE DETAIL RECORD If so configured ('Allow Browse Edit'), you can mark invoice detail records for deletion by pressing 'Ctrl U'. Note, it is recommended you use the DAYO AR module to remove, archive, and/or void invoices (both header and detail records). ■ TEMPLATES 'Templates' is the DAYO POS term for a collection of detail line items that can be easily added to an invoice. Templates can be created to contain a set of items that may create a bundle, 'bill of material', or a group of commonly sold items. Creating templates is accomplished by selecting the fourth INVOICE menu option ('BROWSE/CREATE TEMPLATE'). The TEMPLATE browse screen contains a box atop the page with all the key item information. The lower part of the screen is your normal DAYO browse screen. DAYO POS Version 3.0 TJS LAB INVOICE ╔═════════════════════════════════════════[ Item Info ]══════════════════════╗ ║ Item Vendor Item Vendor Description Type ║ ║ DAYOPOS-M DAYOPOS-M TJS Manual, DAYO POS MAN ║ ║ Onhand OnOrder Cost Retail Price Template Price ║ ║ 22 1 5.00 5.00 5.00 5.00 ║ ╚════════════════════════[ Browse/Create Templates ]═════════════════════════╝ TEMPLATE ITEM DESC QTY ───────────────╥──────────────╥────────────────────────────────╥────────────── 4 ║ DAYOPOS-M ║ Manual, DAYO POS ║ 1 4 ║ DAYOQUO-M ║ Manual, DAYO Quotes ║ 1 4 ║ DAYOPB-M ║ Manual, DAYO Price Book ║ 1 5 ║ DAYOX-SL ║ DAYO Index, Source License ║ 1 5 ║ DAYOINV-SL ║ DAYO Inventory, Source License ║ 1 5 ║ DAYOPOS-SL ║ DAYO POS, Source License ║ 1 5 ║ DAYOAR-SL ║ DAYO AR, Source License ║ 1 6 ║ DAYOUTIL-SL ║ DAYO UTILITIES, Source License ║ 1 ║ ║ ║ Esc (Exit/Abort) F1 (Help) F2 (Edit) F3 (Add Item From Inventory) Ctrl N (Add/Create New Template) Ctrl U (Delete/Recall) Find: F5 (Template) DAYO POS, TJS LAB Page: 32 Press 'F2' to bring up the Full Screen Edit screen, ie: DAYO POS Version 3.0 TJS LAB INVOICE ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ TEMPLATE: 0 │ │ ITEM: 199900 │ │ DESC: BIG JAR │ │ QTY: 23 │ │ PRICE: 23.40 │ │ DATE: 12/12/89 │ │ │ Press 'F3' to add an item to the template. This brings up a browse selection screen of the inventory (below). Find the item you wish to add to the current template, and press Enter/Return. DAYO POS Version 3.0 TJS LAB INVOICE ╔═════════════════════════════════════════[ Item Info ]══════════════════════╗ ║ Item Vendor Item Vendor Description Type ║ ║ ABC-12312 ABC-12312 ABC SOFA, GROMMAN STYLE, BROWN SOF ║ ║ Onhand OnOrder Cost Retail Price Template Price ║ ║ 12 100 145.00 565.00 235.00 199.00 ║ ╚═════════════════════[ Select Item From The Inventory ]═════════════════════╝ ITEM DESC ONHAND ONORDER BO ──────────────╥────────────────────────────────╥─────────╥─────────╥────────── ABC-12312 ║ SOFA, GROMMAN STYLE, BROWN ║ 12 ║ 100 ║ 0 ABC-12324 ║ SOFA, GREEN ║ 23 ║ 0 ║ 0 ABC-12343 ║ SOFA, TYPE 2 ║ 23 ║ 25 ║ 0 ABC-12345 ║ SOFA, NEW YORKER ║ 30 ║ 0 ║ 0 ABC-12354 ║ SOFA, WICKER ║ 60 ║ 35 ║ 0 ABC-12365 ║ SOFA, SMALL WICKER ║ 64 ║ 2 ║ 0 ABC-12371 ║ SOFA, SMALL WICKER, (USED) ║ 15 ║ 5 ║ 0 ABC-12399 ║ SOFA, MISC ║ 44 ║ 5 ║ 0 ABC-123A1 ║ SOFA, CHAIR (1/2 SIZE) ║ 18 ║ 25 ║ 0 ABC-123A1 ║ SOFA, ARMLESS, RED BROWN ║ 54 ║ 0 ║ 0 ABC-123A1 ║ CHAIR, PLAIN ║ 45 ║ 0 ║ 0 ABC-123A1 ║ CHAIN, KITCHEN PADDED TAN ║ 0 ║ 34 ║ 0 ABC-123A1 ║ CHAIR, KITCHEN PADDED GREEN ║ 35 ║ 0 ║ 0 Esc (Exit/Abort) Enter/Return (Select Item) Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type) 70/74 DAYO POS, TJS LAB Page: 33 ■ CREATE NEW TEMPLATE Press 'Ctrl N' to create a new template number. A default template number is determined by going to the bottom of the file and adding '1' to that template number. You will be prompted to change or accept the new template number, ie: ┌────────────────────────────────────────────────────────────────────────────┐ │ Enter Template Number: 4 │ └────────────────────────────────────────────────────────────────────────────┘ After this point, the adding of the template line items is the same as described above (using the F3 key)... ■ DELETE TEMPLATE ITEM Press 'Ctrl U' to delete a template line item. Use the MISC ROUTINES module to PACK the TEMPLATE DATABASE. BE SURE TO REINDEX THE TEMPLATE INDEX (TEMPLATE.NTX)! ■ REPRINT AN INVOICE (OR WORK ORDER) Reprinting an invoice or work order is accomplished via the fifth INVOICE menu option (REPRINT INVOICE). The REPRINT INVOICE screen is a browse screen of all invoice header records. The important invoice and customer data is displayed at the top of the screen, ie: DAYO POS Version 3.0 TJS LAB INVOICE ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ MORGAN SCOTT MORGAN SCOTT WAREHOUSE #5 ║ ║ 1929 LAKE CITY ROAD 8000 EAST STREET ║ ║ DOOR 5 ║ ║ CANTON, OH 23433 HARTFORD, CT 23493-2333 ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 2333 A DSG NET 36 UPS BLUE ║ ║ PHONE ATTN CREDIT LASTDATE ║ ║ (237) 333-5555 Harold Keith 394.56 12/29/89 ║ ╚═══════════════════════════[ Reprint An Invoice ]═══════════════════════════╝ INVOICE CUSTOMER SHIPNAME ─────────────────────╥──────────╥───────────────────────────────────────────── 2341 ║ 27400 ║ MARTINS NURSERY 2342 ║ 25423 ║ JULIE BROWN 2343 ║ 23323 ║ JULIE BROWN, INC 2344 ║ 28434 ║ HARPERS FERRY BOAT 2345 ║ 32333 ║ MORGAN SCOTT 2347 ║ 32323 ║ TIME SOLUTIONS 2348 ║ 21188 ║ COMPU AIDE Esc (Exit/Abort) Enter/Return (Select Invoice For Reprint) Find: F5 (Invoice) F6 (Ship To Name) F7 (Customer) DAYO POS, TJS LAB Page: 34 You can reprint a specific invoice or work order, or 'batch' print all open invoices that have not yet been printed (OPEN=.T., PRINTED=.F.). Find the invoice you want reprinted, then press Enter/Return. Just press Enter/Return on any invoice if you intend to Batch print the invoices. The following window will appear prompting you to print an invoice or work order or Batch print: ╔════════════════════════════════════════════════════════════════════╗ ║ Select Print Option -> INVOICE ║ ║ WORK ORDER ║ ║ BATCH PRINT ALL UNPRINTED INVOICES ║ ║ EXIT ║ ╚════════════════════════════════════════════════════════════════════╝ If you select the work order option, you can make changes to the work order comments/notes. Note, if an invoice is printed for the first time (even via this routine), it will not have 'REPRINT' printed on it. ■ ADD COMMENTS TO WORK ORDER OR INVOICE The option exists to print up to 21 lines of notes/comments onto the invoice and/or work order. Note, this is a setting you must 'turn on' in the Configuration routine. ╔════════════════════════════════════════════════════════════════════════╗ ║ Do you wish to add any comments to the Invoice/Work Order? (Y/N) ■ ║ ╚════════════════════════════════════════════════════════════════════════╝ ■ OPEN CASH DRAWER If you have the 'Cash Drawer' configuration option set to 'Y', and have the cash drawer properly attached to the CPU, the selection of this option will cause the cash drawer to open. Note, you will experience a serious error at this point if there exists a problem with the cash drawer connection (or if it does not exist). DAYO POS, TJS LAB Page: 35 ■ VIEW INVENTORY This option was provided to find a faster/easier way to view the inventory. No editing is allowed. DAYO POS Version 3.0 TJS LAB VIEW INVENTORY ╔════════════════════════════════════════════════════════════════════════════╗ ║ Item: YK90086 Desc: TRACKS KIDS TRI-COLOR NEON BB Type: Class: BB ║ ║ VendItem: YUNGKE12 222-TRACKS KIDS TRI-COLOR NEON Vendor: YUNGKE ║ ║ Onhand: 998.000 Allocated: 0.000 BO: 1.000 OnOrder: 24.000 ║ ║ Price: 0.792 Retail: 24.792 PTD: 3.00 YTD: 3.00 ║ ║ Price1: 24.790 Cost: 12.396 Date: / / Accessed: 02/01/91 ║ ║ Price2: 20.660 AVG Cost: 0.000 Stock: / / Location: ║ ║ Price3: 17.710 Real Cost: 0.000 BOM: No NS: No ║ ║ Price4: 15.500 Taxable: No Serialized: No Time: No ║ ║ Price5: 13.770 Wt: 0.000nDZ UnitQty: 12 PackQty: 12/// ║ ╟═════════════════════════[ VIEW INVENTORY DATABASE ]════════════════════════╢ ║ ITEM DESC ONHAND ONORDER ║ ║─────────────────╥────────────────────────────────╥───────────╥─────────────║ ║ VELCRO FRAME ║ 23-3/8X18-3/4X3/4 ║ 368.44 ║ 0.00 ║ ║ VELCRO FRME ║ 17-1/2X16-3/4X3/4 ║ 378.67 ║ 0.00 ║ ║ WWHA18 ║ HAIR BENDERS-ASSORTED ║ 1023.44 ║ 0.00 ║ ║ WWHA81 ║ HAIRTIE WITH ORNAMENT ║ 1033.67 ║ 0.00 ║ ║ WWVW02 ║ GATOR & SEMINOLE WALLETS ║ 1043.91 ║ 0.00 ║ ║ YK8686L ║ PVC SLIPPER ║ 992.74 ║ 0.00 ║ ║ YK8686L ║ PVC SLIPPER ║ 1299.77 ║ 0.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Full Screen View) Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type) DAYO POS, TJS LAB Page: 36 ■ FULL SCREEN VIEW - F2 No edit is allowed here... DAYO POS Version 3.0 TJS LAB VIEW INVENTORY ╔════════════════════════════[ FULL SCREEN VIEW ]════════════════════════════╗ ║ITEM: YK90086 UNITQTY: 12 ║ ║DESC: TRACKS KIDS TRI-COLOR NEO UNIT: DZ ║ ║ONHAND: 998.00 LOCATION: ║ ║ONORDER: 24.00 ALLOCATED: 0 ║ ║BO: 1 AVGCOST: 0.000 ║ ║SOLDPTD: 3 REALCOST: 0.000 ║ ║SOLDYTD: 3 TI: F ║ ║VENDITEM: YUNGKE12 NS: F ║ ║VENDOR: YUNGKE PRICE1: 24.79 ║ ║DATE: / / PRICE2: 20.66 ║ ║LASTDATE: 02/01/91 PRICE3: 17.71 ║ ║COST: 12.396 PRICE4: 15.50 ║ ║LPRICE: 2.500 PRICE5: 13.77 ║ ║RETAIL: 24.792 DESC2: 222-TRACKS KIDS TRI-COLOR║ ║PRICE: 0.792 PACKQTY: 12/// ║ ║STOCKLEVEL: 0 BOM: F ║ ║TYPE: ║ ║CLASS: BB ║ ║TAXABLE: F ║ ║SERIALNO: F ║ ║WEIGHT: 0.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... DAYO POS, TJS LAB Page: 37 ■ VIEW CUSTOMER This option makes viewing (no editing) of the customer data easier. You can also display/browse a customer's sales profile/history. DAYO POS Version 3.0 TJS LAB VIEW CUSTOMER ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ Bumler Heating & Specs., Inc. ║ ║ 11501 Stephens ║ ║ Suite B ║ ║ Warren, MI 48089 , ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 2021 ║ ║ PHONE ATTN CREDIT LASTDATE ║ ║ (313) 754-2610 Mike Tremblay 5.00 10/01/90 ║ ╚═══════════════[ VIEW CUSTOMER DATA & PROFILE/SALES HISTORY ]═══════════════╝ CUSTOMER NAME ATTN ───────────╥────────────────────────────────╥───────────────────────────────── 2020 ║ Paper Image ║ Fred Haney 2021 ║ Bumler Heating & Specs., Inc. ║ Mike Tremblay 2022 ║ Richard H. Mason ║ 2023 ║ Rick Guggemos ║ 2024 ║ SDN PROJECT ║ Ray Kaliss 2026 ║ Computer Directions, Inc. ║ Barry Lee 2027 ║ Pro. Shareware Libraries ║ Eric Engelmann 2028 ║ Public (software) Library ║ Esc (Exit) F1 (Help) F2 (Full Screen View) F3 (Profile) Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code) 89/309 DAYO POS, TJS LAB Page: 38 ■ FULL SCREEN VIEW - F2 Press F2 to view (but not edit) the customer's record/data: DAYO POS Version 3.0 TJS LAB VIEW CUSTOMER ╔════════════════════════════[ FULL SCREEN VIEW ]════════════════════════════╗ ║CUSTOMER: 2021 LASTDATE: 10/01/90 ║ ║NAME: Bumler Heating & Specs., TYPE: ║ ║ATTN: Mike Tremblay CLASS: ║ ║ADDR1: 11501 Stephens PBM: 0.000 ║ ║ADDR2: Suite B PBL: 0.000 ║ ║CITY: Warren SALESPTD: 5.00 ║ ║STATE: MI SALESYTD: 5.00 ║ ║ZIP: 48089 DUE: -5.00 ║ ║SHIPNAME: PAID_PURC: 135.00 ║ ║SHIPADDR1: LIMIT: 0.00 ║ ║SHIPADDR2: ACTIVE: T ║ ║SHIPCITY: TAXCODE: ║ ║SHIPSTATE: FAX: ║ ║SHIPZIP: SHIPPHONE: ║ ║PHONE: (313) 754-2610 FOB: ║ ║SALESPER: PRICEX: 0 ║ ║RATE: 0.000 ║ ║TAXRATE: 0.0000 ║ ║TERMS: ║ ║SHIPPER: ║ ║DATE: 02/04/90 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... DAYO POS, TJS LAB Page: 39 ■ CUSTOMER PROFILE/HISTORY Press F3 to bring up a browse display of all detail items a customer has purchased. Note, the data is derived from the DAYO AR database: ARD.DBF, which contains posted invoices. DAYO POS Version 3.0 TJS LAB VIEW CUSTOMER ╔════════════════════════════════════════════════════════════════════════════╗ ║ Customer Name: YALE SECURITY INC. Invoice: 329 Date: 01/13/90 ║ ║ Customer PO: P109011371 Taxable: Yes SalesPer: 2 ║ ║ INVOICE ITEM DESC QTY ║ ║────────────╥──────────────╥────────────────────────────────╥───────────────║ ║ 304 ║ A200041 ║ AP-11 16 X 20 X 2 ║ 12.00 ║ ║ 329 ║ A905500 ║ 20 X 20 X 2 PAINT ARREST PADS ║ 1250.00 ║ ║ 407 ║ LB MEDIA. ║ 58"X90' STYLE LB MEDIA ║ 6.00 ║ ║ 511 ║ AMW ║ 12X12X2 NOMINAL AMW ║ 1.00 ║ ║ 586 ║ 1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 10.00 ║ ║ 586 ║ 1246G1 ║ A2251246G1 REGISTER ASSEMBLY ║ 10.00 ║ ║ 586 ║ 1247G1 ║ A2251247G1 ║ 2.00 ║ ║ 586 ║ 1051232P1 ║ 1051232P1 LAMP ║ 10.00 ║ ║ 631 ║ 1257791G51 ║ 1B32083-1S ║ 3.00 ║ ║ 670 ║ M-2 PANEL ║ 20X25X1 M-2 PANEL ║ 42.00 ║ ║ 717 ║ TIF.. ║ 19-1/8X23-1/8X1-3/4 EXACT ║ 1.00 ║ ║ 772 ║ 45FB-45 ║ 24X24X8-3/4 FILT. W.HOUSING ║ 1.00 ║ ║ 812 ║ 6-40G16 ║ 12X24X15 ║ 1.00 ║ ║ 812 ║ 6-40A16 ║ 24X24X15 ║ 4.00 ║ ║ 812 ║ 6-40D16 ║ 20X20X15 ║ 5.00 ║ ║ 846 ║ A200122 ║ AP-15 20 X 25 X 2 ║ 10.00 ║ ║ Move around with PgUp/PgDn and/or Arrow Keys Press Esc to Exit... ║ ╚════════════════════════════════════════════════════════════════════════════╝ 21/106 DAYO POS, TJS LAB Page: 40 ■ CUSTOMERS The customer maintenance routine for DAYO POS is not a very elaborate one, nor was meant to be. Use DAYO AR to maintenance your customer data. It is recommended that this routine only be made available for viewing of customer information. If you set your configuration to allow editing of the data, make note that NO validation of data entry is performed! The CUSTOMERS option consists of a typical DAYO browse screen of all customers. Key customer information is printed on the top half of the screen, the browse at the lower half, ie: DAYO POS Version 3.0 TJS LAB ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ DIRK HARPER WAREHOUSE 3 ║ ║ 3900 LEFTY ROAD ║ ║ ║ ║ Lake Mary, FL HINESVILLE, GA 31313 ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 687 REG DD NET 60 UPS RED ║ ║ PHONE ATTN TAXRATE LASTDATE ║ ║ 912 767-5555 MOHAMMED 0.550 12/29/89 ║ ╚══════════════════════[ Browse the Customer Database ]══════════════════════╝ CUSTOMER NAME ATTN ───────────╥────────────────────────────────╥───────────────────────────────── 687 ║ DIRK HARPER ║ MOHAMMED 2344 ║ DON JUAN PRODUCTIONS ║ 2356 ║ UNIVERSAL INC ║ 2365 ║ HAPPY FLOWERS BOUTIQUE ║ JOE 3457 ║ ARGON DEVELOPERS ║ 3465 ║ ARGON, INC ║ GEORGE 3477 ║ BILLY ARGON ║ ARLIE 3478 ║ MARY ELIZABETH COSMETICS ║ TRACIE MORGAN Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code) 11/17 DAYO POS, TJS LAB Page: 41 ■ CUSTOMER FULL SCREEN EDIT Press 'F2' to edit the customer record in a full screen edit, ie: DAYO POS Version 3.0 TJS LAB ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ CUSTOMER: 687 TYPE: REG │ │ NAME: DIRK HARPER CLASS: A │ │ ATTN: MOHAMMED PBM: 0.000 │ │ ADDR1: PBL: 0.000 │ │ ADDR2: SALESPTD: 234.58 │ │ CITY: Hinesville SALESYTD: 5640.31 │ │ STATE: GA DUE: 453.30 │ │ ZIP: PAID_PURC: 356.54 │ │ SHIPNAME: WAREHOUSE 3 LIMIT: 7000.00 │ │ SHIPADDR1: 3900 LEFTY ROAD ACTIVE: T │ │ SHIPADDR2: │ │ SHIPCITY: HINESVILLE │ │ SHIPSTATE: GA │ │ SHIPZIP: 31313 │ │ PHONE: 912 767-5555 │ │ SALESPER: DD │ │ TAXRATE: 0.550 │ │ TERMS: NET 7 │ │ SHIPPER: UPS RED │ │ DATE: 08/17/89 │ │ LASTDATE: 12/29/89 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO POS, TJS LAB Page: 42 ■ CONFIGURATION DAYO POS configuration contains many configurable options to better meet your specific needs. There are 70+ significant DAYO POS configuration settings: Company Name Allow Customer Add Report Printer Type Company Address Use Credit Limit Report Printer Port Company Telephone Open/Close Registers Visual Indexing Last Customer Number Display Cost Auto Daily Indexing Auto Print Invoice Default Shipper Print Packing List Last Invoice Number Default Terms Packing List Port Invoice Printer Type Inventory Location Price on Packing List Invoice Printer Port Customer Location Work Order Copies Invoice Copies Quotes Location W.O. Printer Type Default Tax Code Back Orders Location W.O. Printer Port Default Invoice Type Price Book Location W.O. Notes Phrase Override Onhand Serial Cash Drawer Allocate Work Orders Post Returns/Refunds Cash Drawer Port Default Comment Create BackOrders Parallel Cash Drawer Color Allow Browse Edit Parallel Drawer Port High Intensity Allow Inventory Add Parallel Setup Code Open/Close Register Preselect Ship To Multiple Prices Use ORDERED Field Tax Adjustments Tax Freight Use Warehouses Default Freight % Show Customer Notes Print Invoice Notes Show BO Extension GL Database Location Automatic GL Posting * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Before doing any invoicing, it is highly recommended that you read this section to get a better understanding of the meanings of every configuration setting. After determining how you wish to set/run DAYO POS, make the changes. DAYO POS, TJS LAB Page: 43 ■ CONFIGURATION DEFAULT SETTINGS The default values for the configuration settings are listed below: Company Name YOUR COMPANY NAME HERE Company Address Attn: Accounts Receivable P.O. Box 555555 Someplace, ST 55555-5555 Company Telephone 800-555-5555 Last Customer Number 0 Auto Print Invoice YES Last Invoice Number 0 Invoice Printer Type STANDARD Invoice Printer Port LPT1 Invoice Copies 1 Default Tax Code 1 Default Invoice Type REG Override Onhand NO Create BackOrders NO Allow Browse Edit YES Allow Inventory Add YES Allow Customer Add YES Use Credit Limit NO Display Cost to Customer YES Default Shipper PICKUP Default Terms CASH Inventory Location '' Customer Location '' Quotes Location '' Back Orders Location '' Price Book Location '' GL Location '' Cash Drawer NO Cash Drawer Port COM1 Report Printer Type STANDARD Report Printer Port LPT1 Visual Indexing YES Auto Daily Indexing YES Print Packing List NO Packing List Port LPT1 Tax Freight YES Tax Freight States Use Warehouses YES Default Freight Percentage 0.0400% Show Customer Notes on Screen YES Print WO Notes on Invoice NO Show Extended BO Price NO Use Multiple Pricing YES Use the ORDERED Field YES Automatic GL Posting NO Color YES High Intensity NO DAYO POS, TJS LAB Page: 44 ■ CONFIGURATION MENU The CONFIGURATION menu is a selection box that appears on the left side of the main menu screen, ie: DAYO POS Version 3.21 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│ ║ Last Customer Number ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │ ║ Auto Print Invoice ║ │ │ ║ Last Invoice Number ║ └────────────────────┘ ║ Invoice Printer Type ║ ╓────────────────────────────────────────────────╖ ║ Invoice Printer Port ║ ║ DAYO POS STATISTICS Register Closed ║ ║ Invoice Copies ║ ╟────────────────────────────────────────────────╢ ║ Default Tax Code ║ ║ DATABASE NAME RECORDS SIZE ║ ║ Default Invoice Type ║ ╟────────────────────────────────────────────────╢ ║ Override Onhand ║ ║ INV.DBF Inventory 74 14K ║ ║ Create BackOrders ║ ║ INVOICE.DBF Invoice Header 61 24K ║ ║ Allow Browse Edit ║ ║ DETAIL.DBF Invoice Detail 286 25K ║ ║ Allow Inventory Add ║ ║ CUSTOMER.DBF Customers 205 104K ║ ║ Allow Customer Add ║ ║ SERIALNO.DBF Serial Numbers 268 17K ║ ║ Use Credit Limit ║ ║ SALESPER.DBF Sales Persons 2 1K ║ ║ Default Shipper ║ ║ TEMPLATE.DBF Templates 9 1K ║ ╟────────────────────────╢ ║ REGISTER.LOG Register Log 594 52K ║ ║ Select Option ║ ╚════════════════════════════════════════════════╝ ╚════════════════════════╝ To access any of the options (you can scroll down to others) highlight the option, and press Enter/Return. Company Name Open/Close Registers Auto Daily Indexing Company Address Display Cost Print Packing List Company Telephone Default Shipper Packing List Port Last Customer Default Terms Price on Packing List Auto Print Invoice Inventory Location Work Order Copies Last Invoice Number Customer Location W.O. Printer Type Invoice Printer Type Quotes Location W.O. Printer Port Invoice Printer Port Back Orders Location W.O. Notes Phrase Invoice Copies Price Book Location Allocate Work Orders Default Tax Code Current Directory Default Comment Default Invoice Type Serial Cash Drawer Show List Invoice Override Onhand Cash Drawer Port Show Price/List Post Returns/Refunds Parallel Cash Drawer Pre-Select Ship To Create BackOrders Parallel Drawer Port Tax Adjustments Allow Browse Edit Parallel Setup Code Use Warehouses Allow Inventory Add Report Printer Type Color Allow Customer Add Report Printer Port High Intensity Use Credit Limit Visual Indexing Freight Percentage Display Customer Notes Tax Freight MRP Location Manufacture ENDITEMS Override Invoice Number Print Control Number Second Tax CreditCard On Invoice Print BOM Worksheet Order Entry Location Margin: points vs % BOM Printer Port DAYO POS, TJS LAB Page: 45 ■ COMPANY NAME, ADDRESS & TELEPHONE Each field for these options is limited to 30 characters, 14 for the telephone... ┌──────────────────────────────[ COMPANY NAME ]─────────────────────────────┐ │ Enter Your Company Name: Marvin Plesance & Company │ └───────────────────────────────────────────────────────────────────────────┘ ┌─────────────────────────────[ COMPANY ADDRESS ]───────────────────────────┐ │ Address Line 1: Attn: Accounts Receivable │ │ Address Line 2: 1400 East Lancaster Street │ │ City, State ZIP: Mytown, GA 55555-5555 │ └───────────────────────────────────────────────────────────────────────────┘ ┌────────────────────────────[ COMPANY TELEPHONE ]──────────────────────────┐ │ Enter Your Company Telephone: 404-555-5555 │ └───────────────────────────────────────────────────────────────────────────┘ ■ LAST CUSTOMER ACCOUNT NUMBER ┌──────────────────────[ LAST CUSTOMER ACCOUNT NUMBER ]──────────────────────┐ │ Note, this option is overridden by DAYO AR... │ │ │ │ Enter Last Customer Account Number: 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATICALLY PRINT THE INVOICE ┌──────────────[ AUTOMATICALLY PRINT INVOICES AFTER INVOICING ]──────────────┐ │ If you want your invoices to automatically print after invoicing, then │ │ change this option to Y (YES). │ │ Default is to automatically print the invoices. │ │ │ │ Automatically Print Invoices? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST INVOICE NUMBER ┌──────────────────────────[ LAST INVOICE NUMBER ]───────────────────────────┐ │ Enter Last Invoice Number: 4999 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 46 ■ INVOICE PRINTER TYPE ┌──────────────────────────[ INVOICE PRINTER TYPE ]──────────────────────────┐ │ There are 4 types of DAYO POS printed invoices: STANDARD, LASER, │ │ DATA ONLY, and the RECEIPTS invoice. │ │ The STANDARD invoice prints standard characters with headings. │ │ The LASER invoice prints a special invoice onto a Hewlett Packard │ │ compatible laser printer. │ │ The DATA ONLY invoice is the same as the STANDARD with the exception │ │ of the headings (for use with pre-printed forms). │ │ The RECEIPT invoice is a simple (40 characters wide) listing of │ │ items sold with subtotals. │ │ │ │ Enter Your Invoice Printer Type -> STANDARD │ │ LASER │ │ DATA ONLY │ │ RECEIPT │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE PRINTER PORT ┌──────────────────────────[ INVOICE PRINTER PORT ]──────────────────────────┐ │ Enter Your Invoice Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE COPIES ┌───────────────────[ Number of Invoice Copies To Print ]────────────────────┐ │ This option determines the number of invoice copies to print at the │ │ time of invoicing. Default is to print one copy of the invoice. │ │ │ │ Enter Number of Invoice Copies: 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT TAX CODE ┌────────────────────────────[ DEFAULT TAX CODE ]────────────────────────────┐ │ This Tax Code/Rate will be the percentage of tax withheld on all │ │ taxable customer invoices. These Tax Codes/Rates are maintained in │ │ the tax code database (TAXCODE.DBF). Use the BROWSE DATABASE option in │ │ the MISC Routines to add/change/delete the records in this database. │ │ │ │ Select The Default Tax Code/Rate -> 0 - 0.0000 │ │ 1 - 0.0600 │ │ 2 - 0.0625 │ └────────────────────────────────────────────────────────────────────────────┘ *** If you need additional decimals, read about the 'fix' in the QUIRKS section near the end of this document... DAYO POS, TJS LAB Page: 47 ■ DEFAULT INVOICE TYPE ┌──────────────────────────[ DEFAULT INVOICE TYPE ]──────────────────────────┐ │ The Invoice Type is used to differentiate between types of invoices. │ │ For example, type REG would be for regular sales, Ret for returns, │ │ and type VOD for voided invoices. The Invoice Types are maintained in │ │ the invoice types database (TYPE.DBF). Use the BROWSE DATABASE option in │ │ the MISC Routines to add/change/delete the records in this database. │ │ │ │ Select The Default Invoice Type -> REG - REGULAR SALE │ │ Ret - RETURN │ │ Ref - REFUND │ │ SPC - SPECIAL │ │ LON - LOANED │ │ EXC - EXCHANGE │ │ TRN - TRANSFER │ │ VOD - VOIDED │ └────────────────────────────────────────────────────────────────────────────┘ The TYPE field is one of the most important invoice fields. It is this field that determines how the invoiced data will be posted to many databases. DAYO POS comes with 8 default invoice types, but more can be added. It is imperative that these TYPE entries NOT be altered. Any additional TYPE entries will be handled (posted), just like the REG (Regular Sale) type. Type Meanings: REG - REGULAR SALE Regular sale, posted to all databases Ret - RETURN Return of items, creates a refund invoice, does NOT put items back into the inventory. Use the DAYO Inventory adjustments option to readjust the inventory RET - RENTAL RETURN Returned Rental Invoice Ref - REFUND Refund. Treated just like a return SPC - SPECIAL Special invoice LON - LOANED Loaned out. NOT posted to inventory EXC - EXCHANGE Exchange of items. NOT posted to inventory TRN - TRANSFER Transfer of items VOD - VOIDED Voided invoice. NOT posted to inventory ■ OVERRIDE ONHAND ┌────────────────────[ OVERRIDE ONHAND WHILE INVOICING ]─────────────────────┐ │ To allow the invoicing of items with an inventory ONHAND quantity less │ │ than or equal to zero, you must change this option to Y (YES). │ │ Default is not to allow invoicing of something not onhand! The purpose │ │ of this option (when set to the default - N ), is to prevent negative │ │ ONHAND quantities in the inventory file (INV.DBF). │ │ │ │ Allow User to Invoice with Nothing Onhand? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 48 ■ POST RETURNS/REFUNDS ┌──────────────────[ POST RETURNS/REFUND TO THE INVENTORY ]──────────────────┐ │ If you wish to Post Returns and Refunded items back into the inventory │ │ when you create a Return/Refund Invoice, then set this option to Y (YES).│ │ The default is not to post quantity back into the inventory file. │ │ 'Manual' adjustments to the inventory will have to take place if this │ │ option is set to N (No)... │ │ │ │ Post Returns/Refunds back into Inventory? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE BACKORDERS ┌───────────────────────────[ CREATE BACKORDERS ]────────────────────────────┐ │ If you wish to create a record of orders for your customers that you │ │ can not fill (BackOrders), then set this option to Y (YES). The │ │ default is not to create backorder records. This option (when set to Y), │ │ overrides the previous one (OVERRIDE ONHAND WHILE INVOICING). │ │ Use DAYO BO to maintenance your BackOrders... │ │ │ │ Create BackOrders For Items Not Onhand? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ ALLOW BROWSE EDITING ┌─────────────────────────[ ALLOW BROWSE EDITING ]───────────────────────────┐ │ To disable the editing of the Invoice Detail Records and Customer │ │ Records, select N (NO) to this option. Default is to allow it. │ │ │ │ Allow Editing of Invoice Detail Records? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ ALLOW INVENTORY ADD ┌────────────────────────[ ALLOW INVENTORY ITEM ADD ]────────────────────────┐ │ If you want the user to have the ability to create new inventory items │ │ at invoicing time, select Y (YES) to this option. │ │ Default is not to allow the creation of inventory items. Use the DAYO │ │ Inventory program (DAYOINV) to maintain the inventory file (INV.DBF). │ │ │ │ Allow User to Create New Inventory Items At Time Of Invoicing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 49 ■ ALLOW CUSTOMER ADD ┌───────────────────────────[ ALLOW CUSTOMER ADD ]───────────────────────────┐ │ To disable the capability of the user to create new customer records, │ │ select N (NO) to this option. Default is Y (YES). │ │ It is recommended that DAYO AR be used to maintain customer records... │ │ │ │ Allow Creation of New Customer Records? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ USE CREDIT LIMIT ┌────────────────────────────[ USE CREDIT LIMIT ]────────────────────────────┐ │ If you wish to place credit limits on your customers, then set this │ │ option to Y (YES). Default is N (NO). If set to Y, then no 'Net' │ │ sales/invoice can be made if that invoice amount plus the amount due │ │ on other sales is greater than the customers credit limit. The credit │ │ limit is the value of the LIMIT field in the customer database │ │ (CUSTOMER.DBF). │ │ Limit Credit? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ OPEN/CLOSE REGISTERS ┌──────────────────────────[ OPEN/CLOSE REGISTERS ]──────────────────────────┐ │ This option determines whether the prompt to open and/or close the │ │ registers is activated. Default (Yes) is to require that you │ │ open/close the registers. │ │ │ │ Open/Close Registers? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ DISPLAY COST FIELD WHILE INVOICING ┌────────────────────[ DISPLAY COST FIELD WHILE INVOICING ]──────────────────┐ │ If you wish to hide the COST field when you are creating an invoice, │ │ set this option to Y (YES). Default is N (NO). │ │ The COST field may be in sight of the customer... │ │ Hide the COST field? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 50 ■ DEFAULT SHIPPER/METHOD OF SHIPMENT ┌───────────────────[ DEFAULT SHIPPER/METHOD OF SHIPMENT ]───────────────────┐ │ This selection is placed on new invoices if the Customers SHIPPER/ │ │ METHOD OF SHIPMENT can not be determined. SHIPPERS/METHOD OF SHIPMENT │ │ selections are maintained in the shipper database (SHIPPER.DBF). │ │ Use the BROWSE DATABASE option in the MISC Routines to add/change/delete │ │ the records in this database. │ │ │ │ Select The Default Shipper -> PICKUP │ │ DELIVER │ │ UPS GROUND │ │ UPS BLUE │ │ FEDERAL EXPRESS │ │ TRUCK │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT TERMS ┌─────────────────────────────[ DEFAULT TERMS ]──────────────────────────────┐ │ This selection is placed on new invoices if the Customers TERMS │ │ can not be determined. TERMS are maintained in the terms database │ │ (TERMS.DBF). Use the BROWSE DATABASE option in the MISC Routines to │ │ add/change/delete the records in this database. │ │ │ │ Select The Default Terms -> CASH │ │ CHECK │ │ COD │ │ AMERICAN EXPRESS │ │ MASTERCARD │ │ NET 10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY DATABASE LOCATION ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in │ │ the same drive/directory as DAYO POS. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO POS where to find the │ │ inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYO\ │ │ The drive designation is optional (if same as DAYO POS). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 51 ■ CUSTOMER DATABASE LOCATION ┌─────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │ │ in the same drive/directory as DAYO POS. If you have installed the DAYO │ │ Customer Database (CUSTOMER.DBF), into a different directory, you need │ │ to tell DAYO POS where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO POS). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ QUOTES DATABASE LOCATION ┌──────────────────[ 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 POS. If you have installed DAYO Quotes │ │ into a different directory, you need to tell DAYO POS 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 POS). │ │ │ │ Enter Location: \DAYOQUO\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ BACK ORDERS DATABASE LOCATION ┌─────────────────[ 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 POS. If you have installed DAYO BO │ │ into a different directory, you need to tell DAYO POS 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 POS). │ │ │ │ Enter Location: \DAYOBO\ │ └───────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 52 ■ MRP - BILL OF MATERIALS DATABASE LOCATION/DIRECTORY ┌───────────[ MRP - BILL OF MATERIALS DATABASE LOCATION/DIRECTORY ]──────────┐ │ The location of the DAYO MRP Bill of Materials Database (BOM.DBF) does │ │ not have to be in the same drive/directory as DAYO POS. If you have │ │ installed DAYO MRP into a different directory, you need to tell DAYO POS │ │ where to find database: BOM.DBF. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOMRP\ │ │ The drive designation is optional (if same as DAYO POS). │ │ │ │ Enter Location: \DAYOMRP\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ ORDER ENTRY DATABASE LOCATION/DIRECTORY ┌─────────────────[ ORDER ENTRY DATABASE LOCATION/DIRECTORY ]────────────────┐ │ The location of the DAYO Order Entry Databases (ie: ORDERS.DBF) does │ │ not have to be in the same drive/directory as DAYO POS. If you have │ │ installed DAYO Order Entry into a different directory, you need to tell │ │ DAYO POS where to find Order Entry databases. Default is nil (current │ │ directory). Be sure to include the rightmost slash, ie: \DAYOORD\ │ │ The drive designation is optional (if same as DAYO POS). │ │ │ │ Enter Location: \DAYOORD\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CURRENT DIRECTORY DATABASE LOCATION ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOPOS\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 53 ■ PRICE BOOK DATABASE LOCATION ┌─────────────────[ 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 POS. If you have installed DAYOPB │ │ into a different directory, you need to tell DAYO POS 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 POS). │ │ │ │ Enter Location: \DAYOPB\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐ │ The location of DAYO General Ledger Databases does not have to be │ │ in the same drive/directory as this module. If you have installed DAYO GL │ │ into a different directory, you need to tell this module where to find │ │ the GL databases. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOGL\ │ │ The drive designation is optional (if same as this module). │ │ │ │ Enter Location: \DAYOGL\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CASH DRAWER SERIAL ┌──────────────────────────[ CASH DRAWER SERIAL ]────────────────────────────┐ │ The default for DAYO POS is that a cash drawer is NOT attached. │ │ The type of cash drawer that works with DAYO POS connects via the │ │ serial port. It will open when a signal is sent to it via the │ │ communications port (COM1:, COM2:, or COM3:). │ │ Note, an error will occur if you set this to Y (Yes), and you │ │ do not have a cash drawer attached. │ │ │ │ Do you have a cash drawer attached? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ CASH DRAWER SERIAL PORT ┌────────────────────────[ CASH DRAWER SERIAL PORT ]─────────────────────────┐ │ Enter Your Cash Drawer Serial Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PARALLEL CASH DRAWER ┌──────────────────────────[ PARALLEL CASH DRAWER ]──────────────────────────┐ │ The default for DAYO POS is that a parallel cash drawer is NOT attached. │ │ The parallel cash drawer connects via the parallel/printer port: LPT1, │ │ LPT2, or LPT3. It will open when a signal (Setup Code), is sent to it │ │ at invoice time. │ │ Note, an error will occur if you set this to Y (Yes), and you │ │ do not have a cash drawer attached, or have it off/offline. │ │ │ │ Do you have a parallel cash drawer attached? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 54 ■ PARALLEL CASH DRAWER PORT ┌───────────────────────[ PARALLEL CASH DRAWER PORT ]────────────────────────┐ │ Enter Your Cash Drawer Parallel Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PARALLEL CASH DRAWER PRINTER SETUP CODE ┌────────────────────[ PARALLEL CASH DRAWER SETUP CODE ]─────────────────────┐ │ If you have a parallel cash drawer, it is required that some character │ │ string (setup code), be sent as a signal to the cash drawer instructing │ │ it to open. When entering the setup code, you must enter a valid │ │ character string in the format: 'OPEN SAYS ME' or 'CHR(1)+CHR(1)' │ │ Check your cash drawer manual for the correct Setup Code! │ │ │ │ Enter Your Cash Drawer Parallel Setup Code On The Next Line: │ │ Setup Code: "" │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 55 ■ VISUAL INDEXING ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ┌──────────────────────────────────────────────────────────┐ │ Database Name: DETAIL.DBF │ │ Index Name: DETITEM.NTX │ │ Number of Records: 394 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ ■ AUTOMATIC DAILY INDEXING ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO POS will be recreated once daily. This will occur when the first │ │ DAYO POS program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO POS Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ Note, the DAYO Indexing program (DAYOX) was created for this purpose. ■ AUTO PRINT PACKING LIST ┌────────────[ AUTOMATICALLY PRINT PACKING LIST AFTER INVOICING ]────────────┐ │ If you want a packing list to print automatically after invoicing, then │ │ change this option to Y (YES). │ │ Default is not to print packing lists. │ │ │ │ Automatically Print Packing Lists? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 56 ■ PACKING LIST PRINTER PORT ┌───────────────────────[ PACKING LIST PRINTER PORT ]────────────────────────┐ │ Enter Your Packing List Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT PRICE ON PACKING LIST ┌────────────────────[ PRINT PRICE ON THE PACKING LIST ]─────────────────────┐ │ If you want to print the PRICE on the packing list, the set this option │ │ to Y (YES). Default is NOT to print the price on the packing lists. │ │ │ │ Print Price On The Packing List? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ WORK ORDER COPIES ┌──────────────────[ Number of Work Order Copies To Print ]──────────────────┐ │ This option determines the number of Work Order copies to print at the │ │ time of invoicing. Default is to print one copy of the work order. │ │ │ │ Enter Number of Work Order Copies: 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ WORK ORDER PRINTER TYPE ┌────────────────────────[ WORK ORDER PRINTER TYPE ]─────────────────────────┐ │ Work Orders 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 Work Order Printer Type -> STANDARD │ │ LASER │ │ PREPRINTED │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ WORK ORDER PRINTER PORT ┌────────────────────────[ WORK ORDER PRINTER PORT ]─────────────────────────┐ │ Enter Your Work Order Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 57 ■ WORK ORDER NOTES PHRASE ┌─────────────────────────[ WORK ORDER NOTE PHRASE ]─────────────────────────┐ │ This 'Phrase' or 'Leading Comment' is printed at the beginning of all │ │ Work Order Notes/Comments. Examples are 'Shipping Instructions:', │ │ 'Notes:' or 'Special Instructions:' │ │ Default is not to print anything! │ │ │ │ Enter Work Order Notes Phrase: │ └────────────────────────────────────────────────────────────────────────────┘ ■ ALLOCATE WORK ORDERS ┌──────────────────────────[ ALLOCATE WORK ORDERS ]──────────────────────────┐ │ If you wish to Allocate Work Order quantity (add to the ALLOCATE │ │ field instead of removing from the ONHAND field) in the inventory │ │ database, then select Y (Yes) to this option. If set to Y (Yes), │ │ the quantity is removed from inventory ONHAND field when invoiced. │ │ Default is to remove quantity from inventory when the work order │ │ is created. │ │ │ │ Allocate Work Orders? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT COMMENT ┌────────────────────────────[ DEFAULT COMMENT ]─────────────────────────────┐ │ This comment is printed onto every Invoice and Work Order. │ │ │ │ Enter Default Comment: Thank You! │ └────────────────────────────────────────────────────────────────────────────┘ ■ SHOW RETAIL/LIST PRICE ON STANDARD INVOICE ┌───────────────[ SHOW RETAIL/LIST PRICE ON STANDARD INVOICE ]───────────────┐ │ If you wish to print the inventory price or retail (list) price onto │ │ the standard invoice, then select Y (Yes) to this option. │ │ Default is N (No), not to show the inventory price/list... │ │ │ │ Do you want to print the inventory retail/list? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 58 ■ PRINT INVENTORY PRICE OR RETAIL IF 'SHOW RETAIL' IS SET TO YES ┌─────[ PRINT INVENTORY PRICE OR RETAIL IF 'SHOW RETAIL' IS SET TO YES ]─────┐ │ You can print either the inventory RETAIL or PRICE field onto the │ │ standard invoice. Select Y (Yes) for the PRICE, N (No) for RETAIL. │ │ Default is N (No) -> print RETAIL... │ │ │ │ Do you want to print the inventory PRICE? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRE-SELECT THE SHIP TO ADDRESS PRIOR TO INVOICING DETAIL LINE ITEMS ┌──[ PRE-SELECT THE SHIP TO ADDRESS PRIOR TO INVOICING DETAIL LINE ITEMS ]───┐ │ This option (if set to Yes) will highlight a specific Ship To's │ │ history of purchased items when using the Pop-Up item/customer routine. │ │ Default is N (No) -> display/highlight all items... │ │ │ │ Do you wish to display specific Ship To history? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ TAX THE ADJUSTMENT FIELD ON THE INVOICE ┌────────────────[ TAX THE ADJUSTMENT FIELD ON THE INVOICE ]─────────────────┐ │ This option determines if the field ADJUST (Adjustments) will be used in │ │ the computation of taxes on invoices. │ │ Default is N (No) -> do not tax ADJUSTMENTS... │ │ │ │ Do you wish to tax ADJUSTMENTS? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ USE WAREHOUSES - INVOICE FROM WAREHOUSES ┌────────────────[ USE WAREHOUSES - INVOICE FROM WAREHOUSES ]────────────────┐ │ This option determines if the Warehouses will be available for invoicing. │ │ Warehouses are maintained in the Inventory module. │ │ Default is N (No) -> not to invoice from warehouses. │ │ │ │ Do you wish to use the Warehouses? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 59 ■ DEFAULT FREIGHT PERCENTAGE ┌───────────────────────[ DEFAULT FREIGHT PERCENTAGE ]───────────────────────┐ │ This percentage value determines/calculates a default freight amount for │ │ every new invoice. Default is 0%; to enter the freight amount. │ │ Example: 4% would be entered as '0.0400' │ │ │ │ Enter Default Freight Percentage: 000.040 │ └────────────────────────────────────────────────────────────────────────────┘ ■ SHOW/DISPLAY CUSTOMER NOTES ONTO SCREEN AT INVOICE TIME ┌────────[ SHOW/DISPLAY CUSTOMER NOTES ONTO SCREEN AT INVOICE TIME ]─────────┐ │ If you want the top 10 lines of a customer's notes/memo to be │ │ displayed onto the screen at time of invoicing, then select Y (Yes) to │ │ this option. Notes are found in the DAYO AR database: CUSTMEMO.DBF. │ │ There will be no delay or pause if no memo/notes exist for a customer. │ │ │ │ Show/display Customer Notes Onto Screen? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ TAX THE FREIGHT FIELD ON THE INVOICE ┌──────────────────[ TAX THE FREIGHT FIELD ON THE INVOICE ]──────────────────┐ │ This option determines if the field FREIGHT will be used in │ │ the computation of taxes on invoices. │ │ Default is N (No) -> do not tax FREIGHT... │ │ │ │ Do you wish to tax FREIGHT? (Y/N) │ │ │ │ You can specify specific states (based on SHIPSTATE), or just leave │ │ blank to tax freight for all customers in all states... │ │ Separate valid state codes with a comma, ie: 'SC,NC,GA,CA' │ │ Default is to tax freight for all SHIP TO STATES. │ │ │ │ Enter Specific SHIPSTATEs: FL,GA,NC │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 60 ■ PRINT INVOICE/WORK ORDER COMMENTS ON THE INVOICE ┌────────────[ PRINT INVOICE/WORK ORDER COMMENTS ON THE INVOICE ]────────────┐ │ If you want to print the first 21 lines of the Work Order and/or │ │ invoice comments/notes onto the invoice, then select Y (Yes) to this │ │ option. Default is NOT to print the comments/notes... │ │ │ │ Print Invoice/Work Order Comments Onto Invoice? (Y/N) │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT BACK ORDER PRICE EXTENSION ON INVOICE/WORK ORDER ┌─────────[ PRINT BACK ORDER PRICE EXTENSION ON INVOICE/WORK ORDER ]─────────┐ │ If you want to print the extended Back Order price on the Invoice │ │ and/or Work Order, then select Y (Yes) to this option... │ │ Default is SHOW the extended price... │ │ │ │ Print Back Order Extended Price? (Y/N) │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ USE MULTIPLE PRICES - MULTIPLE PRICE TABLES ┌──────────────[ USE MULTIPLE PRICES - MULTIPLE PRICE TABLES ]───────────────┐ │ If your inventory databases has multiple prices (PRICE1 -> PRICE5), and │ │ you wish to have the option to select from them at time of invoicing, │ │ then select Y (Yes) to this option. Default is Y (Yes)... │ │ If this option is set to Y (Yes), you are given the option to edit │ │ the Multiple Price Tables which determines which of the PRICEx fields │ │ will be the default based on the number of items ordered (ie: you give │ │ your customers discounts for buying more than 1 item...) │ │ * Use the 'SET PRICEx' routine in Smart Reports to place values in the │ │ PRICEx fields (in the inventory database). │ │ │ │ Use Multiple Pricing? (Y/N) │ │ │ │ Input the limits (eXclusive) for each of the Price fields. │ │ * Any quantities greater to or equal to the PRICE4 quantity will take │ │ the PRICE5 price as the default... │ │ │ │ PRICE PRICE1 PRICE2 PRICE3 PRICE4 │ │ 5 10 15 44 47 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 61 ■ MANUFACTURE ENDITEMS - BILL OF MATERIALS ┌────────────────[ MANUFACTURE ENDITEMS - BILL OF MATERIALS ]────────────────┐ │ Set this option to Y (Yes) if you wish to be able to 'build' (ENDITEMS) │ │ from other items (COMPONENTS) in the inventory. An item is flagged as │ │ an ENDITEM by setting the field 'BOM' to true (.T.) in the inventory │ │ database (INV.DBF). The DAYO MRP module must be installed and a Bill of │ │ Materials created for the selected item (ENDITEM). All component items │ │ must be in inventory and in sufficient quantities to build the ENDITEM, │ │ unless the 'OVERRIDE ONHAND WHILE INVOICING' option is set to true (.T.).│ │ │ │ Manufacture ENDITEMS? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ USE THE ORDERED FIELD - RECORD CUSTOMER'S ORDER QUANTITY ┌────────[ USE THE ORDERED FIELD - RECORD CUSTOMER'S ORDER QUANTITY ]────────┐ │ Set this option to Y (Yes) if you invoice the customer for quantities │ │ not equal to (or not the same as) the quantity ORDERED. An example │ │ would be when a customer orders 3 little pigs, but you sell little pigs │ │ by the kilo. The subsequent invoice would show '3 ordered', but would │ │ bill the customer for 8.50 kilos (they were very little pigs...). │ │ The ORDERED quantity defaults to the quantity invoiced. │ │ │ │ Use the ORDERED field? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ OVERRIDE INVOICE NUMBER ┌────────────────────────[ OVERRIDE INVOICE NUMBER ]─────────────────────────┐ │ If you do NOT want to have the program automatically generate sequencial │ │ invoice numbers, then select Y (Yes) to this option. │ │ The default is to automatically generate sequential invoice numbers, │ │ and NOT to prompt for the invoice number. │ │ │ │ Override Invoice Numbers? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 62 ■ PRINT CONTROL NUMBER ONTO INVOICE ┌───────────────────[ PRINT CONTROL NUMBER ONTO INVOICE ]────────────────────┐ │ Use this option to generate and print a sequential CONTROL number for │ │ your invoices. This option is often necessary when Work Orders are used, │ │ and not printed daily. IRS 'requires' your invoices to be sequentially │ │ filed without breaks in sequence. This CONTROL number is incremented │ │ each time any invoice is printed. │ │ │ │ Do you want to print a CONTROL number onto your invoices? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ USE 2ND TAX In addition to the prompts below, the option to select the 2nd tax title/heading exists. Note, the amount in the 11th and 12th options is specified by you. ┌──────────────────────────────[ USE 2ND TAX ]───────────────────────────────┐ │ If you have 2 taxes to be recorded at time of invoice, then select │ │ Y (YES), else select N (NO) for single or no taxes. │ │ The default is NOT to prompt/use a second tax. │ │ 2nd Tax Current Setting: Tax Subtotal + Adjustments + Freight + 1st Tax │ │ │ │ Do you wish to maintain a second tax? (Y/N) │ │ │ │ Select Option -> Tax Subtotal Only │ │ Tax Freight Only │ │ Tax Adjustments Only │ │ Tax Subtotal + 1st Tax │ │ Tax Subtotal + Adjustments │ │ Tax Subtotal + Adjustments + 1st Tax │ │ Tax Subtotal + Freight │ │ Tax Subtotal + Freight + 1st Tax │ │ Tax Subtotal + Adjustments + Freight │ │ Tax Subtotal + Adjustments + Freight + 1st Tax │ │ Tax Subtotal Up To $5000.00 │ │ Tax Subtotal After $5000.00 │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 63 ■ PRINT CREDIT CARD & AUTHORIZATION NUMBER ON INVOICE ┌──────────[ PRINT CREDIT CARD & AUTHORIZATION NUMBER ON INVOICE ]───────────┐ │ If you wish to print the credit card number and its authorization │ │ number onto the invoice, then select Y (YES), else select N (NO). │ │ The default is NOT to print this information. │ │ │ │ Do you want to print the credit card number onto the invoice? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT BILL OF MATERIAL WORKSHEET FOR ASSEMBLED ITEMS ┌──────────[ PRINT BILL OF MATERIAL WORKSHEET FOR ASSEMBLED ITEMS ]──────────┐ │ If you wish to print a Bill of Material Worksheet for each item │ │ requiring an assembly, at invoice time, then select Y (YES) to this │ │ option. The default is NOT to print BOM Worksheets. │ │ Items requiring an assembly must be flagged as .T. in the 'BOM' field │ │ in the inventory database (INV.DBF), and contain a valid Bill of │ │ Material in the BOM database (BOM.DBF). │ │ │ │ Print BOM Worksheet(s) after invoicing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ BILL OF MATERIAL WORKSHEET PRINTER PORT ┌────────────────[ BILL OF MATERIAL WORKSHEET PRINTER PORT ]─────────────────┐ │ Enter Your BOM Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE ┌───────────[ MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE ]────────────┐ │ You have the option of using a margin/'cost plus' method of pricing │ │ your inventory at time of invoicing (ie: using the 'PBM' field in the │ │ customer's record). The default is to compute this margin based on │ │ 'points'. If you wish, you can change this to compute the margin │ │ based on a 'percentage' of cost. │ │ │ │ Do you wish to use the 'Points' method? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 64 ■ AUTOMATIC GL POSTING This Configuration routine was added to allow you to post your transactions (ie: Invoice Posting, Cash Receipts, and Credit Memos), automatically into General Ledger (GL). If this option is set to 'Y' (Yes), each time you adjust or edit key accounting fields (ie: COST, AMOUNT, SUBTOTAL, FREIGHT, ADJUST, QTY...), a GL transaction records will be created. This routine includes an option to browse, edit, add, and/or delete records in the General Ledger Class Code Table/Database (GLCLASS.DBF). ╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗ ║ If you are using General Ledger (GL), you can automatically update ║ ║ or create GL transactions every time you make an accounting adjustment. ║ ║ ║ ║ Do you want Automatic GL Posting? (Y/N) ║ ║ ║ ║ Default CLASS Code: AR Name: RECEIPTS ║ ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║ ║ Database: RECEIPTS.DBF Field: AMOUNT ║ ╟─────────────[ SELECT DEFAULT ACCOUNTS RECEIVABLE CLASS CODE ]──────────────╢ ║ CLASS NAME DEBIT CREDIT ║ ║──────────╥────────────────────────────────╥──────────────╥─────────────────║ ║ AR ║ Invoice Freight *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 1st Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 2nd Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Adjustments *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Paid/Collected *** ║ 10000-000000 ║ 40000-000000 ║ ║ REC ║ RECIPTS INTO INVENTORY ║ 91000-000000 ║ 20000-000000 ║ ║ INV ║ RECEIPTS INTO THE INVENTORY ║ 91000-000000 ║ 11000-000000 ║ ║ AR ║ RECEIPTS ║ 10000-000000 ║ 20000-000000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE) 20/20 DAYO POS, TJS LAB Page: 65 ■ EDIT CLASS CODE RECORD Press 'F2' to edit a Class Code record. Note, valid entries are crucial to making this posting process work correctly... ╔═════════════════════════[ EDIT CLASS CODE RECORD ]═════════════════════════╗ ║ CLASS Code: AR ║ ║ Name: AR FREIGHT ║ ║ Debit Account: 11000-000000 ║ ║ Credit Account: 10000-000000 ║ ║ Database (.DBF): ARH.DBF ║ ║ Field: FREIGHT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) ■ ADD NEW CLASS CODE RECORD Press 'Ctrl N' to add a new CLASS code record. ╔═══════════════════════[ ADD NEW CLASS CODE RECORD ]════════════════════════╗ ║ CLASS Code: ║ ║ Name: ║ ║ Debit Account: 00000-000000 ║ ║ Credit Account: 00000-000000 ║ ║ Database (.DBF): INVADJ.DBF ║ ║ Field: ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO POS, TJS LAB Page: 66 ■ FIND CLASS CODE Use the 'F5' through 'F9' keys to locate a desired CLASS code record Press 'F5' to locate a CLASS code record based on the CLASS field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS+DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to locate a CLASS code record based on the DEBIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 30000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to locate a CLASS code record based on the CREDIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 10000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to locate a CLASS code record based on the NAME field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to locate a CLASS code record based on the DATABASE field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO POS, TJS LAB Page: 67 ■ COLOR MONITOR ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 68 ■ REPORTS The REPORTS menu contains 13 reports and routines, many with different options. Note that other reports can be created using dBase III+/IV (tm) as well as other compatible report writers (ie: R&R). The MISC Routines even has the LIST function that allows the creation of simple lists/reports... Printer Setup Customer Address Labels Register Status/Summary Graph, Last 12 Months Sales Abbre. Open Invoice Report Graph, Last 12 Weeks Sales Expanded Open Invoice Rpt. Templates All POS Header Reports Database Status POS Detail Reports Config Status View Reports On Screen ■ REPORTS MENU SCREEN DAYO POS Version 3.0 TJS LAB REPORTS ┌───[February 1991]──┐ ╔═════════════════════════════╗ │S M T W T F S │ ║ DAYO POINT OF SALE REPORTS ║▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ║ Printer Setup ║█░ █░█░ █░ █░ █░ █░ │ 1 2 3 4│ ║ Register Status/Summary ║█░ █░█░ ▀█░██░ █░ █░ │ 5 6 7 8 9 10 11│ ║ Abbre. Open Invoice Report ║█░ █▀▀▀█░ ▀█▀ █░ █░ │12 13 14 15 16 17 18│ ║ Expanded Open Invoice Rpt. ║█░ █░ █░ █░ █░ █░ │19 20 21 22 23 24 25│ ║ POS Header Reports ║▀ █░ █░ █░ ▀███▀ │26 27 28 29 30 31 │ ║ POS Detail Reports ║ │ │ ║ Customer Address Labels ║ └────────────────────┘ ║ Graph, Last 12 Months Sales ║─────────────────────────────────────────────╖ ║ Graph, Last 12 Weeks Sales ║YO POS STATISTICS Register Open ║ ║ SELECT REPORT ║─────────────────────────────────────────────╢ ╚═════════════════════════════╝TABASE NAME RECORDS SIZE ║ ╟────────────────────╢ ╟────────────────────────────────────────────────╢ ║ 7 EXIT ║ ║ INV.DBF Inventory 50 10K ║ ╚════════════════════╝ ║ INVOICE.DBF Invoice Header 130 51K ║ Select Option ║ DETAIL.DBF Invoice Detail 273 26K ║ ████▄ ▄███▄ ▄██▄ ║ CUSTOMER.DBF Customers 15 8K ║ █░ █░ █░ █░ █░ ║ SERIALNO.DBF Serial Numbers 0 0K ║ ████▀ █░ █░ █▄ ║ SALESPER.DBF Sales Persons 10 2K ║ █░ █░ █░ ▀█▄ ║ TEMPLATE.DBF Templates 1 0K ║ █░ █░ █░ █░ ║ REGISTER.LOG Register Log 753 66K ║ █░ ▀███▀ ███▀ ╚════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select Report Option) DAYO POS, TJS LAB Page: 69 ■ 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 POS, TJS LAB Page: 70 ■ 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 POS, TJS LAB Page: 71 ■ 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 POS, TJS LAB Page: 72 ■ REGISTER STATUS/SUMMARY This report prints out invoice information based on the register. Use it to audit the cash transactions or to report daily sales totals. Note, this report does not use a report form ('hard coded'). It will print all registers, or a specific one. The index is either by TERMS or TYPE. The starting date and ending date default to current date, but can be changed. The report can be printed to the printer or to a file. If a file is selected, the default file name will be 'REG.TXT'. Example of a completed REGISTER STATUS/SUMMARY Report selection box: ╔═══════════════════════════════════════════════════════╗ ║The Register Status/Summary Report prints to printer or║ ║file of all transactions for all registers, or a ║ ║specific register. The Report is Grouped by Register, ║ ║and then TERMS or TYPE. A date range is also available.║ ║Date range defaults to current date. ║ ║ ║ ║ ║ ║ ║ ║Select Register -> ALL ║ ║ ║ ║Select Index -> Terms ║ ║ ║ ║Start Date: 12/28/89 Ending Date: 12/28/89 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: REG.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO POS, TJS LAB Page: 73 ■ EXAMPLE OF A REGISTER STATUS/SUMMARY REPORT TJS LAB REGISTER STATUS/SUMMARY From 12/28/89 To 12/28/89 12/28/89 22:03:17 Register: 1 Is Open?: Yes, but not in use! OpenDate: 12/28/89 OpenTime: 21:08:28 CloseDate: / / CloseTime: By: TOM JOHNSON StartSum: 23.00 EndSum: 0.00 ---------- Difference: 23.00 Invoice Header Totals by Terms: *************************************** * Grand Totals Register: 1 * * Total Sales: 0.00 * * Total Payments Received: 0.00 * * ---------- * * Difference: 0.00 * *************************************** DAYO POS, TJS LAB Page: 74 ■ ABBREVIATED OPEN ORDER REPORT The Abbreviated Open Order Report lists out information on all undeleted records in the invoice header and detail databases and the backorder database. The report contains the following fields: Invoice Number Class (both header & detail) Customer Number Price Each Ship To Name Quantity Ordered/Backordered Item Number BO Filled Quantity Description A coded message is also printed: Prnt - Printed Clos - Closed B.O. - BackOrdered WO - Work Order The report has three (3) indexes, Invoice Number, Customer Ship To Name, and Customer Number: ╔═══════════════════════════════════════════════════════╗ ║Abbreviated Open Order Report (Includes Back Orders). ║ ║This report is 144 characters wide. ║ ║ ║ ║Select Index -> Invoice Number ║ ║ Customer Ship To Name ║ ║ Customer Number ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO POS, TJS LAB Page: 75 A prompt is displayed for the number of lines per page. You can also direct the printed output to printer to file: ╔═══════════════════════════════════════════════════════╗ ║Abbreviated Open Order Report (Includes Back Orders). ║ ║This report is 144 characters wide. ║ ║ ║ ║Select Index -> Invoice Number ║ ║ ║ ║Enter Page Length: 56 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: AOPEN.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ EXPANDED OPEN ORDER REPORT The Expanded Open Order Report is really two (2) reports; an Open Invoice Report, and an Open BackOrder Report. This report lists out information on all undeleted records in the invoice header and detail databases and the backorder database. The report contains the following fields: Customer Number Sales Rep Name Bill To Name Invoice Type Promised Date Class Code Adjustment Amount Item Number Freight Description Taxes Quantity Ordered/BackOrdered Detail Subtotal Quantity Filled Amount Collected (Paid) Cost Each Invoice Number Price Each Customer Purchase Order Number Extended Cost Order Date Extended Price DAYO POS, TJS LAB Page: 76 The only option for this report is to direct the output to a printer or a file and to give it a title: ╔═══════════════════════════════════════════════════════╗ ║Expanded Open Order Report (Includes Back Orders). ║ ║This report is 144 characters wide. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: OPEN.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ POS DETAIL, HEADER & TEMPLATE REPORTS The POS Header, Detail, and the Template Reports are a collection of 'report forms'. These report forms all have the extension of '.FRM' and are dBase (tm) compatible. Report Form Uses Name Database ────────────── ─────────────── TEMPLATE.FRM TEMPLATE.DBF INVOICE.FRM INVOICE.DBF REGTERMS.FRM " REGTYPE.FRM " TYPE.FRM " TERMS.FRM " SALESPER.FRM " INVCUST.FRM " DETAIL.FRM DETAIL.DBF & INVOICE.DBF & CUSTOMER.DBF DETSALP.FRM " " " DETREGTY.FRM " " " DETREGTM.FRM " " " DETITEM.FRM " " " DETVEND.FRM " " " DETCUST.FRM " " " DAYO POS, TJS LAB Page: 77 ■ POS HEADER REPORTS POS Header Reports are printouts (to paper or disk file) of records in the database INVOICE.DBF. There are 7 POS Header Report types, each with its own index and report form, ie: Report Name Indexed on Report Form Name ─────────────────── ───────────── ───────────────── Register by Terms REG+TERMS REGTERMS.FRM Register by Type REG+TYPE REGTYPE.FRM Invoice Terms TERMS TERMS.FRM Invoice Type TYPE TYPE.FRM Sales Person SALESPER SALESPER.FRM Customer Number CUSTOMER INVCUST.FRM Invoice Number INVOICE INVOICE.FRM The POS Header Reports selection box: ╔═══════════════════════════════════════════════════════╗ ║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 ║ ║ ║ ║Print All? (Y/N) ║ ║( N -> prompts for specific Register ) ║ ║ ║ ║ ║ ║ ║ ║Start Date: 12/28/89 Ending Date: 12/28/89 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: Register.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ╚═══════════════════════════════════════════════════════╝ DAYO POS, TJS LAB Page: 78 ■ POS DETAIL REPORTS POS Detail Reports are printouts (to paper or disk file) of records in the database DETAIL.DBF. The INVOICE.DBF and the CUSTOMER.DBF are also used in the creation of Invoice Detail Reports. There are 7 POS Detail Report types, each with its own index and report form, ie: Report Name Indexed on Report Form Name ─────────────────── ───────────── ───────────────── Register by Terms REG+TERMS DETREGTM.FRM Register by Type REG+TYPE DETREGTY.FRM Invoice INVOICE DETAIL.FRM Item ITEM DETITEM.FRM Vendor Item VENDITEM DETVEND.FRM Sales Person SALESPER DETSALP.FRM * Customer CUSTOMER DETCUST.FRM * (This report has been expanded to include more information, see below) The POS Detail Reports selection box: ╔═══════════════════════════════════════════════════════╗ ║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 -> Item ║ ║ ║ ║Print All? (Y/N) ║ ║( N -> prompts for specific Item ) ║ ║ ║ ║Enter Item: ABC-1000 ║ ║ ║ ║Start Date: 01/01/90 Ending Date: 01/01/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: Item.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ╚═══════════════════════════════════════════════════════╝ ■ OPEN ORDER - DETAIL - REPORT The CUSTOMER option includes more information. Included is the Ship To name, the customer's purchase order, the preparer of the invoice, the CLASS field, status of OPEN, and the whether the invoice has been printed or not. DAYO POS, TJS LAB Page: 79 ■ CUSTOMER SHIP TO ADDRESS LABELS This report option prints out labels containing the Ship To address of the customer/client. Find the customer/client you want to create a label for and press Enter/Return. Press Enter/Return for as many labels you desire. To assist you in locating a customer/client, the FIND function keys F5, F6, F7, and F8 are available. ╔═══════════════════════════════════════════════════════╗ ║Use this option to print the Customer SHIP TO address ║ ║Labels. The Address Label is the standard size of ║ ║ 3.5x15/16, 6LPI, and contains the following fields: ║ ║ SHIPNAME SHIPPADDR1 SHIPADDR2 ║ ║ SHIPCITY SHIPSTATE SHIPZIP ║ ║ ║ ║ ┌──────────────────────────────┐ ║ ║ │JOSE L MARTINEZ │ ║ ║ │90 VEEGE │ ║ ║ │MEXICO CITY, MEXICO │ ║ ║ │ │ ║ ║ │ │ ║ ║ ╘══════════════════════════════╛ ║ ║ CUSTOMER ║ ║Select Customer -> 3444 ║ ║ 3445 ║ ║ 3446 ║ ║ 3447 ║ ║ 3448 ║ ║Esc (Exit) Enter/Return (Print) F5/F6/F7/F8 (Find) ║ ╚═══════════════════════════════════════════════════════╝ ■ GRAPH, LAST 12 MONTHS SALES This option can be used if you keep (do not archive or delete) 12 months of invoicing data. This option sums up the ADJUST, FREIGHT, TAXES, and SUBTOTAL fields of every invoice header record in the database: INVOICE.DBF. The name of your company is printed atop the graph (as defined in the configuration settings). DAYO POS, TJS LAB Page: 80 The first screen is the graph: TJS LAB 12/28/89 SALES HISTORY, Past 12 Calendar Months ╔═══════════════════════════════════════════════════════════════════════╗ ║ ██▓▒░║ ║ ██▓▒░║ ║ ██▓▒░║ ║ ██▓▒░║ ║ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║██$▒░ ██$▒░ ██$▒░ ██$▒░ ██$▒░ ██$▒░ ██$▒░ ██$▒░║ ║██1▒░ ██1▒░ ██1▒░ ██1▒░ $ ██1▒░ ██1▒░ ██1▒░ $ $ $ ██2▒░║ ║██2▒░ ██6▒░ ██6▒░ ██3▒░ 3 ██2▒░ ██0▒░ ██2▒░ 3 6 1 ██1▒░║ ║██3▒░ ██7▒░ ██4▒░ ██5▒░ 2 ██7▒░ ██0▒░ ██3▒░ 6 ██8▒░ 1 ██8▒░║ ║██8▒░ ██0▒░ ██7▒░ ██0▒░ 9 ██0▒░ ██4▒░ ██9▒░ 5 ██1▒░ 7 ██0▒░║ ║██.▒░ ██.▒░ ██.▒░ ██.▒░ . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ . ██.▒░║ ║██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██6▒░ ██1▒░ 3 ██2▒░║ ║██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██2▒░ ██6▒░ ██0▒░ 2▒░ ██4▒░║ ╟─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────╢ ║Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89│Dec89║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars YTD: $13,093.08 Total Invoices: 88 The second contains the totals by month: TJS LAB 12/28/89 SALES HISTORY, Past 12 Calendar Months ╔═══════════════════════════════════════════════════════════════════════╗ ║╔═[ Summary ]════════════════════════════════╗ ██▓▒░║ ║║ Month Year Total Sales ║ ██▓▒░║ ║║ December 1989 $2,180.24 ║ ██▓▒░║ ║║ November 1989 $117.32 ║ ██▓▒░║ ║║ October 1989 $681.10 ║ ██▓▒░║ ║║ September 1989 $365.66 ║ ██▓▒░║ ║║ August 1989 $1,239.22 ║ ██▓▒░║ ║║ July 1989 $1,004.22 ║ ██▓▒░║ ║║ June 1989 $1,270.22 ║░ ██▓▒░║ ║║ May 1989 $329.22 ║░ ██▓▒░║ ║║ April 1989 $1,350.22 ║░ ██$▒░║ ║║ March 1989 $1,647.22 ║░ $ $ $ ██2▒░║ ║║ February 1989 $1,670.22 ║░ 3 6 1 ██1▒░║ ║║ January 1989 $1,238.22 ║░ 6 ██8▒░ 1 ██8▒░║ ║╚════════════════════════════════════════════╝░ 5 ██1▒░ 7 ██0▒░║ DAYO POS, TJS LAB Page: 81 ■ GRAPH, LAST 12 WEEKS SALES This option can be used if you keep (do not archive or delete) 12 weeks of invoicing data. This option sums up the ADJUST, FREIGHT, TAXES, and SUBTOTAL fields of every invoice header record in the database: INVOICE.DBF for the last 12 weeks starting from the current date, or from the one you enter at the first prompt for this report, ie: ╔═════════════════════════[ LAST 12 WEEKS OF SALES ]═════════════════════════╗ ║ This report will graph the past 12 weeks of Sales starting with ║ ║ the date you enter next. This date would normally be the last day ║ ║ of your work week. ║ ║ ║ ║ Enter Last Date for Graph: 12/28/89 ║ ╚════════════════════════════════════════════════════════════════════════════╝ The name of your company is printed atop the graph (as defined in the configuration settings). The first screen is the graph: TJS LAB 12/28/89 SALES HISTORY, Past 12 Weeks Last Date: 12/28/89 ╔═══════════════════════════════════════════════════════════════════════╗ ║ ██▓▒░║ ║ ██▓▒░║ ║ ██▓▒░║ ║ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░║ ║██▓▒░ ██▓▒░ ██▓▒░║ ║██▓▒░ ██▓▒░ ██▓▒░║ ║██▓▒░ ██▓▒░ ██$▒░║ ║██$▒░ ██$▒░ ██1▒░║ ║██6▒░ $ $ $ $ $ $ ██9▒░ $ ██1▒░║ ║██5▒░ 1 $ $ 1 7 1 1 7 ██3▒░ 3 ██2▒░║ ║██8▒░ 1 0 8 1 5 1 1 8 ██8▒░ 9 ██3▒░║ ║██.▒░ . . . . . . . . ██.▒░ . ██.▒░║ ║██6▒░ 2 0 2 2 4 2 2 4 ██6▒░ 4 ██6▒░║ ║██6▒░ 2▒░ 0 2▒░ 2▒░ ██4▒░ 2▒░ 2▒░ ██4▒░ ██8▒░ 4▒░ ██8▒░║ ╟─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────╢ ║10/12│10/19│10/26│11/02│11/09│11/16│11/23│11/30│12/07│12/14│12/21│12/28║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars: $2,967.44 Total Invoices: 73 DAYO POS, TJS LAB Page: 82 The second screen contains the summary by week: TJS LAB 12/28/89 SALES HISTORY, Past 12 Weeks Last Date: 12/28/89 ╔═══════════════════════════════════════════════════════════════════════╗ ║╔═[ Summary ]════════════════════════════════╗ ██▓▒░║ ║║ Week Month Total Sales ║ ██▓▒░║ ║║ 12/28 Dec $1,123.68 ║ ██▓▒░║ ║║ 12/21 Dec $39.44 ║ ██▓▒░ ██▓▒░║ ║║ 12/14 Dec $938.68 ║ ██▓▒░ ██▓▒░║ ║║ 12/07 Dec $78.44 ║ ██▓▒░ ██▓▒░║ ║║ 11/30 Nov $11.32 ║ ██▓▒░ ██▓▒░║ ║║ 11/23 Nov $11.32 ║ ██▓▒░ ██▓▒░║ ║║ 11/16 Nov $75.44 ║ ██▓▒░ ██▓▒░║ ║║ 11/09 Nov $11.32 ║ ██▓▒░ ██▓▒░║ ║║ 11/02 Nov $8.22 ║ ██▓▒░ ██$▒░║ ║║ 10/26 Oct $0.00 ║ ██$▒░ ██1▒░║ ║║ 10/19 Oct $11.32 ║ $ ██9▒░ $ ██1▒░║ ║║ 10/12 Oct $658.66 ║ 7 ██3▒░ 3 ██2▒░║ ║╚════════════════════════════════════════════╝ 8 ██8▒░ 9 ██3▒░║ ║██.▒░ . . . . . . . . ██.▒░ . ██.▒░║ ║██6▒░ 2 0 2 2 4 2 2 4 ██6▒░ 4 ██6▒░║ ║██6▒░ 2▒░ 0 2▒░ 2▒░ ██4▒░ 2▒░ 2▒░ ██4▒░ ██8▒░ 4▒░ ██8▒░║ ╟─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────▄─────╢ ║10/12│10/19│10/26│11/02│11/09│11/16│11/23│11/30│12/07│12/14│12/21│12/28║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars: $2,967.44 Total Invoices: 73 ■ TEMPLATES ALL REPORT This report prints the entire contents of the database: TEMPLATE.DBF out to either the printer or to a disk file. No other option is given. It uses the report form: TEMPLATE.DBF. ╔═══════════════════════════════════════════════════════╗ ║The Template Reports print all template records indexed║ ║by the template number. Templates are maintained in the║ ║database: TEMPLATE.DBF. ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: TEMPLATE.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO POS, TJS LAB Page: 83 ■ DATABASE STATUS REPORT This report prints out the structure, number of records and sizes of all major DAYO POS database. This report does not use a report form. Like the TEMPLATE Report, this one only gives you the option to print to the printer or to a disk file, ie: ╔═══════════════════════════════════════════════════════╗ ║The Database Status Report lists the DAYO POS ║ ║databases with their current fields, sizes and number ║ ║of records. Index files included. Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: DATABASE.TXT ║ ╚═══════════════════════════════════════════════════════╝ An example of a Database Status Report follows. Note, only one database is listed (there are more!): ++++++++++++++++++++++++ + DAYO DATABASE REPORT + ++++++++++++++++++++++++ 12/28/89 22:14:39 Inventory Database: \dayoinv\INV.DBF Number of Records: 74 File Size: 13,138 FIELD NAME TYPE LENGTH DECIMALS ============ ==== ====== ======== ITEM C 12 0 DESC C 30 0 ONHAND N 7 0 ONORDER N 7 0 SOLDPTD N 7 0 SOLDYTD N 7 0 VENDITEM C 12 0 VENDOR C 10 0 DATE D 8 0 LASTDATE D 8 0 COST N 10 2 RETAIL N 10 2 PRICE N 10 2 STOCKLEVEL N 7 0 DAYO POS, TJS LAB Page: 84 TYPE C 3 0 CLASS C 3 0 TAXABLE L 1 0 SERIALNO L 1 0 WEIGHT N 8 2 UNIT C 3 0 LOCATION C 3 0 ====== 167 Index Files: INV.NTX Index Key: ITEM DESC.NTX Index Key: DESC VENDOR.NTX Index Key: VENDOR VENDITEM.NTX Index Key: VENDITEM INVTYPE.NTX Index Key: TYPE ■ CONFIGURATION STATUS REPORT The Configuration Status Report is just a list of the current configuration settings. It is not a report form. The only option is to print it to a printer or to a disk file, ie: ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOPOS.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO POS, TJS LAB Page: 85 ■ AN EXAMPLE OF A CONFIGURATION STATUS REPORT +++++++++++++++++++++++++++++++++++++++++++ + DAYO POINT OF SALE CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++ 12/31/89 23:16:04 Company Name: YOUR COMPANY NAME HERE Address Line 1: Attn: Accounts Receivable Address Line 2: P.O. BOX 555 City, State Zip: YOURTOWN, ST 55555-5555 Telephone: 800-555-5555 Last Customer Number: 0 Auto Print Invoice: Yes Last Invoice Number: 23 Invoice Printer Type: STANDARD Invoice Printer Port: LPT1 Number of Invoice Copies: 1 Default Tax Code: 1 Default Invoice Type: REG Allow Negative Onhand: No Create Back Orders: Yes Allow Editing In Browse: Yes Allow Adding of New Item: Yes Allow Adding of Customer: Yes Use Credit Limits: Yes Default Shipper/Shipment: PICKUP Default Terms: CASH Inventory Database Location: \DAYOINV\ Customer Database Location: \DAYOAR\ Quotes Database Location: \DAYOQUO\ BackOrder Database Location: \DAYOBO\ PriceBook Database Location: \DAYOPB\ Cash Drawer Attached: No Cash Drawer Com Port: COM1 Parallel Cash Drawer Attached: No Parallel Cash Drawer Port: LPT1 Parallel Drawer Setup Code: Report Printer Type: LASER PRINTER Report Printer Port: LPT1 Visual Indexing: Yes Automatically Reindex Daily: Yes Auto Print Packing List: No Packing List Printer Port: LPT1 Color: Yes High Intensity: No DAYO POS, TJS LAB Page: 86 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO POS, TJS LAB Page: 87 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYORPT View Reports │ File Name: COA.TXT Page No. 1 07/27/90 INVENTORY ITEM LISTING Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2" GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO POS, TJS LAB Page: 88 ■ 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 POS Version 3.0 TJS LAB ┌───[February 1991]──┐ ╔════════════════════╗ │S M T W T F S │ ║ MISC ROUTINES ║ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2│ ║ APPEND FROM ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│ ║ BROWSE DATABASES ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│ ║ COPY (.DBF) TO ║ █░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│ ║ CREATE DATABASE ║ ████▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 29 30│ ║ DELETE RECORDS ║ │31 │ ║ ERASE FILE ║ └────────────────────┘ ║ EXIT TO DOS ║ ╓────────────────────────────────────────────────╖ ║ INDEX A DATABASE ║ ║ DAYO POS STATISTICS Register Closed ║ ║ LIST FIELDS ║ ╟────────────────────────────────────────────────╢ ║ PACK DATABASE ║ ║ DATABASE NAME RECORDS SIZE ║ ║ MODIFY DATABASE ║ ╟────────────────────────────────────────────────╢ ║ RECALL RECORDS ║ ║ INV.DBF Inventory 74 14K ║ ║ RETURN TO MENU ║ ║ INVOICE.DBF Invoice Header 26 10K ║ ║ RUN (DOS COMMAND) ║ ║ DETAIL.DBF Invoice Detail 394 34K ║ ║ SIMPLE EDITOR ║ ║ CUSTOMER.DBF Customers 18 9K ║ ║ SORT DATABASE ║ ║ SERIALNO.DBF Serial Numbers 182 12K ║ ║ TYPE (PRINT) FILE ║ ║ SALESPER.DBF Sales Persons 2 1K ║ ║ ZAP DATABASE ║ ║ TEMPLATE.DBF Templates 9 1K ║ ╟────────────────────╢ ║ REGISTER.LOG Register Log 535 47K ║ ║ Select Option ║ ╚════════════════════════════════════════════════╝ ╚════════════════════╝ DAYO POS, TJS LAB Page: 89 ■ 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 POS, TJS LAB Page: 90 - 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: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 91 ■ 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 POS, TJS LAB Page: 92 - 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 POS, TJS LAB Page: 93 ■ 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 POS, TJS LAB Page: 94 - 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 POS, TJS LAB Page: 95 - 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 POS, TJS LAB Page: 96 * * * 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 POS, TJS LAB Page: 97 ■ 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 POS, TJS LAB Page: 98 ■ 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 POS, TJS LAB Page: 99 ■ 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 POS, TJS LAB Page: 100 - 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 POS, TJS LAB Page: 101 - 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 POS, TJS LAB Page: 102 - 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 POS, TJS LAB Page: 103 - 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 POS, TJS LAB Page: 104 *** 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 POS, TJS LAB Page: 105 ■ 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 POS, TJS LAB Page: 106 ■ 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 POS, TJS LAB Page: 107 - 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 POS, TJS LAB Page: 108 - 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 POS, TJS LAB Page: 109 - 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 POS, TJS LAB Page: 110 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO POS, TJS LAB Page: 111 ■ 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: ┌──────────────────────[ DAYOPOS 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: ┌───────────────────────[ DAYOPOS 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 POS, TJS LAB Page: 112 - Editor help: ┌──────────────────────[ DAYOPOS 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 POS, TJS LAB Page: 113 ■ 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 POS Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌──────[ DAYO HELP Called by Program: DAYOPOS 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 DAYOPOS. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ 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 POS, TJS LAB Page: 114 DAYO POS Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌───────[ DAYO HELP Called by Program: DAYOPOS 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, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOPAY 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 POS, TJS LAB Page: 115 ■ DATABASE STRUCTURE ■ DATABASE - BO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 ITEM Character 12 7 18 3 DESC Character 30 19 48 4 QTY Numeric 7 49 55 5 FILLED Numeric 7 56 62 6 PRICE Numeric 10 2 63 72 7 COST Numeric 10 2 73 82 8 DESC2 Character 30 83 112 9 TAXABLE Logical 1 113 113 10 DATE Date 8 114 121 11 PAY Logical 1 122 122 12 MRP Logical 1 123 123 13 TIME Character 8 124 131 14 CLASS Character 3 132 134 15 CUSTOMER Numeric 6 135 140 ───── Total 141 DAYO POS, TJS LAB Page: 116 ■ DATABASE - CUSTOMER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CUSTOMER Numeric 6 1 6 2 NAME Character 30 7 36 3 ATTN Character 30 37 66 4 ADDR1 Character 30 67 96 5 ADDR2 Character 30 97 126 6 CITY Character 22 127 148 7 STATE Character 2 149 150 8 ZIP Character 10 151 160 9 PHONE Character 14 161 174 10 SHIPNAME Character 30 175 204 11 SHIPADDR1 Character 30 205 234 12 SHIPADDR2 Character 30 235 264 13 SHIPCITY Character 22 265 286 14 SHIPSTATE Character 2 287 288 15 SHIPZIP Character 10 289 298 16 SHIPPHONE Character 14 299 312 17 SALESPER Character 3 313 315 18 TAXRATE Numeric 7 5 316 322 19 TAXRATE2 Numeric 7 5 323 329 20 TERMS Character 20 330 349 21 SHIPPER Character 20 350 369 22 FOB Character 20 370 389 23 DATE Date 8 390 397 24 LASTDATE Date 8 398 405 25 TYPE Character 3 406 408 26 CLASS Character 3 409 411 27 PBM Numeric 6 3 412 417 28 PBL Numeric 6 3 418 423 29 SALESPTD Numeric 10 2 424 433 30 SALESYTD Numeric 10 2 434 443 31 DUE Numeric 10 2 444 453 32 PAID_PURC Numeric 10 2 454 463 33 LIMIT Numeric 10 2 464 473 34 FAX Character 14 474 487 35 PRICEX Numeric 1 488 488 36 ACTIVE Logical 1 489 489 37 CREDCARD Character 20 490 509 38 TAXCODE Character 3 510 512 ───── Total 513 DAYO POS, TJS LAB Page: 117 ■ DATABASE - CUSTMEMO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CUSTOMER Numeric 6 1 6 2 NOTES Memo 10 7 16 ───── Total 17 ■ DATABASE - DAYOFORM.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TOPLINE Numeric 2 1 2 2 LEFTCOLUMN Numeric 2 3 4 3 SETUPCODE Character 20 5 24 4 COMMENT Character 30 25 54 ───── Total 55 ■ DATABASE - DETAIL.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 ITEM Character 12 7 18 3 DESC Character 30 19 48 4 QTY Numeric 7 49 55 5 PRICE Numeric 10 2 56 65 6 COST Numeric 10 2 66 75 7 DESC2 Character 30 76 105 8 TAXABLE Logical 1 106 106 9 DATE Date 8 107 114 10 CUSTOMER Numeric 6 115 120 11 ORDERED Numeric 7 121 127 12 PROJECT Numeric 6 128 133 13 NS Logical 1 134 134 14 TI Logical 1 135 135 15 CLASS Character 3 136 138 ───── Total 139 DAYO POS, TJS LAB Page: 118 ■ DATABASE - INV.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 DESC Character 30 13 42 3 DESC2 Character 30 43 72 4 ONHAND Numeric 7 73 79 5 ALLOCATED Numeric 7 80 86 6 ONORDER Numeric 7 87 93 7 BO Numeric 7 94 100 8 SOLDPTD Numeric 7 101 107 9 SOLDYTD Numeric 7 108 114 10 VENDITEM Character 12 115 126 11 VENDOR Character 10 127 136 12 DATE Date 8 137 144 13 LASTDATE Date 8 145 152 14 COST Numeric 10 2 153 162 15 AVGCOST Numeric 10 2 163 172 16 REALCOST Numeric 10 2 173 182 17 RETAIL Numeric 10 2 183 192 18 PRICE Numeric 10 2 193 202 19 PRICE1 Numeric 10 2 203 212 20 PRICE2 Numeric 10 2 213 222 21 PRICE3 Numeric 10 2 223 232 22 PRICE4 Numeric 10 2 233 242 23 PRICE5 Numeric 10 2 243 252 24 STOCKLEVEL Numeric 7 253 259 25 TYPE Character 3 260 262 26 CLASS Character 3 263 265 27 TAXABLE Logical 1 266 266 28 SERIALNO Logical 1 267 267 29 WEIGHT Numeric 8 2 268 275 30 UNIT Character 3 276 278 31 UNITQTY Numeric 7 279 285 32 PACKQTY Character 6 286 291 33 BOM Logical 1 292 292 34 NS Logical 1 293 293 35 TI Logical 1 294 294 36 LOCATION Character 3 295 297 ───── Total 298 DAYO POS, TJS LAB Page: 119 ■ DATABASE - INVOICE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 CUSTOMER Numeric 6 7 12 3 SHIPNAME Character 30 13 42 4 SHIPADDR1 Character 30 43 72 5 SHIPADDR2 Character 30 73 102 6 SHIPCITY Character 17 103 119 7 SHIPSTATE Character 2 120 121 8 SHIPZIP Character 10 122 131 9 PHONE Character 14 132 145 10 TYPE Character 3 146 148 11 TERMS Character 20 149 168 12 TERMS2 Character 20 169 188 13 AMOUNT2 Numeric 10 2 189 198 14 SHIPPER Character 20 199 218 15 FOB Character 20 219 238 16 PROMISED Date 8 239 246 17 DATE Date 8 247 254 18 TIME Character 8 255 262 19 REG Character 3 263 265 20 BY Character 30 266 295 21 SALESPER Character 3 296 298 22 CUST_PO Character 15 299 313 23 SC Logical 1 314 314 24 BO Numeric 6 315 320 25 TAXRATE Numeric 7 5 321 327 26 TAXRATE2 Numeric 7 5 328 334 27 TAXCODE Character 3 335 337 28 TAXES Numeric 10 2 338 347 29 TAXES2 Numeric 10 2 348 357 30 ADJUST Numeric 10 2 358 367 31 FREIGHT Numeric 10 2 368 377 32 SUBTOTAL Numeric 10 2 378 387 33 OPEN Logical 1 388 388 34 PRINTED Logical 1 389 389 35 PAID Numeric 10 2 390 399 36 DISCOUNT Numeric 10 2 400 409 37 CLASS Character 3 410 412 38 PROJECT Numeric 6 413 418 39 WHSE Numeric 3 419 421 40 CREDCARD Character 20 422 441 41 AUTHORIZE Character 15 442 456 42 COMMENT Character 50 457 506 ───── Total 507 DAYO POS, TJS LAB Page: 120 ■ DATABASE - PB.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CUSTOMER Numeric 6 1 6 2 ITEM Character 12 7 18 3 PRICE Numeric 10 2 19 28 ───── Total 29 ■ DATABASE - REGISTER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 OPEN Logical 1 1 1 2 OPENDATE Date 8 2 9 3 OPENTIME Character 8 10 17 4 CLOSEDATE Date 8 18 25 5 CLOSETIME Character 8 26 33 6 STARTSUM Numeric 10 2 34 43 7 ENDSUM Numeric 10 2 44 53 8 BY Character 30 54 83 ───── Total 84 ■ DATABASE - SALESPER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 SALESPER Character 3 1 3 2 NAME Character 30 4 33 3 ADDR1 Character 30 34 63 4 ADDR2 Character 30 64 93 5 CITY Character 22 94 115 6 STATE Character 2 116 117 7 ZIP Character 10 118 127 8 PHONE Character 14 128 141 9 DATE Date 8 142 149 10 LASTDATE Date 8 150 157 11 TYPE Character 3 158 160 12 SALESPTD Numeric 10 2 161 170 13 SALESYTD Numeric 10 2 171 180 ───── Total 181 DAYO POS, TJS LAB Page: 121 ■ DATABASE - SERIALNO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 INVOICE Numeric 6 13 18 3 SERIALNO Character 30 19 48 4 CUSTOMER Numeric 6 49 54 5 DATE Date 8 55 62 ───── Total 63 ■ DATABASE - SHIPPER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 SHIPPER Character 20 1 20 ───── Total 21 ■ DATABASE - SHIPTOS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CUSTOMER Numeric 6 1 6 2 SHIPNAME Character 30 7 36 3 SHIPADDR1 Character 30 37 66 4 SHIPADDR2 Character 30 67 96 5 SHIPCITY Character 22 97 118 6 SHIPSTATE Character 2 119 120 7 SHIPZIP Character 10 121 130 8 PHONE Character 14 131 144 9 SALESPER Character 3 145 147 10 TAXRATE Numeric 7 5 148 154 11 TAXRATE2 Numeric 7 5 155 161 12 TAXCODE Character 3 162 164 13 TERMS Character 20 165 184 14 SHIPPER Character 20 185 204 15 FOB Character 20 205 224 16 TYPE Character 3 225 227 17 CLASS Character 3 228 230 18 DATE Date 8 231 238 ───── Total 239 DAYO POS, TJS LAB Page: 122 ■ DATABASE - TAXCODE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TAXCODE Character 1 1 1 2 TAXRATE Numeric 7 5 2 8 ───── Total 9 ■ DATABASE - TEMPLATE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TEMPLATE Numeric 6 1 6 2 ITEM Character 12 7 18 3 DESC Character 30 19 48 4 QTY Numeric 7 49 55 5 PRICE Numeric 10 2 56 65 6 DESC2 Character 30 66 95 7 DATE Date 8 96 103 ───── Total 104 ■ DATABASE - TERMS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TERMS Character 20 1 20 ───── Total 21 ■ DATABASE - TYPE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TYPE Character 3 1 3 2 DESC Character 30 4 33 ───── Total 34 DAYO POS, TJS LAB Page: 123 ■ DATABASE - QUOTES.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 QUOTE Numeric 6 1 6 2 CUSTOMER Numeric 6 7 12 3 SHIPNAME Character 30 13 42 4 SHIPADDR1 Character 30 43 72 5 SHIPADDR2 Character 30 73 102 6 SHIPCITY Character 17 103 119 7 SHIPSTATE Character 2 120 121 8 SHIPZIP Character 10 122 131 9 PHONE Character 14 132 145 10 TYPE Character 3 146 148 11 TERMS Character 20 149 168 12 SHIPPER Character 20 169 188 13 DATE Date 8 189 196 14 TIME Character 8 197 204 15 REG Character 3 205 207 16 BY Character 30 208 237 17 SALESPER Character 3 238 240 18 CUST_PO Character 15 241 255 19 TAXRATE Numeric 7 5 256 262 20 TAXRATE2 Numeric 7 5 263 269 21 TAXCODE Character 3 270 272 22 TAXES Numeric 10 2 273 282 23 TAXES2 Numeric 10 2 283 292 24 ADJUST Numeric 10 2 293 302 25 FREIGHT Numeric 10 2 303 312 26 SUBTOTAL Numeric 10 2 313 322 27 OPEN Logical 1 323 323 28 PRINTED Logical 1 324 324 29 PAID Numeric 10 2 325 334 30 CLASS Character 3 335 337 31 COMMENT Character 50 338 387 ───── Total 388 ■ DATABASE - QUOTESD.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 QUOTE Numeric 6 1 6 2 ITEM Character 12 7 18 3 DESC Character 30 19 48 4 QTY Numeric 7 49 55 5 PRICE Numeric 10 2 56 65 6 COST Numeric 10 2 66 75 7 DESC2 Character 30 76 105 8 TAXABLE Logical 1 106 106 9 CLASS Character 3 107 109 10 DATE Date 8 110 117 ───── Total 118 DAYO POS, TJS LAB Page: 124 ■ DATABASE - WAREHOUS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 LOC1 Numeric 7 13 19 3 SLLOC1 Numeric 7 20 26 4 LOC2 Numeric 7 27 33 5 SLLOC2 Numeric 7 34 40 6 LOC3 Numeric 7 41 47 7 SLLOC3 Numeric 7 48 54 8 LOC4 Numeric 7 55 61 9 SLLOC4 Numeric 7 62 68 10 LOC5 Numeric 7 69 75 11 SLLOC5 Numeric 7 76 82 12 LOC6 Numeric 7 83 89 13 SLLOC6 Numeric 7 90 96 14 LOC7 Numeric 7 97 103 15 SLLOC7 Numeric 7 104 110 ───── Total 111 ■ DATABASE - WO_NOTES.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 NOTES Memo 10 7 16 ───── Total 17 DAYO POS, TJS LAB Page: 125 ■ DATA DICTIONARY Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── ACTIVE L 1 0 CUSTOMER.DBF Used to designate a customer as active or not ADDR1 C 30 0 CUSTOMER.DBF Address line 1 SALESPER.DBF ADDR2 C 30 0 CUSTOMER.DBF Address line 2 SALESPER.DBF ADJUST N 10 2 QUOTES.DBF Adjustment amount INVOICE.DBF ALLOCATED N 7 0 INV.DBF Allocated quantity in inventory AMOUNT2 N 10 2 INVOICE.DBF Second terms amount ATTN C 30 0 CUSTOMER.DBF Attention/customer contact AUTHORIZE C 15 0 INVOICE.DBF Credit card or check authorization number AVGCOST N 10 2 INV.DBF Computed average cost BO N 6 0 INVOICE.DBF Quantity on backorder BO N 7 0 INV.DBF DETAIL.DBF BOM L 1 0 INV.DBF Flag to designate item as an ENDITEM with a Bill of Material (BOM) BY C 30 0 QUOTES.DBF DAYO user's name REGISTER.DBF INVOICE.DBF CITY C 22 0 SALESPER.DBF City CUSTOMER.DBF CLASS C 3 0 QUOTES.DBF Class code used with DAYO General INVOICE.DBF Ledger. Not used otherwise... INV.DBF CUSTOMER.DBF QUOTESD.DBF DETAIL.DBF BO.DBF SHIPTOS.DBF CLOSEDATE D 8 0 REGISTER.DBF Date register was last closed CLOSETIME C 8 0 REGISTER.DBF Time register was last closed COMMENT C 30 0 DAYOFORM.DBF Description of special forms code COMMENT C 50 0 QUOTES.DBF Quotes comment INVOICE.DBF Invoice/Work Order comment COST N 10 2 BO.DBF Cost of item INV.DBF DETAIL.DBF QUOTESD.DBF CREDCARD C 20 0 CUSTOMER.DBF Credit card number INVOICE.DBF DAYO POS, TJS LAB Page: 126 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── CUSTOMER N 6 0 CUSTMEMO.DBF Customer's unique number SERIALNO.DBF QUOTES.DBF BO.DBF DETAIL.DBF PB.DBF CUSTOMER.DBF INVOICE.DBF SHIPTOS.DBF CUST_PO C 15 0 INVOICE.DBF Customer's purchase order number QUOTES.DBF DATE D 8 0 CUSTOMER.DBF Date record was created SALESPER.DBF INVOICE.DBF TEMPLATE.DBF BO.DBF DETAIL.DBF QUOTESD.DBF QUOTES.DBF SHIPTOS.DBF SERIALNO.DBF INV.DBF DESC C 30 0 DETAIL.DBF Item description TEMPLATE.DBF INV.DBF QUOTESD.DBF TYPE.DBF Type description BO.DBF Item description DESC2 C 30 0 TEMPLATE.DBF 2nd description QUOTESD.DBF INV.DBF DETAIL.DBF BO.DBF DISCOUNT N 10 2 INVOICE.DBF User defined. Not used by DAYO DUE N 10 2 CUSTOMER.DBF Estimated amount due from customer ENDSUM N 10 2 REGISTER.DBF Ending amount in register FAX C 14 0 CUSTOMER.DBF FAX telephone number FILLED N 7 0 BO.DBF Backordered quantity filled FOB C 20 0 INVOICE.DBF Freight on Board CUSTOMER.DBF SHIPTOS.DBF FREIGHT N 10 2 INVOICE.DBF Freight charges QUOTES.DBF INVOICE N 6 0 SERIALNO.DBF Unique invoice number INVOICE.DBF WO_NOTES.DBF BO.DBF DETAIL.DBF DAYO POS, TJS LAB Page: 127 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── ITEM C 12 0 WAREHOUS.DBF Your product number INV.DBF DETAIL.DBF TEMPLATE.DBF PB.DBF BO.DBF QUOTESD.DBF SERIALNO.DBF LASTDATE D 8 0 SALESPER.DBF Date record was last accessed CUSTOMER.DBF INV.DBF LEFTCOLUMN N 2 0 DAYOFORM.DBF Starting position for special form ie: DATA ONLY invoice type LIMIT N 10 2 CUSTOMER.DBF Customer's credit limit LOC1 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #1 LOC2 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #2 LOC3 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #3 LOC4 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #4 LOC5 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #5 LOC6 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #6 LOC7 N 7 0 WAREHOUS.DBF Quantity in location/warehouse #7 LOCATION C 3 0 INV.DBF Location code, user defined MRP L 1 0 BO.DBF Flag to designate item as being an ENDITEM, consisting of other items NAME C 30 0 CUSTOMER.DBF Name of customer SALESPER.DBF NOTES M 10 0 WO_NOTES.DBF Memo notes/text CUSTMEMO.DBF NS L 1 0 INV.DBF Flag to designate item as being a DETAIL.DBF non-standard inventory item ONHAND N 7 0 INV.DBF * Quantity in main warehouse ONORDER N 7 0 INV.DBF Quantity on order with purchase orders OPEN L 1 0 QUOTES.DBF Flag that designates invoices as REGISTER.DBF being open, or that a register has INVOICE.DBF not been closed yet OPENDATE D 8 0 REGISTER.DBF Date register was opened OPENTIME C 8 0 REGISTER.DBF Time register was opened ORDERED N 7 0 DETAIL.DBF Quantity ordered PACKQTY C 6 0 INV.DBF Package quantity. User defined PAID N 10 2 INVOICE.DBF Amount collected from customer QUOTES.DBF PAID_PURC N 10 2 CUSTOMER.DBF Amount of purchases to date PAY L 1 0 BO.DBF Flag that designates a backorder invoice as being pre-paid PBL N 6 3 CUSTOMER.DBF Retail/List discount variable PBM N 6 3 CUSTOMER.DBF Margin/Cost Plus variable DAYO POS, TJS LAB Page: 128 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── PHONE C 14 0 CUSTOMER.DBF Telephone number SHIPTOS.DBF SALESPER.DBF INVOICE.DBF QUOTES.DBF PRICE N 10 2 QUOTESD.DBF Item price. User defined PB.DBF DETAIL.DBF BO.DBF INV.DBF TEMPLATE.DBF PRICE1 N 10 2 INV.DBF 1st multiple price PRICE2 N 10 2 INV.DBF 2nd multiple price PRICE3 N 10 2 INV.DBF 3rd multiple price PRICE4 N 10 2 INV.DBF 4th multiple price PRICE5 N 10 2 INV.DBF 5th multiple price PRICEX N 1 0 CUSTOMER.DBF Designation for default multiple price value PRINTED L 1 0 INVOICE.DBF Flag to show if a work order has been QUOTES.DBF printed as an invoice... PROJECT N 6 0 INVOICE.DBF Project number DETAIL.DBF PROMISED D 8 0 INVOICE.DBF Date order was promised to customer QTY N 7 0 DETAIL.DBF Quantity QUOTESD.DBF TEMPLATE.DBF BO.DBF QUOTE N 6 0 QUOTES.DBF Quote number QUOTESD.DBF REALCOST N 10 2 INV.DBF Real Cost REG C 3 0 INVOICE.DBF Register number used QUOTES.DBF RETAIL N 10 2 INV.DBF Retail/List price of an item SALESPER C 3 0 SALESPER.DBF Sales person number/code CUSTOMER.DBF SHIPTOS.DBF QUOTES.DBF INVOICE.DBF SALESPTD N 10 2 SALESPER.DBF Sales total period to date CUSTOMER.DBF SALESYTD N 10 2 SALESPER.DBF Sales total year to date CUSTOMER.DBF SC L 1 0 INVOICE.DBF Ship complete flag SERIALNO C 30 0 SERIALNO.DBF Serial number SERIALNO L 1 0 INV.DBF Flag to designate an item as requiring a serial number input SETUPCODE C 20 0 DAYOFORM.DBF Printer setup code SHIPADDR1 C 30 0 SHIPTOS.DBF Shipping address line 1 INVOICE.DBF QUOTES.DBF CUSTOMER.DBF DAYO POS, TJS LAB Page: 129 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── SHIPADDR2 C 30 0 SHIPTOS.DBF Shipping address line 1 CUSTOMER.DBF INVOICE.DBF QUOTES.DBF SHIPCITY C 17 0 INVOICE.DBF Ship To city QUOTES.DBF SHIPCITY C 22 0 CUSTOMER.DBF SHIPTOS.DBF SHIPNAME C 30 0 CUSTOMER.DBF Ship To name INVOICE.DBF QUOTES.DBF SHIPTOS.DBF SHIPPER C 20 0 SHIPTOS.DBF Shipper/Method of shipping CUSTOMER.DBF SHIPPER.DBF QUOTES.DBF INVOICE.DBF SHIPPHONE C 14 0 CUSTOMER.DBF Ship To telephone SHIPSTATE C 2 0 QUOTES.DBF Ship To state SHIPTOS.DBF INVOICE.DBF CUSTOMER.DBF SHIPZIP C 10 0 CUSTOMER.DBF Ship To zip code INVOICE.DBF QUOTES.DBF SHIPTOS.DBF SLLOC1 N 7 0 WAREHOUS.DBF Stock level for warehouse #1 SLLOC2 N 7 0 WAREHOUS.DBF Stock level for warehouse #2 SLLOC3 N 7 0 WAREHOUS.DBF Stock level for warehouse #3 SLLOC4 N 7 0 WAREHOUS.DBF Stock level for warehouse #4 SLLOC5 N 7 0 WAREHOUS.DBF Stock level for warehouse #5 SLLOC6 N 7 0 WAREHOUS.DBF Stock level for warehouse #6 SLLOC7 N 7 0 WAREHOUS.DBF Stock level for warehouse #7 SOLDPTD N 7 0 INV.DBF Quantity sold period to date SOLDYTD N 7 0 INV.DBF Quantity sold year to date STARTSUM N 10 2 REGISTER.DBF Amount register started off with STATE C 2 0 CUSTOMER.DBF Customer's address state SALESPER.DBF STOCKLEVEL N 7 0 INV.DBF Main inventory stock level amount SUBTOTAL N 10 2 QUOTES.DBF Subtotal INVOICE.DBF TAXABLE L 1 0 INV.DBF Flag to designate an item as being BO.DBF taxable QUOTESD.DBF DETAIL.DBF TAXCODE C 3 0 INVOICE.DBF Taxcode variable CUSTOMER.DBF QUOTES.DBF SHIPTOS.DBF TAXCODE C 1 0 TAXCODE.DBF DAYO POS, TJS LAB Page: 130 Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── TAXES N 10 2 QUOTES.DBF 1st Tax subtotal INVOICE.DBF TAXES2 N 10 2 QUOTES.DBF 2nd Tax subtotal INVOICE.DBF TAXRATE N 7 5 QUOTES.DBF 1st Tax rate TAXCODE.DBF SHIPTOS.DBF CUSTOMER.DBF INVOICE.DBF TAXRATE2 N 7 5 QUOTES.DBF 2nd Tax rate INVOICE.DBF SHIPTOS.DBF CUSTOMER.DBF TEMPLATE N 6 0 TEMPLATE.DBF Template/Bundle number used to recall 'templates' for easier invoicing TERMS C 20 0 QUOTES.DBF 1st terms code TERMS.DBF CUSTOMER.DBF INVOICE.DBF SHIPTOS.DBF TERMS2 C 20 0 INVOICE.DBF 2nd terms code TI L 1 0 INV.DBF Designates any item as being a DETAIL.DBF 'time' item, ie: service TIME C 8 0 INVOICE.DBF Time of access QUOTES.DBF BO.DBF TOPLINE N 2 0 DAYOFORM.DBF Number of lines to skip down at top of DATA ONLY invoice TYPE C 3 0 QUOTES.DBF Record type. Required only in the SHIPTOS.DBF database: INVOICE.DBF & ARH.DBF CUSTOMER.DBF INVOICE.DBF TYPE.DBF SALESPER.DBF INV.DBF UNIT C 3 0 INV.DBF Unit of issue, ie: 'EA' UNITQTY N 7 0 INV.DBF Number of individual pieces that comprise a unit ordered from a vendor VENDITEM C 12 0 INV.DBF Vendor/Manufacter's item number VENDOR C 10 0 INV.DBF Vendor/Manufacter's WEIGHT N 8 2 INV.DBF Total weight of an order WHSE N 3 0 INVOICE.DBF Warehouse number ZIP C 10 0 CUSTOMER.DBF Zip code SALESPER.DBF DAYO POS, TJS LAB Page: 131 ■ DAYO POS MAINTENANCE & QUIRKS - After using DAYO POS for a any period of time, you will need to 'clean out' deleted and closed invoices (INVOICE.DBF, DETAIL.DBF), and register log entries (REGISTER.LOG). This task can be accomplished with the DAYO End of Period program (DAYO EOP), but if you are not using it, then you will have to use the MISC ROUTINES to DELETE, then PACK the databases. This task is often called the 'End of Month' (EOM), or 'End of Period' (EOP) purge. The period may be daily, weekly, monthly, quarterly, or yearly. Deleted records should remain in their respected databases until this time to allow for organized record keeping. At this time, reports covering the period could be printed as well as backups of the databases being made. The backup is especially important since you will be permanently removing the records with the PACK option in the MISC routines. - At EOM/EOP time, the SOLDPTD field in the inventory database (INV.DBF), the SALESPTD field in the customer and sales persons database (CUSTOMER.DBF & SALESPER.DBF), should be set to zero. Note that these field are maintained/ adjusted by the use of the Inventory Adjustments option in the inventory browse screen, and by using DAYO POS. - On occasion (maybe an under statement), index files will get corrupted, especially on networks. To 'fix' a corrupted index requires that everyone 'get out of' the DAYO databases, and then perform a reindexing (actually a recreation of the indexes). The reindex is accomplished by running the DAYO POS program with a parameter of 'INDEX' (or using DAYOX). ie: C:\>DAYOP INDEX - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Indexes are recreated once every day. This is automatically performed by the first user to run DAYO POS. This process will take more time as your files get larger. This process should take place daily, but you can run it at night with a batch file that waits until after midnight (ie: DAYO Clock), or a with most scheduling programs. All other users and computers must be out of the databases, or the procedure will not occur properly. Remember to 'flag' the files sharable, readable and writable. DAYO POS, TJS LAB Page: 132 - Backups of your data and configuration files should take place daily! You have no doubt heard many scare stories. They are all true! The key files that need to be backed up all have the extension of .DBF, and .CFG. The .DBF files are your databases. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - 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 POS, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! DAYO POS, TJS LAB Page: 133 ■ 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...