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 / DAYORD.ZIP / DAYORD.EXE / DAYORPT.DOC < prev next >

Wrap

Text File | 1991-09-10 | 432.1 KB | 5,633 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ▄██▄ █▄ ▄█░ ▄█▄ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ ║ ║ █░ ██▄██░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ ║ ║ █░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ║ ║ ▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ ║ ║ █░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░║ ║ ▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ SMART REPORTS FOR THE DAYO MODULES ║ ║ ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, 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 upgrade. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO Smart Reports, TJS LAB Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 2......SETUP 3......PASSWORD/NAME 4......MAIN MENU 4......REPORTS/ROUTINES LIST 5......SINGLE WAREHOUSE REPORT 6......VALUATION EXPANDED REPORT 8......REORDER REPORT - 2, 4, OR 8 WEEKS AVERAGE 9......STOCKLEVEL SHORTAGE REPORT 10......STOCKLEVEL OVER REPORT 11......INVENTORY ASCII TEXT 12......LATE PURCHASE ORDER REPORT 13......PURCHASE ORDER DUE IN REPORT 14......INVENTORY ZERO COST ITEMS REPORT 15......INVENTORY ZERO PRICE ITEMS REPORT 16......INVENTORY ZERO RETAIL ITEMS REPORT 17......NEGATIVE ONHAND REPORT 18......MARGIN HISTORY (AVERAGE MARGIN & COST) 19......MARGIN HISTORY (LAST 12 WEEKS) 20......VENDOR LIST 20......EXAMPLE OF THE VENDOR LIST 21......CUSTOMER LIST 21......EXAMPLE OF THE CUSTOMER LIST 22......INVENTORY ITEM LIST 22......EXAMPLE OF THE INVENTORY ITEM LIST 23......CHECKING ACCOUNT LIST 23......EXAMPLE OF THE CHECKING ACCOUNT LIST 24......CHECK FORMAT LIST 24......EXAMPLE OF THE CHECKING ACCOUNT FORMATS LIST 25......EXPENSES LIST 25......EXAMPLE OF THE EXPENSES LIST 26......WAREHOUSE ADJUSTMENTS REPORT 26......EXAMPLE OF THE WAREHOUSE ADJUSTMENTS REPORT 27......HP LASER PULL SHEET/REPORT WITH FILTER 29......INVENTORY EXPANDED REPORT WITH FILTER 30......INVENTORY AVAILABLE REPORT WITH FILTER 31......CHECK FOR DUPLICATE RECORDS/INDEX KEYS 31......EXAMPLE OF THE DUPLICATE RECORD/INDEX KEY REPORT 32......GL POSTING PROBLEMS 32......EXAMPLE OF GL POSTING PROBLEMS REPORT 33......TAX SUMMARIES 34......MASTER INVENTORY 34......EXAMPLE OF THE MASTER INVENTORY UPDATE REPORT 35......NON-TAXABLE SALES 36......BIG LABELS 36......BIG LABELS CONFIGURATION DAYO Smart Reports, TJS LAB Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 37......CUSTOMER EXPANDED 38......AP ADJUSTMENTS 38......BATCH INVENTORY ADJUSTMENTS 39......AR ADJUSTMENTS 40......SPECIAL SALES REPORT I 41......SPECIAL SALES REPORT II 43......SPECIAL SALES REPORT III 44......CUSTOMER LIST #2 45......EXAMPLE OF THE CUSTOMER LIST #2 46......INSERT DECIMALS 47......WAREHOUSE REORDER 48......SERIAL NUMBERS IN 49......EXAMPLE OF THE SERIAL NUMBER IN REPORT 49......SERIAL NUMBERS OUT 49......EXAMPLE OF THE SERIAL NUMBER OUT REPORT 50......BAD RECORDS 51......RESET ALLOCATED 52......RESET BO - BACK ORDER QUANTITY 53......SET MULTIPLE PRICE FIELDS IN INVENTORY 54......MULTIPLE PRICING PROGRESS GRAPH 55......MODIFY SCREEN COLORS 55......COLOR CHART 58......ITEM TRACKER 61......AR DISCREPANCIES 62......EXAMPLE OF AR BUG REPORT 63......AP DISCREPANCIES 64......EXAMPLE OF AP BUG REPORT 65......RENTAL REPORT, RENTALS OUT 66......CHANGE ITEM NUMBER 68......CREDIT CARDS & CHECKS 69......INVENTORY PRICES 70......SALES COMMISSION REPORT 70.1....DAILY 'DOLLAR' (AR RECEIPTS) REPORT 70.1....JEWELRY TAGS - INVENTORY PRICE TAGS 70.2....INVOICE DETAIL HISTORY REPORT 71......VIEW REPORTS ON SCREEN 72......REPORT VIEWING SCREEN 73......PRINTER DRIVER (SETUP) 73......PRINTER DRIVER OPTIONS 74......CHANGE DEFAULT PRINTER 75......FULL SCREEN EDIT - F2 75......PRINTER DRIVER DATABASE FIELD DEFINITIONS 76......CONFIGURATION 76......CONFIGURATION LISTING 77......COMPANY NAME, ADDRESS & TELEPHONE 77......INVENTORY LOCATION/DIRECTORY 77......POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY 78......CUSTOMER DATABASE LOCATION/DIRECTORY 78......ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY DAYO Smart Reports, TJS LAB Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 78......QUOTES DATABASE LOCATION/DIRECTORY 79......BACKORDERS DATABASE LOCATION/DIRECTORY 79......PRICE BOOK DATABASE LOCATION/DIRECTORY 79......REPORT PRINTER TYPE 79......REPORT PRINTER PORT 80......MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE 80......COLOR MONITOR 80......COLOR INTENSITY 81......MISCELLANEOUS ROUTINES 81......MISC ROUTINES MENU: 82......APPEND FROM 84......BROWSE DATABASES 86......COPY (.DBF) TO 88......CREATE DATABASE 90......DELETE RECORDS 91......ERASE FILE 91......EXIT TO DOS 92......INDEX A DATABASE 93......LIST FIELDS 96......MODIFY DATABASE 97......PACK DATABASE 98......RECALL RECORDS 98......RETURN TO MENU 98......RUN (DOS COMMAND) 99......SIMPLE EDITOR 100......SORT DATABASE 101......TYPE (PRINT) FILE 102......ZAP DATABASE 104......HELP SCREENS 105......EXPANDED HELP 106......USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 107......VIEW DOCUMENTATION ONSCREEN 108......DAYO SMART REPORTS MAINTENANCE & QUIRKS 109......TJS 'Computer' LAB DAYO Smart Reports, TJS LAB Page: 1 ■ INTRODUCTION DAYO Smart Reports contains a collection of miscellaneous reports and routines that many other software packages leave out. Some of the DAYO Smart Reports actually write to your databases (ie: the calculating of the STOCKLEVEL field in the database INV.DBF). Smart Reports should be run periodically to 'check up on' or comfirm the accuracy of your data. There are 70+ Reports/Lists/Routines included in Smart Reports: Configuration AP Adjustments Single Warehouse Batch Inventory Adjustments Valuation Expanded AR Adjustments ReOrder (2 weeks) Special Sales Report I ReOrder (4 weeks) Special Sales Report II ReOrder (8 weeks) Special Sales Report III StockLevel Shortage Customer List #2 StockLevel Over Insert Decimals Inventory ASCII Text Insert Decimals #2 Late PO Warehouse Reorder PO - Due In This Week Serial Numbers In Inventory Zero Cost Serial Numbers Out Inventory Zero Price Bad Records Inventory Zero Retail Reset Allocated Negative Onhand Reset BO Margin (History) Set/Reset Prices Margin (12 Weeks) Modify Screen Colors Vendor List ITEM TRACKER Customer List AR Discrepancies Inventory Item List AP Discrepancies Checking Account List Rentals Out Check Format List Change ITEM Number Expenses List Credit Cards & Checks Warehouse Adjustments Inventory Prices HP Laser Pull Sheet Sales Commission Report Expanded Inventory Daily Dollar Report Available Inventory Jewelry Inventory Tags Check for Duplicates Invoice Detail History GL Posting Problems Expanded Detail History Tax Summaries Specific Customer Master Inventory ABC Reset & Report Non-Taxable Sales Average Cost Report Department Sales Reports On Screen Sales Profit Printer Setup Big Address Labels Miscellaneous Routines Customer Expanded DAYO Smart Reports is by default a multiuser system. Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sales Billing & Invoicing DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYOX Network/LAN Index Maintenance Utility & many more... DAYO Smart Reports, 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 Smart Reports software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using DAYO Smart Reports. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO Smart Reports, copy the contents of the DAYO Smart Reports floppy disk into a directory on your hard disk (ie: \DAYORPT). If this is the Shareware Version, you need to UnZip/UnArc the files. When you run DAYO Smart Reports for the first time, it will create all the database, index, and configuration files it requires for operation. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO Smart Reports configuration. Type and enter 'DAYOR' at the DOS prompt to run the program (ie: C:\DAYOR ). *** Your CONFIG.SYS file must have the buffers set to a minimun of 10, and your files must have a minimun setting of 55! Failure to edit the CONFIG.SYS file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is created if there is a problem detected, in the directory that this DAYO module is being run in. You may copy this file into your root/boot drive. Refer to your DOS manual for more information on the CONFIG.SYS file! DAYO Smart Reports, TJS LAB Page: 3 ■ PASSWORD/NAME The first prompt you get when you enter DAYO Reports is the one for you to enter your name (or password if using DAYO Passwords): DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐ Copyright (c) 1989-1991, All Rights Reserved │S M T W T F S │ ╔════════════════════════╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ║ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ DAYO ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │ ║ Smart ║ │ │ ║ Reports ║ └────────────────────┘ ║ ╠══════════════════════════════════════════════════╗ ║ ║ ║ ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ ╚════════════════════════╩══════════════════════════════════════════════════╝ ▄██▄ █▄ ▄█░ ▄█▄ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ █░ ██▄██░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ █░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░ ▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ DAYO Smart Reports, TJS LAB Page: 4 ■ MAIN MENU After a few moments and possibly a reindex, the main menu will appear (the left side of the screen is the actual main menu): DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐ Copyright (c) 1989-1991, All Rights Reserved │S M T W T F S │ ╔════════════════════════╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ║Configuration ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║Single Warehouse ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║Valuation Expanded ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ReOrder (2 weeks) ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ReOrder (4 weeks) ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │ ║ReOrder (8 weeks) ║ │ │ ║StockLevel Shortage ║ └────────────────────┘ ║StockLevel Over ╠═[ Configuration ]═════════════════════════════════╗ ║Inventory ASCII Text ║ ║ ║Late PO ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║PO - Due In This Week ║ DAYO Reports Configuration Settings. ║ ║Inventory Zero Cost ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ╠════════════════════════╣ ║ ║ Press Esc to Exit ║ ║ ╚════════════════════════╩═══════════════════════════════════════════════════╝ ▄██▄ █▄ ▄█░ ▄█▄ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ █░ ██▄██░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ █░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░ ▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ Report 1 of 31 Note that this DAYO Module has a different Main Menu. With the exception of the CONFIGURATION and MISC ROUTINES menu options, all other options listed on the DAYO Smart Reports menu are reports. DAYO Smart Reports, TJS LAB Page: 5 ■ SINGLE WAREHOUSE REPORT The Single Warehouse Report prints cost information about each item in a specific warehouse (found in the WAREHOUS.DBF). This report also includes the valuation of each item (cost * quantity). This report is 'hard coded'; not a report form. The following fields/variables are printed: Item VendItem Description Cost Price Main Inventory Stock Level LOCxxx (Warehouse Quantity) SLLOCxxx (Stocking Level for this Warehouse Item) ReOrder Valuation ╔═[ Single Warehouse ]═══════════════════════════════╗ ║ ║ ║ Single Expanded Inventory Warehouse Report. ║ ║ Not a Report Form. ║ ║ Uses Databases: INV.DBF, WAREHOUS.DBF, ║ ║ & WARENAME.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Single Warehouse ]═══════════════════════════════╗ ║ ║ ║ Enter Location: LOC 1 ║ ║ Include 'Ok' Items? (Y/N) ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: SINGLE.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 6 ■ VALUATION EXPANDED REPORT The Valuation Expanded Report is essentially the same as the Inventory Expanded report except that the Valuation is included. A dBase (tm) compatible report form is required (VALUATIO.FRM). The following fields/variables are included on this report: ITEM ONORDER VALUATION VENDOR ITEM COST TYPE DESCRIPTION RETAIL CLASS ONHAND PRICE The first prompt is to select the index (order of the report): ╔══════════════════════════════════════════════════════╗ ║The Default Valuation Inventory Report (VALUATIO.FRM) ║ ║contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VALUATION ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 7 The second prompt is for a 'filter' or condition. The filter must/can be any valid dBase (tm) expression. To include all records (no filter), just press enter on an empty (blank) prompt... ╔══════════════════════════════════════════════════════╗ ║The Default Valuation Inventory Report (VALUATIO.FRM) ║ ║contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VALUATION ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ ║ ║Enter Filter: PRICE>100.00 ║ ║EG: TYPE = "XXX" ║ ║ ║ ║Enter Heading: TJS LAB ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: VALUE.TXT ║ ║ ║ ╚══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 8 ■ REORDER REPORT - 2, 4, OR 8 WEEKS AVERAGE This ReOrder Report calculates and optionally resets the STOCKLEVEL field in the database INV.DBF based on sales data (from the DAYO POS database DETAIL.DBF). You select the number of weeks stockage (2, 4, or 8 weeks). This report does not utilize a report form. The following fields/variables are included on this report: ITEM STOCKLEVEL REORDER VENDOR ITEM COST EXTENDED COST DESCRIPTION RETAIL CLASS ONHAND PRICE TYPE ╔═[ ReOrder (2 weeks) ]══════════════════════════════╗ ║ ║ ║ ReOrder Based On Last 2 Weeks Sales. ║ ║ Not a Report Form. ║ ║ Uses Databases: INV.DBF, DETAIL.DBF. ║ ║ Optionally Resets the StockLevel Field. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ ReOrder (8 weeks) ]══════════════════════════════╗ ║ ║ ║ Reset the StockLevel Field? (Y/N) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: REORDER8.TXT ║ ╚════════════════════════════════════════════════════╝ The progress of the reorder report is display with a graph... 0 Records 2 3 ╔════════════════╦══════════════════╦═════════════════╦════════════════╗ ╠███████████████████████════════════╬═════════════════╬════════════════╣ ╠════════════════╩══════════════════╬═════════════════╩════════════════╣ 0% Completed 50% Done! DAYO Smart Reports, TJS LAB Page: 9 ■ STOCKLEVEL SHORTAGE REPORT The StockLevel Shortage Report will alert you to any item that falls below the stockage level in the main inventory database INV.DBF. The algorithm/formula is to report all items when ONHAND is less than the STOCKLEVEL. This report does use a report form (INVSTOCK.FRM), and it is highly recommended that you modify it (with dBase III+/IV), if you want to use your other warehouses (WAREHOUS.DBF), in the calculation. The following fields/variables are included on this report: ITEM ONHAND RETAIL VENDITEM LEVEL PRICE DESC ONORDER TYPE VENDOR COST ╔═[ StockLevel Shortage ]════════════════════════════╗ ║ ║ ║ StockLevel Shortage Report. ║ ║ Reports ONHAND < STOCKLEVEL. ║ ║ Uses a Report Form: INVSTOCK.FRM. ║ ║ Uses Database: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ StockLevel Shortage ]════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: INVSHORT.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 10 ■ STOCKLEVEL OVER REPORT The StockLevel Over Report will alert you to any item that is excess in the main inventory database INV.DBF. The algorithm/formula is to report all items when ONHAND is greater than the STOCKLEVEL. This report does use a report form (INVSTOCK.FRM), and it is highly recommended that you modify it (with dBase III+/IV), if you want to use your other warehouses (WAREHOUS.DBF), in the calculation. The following fields/variables are included on the STOCK OVER report: ITEM ONHAND RETAIL VENDITEM LEVEL PRICE DESC ONORDER TYPE VENDOR COST ╔═[ StockLevel Over ]════════════════════════════════╗ ║ ║ ║ StockLevel Over Report. ║ ║ Reports ONHAND > STOCKLEVEL. ║ ║ Uses a Report Form: INVSTOCK.FRM. ║ ║ Uses Database: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ StockLevel Over ]════════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: INVOVER.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 11 ■ INVENTORY ASCII TEXT If there exists a need to import inventory fields into a word processor or editor, you can use this report to create an ASCII/text file in the Standard Data Format (SDF). This format is often called a flat file. Other 'flat' files/reports can be created with the LIST option in the MISC ROUTINES. The format for the file is: Field Len Start Stop ----------- --- ----- ---- ITEM 12 1 12 VENDITEM 12 13 24 DESC 30 25 54 VENDOR 10 55 64 ONHAND 7 65 71 COST 10 72 81 PRICE 10 82 91 RETAIL 10 92 101 STOCKLEVEL 7 102 108 TYPE 3 109 111 CLASS 3 112 114 ╔═[ Inventory ASCII Text ]═══════════════════════════╗ ║ ║ ║ Inventory ASCII Text File. ║ ║ Creates an ASCII text file for ║ ║ import into a work processor or ║ ║ spreadsheet. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Inventory ASCII Text ]═══════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Enter File Name: INVASCII.TXT ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 12 ■ LATE PURCHASE ORDER REPORT This report simply reports any purchase order that is overdue to be received. This report will only work if the ETA (Estimate time [date]), field in the database POH.DBF (Purchase Order Headers), is maintain. A report form is used (LATEPO.FRM). Fields/variables in the report: PO DESC DATE (of PO) VENDOR ORDERED ETA ITEM RECEIVED LATE (Number of days overdue) VENDITEM DUE (Amount due in) ╔═[ Late PO ]════════════════════════════════════════╗ ║ ║ ║ Late Purchase Order Report. ║ ║ Reports Date > ETA. ║ ║ Uses a Report Form: LATEPO.FRM. ║ ║ Uses Databases: POD.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Late PO ]════════════════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: LATEPO.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 13 ■ PURCHASE ORDER DUE IN REPORT This report will give you advance notice of the due dates/arrival of product from your vendors. This report requires the maintenance of the ETA field in the database POH.DBF (Purchase Order Headers). Fields/variables in the report: PO DESC DATE (of PO) VENDOR ORDERED ETA ITEM RECEIVED DUE (Number of days overdue) VENDITEM DUE (Amount due in) ╔═[ PO - Due In This Week ]══════════════════════════╗ ║ ║ ║ PO - Due In This Week Report. ║ ║ Reports Purchase Orders Due to be received within ║ ║ the next 7 days. ║ ║ Uses Report Form: PODUEIN.FRM. ║ ║ Uses Databases: POH.DBF & POD.DBF. ║ ╚════════════════════════════════════════════════════╝ ╔═[ PO - Due In This Week ]══════════════════════════╗ ║ ║ ║ Select the Index -> PO ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: PODUEIN.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 14 ■ INVENTORY ZERO COST ITEMS REPORT This Smart Report will report only items with a cost less than or equal to zero. Use this report to insure you have no items listed in your inventory database without a cost value. The report form ZEROCOST.FRM is utilized. The following fields/variables are included in the report: ITEM ONHAND PRICE VENDITEM ONORDER TYPE DESC COST CLASS VENDOR RETAIL ╔═[ Inventory Zero Cost ]════════════════════════════╗ ║ ║ ║ Inventory Zero Cost Items Report. ║ ║ Reports any inventory item with a COST <= 0. ║ ║ Uses a Report Form: ZEROCOST.FRM. ║ ║ Uses Databases: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Inventory Zero Cost ]════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: 0COST.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 15 ■ INVENTORY ZERO PRICE ITEMS REPORT This Smart Report will report only items with a price less than or equal to zero. Use this report to insure you have no items listed in your inventory database without a price value. The report form ZEROCOST.FRM is utilized. The following fields/variables are included in the report: ITEM ONHAND PRICE VENDITEM ONORDER TYPE DESC COST CLASS VENDOR RETAIL ╔═[ Inventory Zero Price ]═══════════════════════════╗ ║ ║ ║ Inventory Zero Price Items Report. ║ ║ Reports any inventory item with a PRICE <= 0. ║ ║ Uses a Report Form: ZEROCOST.FRM. ║ ║ Uses Databases: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Inventory Zero Price ]═══════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: 0PRICE.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 16 ■ INVENTORY ZERO RETAIL ITEMS REPORT This Smart Report will report only items with a retail/list 'price' less than or equal to zero. Use this report to insure you have no items listed in your inventory database without a retail/list value. The report form ZEROCOST.FRM is utilized. The following fields/variables are included in the report: ITEM ONHAND PRICE VENDITEM ONORDER TYPE DESC COST CLASS VENDOR RETAIL ╔═[ Inventory Zero Retail ]══════════════════════════╗ ║ ║ ║ Inventory Zero Retail Items Report. ║ ║ Reports any inventory item with a RETAIL <= 0. ║ ║ Uses a Report Form: ZEROCOST.FRM. ║ ║ Uses Databases: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Inventory Zero Retail ]══════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: 0RETAIL.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 17 ■ NEGATIVE ONHAND REPORT This report will alert you to a posting problem (probably with DAYO POS). It is not recommended that invoices be created without items in the inventory database (INV.DBF), however it is an optional DAYO Inventory configuration setting to allow/disallow it. The report form NEGQTY.FRM is utilized. The following fields/variables are included in the report: ITEM ONHAND PRICE VENDITEM ONORDER TYPE DESC COST CLASS VENDOR RETAIL ╔═[ Negative Onhand ]════════════════════════════════╗ ║ ║ ║ Inventory Negative Onhand Report. ║ ║ Reports any inventory item with an ONHAND < 0. ║ ║ Uses a Report Form: NEGQTY.FRM. ║ ║ Uses Databases: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Negative Onhand ]════════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: NEGQTY.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 18 ■ MARGIN HISTORY (AVERAGE MARGIN & COST) Use this report on the occasions that you need to know the average margin for your inventory items based on the total sales history. The average cost is also calculated. Knowing these values is often necessary in determining the PRICE. No report form is utilized. The following fields/variables are included in the report: ITEM PRICE VENDITEM RETAIL DESC AVERAGE COST COST MARGIN ╔═[ Margin (History) ]═══════════════════════════════╗ ║ ║ ║ Item Average Margin (All Sales History). ║ ║ Report of the average sales margin for an item. ║ ║ Uses a Report Form: AMARGIN.FRM. ║ ║ Uses Databases: INV.DBF & DETAIL.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Margin (History) ]═══════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: AMARGIN.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 19 ■ MARGIN HISTORY (LAST 12 WEEKS) Use this report on the occasions that you need to know the average margin for your inventory items based on the last 12 weeks of sales history. The average cost is also calculated. Knowing these values is often necessary in determining the PRICE. No report form is utilized. The following fields/variables are included in the report: ITEM PRICE VENDITEM RETAIL DESC AVERAGE COST COST MARGIN ╔═[ Margin (12 Weeks) ]══════════════════════════════╗ ║ ║ ║ Item Average Margin (Last 12 Weeks History). ║ ║ Report of the average sales margin for an item ║ ║ using the last 12 weeks of sales data. ║ ║ Uses a Report Form: AMARGIN.FRM. ║ ║ Uses Databases: INV.DBF & DETAIL.DBF. ║ ╚════════════════════════════════════════════════════╝ ╔═[ Margin (12 Weeks) ]══════════════════════════════╗ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: AMARGIN.TXT ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 20 ■ VENDOR LIST This is a simple listing of your vendors. Uses the report form VENDLIST.FRM. The following fields/variables are included in the report: VENDOR NAME DATE PHONE ╔═[ Vendor List ]════════════════════════════════════╗ ║ ║ ║ Vendor List. ║ ║ ║ ║ Uses a Report Form: VENDLIST.FRM. ║ ║ Uses Database: VENDORS.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Vendor List ]════════════════════════════════════╗ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: VENDLIST.TXT ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE VENDOR LIST Page No. 1 07/27/90 Vendors Listing Vendor Last Number Vendor Name Date Phone ---------- ------------------------------ -------- -------------- 3M 3M TAPES 07/03/90 24 ____ 6MM 6M MAINTENANCE CO 07/03/90 24 ____ ABC AL'S BEVERAGE COMPANY 07/03/90 24 ____ RDD RESEACH DEV. DIST. CENTER 07/03/90 24 ____ ROC REPUBLIC OF CHINA 07/03/90 24 ____ SSS SIERRA SUPPLY & SERVICES 07/03/90 24 ____ TLJ TJS LAB 07/03/90 24 ____ DAYO Smart Reports, TJS LAB Page: 21 ■ CUSTOMER LIST This is a simple listing of your customers. Uses the report form CUSTLIST.FRM. The following fields/variables are included in the report: CUSTOMER NAME PHONE ╔═[ Customer List ]══════════════════════════════════╗ ║ ║ ║ Customer List. ║ ║ ║ ║ Uses a Report Form: CUSTLIST.FRM. ║ ║ Uses Database: VENDORS.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Customer List ]══════════════════════════════════╗ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: CUSTLIST.TXT ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CUSTOMER LIST Page No. 1 07/27/90 Customer List Customer Name Phone -------- ------------------------------ -------------- 301210 DASHER, DON 744-4541 _____________ 301211 DASHLEY COURT _____________ 301212 MRS. BERT _____________ 301213 KALUMINEX 743-8634 _____________ 301214 ADVANCED ELECTRONICS _____________ 301215 DENNYS CONSTRUCTION 740-6741 _____________ 301216 BARKALOW, ROB 846-4169 _____________ 301218 BURGER KING 744-3332 _____________ 301219 MALLO CONSTRUCTION CO _____________ DAYO Smart Reports, TJS LAB Page: 22 ■ INVENTORY ITEM LIST This is a listing of your inventory items. Uses the report form ITEMLIST.FRM. The following fields/variables are included in the report: ITEM VENDITEM DESC ╔═[ Inventory Item List ]════════════════════════════╗ ║ ║ ║ Inventory Item List. ║ ║ ║ ║ Uses a Report Form: ITEMLIST.FRM. ║ ║ Uses Database: INV.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Inventory Item List ]════════════════════════════╗ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: ITEMLIST.TXT ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE INVENTORY ITEM LIST 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 _____________ 2ANT143 2" ANT IVORY COIL _____________ 2ANT148 2" ANT IVORY COIL _____________ DAYO Smart Reports, TJS LAB Page: 23 ■ CHECKING ACCOUNT LIST This is a listing of your inventory items. Uses the report form ACCTLIST.FRM. The following fields/variables are included in the report: NUMBER ACCTNUM NAME BALANCE ╔═[ Checking Account List ]══════════════════════════╗ ║ ║ ║ Checking Account List. ║ ║ ║ ║ Uses a Report Form: ACCTLIST.FRM. ║ ║ Uses Database: ACCOUNTS.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Checking Account List ]══════════════════════════╗ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: ACCTLIST.TXT ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CHECKING ACCOUNT LIST Page No. 1 07/27/90 CHECKING ACCOUNTS LISTING Account Number Number Bank/Account Name Balance ------ -------------------- ------------------------------ ---------- 1 0100983-28838-20 C&S National Bank, Orlando 12980.17 2 12321-1232-XA CAPONES Private Bank 15.00 *** Total *** 12995.12 DAYO Smart Reports, TJS LAB Page: 24 ■ CHECK FORMAT LIST This is a listing of all your check formats (the printer settings for the printing of special/custom checks). Only the length and width of the check form is printed... Uses the report form CHKFLIST.FRM. The following fields/variables are included in the report: FORMAT NAME CHECK LENGTH CHECK WIDTH ╔═[ Check Format List ]══════════════════════════════╗ ║ ║ ║ Check Format List of all your 'Unique' ║ ║ Check Formats. ║ ║ Uses a Report Form: CHKFLIST.FRM. ║ ║ Uses Database: CFORMAT.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Check Format List ]══════════════════════════════╗ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: CHKFLIST.TXT ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CHECKING ACCOUNT FORMATS LIST Page No. 1 07/27/90 CHECKING ACCOUNT FORMATS LIST Check Check Format Name Length Width ------ ------------------------------ ------ ----- 1 Nebb's Radio Shack Check Type 41 80 __________________ 2 Moore Check # 1929 21 80 __________________ 3 Computer Forms, Inc #93001-A 19 90 __________________ DAYO Smart Reports, TJS LAB Page: 25 ■ EXPENSES LIST This is a listing of all your expenses. Uses the report form EXPLIST.FRM. The following fields/variables are included in the report: WHATFOR NUMBER AMOUNT DATE ╔═[ Expenses List ]══════════════════════════════════╗ ║ ║ ║ Expenses List of all your 'Unique' Expenses. ║ ║ ║ ║ Uses a Report Form: EXPLIST.FRM. ║ ║ Uses Database: EXPENSES.DBF. ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═[ Expenses List ]══════════════════════════════════╗ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ ║ ║ Enter File Name: EXPLIST.TXT ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE EXPENSES LIST Page No. 1 07/27/90 EXPENSES LIST Expense Expense For... Number Amount Date ---------------------------------------- ------- ---------- -------- Red Bug Exterminators 120 45.00 12/04/89 _______ South Carolina Electric & Gas 121 1245.31 01/17/90 _______ Carleton Cars 122 530.40 01/12/90 _______ Joe's Lawn Service 123 15.00 02/23/90 _______ Mary Martin & Associates 144 50.00 04/14/90 _______ *** Total *** 1885.71 DAYO Smart Reports, TJS LAB Page: 26 ■ WAREHOUSE ADJUSTMENTS REPORT This report list all inventory adjusts for a selected data range that are warehouse related. Uses the report form WAREADJ.FRM ╔═[ Warehouse Adjustments ]══════════════════════════╗ ║■Start Date: 01/27/90 Ending Date: 07/27/90 ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: WAREADJ.TXT ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE WAREHOUSE ADJUSTMENTS REPORT Page No. 1 07/27/90 WAREHOUSE ADJUSTMENTS REPORT Ware- Reason Extended House For Item Description Qty Cost Date ------- --------------- ------------ --------------- ------ ---------- ----- ** Warehouse: LOC1 1 Found in the JAR-1 3 4.23 12/89 receiving area JAR #1, 30 1 Found in the JAR-2 1 1.00 12/89 receiving area JAR #2, 10-A 1 Returned JAR-3 1 1.00 12/89 JAR #3 ** Subtotal ** 5 6.23 3 Found in the JAR-3 1 1.00 12/89 shipping area JAR #3 ** Subtotal ** 1 1.00 *** Total *** 6 7.23 DAYO Smart Reports, TJS LAB Page: 27 ■ HP LASER PULL SHEET/REPORT WITH FILTER This report will ONLY print onto an HP Laser or a compatible printer! The first prompt is for a 'filter' or condition. The filter must/can be any valid dBase (tm) expression. To include all records (no filter), just press enter on an empty (blank) prompt... ╔═[ HP Laser Pull Sheet ]════════════════════════════╗ ║■ ║ ║ EG: TYPE='XXX' ║ ║ Enter Filter: TYPE="ABC" ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ The Pull Sheet can be printed without any prices, the cost, price, or the retail (list) price... ╔═[ HP Laser Pull Sheet ]════════════════════════════╗ ║■Select Pull Sheet -> Pull Sheet - No Costs/Prices ║ ║ Pull Sheet - Cost ║ ║ Pull Sheet - Price ║ ║ Pull Sheet - Retail/List ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ There exists 8 index options for the Pull Report: 1. Item Number 2. Item Description 3. Vendor Number 4. Vendor/Mfg Item Number 5. Item Type 6. Item CLASS Code 7. Item Cost 8. Location + Item Number ╔═[ HP Laser Pull Sheet ]════════════════════════════╗ ║■Select Pull Sheet ->Pull Sheet - No Costs/Prices ║ ║ Select Index -> Item Number ║ ║ Item Description ║ ║ Use the down Vendor Number ║ ║ arrow key to Vendor/Mfg Item Number ║ ║ view more... Item Type ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 28 The last 3 index options (CLASS, COST, or LOCATION) require the creation of a temporary index, ie: ┌──────────────────────────────────────────────────────────┐ │ Database Name: \DAYOINV\INV.DBF │ │ Index Name: TEMP51.NTX │ │ Number of Records: 303 │ │ ┌──────────────────────────────────────────────────┐ │ │ │██████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ The Pull Sheet can be directed to the printer or to a file (for later printing. Note, this report CAN NOT be viewed onscreen because of the laser printer codes... ╔═[ HP Laser Pull Sheet ]════════════════════════════╗ ║■Select Pull Sheet ->Pull Sheet - No Costs/Prices ║ ║ Select Index ->Item CLASS Code ║ ║ Send Output to Printer? (Y/N) ║ ║ (Remember, only HP Laser or Compatible) ║ ║ Enter File Name: PULL.TXT ║ ║ ║ ╚════════════════════════════════════════════════════╝ A progress graph is displayed while the report is generated: ╔═[ HP Laser Pull Sheet ]════════════════════════════╗ ║■Select Pull Sheet ->Pull Sheet - No Costs/Prices ║ ║ Select Index ->Item Cost ║ ║ Send Output to Printer? (Y/N) ║ ║ (Remember, only HP Laser or Compatible) ║ ║ ├███████─┬──┬──┬──┬──┬──┼──┬──┬──┬──┬──┬──┬──┬──┤ ║ ║ % 50% finis ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 29 ■ INVENTORY EXPANDED REPORT WITH FILTER The first prompt for the Expanded Inventory is for the index (order of the report): ╔═[ Expanded Inventory Report ]════════════════════════╗ ║The Default Expanded Inventory Report (EXPANDED.FRM) ║ ║contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VENDOR ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════════════════════════╝ The second prompt is for a 'filter' or condition. The filter must/can be any valid dBase (tm) expression. To include all records (no filter), just press enter on an empty (blank) prompt... ╔═[ Expanded Inventory Report ]════════════════════════╗ ║The Default Expanded Inventory Report (EXPANDED.FRM) ║ ║contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VENDOR ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ ║ ║Enter Filter: CLASS=" " ║ ║EG: TYPE = "XXX" ║ ║ ║ ║Include Zero (0) Cost Items? (Y/N) ║ ║Enter Heading: EXPANDED REPORT ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: EXPANDED.TXT ║ ╚══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 30 ■ INVENTORY AVAILABLE REPORT WITH FILTER This report is identical to the Expanded Inventory Report except that it only reports items with an ONHAND quantity not equal to Zero (0). ╔═[ Available Inventory Report ]═══════════════════════╗ ║The Available Report only prints items with an ONHAND ║ ║not equal to zero. Otherwise the same as the Expanded.║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VENDOR ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ ║ ║Enter Filter: COST>1000 ║ ║EG: TYPE = "XXX" ║ ║ ║ ║Include Zero (0) Cost Items? (Y/N) ║ ║Enter Heading: AVAILABLE REPORT ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: AVALABLE.TXT ║ ╚══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 31 ■ CHECK FOR DUPLICATE RECORDS/INDEX KEYS This report/routine is used to find duplicate records in any database that is indexed. The prompts are for the database name (you can include the drive/directory/path), and the index name. The routine will determine the index key (the field that created the selected index). If any duplicate records (index key values) are found, a report will be generated (directed to printer or file). ╠═[ Check for Duplicates ]═══════════════════════════╗ ║■ ║ ║ Enter Database Name: \DAYOPOS\INVOICE ║ ║ Enter Index Name: \DAYOPOS\INVOICE ║ ║ Send Output to Printer? (Y/N) ║ ╣ ( No -> To File) ║ ║ Enter File Name: DUPES.TXT ║ ╩════════════════════════════════════════════════════╝ The progress of this routine is displayed onto the screen. If any duplicates are found, a short beep will sound... ╔════[ Duplicate Record Check ]══════════════════════════════════════╗ ║ Looking for duplicate KEY fields in the following: ║ ║ Database \DAYOPOS\INVOICE ║ ║ Index \DAYOPOS\INVOICE ║ ║ KEY INVOICE ║ ║ Number of records to search: 111 ║ ╟██████████████████████████████████████┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢ ║0 50% Finis║ ╚════════════════════════════════════════════════════════════════════╝ Standby While I Print This Report! Press Esc to Abort ■ EXAMPLE OF THE DUPLICATE RECORD/INDEX KEY REPORT Duplicate Record Check Page 1 Database: \DAYOPOS\INVOICE Index: \DAYOPOS\INVOICE KEY: INVOICE Records 6 & 7 are duplicated: 63 Records 7 & 8 are duplicated: 63 Records 20 & 21 are duplicated: 77 Records 28 & 29 are duplicated: 86 DAYO Smart Reports, TJS LAB Page: 32 ■ GL POSTING PROBLEMS This report checks databases for 'Bad' CLASS Codes that will cause a problem at time of GL Posting. You have the option to run it against all databases or to select specific databases. ■ EXAMPLE OF GL POSTING PROBLEMS REPORT Page No. 1 09/07/90 GENERAL LEDGER PRE-POST CLASS CODE PROBLEM REPORT DATABASE: INV.DBF ***** CLASS Extended Item Vendor Description CODE Date Cost*Onhand ------------ ---------- ------------------------- ***** -------- ----------- AC2320 ACSCOMMERI CHILDREN'S STRAWBERRY SAN SH 08/27/90 0.00 AC3011 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3011C ACSCOM 2-LEAF CHILD SLIPPERS SH / / 0.00 AC3019 ACSCOM DOUBLE BOWTIE LADIES SLIP SH / / 0.00 AC3111 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3211 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3311 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3411 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3511 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3611 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 AC3711 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00 DAYO Smart Reports, TJS LAB Page: 33 ■ TAX SUMMARIES For tax reporting purposes, it is often required to summarize taxes paid to states, and in some cases to counties. By using the TAXCODE field in the customer's record, you can summarize taxes by unique TAXCODEs. This is a two part report. The first part summarizes by Ship To state, ie: Page No. 1 Period: 01/08/90 to 09/08/90 09/08/90 DAYO TAX REPORT SUBTOTAL BY STATE Taxes ---------- ** State Code: FL ** Subtotal ** 20003.12 ** State Code: CA ** Subtotal ** 20.00 ** State Code: SC ** Subtotal ** 10.20 *** Total *** 20033.32 The second part summarizes by TAXCODE, ie: TAX SUMMARY BY TAX CODE Date: 09/04/90 Period: 08/01/90 to 08/31/90 Code Amount ---- ---------- CX1 10.12 CX2 10.00 CX3 10.00 CX4 10.00 CX5 10.10 CX6 10.10 CXA 10.10 ---------- 70.42 DAYO Smart Reports, TJS LAB Page: 34 ■ MASTER INVENTORY This routine compares two DAYO inventory databases, updating one from the the other. One database (the Master/Main Inventory) is used to update another. Produces a report of changes & additions. A special feature of this report is that you can select an option to return to DOS immediately after running the report. ■ EXAMPLE OF THE MASTER INVENTORY UPDATE REPORT MASTER INVENTORY UPDATE - ADDITIONS & CHANGES Date: 09/08/90 Time: 00:04:57 Page 1 Run by: SDF Site: SAL'S THINGS ITEM DESCRIPTION MESSAGE ------------ ------------------------------ ---------- EV044K5 EVEREST BELLY BAG 5-POCKET Change Field: CLASS Was: BB Now: CCC SH509 PALADINO NYLON 3-PKT BELLY BAG Change Field: WEIGHT Was: 0.00 Now: 23.00 SH709FLA FLORIDA SUPER 5-PKT BELLY BAG Change Field: SERIALNO Was: .F. Now: .T. MASTER INVENTORY UPDATE - ITEMS NOT IN MASTER INVENTORY * * * Date: 09/08/90 Time: 00:05:01 Page 1 Run by: SDF Site: SAL'S THINGS ITEM DESCRIPTION ONHAND SOLDYTD DATE ------------ ------------------------------ --------- --------- -------- AC2320 CHILDREN'S STRAWBERRY SANDAL 0.000 0.000 08/27/90 AC3011 2-LEAF LADIES SLIPPERS 0.000 0.000 08/11/90 AC3011C 2-LEAF CHILD SLIPPERS 0.000 0.000 / / AC3019 DOUBLE BOWTIE LADIES SLIPPERS 0.000 0.000 / / AC3211 MEN/LADIES NEON BEACHCOMBERS 0.000 0.000 / / AC3666 SINGLE BOWTIE LADIES SLIPPERS 0.000 0.000 / / AC3734 LADIES ELASTIC SANDAL 0.000 0.000 08/28/90 AC5201 MEN/LADIES BEACHCOMBERS 0.000 0.000 / / DAYO Smart Reports, TJS LAB Page: 35 ■ NON-TAXABLE SALES This routine will print all taxable or non-taxable AR Header records. This enables you to break down your sales by tax type. The report also has the option of printing just a one line summary. The expanded report contains the following fields: INVOICE, CUSTOMER, TYPE, TERMS, SALESREP, CLASS, TAXRATE, TAXES, FREIGHT, ADJUST, SUBTOTAL, PAID, BALANCE, & DATE The summary and expanded report contains subtotals for the following fields: TAXES, FREIGHT, ADJUST, SUBTOTAL, PAID, & BALANCE ╔═══════════════════════════════════════════════════════╗ ║This report will print all your taxable or ║ ║non-taxable posted invoice headers (database ARH.DBF) ║ ║or a summary for a selected date range. ║ ║Uses Report Form TAXABLES.FRM (132 Character Wide) ║ ║ ║ ║Start Date: 08/09/90 Ending Date: 09/08/90 ║ ║ ║ ║Report Non-Taxable Only? (Y/N) (No: Taxable Only) ║ ║ ║ ║Will this be a Summary Only? (Y/N) ║ ║ ║ ║Select Index -> INVOICE NUMBER ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: TAX_N_X.TXT ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 36 ■ BIG LABELS This report option was added to allow you to print any size address labels (ie: 4" X 4") for customer, shiptos, and vendors. DAYORPT V3.0, TJS LAB ┌──[September 1990]──┐ ██▄████░ ████░ ▄██████░ │■│┌───────────────────────────────┐│■│ ██░ ██░ ██░ ██░ │■││ Your Company Name ││■│ ██░ ██░ ██░ ██░ │■││ 12345 Orange Street ││■│ ██████░ ██░ ██░ ███░ │■││ Suite 100A ││■│ ██░ ██░ ██░ ██░ ██░ │■││ Anyplace, ST 12345-1234 ││■│ ██░ ██░ ██░ ██░ ██░ │■│├───────────────────────────────┤│■│ ██▀████░ ████░ ▀██████▀ │■││ Customer, ShipTo, Vendor ││■│ │■││ Address Line Here ││■│ █░ ▄█▄ █▄██░ ███░ █░ ▄██▄ │■││ Another Address Line ││■│ █░ █░█░ █░ █░ █░ █░ █░ │■││ City, State, ZIP ││■│ █░ █▄█░ █▄▄█░ ██░ █░ █▄▄▄ │■│└───────────────────────────────┘│■│ █░ █▀ ▀█░ █░ █░ █░ █░ █░ │■│┌───────────────────────────────┐│■│ ███░ █░ █░ █▀██░ ███░ ███░ ▀██▀ │■││ Your Company Name ││■│ ╔════════════════════════════════════════════════════════════════════════════╗ ║Select Label Option -> Customer Bill To ║ ║ Customer Ship To #1 ║ ║ Customer Ship To #2 ║ ║ Vendor Bill To ║ ║ Vendor Ship To ║ ║ Label Configuration ║ ║ Line Feed ║ ║ Exit ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ BIG LABELS CONFIGURATION A default label configuration is shown in the following diagram, but you can change it to fix another label... ╔════════════════════════════════════════════════════════════════════╗ ║ Print Your Company Name & Address: Y ║ ║ Print ATTN (Contact) Field: Y ║ ║ Number of Lines per Label: 18 ║ ║ Label Width (for centering): 40 ║ ║ Starting Column: 0 ║ ║ Starting Line For Your Address: 5 ║ ║ Starting Line For Addressee: 12 ║ ║ ║ ║ Print Sample? (Y/N) ║ ║ ║ ║ Exit? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 37 ■ CUSTOMER EXPANDED This report is a modified version of the expanded customer report found in DAYO AR Reports menu. This one has more options. ╔═[ Customer Expanded ]══════════════════════════════╗ ║ Customer Expanded Report with Ship To Data. ║ ║ Multiple Indexes. ║ ║ Not a Report Form. ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ This report has 10 indexes to chose from: ╔═══════════════════════════════════════════════════════╗ ║The Customer Expanded Report contains as much data ║ ║for each customer that can fit onto a 132 character ║ ║wide printout. * Includes Ship To Information also. ║ ║ ║ ║Not a Report Form. ║ ║ ║ ║Select the Index -> CUSTOMER ║ ║ BILL TO NAME ║ ║ SHIP TO NAME ║ ║ LAST 4 DIGITS PHONE ║ ║ BILL TO ZIP CODE ║ ║ ATTENTION/CONTACT ║ ║ BILL TO CITY ║ ║ SHIP TO ZIP CODE ║ ║ SALES PERSON CODE ║ ║ FAX PHONE NUMBER ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ Most of the index options/selections require a temporary index: ┌──────────────────────────────────────────────────────────┐ │ Database Name: \DAYOAR\CUSTOMER.DBF │ │ Index Name: TEMPNTX7.NTX │ │ Number of Records: 302 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO Smart Reports, TJS LAB Page: 38 ■ AP ADJUSTMENTS This report prints all Accounts Payable (AP) records that appear to be adjustments. AP adjustments have the following phrase in the COMMENT field: ***GL PAYABLES ADJUSTMENT*** ╔═[ AP Adjustments ]═════════════════════════════════╗ ║ ║ ║ Accounts Payable Adjustments. ║ ║ Multiple Indexes. ║ ║ Not a Report Form. ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ After passing through all the prompts/options for this report, an 'exploding box' progress graph is displayed onto the screen. ╔══════════════════════════════════════════════════════┌────────────────────┐ ║The Accounts Payable Adjustments Report will list │┌──────────────────┐│ ║AP Header records that were created as a result of ││┌────────────────┐││ ║making adjustments to one or more of the following │││┌──────────────┐│││ ║fields: SUBTOTAL, FREIGHT, ADJUST, TAXES, PAID ││││┌────────────┐││││ ║List all Detail for the payable also. │││││┌──────────┐│││││ ║Date ranges supported. Not a Report Form (131 WIDE). ││││││┌────────┐││││││ ║ │││││││┌──────┐│││││││ ║Start Date: 12/01/89 End Date: 11/26/90 ││││││││┌────┐││││││││ ║ │││││││││┌──┐│││││││││ ║Select the Index -> PO NUMBER ││││││││││90││││││││││ ║ │││││││││└──┘│││││││││ ║Enter Number of Lines Per Page: 56 ││││││││└────┘││││││││ ║ │││││││└──────┘│││││││ ║Send Output to Printer? (Y/N) ││││││└────────┘││││││ ║ ( No -> To File) │││││└──────────┘│││││ ║Enter File Name: APADJ.TXT ││││└────────────┘││││ ║ │││└──────────────┘│││ ║TLJ 16 100012 S AF;LSDKFJAS;DFAS ││└────────────────┘││ ╚══════════════════════════════════════════════════════│└──────────────────┘│ └────────────────────┘ ■ BATCH INVENTORY ADJUSTMENTS This is not a report. This routine provides a means of making batch adjustments to the inventory (INV.DBF) quantity (ONHAND). ╔═[ Batch Inventory Adj ]════════════════════════════╗ ║ ║ ║ Batch Inventory Adjustments. ║ ║ Routine to make inventory adjustments easier. ║ ║ No report generated with this routine. ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 39 ■ AR ADJUSTMENTS This report prints all Accounts Receivable Header records that have been closed (OPEN=.T.), and the amount collected does not equal the amount charged. The most common occurance for this is when the customer pays only a portion of an invoice, or receives some kind of discount from you. ╔═[ AR Adjustments ]═════════════════════════════════╗ ║ ║ ║ AR Adjustments. ║ ║ Reports all Closed (OPEN=.F.) AR Invoices where ║ ║ PAID <> SUBTOTAL + ADJUST + FREIGHT + TAXES ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ ╔═══════════════════════════════════════════════════════╗ ║The AR Adjustments Report prints all AR Header records ║ ║that have been closed (OPEN=.F.), and the PAID field ║ ║(amount received from the customer) does not equal the ║ ║sum of SUBTOTAL+ADJUST+TAXES+FREIGHT. ║ ║Uses Report Form: ARADJ.FRM. ║ ║ ║ ║Is this for ALL Customers? (Y/N) ║ ║No -> Specific Customer ║ ║Start Date: 11/28/80 Ending Date: 11/26/90 ║ ║ ║ ║Select Index -> INVOICE NUMBER ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ARADJ.TXT ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 40 ■ SPECIAL SALES REPORT I This is the first of a 3 part set of sales reports. This one prints sales data for a specific customer, sales person, class code, state, ship state, zip, ship zip, shipper, or taxcode. The following information is printed onto the report: INVOICE NUMBER CUSTOMER NUMBER CUSTOMER PO SALES PERSON (REP) INVOICE TYPE CLASS TERMS SHIPPER ADJUSTMENT & FREIGHT TOTAL SUBTOTAL AMOUNT PAID DATE OF INVOICE ╔═[ Special Sales Report I ]═════════════════════════╗ ║ ║ ║ Special Sales Report #1. ║ ║ Reports all sales (Header Info) for a specific ║ ║ CUSTOMER, SALES PERSON, CLASS CODE, STATE, ║ ║ SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE. ║ ║ ║ ╚════════════════════════════════════════════════════╝ Many index options are available, but most require the creation of a temporary index: ╔═══════════════════════════════════════════════════════╗ ║Special Sales Report #1. ║ ║Reports all sales (Header Info) for a specific ║ ║CUSTOMER, SALES PERSON, CLASS CODE, STATE, ║ ║SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE. ║ ║Uses Report Forms: SALES1.FRM to SALES9.FRM. ║ ║ ║ ║Select Option -> CUSTOMER ║ ║ SALES PERSON CODE * Requires Indexing ║ ║ CLASS CODE * Requires Indexing ║ ║ BILL TO STATE * Requires Indexing ║ ║ SHIP TO STATE * Requires Indexing ║ ║ BILL TO ZIP CODE * Requires Indexing ║ ║ SHIP TO ZIP CODE * Requires Indexing ║ ║ SHIPPER CODE * Requires Indexing ║ ║ TAX CODE * Requires Indexing ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 41 Current Data can also be printed is defined as the range between the Start Date and the End Date: ╔═══════════════════════════════════════════════════════╗ ║Special Sales Report #1. ║ ║Reports all sales (Header Info) for a specific ║ ║CUSTOMER, SALES PERSON, CLASS CODE, STATE, ║ ║SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE. ║ ║Uses Report Forms: SALES1.FRM to SALES9.FRM. ║ ║ ║ ║Select Option -> SALES PERSON CODE * Requires Indexing ║ ║ ║ ║Enter Sales Person Code: ║ ║ ║ ║Start Date: 11/28/80 Ending Date: 11/26/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: SALES1.TXT ║ ║ ║ ║Enter Report Title: ACME PARTS SUPPLY, INC. ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ SPECIAL SALES REPORT II This report prints similiar data to the 1st sales report, but with more emphasis on summaries of sales. The following information is reported: CUSTOMER NUMBER CUSTOMER NAME SALES PERSON (REP) CLASS PTD SALES PTD PROFIT PTD MARGIN YTD SALES YTD PROFIT YTD MARGIN CURRENT SALES CURRENT PROFIT CURRENT MARGIN GROWTH RATE *** The Growth Rate is a number between 1 and -1. It depicts the Profit Trend for each customer and the report as a whole. A Growth Rate of around 0 means that profits for a customer are constant. A negative Growth Rate shows a decrease in profits for a customer. A positive Growth Rate shows an increase in profits for a customer. DAYO Smart Reports, TJS LAB Page: 42 ╔═[ Special Sales Report II ]════════════════════════╗ ║ ║ ║ Special Sales Report #2. Similiar to #1, but ║ ║ computes data from the AR detail records ║ ║ instead of the header records. Includes PTD, YTD ║ ║ and Last Year sales/profit/margin information. ║ ║ ║ ╚════════════════════════════════════════════════════╝ A more elaborate date reporting system is defined in this report. The user is prompted to enter the beginning and ending dates of last year, current year and current period: ╔════════════════════════════[ SALES REPORT #2 ]═════════════════════════════╗ ║Special Sales Report #2. ║ ║Reports sales totals for a specific CUSTOMER, SALES PERSON, ║ ║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ║ ║Not a Report Form (150 characters wide!)... ║ ║Select Option -> CLASS CODE * Requires Indexing ║ ║ ║ ║ Start of Last Year: 11/06/88 End of Last Year: 11/06/89 ║ ║Start of Current Year: 11/07/89 End of Current Year: 11/06/90 ║ ║ Start of Period: 10/01/90 End of Period: 10/31/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Smart Reports, TJS LAB Page: 43 A progress graph is displayed to the right of the screen: ╔════════════════════════════[ SALES REPORT #2 ]═════════════════════▄▄▄▄▄▄▄▄▄ ║Special Sales Report #2. ║100%┬──╫ ║Reports sales totals for a specific CUSTOMER, SALES PERSON, ║ . │──║ ║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ║ . │──║ ║Not a Report Form (150 characters wide!)... ║ 83%┼──╫ ║Select Option -> CLASS CODE * Requires Indexing ║ . │──║ ║ ║ . │──║ ║ Start of Last Year: 11/06/88 End of Last Year: 11/06/89 ║ 67%┼──╫ ║Start of Current Year: 11/07/89 End of Current Year: 11/06/90 ║ . │──║ ║ Start of Period: 10/01/90 End of Period: 10/31/90 ║ . │──║ ║Enter Growth Rate Range Factor: 8 ║ 50%┼──╫ ║Send Output to Printer? (Y/N) ( No -> To File) ║ . │──║ ║Enter File Name: SALES2.TXT ║ . │──║ ║Enter Number of Lines Per Page: 50 ║ 33%┼──╫ ║Enter Report Title: ACME SUPPLY COMPANY, INC. ║ . │──║ ║ ║ . │──║ ║Enter CLASS Code: NC1 ║ 17%┼──╫ ║ ║ . │██║ ║ ║ . │██║ ║ ║ 0%┴██╫ ╚════════════════════════════════════════════════════════════════════▀▀▀▀▀▀▀▀▀ ■ SPECIAL SALES REPORT III This report is identical to the 2nd sales report except that it also prints all the detail items/records. Using this report, you can identify exactly what a customer/client has purchased. The additional item information that is reported is: INVOICE NUMBER ITEM DESCRIPTION QTY PRICE COST PROFIT MARGIN CLASS ╔═[ Special Sales Report III ]═══════════════════════╗ ║ ║ ║ Special Sales Report #3. Same as #2, but also ║ ║ prints the detail records. ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 44 You can specify whether you want to print the detail lines for just the current period, current year or for last year through current period: ╔════════════════════════════[ SALES REPORT #3 ]═════════════════════════════╗ ║Special Sales Report #3. Prints every Invoice Detail record! ║ ║Reports sales totals for a specific CUSTOMER, SALES PERSON, ║ ║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ║ ║Not a Report Form (150 characters wide!)... ║ ║Select Option -> CLASS CODE * Requires Indexing ║ ║ ║ ║ Start of Last Year: 11/07/88 End of Last Year: 11/07/89 ║ ║Start of Current Year: 11/08/89 End of Current Year: 12/31/90 ║ ║ Start of Period: 10/01/90 End of Period: 12/31/90 ║ ║Enter Growth Rate Range Factor: 12 ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: SALES3.TXT ║ ║Enter Number of Lines Per Page: 50 ║ ║Enter Report Title: dlksjhflksjdfsd ║ ║Select Option -> Print Detail For Last Year Through Current Period ║ ║ Print Detail For Current Year ║ ║ Print Detail For Current Period ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ CUSTOMER LIST #2 This report is similiar to Customer List #1, except that multiple SHIP TO information is also printed out. ╔═[ Customer List #2 ]═══════════════════════════════╗ ║ ║ ║ Customer List #2 with Ship To Names. ║ ║ List the customer Bill To and Ship To names, ║ ║ and telephone numbers. ║ ║ ║ ╚════════════════════════════════════════════════════╝ Multiple index options are presented: Select the Index -> CUSTOMER BILL TO NAME SHIP TO NAME LAST 4 DIGITS PHONE BILL TO ZIP CODE ATTENTION/CONTACT BILL TO CITY SHIP TO ZIP CODE SALES PERSON CODE DAYO Smart Reports, TJS LAB Page: 45 A progress graph depicting colored boxes is displayed onto the screen: ┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐ │10%││20%││30%││40%││50%││60%││70%││80%││90%││100│ └───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘ ■ EXAMPLE OF THE CUSTOMER LIST #2 ACME PARTS SUPPLY, INC. Page: 1 Customer List #2 (with Ship Tos) Date: 11/26/90 ^^ Default Ship To ^ Multiple Ship To Customer Name Phone -------- ------------------------------ -------------- -------------------- 2293 C & S Novelties 237-5555 2311 Rosedale Dataline 2313 Sherman Designs (302) 558-5555 2361 Software Support Customer 2362 The Programmer's Shop (637) 740-5555 2413 New England Comics (502) 583-5555 2457 Gertrude A. Ford 546-6327 2501 Roger Gay 2595 Bradford Board of Education 2624 SDN Project 2643 GAF Tel-Com 2644 Alan Harrison (803) 555-5555 2757 Electric Indicator Co., Inc. (803) 847-5555 2766 Rothrist Tube, Inc. (801) 670-4257 2775 Assc For Retarded Citizens 2780 Pinkstone & Marquez Inc. (904) 869-0100 2783 Atul Mitra (913) 469-2131 28011 Larry Thompson (407) 291-6987 2801^^ Larry Thompson #2 (407) 291-6987 2801^ Larry Thompson #3 (Martin) (407) 291-3960 2801^ Larry Thompson #4 (407) 291-3960 2801^ Larry Thompson #5 (Jose) (407) 291-3960 2801^ Larry Thompson #6 (Juan) (407) 291-3960 2801^ Larry Thompson #7 (Jesus) (407) 291-3960 2801^ Larry Thompson #8 (Mary) (407) 291-3960 2801^ Larry Thompson #9 (407) 291-3960 2801^ Larry Thompson #10 (407) 291-3960 2801^ Larry Thompson #11 (407) 291-3960 2801^ Larry Thompson #12 (Sal) (407) 291-3960 2801^ Larry Thompson #13 (407) 291-3960 2801^ Larry Thompson #14 (Joe) (407) 291-3960 2801^ Larry Thompson #15 (Debbie) (407) 291-3960 2919 Stereo Exchange, Inc. 2922 James J. Spinelli (804) 793-5555 2931 Vitron Management Consult. Inc (313) 793-5555 2979 Remee Products 2982 Home & City Savings Bank (802) 479-5555 3001 Computer Directions, Inc. (213) 834-5555 3023 Rick Guggemos 3048 Carolina Color Corporation 3317 Air Filter Service (803) 555-9321 DAYO Smart Reports, TJS LAB Page: 46 ■ INSERT DECIMALS This is not a report. This routine globally modifies the structure for all quantity fields (ie: ONHAND, PTDSOLD, ORDERED, RECEIVED) in the following databases: INV.DBF, ALLOCATE.DBF, APD.DBF, ARD.DBF, BO.DBF, BOM.DBF, DETAIL.DBF, ENDITEMS.DBF, INVADJ.DBF, PHYINV.DBF, POD.DBF, QUOTESD.DBF, REC.DBF, TEMPLATE.DBF, and WAREHOUS.DBF. ╔═[ Insert Decimals ]════════════════════════════════╗ ║ ║ ║ Insert Decimals into all databases with a ║ ║ quantity field, ie: ONHAND in inventory... ║ ║ This routine does not print anything! ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ The progress of the operation is scrolled onto the lower part of the screen: ╔════════════════════════════════[ DECIMALS ]════════════════════════════════╗ ║This routine will insert decimals in the quantity/onhand fields in all ║ ║DAYO databases that have item quantity fields, ie: inventory, invoices, ║ ║purchase orders, MRP, backorders, quotes, receipts, ... ║ ║Check the database location options in the Configuration Menu to insure ║ ║their accuracy. ║ ║REQUIRES EXCLUSIVE USE OF THE DATABASES! * DO A FULL BACKUP FIRST! * ║ ║IF ON A NETWORK, INSURE THAT NO ONE IS IN THE SYSTEM! ║ ║USE WITH CAUTION! ║ ║Decimals for the ONHAND field in the inventory is currently set to 2 ║ ║Enter Number of Decimals: 2 ║ ║ ║ ║Are you sure you want to continue? (Y/N) ║ ║ ║ ║Last chance to abort! Are you really sure? (Y/N) ║ ║ DATABASE FIELD TYPE LENGTH DECIMALS ║ ║ INV BO N 10 2 ║ ║ INV ONORDER N 10 2 ║ ║ INV UNITQTY N 10 2 ║ ║ INV ALLOCATED N 10 2 ║ ║ INV SOLDPTD N 10 2 ║ ╚════════════════════════════════════════════════════════════════════════════╝ *** Do Not Disturb Me While I Reconstruct The Databases! *** DAYO Smart Reports, TJS LAB Page: 47 ■ WAREHOUSE REORDER This report does require a report form, and will automatically determine and report any number of warehouses. Note, the width of the report increases by 7 spaces for each additional warehouse. The report is 132 characters wide with 10 (3 more than the default of 7) warehouses. ╔═[ Warehouse Reorder ]══════════════════════════════╗ ║ ║ ║ Warehouse Reorder Report. ║ ║ Reports only the reorder quantity for warehouses ║ ║ and the main warehouse (ONHAND). ║ ║ ║ ╚════════════════════════════════════════════════════╝ You have the option of printing only those items that require some kind of reorder, or all: ╔══[ Warehouse Reorder ]═════════════════════════════╗ ║■Print ONLY items requiring reorder? (Y/N) ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ( No -> To File) ║ ║ Enter File Name: REWARE.TXT ║ ╚════════════════════════════════════════════════════╝ A progress graph is displayed on to screen: ╔══════════════════════╗ ║ ┌──────────────┐ ║ ║ │ │ ║ ║ │ │ ║ ║ │██████████████│ ║ ║ │██████████████│ ║ ║ │██████████████│ ║ ║ └─────╖ ╓─────┘ ║ ║ ║██║ ║ ║ ║ ║ ║ ║ ┌─────╜██╙─────┐ ║ ║ │100% │ ║ ║ │80% ██ │ ║ ║ │60% │ ║ ║ │██████████████│ ║ ║ │██████████████│ ║ ║ ╔╧══════════════╧╗ ║ ║ ║ PROGRESS GLASS ║ ║ ║ ═╩════════════════╩═ ║ ╚══════════════════════╝ DAYO Smart Reports, TJS LAB Page: 48 ■ SERIAL NUMBERS IN This report prints records from the database SERIALIN.DBF, found in the DAYO Inventory directory. This report will print serial numbers that were recorded when the items were received into the inventory. ╔═[ Serial Numbers In ]══════════════════════════════╗ ║ ║ ║ Serial Numbers In Report. ║ ║ Reports records of serial numbers recorded at time ║ ║ of receipt into the inventory. ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ You can specify a 'range' of serial number records to print, or all: ╔═════════════════════════════════════════════════════════════════╗ ║ This report will print serial numbers that were recorded ║ ║ when the items were received into the inventory. ║ ║ ║ ║ Select Option -> Specific Purchase Order Number ║ ║ Specific ITEM Number ║ ║ Specific CONTROL Number ║ ║ Specific VENDOR Number ║ ║ Specific Serial Number ║ ║ From/To Dates ║ ║ All ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO Smart Reports, TJS LAB Page: 49 ■ EXAMPLE OF THE SERIAL NUMBER IN REPORT Page No. 1 Specific Control Number: ABC Indexed on Control Number 11/26/90 SERIAL NUMBER IN SERIAL NUMBER ITEM PO KEY CONTROL VENDOR DATE --------------- ------------ ------ ------ ---------- ---------- -------- 123A56-10775 286CPU-1 233 2931 TJ-3990 TJS LAB 03/02/90 1234A6-10797 286CPU-1 323 2941 TJ-3990 TJS LAB 03/18/90 1234D6-10343 286CPU-3 344 3121 TJ-3990 TJS LAB 03/13/90 1234D6-14044 286CPU-1 383 3245 TJ-3990 TJS LAB 04/17/90 1234F6-10425 286CPU-4 387 3323 TJ-3990 TJS LAB 06/04/90 123436-10253 286CPU-1 394 3444 TJ-3990 TJS LAB 06/10/90 123436-12342 286CPU-3 397 3534 TJ-3990 TJS LAB 08/31/90 1234D6-103SG 286CPU-3 411 3604 TJ-3990 TJS LAB 09/02/90 1234R6-10333 286CPU-3 433 3755 TJ-3990 TJS LAB 10/11/90 123436-10222 286CPU-1 458 3800 TJ-3990 TJS LAB 11/21/90 ■ SERIAL NUMBERS OUT This report will print serial numbers that were recorded when the items were invoiced using DAYO Point of Sale (POS). ╔═[ Serial Numbers Out ]═════════════════════════════╗ ║ ║ ║ Serial Numbers Out Report. ║ ║ Reports records of serial numbers recorded at time ║ ║ of invoicing (in POS). ║ ║ ║ ╚════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE SERIAL NUMBER OUT REPORT Page No. 4 Print All Records Indexed on Serial Number 11/26/90 SERIAL NUMBERS OUT (POS) SERIAL NUMBER ITEM INVOICE CUSTOMER DATE --------------- ------------ ------- -------- -------- 12345-1292 PRINTER #3 205 6223 09/04/90 A2 242-2 42 PRINTER #4 225 3002 10/11/90 A2 3223-3 23 A2 213-23 2 TS-393 ALLL143 261 1100 11/13/90 TS-38 ALLL143 259 2999 11/14/90 TS-393 ALLL143 259 2999 11/16/90 TS-89 ALLL143 259 2999 11/21/90 TS-392A ALLL143 259 2999 11/22/90 TOM#9301 TOM TOM 244 4100 11/23/90 12345-12345 AC2334 245 4340 11/26/90 DAYO Smart Reports, TJS LAB Page: 50 ■ BAD RECORDS This report was created to provide a means for users to find and fix Bad records. Bad records created when bad data is placed in one or more fields of a record. A leading cause of this is the rebooting of the machine while it is writing or updating a database. ╔═[ Bad Records ]════════════════════════════════════╗ ║ ║ ║ Find & Fix Bad Records. ║ ║ * Requires Exclusive Use of Databases * ║ ║ * Dangerous Operation - Backup First! * ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ The progress of this operation is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Checking: \DAYOPOS\DETAIL.DBF ║ ╚════════════════════════════════════════════════════════════════════════════╝ ╔════════════════════════════════════════════════════════════════════════════╗ ║ ■ Standby while I check out: \DAYOPOS\DETAIL.DBF ║ ║ Checking record: 597 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 51 ■ RESET ALLOCATED This routine will reset the field 'ALLOCATED' in the inventory database (INV.DBF) to zero (0), then recompute the allocated quantity by counting up the number of items currently on open work orders (invoices not printed). The progress of the process is displayed onto the graph in the form of an hour glass. DAYORPT V3.0, TJS LAB ┌───[January 1991]───┐ ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ │S M T W T F S │ ╔═════█┌──────────────┐█═╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ║Inser█│ │█ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│ ║Inser█│ │█ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│ ║Wareh█│██████████████│█ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│ ║Seria█│██████████████│█ ║ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│ ║Seria█│██████████████│█ ║ ████▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │ ║Bad R█└─────╖ ╓─────┘█ ║ │ │ ║Reset▀▀▀▀▀▀█║ ║█▀▀▀▀▀▀ ║ └────────────────────┘ ║Reset▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ ╠═[ Reset Allocated ]═══════════════════════════════╗ ║Set/R█┌─────╜ ╙─────┐█ ║ ║ ║Repor█│100% │█ ║ Reset the ALLOCATED field in the inventory ║ ║Print█│80% │█ ║ database (INV.DBF) based on open work orders ║ ║Misc █│60% │█ ║ and back orders. ║ ╠═════█│██████████████│█═╣ ║ ║ Pre█│██████████████│█ ║ ║ ╚═════█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█═╩═══════════════════════════════════════════════════╝ ▄███ PROGRESS GLASS █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ █░▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ █░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░ ▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ Recomputing ALLOCATED from Work Orders... Esc (Abort) DAYO Smart Reports, TJS LAB Page: 52 ■ RESET BO - BACK ORDER QUANTITY This routine will reset the field 'BO' in the inventory database (INV.DBF) to zero (0), then recompute the BO quantity by counting up the number of items currently on open invoices in the Back Order database (BO.DBF). The progress of the process is displayed onto the graph in the form of an hour glass. DAYORPT V3.0, TJS LAB ┌───[January 1991]───┐ ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ │S M T W T F S │ ╔═════█┌──────────────┐█═╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ║Inser█│ │█ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│ ║Inser█│ │█ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│ ║Wareh█│ │█ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│ ║Seria█│██████████████│█ ║ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│ ║Seria█│██████████████│█ ║ ████▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │ ║Bad R█└─────╖ ╓─────┘█ ║ │ │ ║Reset▀▀▀▀▀▀█║ ║█▀▀▀▀▀▀ ║ └────────────────────┘ ║Reset▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ ╠═[ Reset BO ]══════════════════════════════════════╗ ║Set/R█┌─────╜ ╙─────┐█ ║ ║ ║Repor█│100% │█ ║ Reset the BO field in the inventory ║ ║Print█│80% │█ ║ database (INV.DBF) based on the number of ║ ║Misc █│██████████████│█ ║ open back orders in database: BO.DBF. ║ ╠═════█│██████████████│█═╣ ║ ║ Pre█│██████████████│█ ║ ║ ╚═════█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█═╩═══════════════════════════════════════════════════╝ ▄███ PROGRESS GLASS █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ █░▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ █░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░ ▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ Resetting BO to Zero (0)... Esc (Abort) DAYO Smart Reports, TJS LAB Page: 53 ■ SET MULTIPLE PRICE FIELDS IN INVENTORY Use this routine to determine and set the multiple price fields 'PRICE1 to PRICE5' based on a List (Retail Price) discount or on a cost plus (Margin) method. Note, the 5 price fields must exist in the inventory database (INV.DBF), and if not, use the DAYO Update & Conversion program to place them there. ╔═════════════════[ SET MULTIPLE PRICE FIELDS IN INVENTORY ]════════════════╗ ║ ║ ║This routine will reset the mulitple price fields: PRICE1, PRICE2, PRICE3, ║ ║PRICE4, PRICE5, based on a margin or list (RETAIL) discount method. ║ ║ ║ ║ ║ ║ Field (M)argin ║ ║ Name (L)ist Discount ║ ║ PRICE1 M 50.000 ║ ║ PRICE2 M 40.000 ║ ║ PRICE3 M 30.000 ║ ║ PRICE4 M 20.000 ║ ║ PRICE5 M 10.000 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Smart Reports, TJS LAB Page: 54 ■ MULTIPLE PRICING PROGRESS GRAPH The progress of the Multiple Price update is displayed onto the screen with an hour glass and a scroll of the items. ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ ╔════█┌──────────────┐█ MULTIPLE PRICE FIELDS IN INVENTORY ]════════════════╗ ║ █│ │█ ║ ║This█│ │█t the mulitple price fields: PRICE1, PRICE2, PRICE3, ║ ║PRIC█│██████████████│█on a margin or list (RETAIL) discount method. ║ ║ █│██████████████│█ ║ ║ █│██████████████│█ ║ ║ █└─────╖ ╓─────┘█ Field (M)argin ║ ║ ▀▀▀▀▀▀█║ ║█▀▀▀▀▀▀ Name (L)ist Discount ║ ║ ▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ PRICE1 M 50.000 ║ ║ █┌─────╜ ╙─────┐█ PRICE2 M 40.000 ║ ║ █│100% │█ PRICE3 M 30.000 ║ ║ █│80% │█ PRICE4 M 20.000 ║ ║ █│60% │█ PRICE5 M 10.000 ║ ║ █│██████████████│█ ║ ║ █│██████████████│█ Item PRICE1 PRICE5 ║ ║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ APSBH-1 30.99 17.22 ║ ║ █ PROGRESS GLASS █ YKEL245 28.92 16.07 ║ ║ ▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ YKEL145 26.86 14.92 ║ ║ YK90086 24.79 13.77 ║ ║ J234324 22.73 12.63 ║ ║ I354534 20.66 11.48 ║ ╚═══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Smart Reports, TJS LAB Page: 55 ■ MODIFY SCREEN COLORS This routine provides you with a means of modifying or altering any color combination in any of the DAYO modules. No Report is printed... This routine optionally creates a color file (database) in a DAYO module directory named COLORSET.DAT. When a DAYO module starts up, it looks for this file in its current directory, and if found uses the color settings in this file instead of the default colors. Erase it if you want to return to the default colors! ╔═[ Modify Screen Colors ]═══════════════════════════╗ ║ ║ ║ Modify Screen Colors in Any DAYO Module. ║ ║ Use this routine to alter the colors in any ║ ║ DAYO Module. ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ ■ COLOR CHART The following is the initial screen for this option: ╔════════════════╦════════╦═══════════════════╦═════════════════════════════╗ ║ Color ║ Letter ║ Monochrome ║ * Creates a blinking effect ║ ╠════════════════╬════════╬═══════════════════╬═════════════════════════════╝ ║ Black ║ N ║ Black ║ ▄███░ ▄██▄ █░ ▄██▄ █▄██░ ║ Blue ║ B ║ Underline ║ █░ █░ █░ █░ █░ █░ █░ █░ ║ Green ║ G ║ White ║ █░ █░ █░ █░ █░ █░ ████░ ║ Cyan ║ BG ║ White ║ █░ █░ █░ █░ █░ █░ █░█░ ║ Red ║ R ║ White ║ ▀███░ ▀██▀ ████░ ▀██▀ █░██░ ║ Magenta ║ RB ║ White ║ ║ Brown ║ GR ║ White ║ █████░ █░ █▄██░ █░ ███░ ║ White ║ W ║ White ║ █░ █▀█░ █░ █░ █░ █░ ║ Gray ║ N+ ║ White ║ █░ █░█░ █▀▀█░ █░ ██░ ║ Bright Blue ║ B+ ║ Bright Underline ║ █░ ██▄██░ █░ █░ █░ █░ ║ Bright Green ║ G+ ║ Bright White ║ █░ █░ █░ █▀██░ ████░ ███░ ║ Bright Cyan ║ BG+ ║ Bright White ║ ║ Bright Red ║ R+ ║ Bright White ║ This routine allows you to ║ Bright Magenta ║ RB+ ║ Bright White ║ modify/alter the screen ║ Yellow ║ GR+ ║ Bright White ║ colors for any DAYO module. ║ Bright White ║ W+ ║ Bright White ║ Read a dBase (tm) or Clipper ║ Black ║ U ║ Underline ║ (tm) manual for more ║ Inverse Video ║ I ║ Inverse Video ║ information on screen color ║ Blank ║ X ║ Blank ║ codes... ╚════════════════╩════════╩═══════════════════╝ Press any key to continue... DAYO Smart Reports, TJS LAB Page: 56 Select the module you wish to install or modify colors in: ╔══════════════════════════[ MODIFY SCREEN COLORS ]══════════════════════════╗ ║ Select Module -> DAYO Menu ║ ║ █▄██ Inventory, Purchasing, Receiving █▄██ ║ ║ █ █ POS, Point of Sale █ █ ║ ║ █ █ Time & Billing █ █ ║ ║ █▀██ AR, Accounts Receivable █▀██ ║ ║ AP, Accounts Payable ║ ║ █ GL, General Ledger █ ║ ║ █▀█ Look Up DAYO Databases █▀█ ║ ║ ██▄██ Payroll ██▄██ ║ ║ █ █ Quotes █ █ ║ ║ Back Orders ║ ║ █ █ MRP, Materials Requirement Planning █ █ ║ ║ ▀█▄█▀ Price Books, Lists ▀█▄█▀ ║ ║ █ Bar Codes █ ║ ║ █ Index █ ║ ║ End of Period, Physical Inventory ║ ║ ▄██▄ Smart Reports ▄██▄ ║ ║ █ █ Passwords █ █ ║ ║ █ █ Graphic Reports █ █ ║ ║ ▀██▀ Sales Contacts ▀██▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter/Return (Select) The following message is displayed onto the screen if colors are to modified for the first time in a particular module: ╔══════════════════════════════════════════════════════════════════════════╗ ║ Color File Not Installed In: DAYO Menu ║ ║ ║ ║ Install? (Y/N) ║ ╚══════════════════════════════════════════════════════════════════════════╝ If you responded 'Y' Yes to the install prompt, you will then be prompted to enter the location of the selected DAYO module: ╔══════════════════════════════════════════════════════════════════════════╗ ║ Color File Not Installed In: DAYO Menu ║ ║ (ie: C:\DAYOPOS\) ║ ║ Enter Drive/Directory/Location: \DAYO\ ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 57 Finally, you will be presented with an edit screen of the 18 color code combinations: ╔══════════════════════════[ MODIFY SCREEN COLORS ]══════════════════════════╗ ║ ║ ║ #1 Red: R+/n,n/W,n/w,,n/w █▄██ ║ ║ #2 White: W+/n,n/w,n/w,,n/w █ █ ║ ║ #3 White on Red: W+/R,n/w,n/w,,n/w █ █ ║ ║ #4 Black on Red: RG+/R,n/w,n/w,,n/w █▀██ ║ ║ #5 White on Blue: W+/B,n/w,n/w,,n/w ║ ║ #6 Blinking White on Red: W+*/R,n/w,n/w,,n/w █ ║ ║ #7 Blinking White on Blue: W+*/B,n/w,n/w,,n/w █▀█ ║ ║ #8 Blue: B+/n,n/w,n/w,,n/w ██▄██ ║ ║ #9 Cyan: BG/N,n/w,n/w,,n/w █ █ ║ ║ #10 Green: G/n,n/w,n/w,,n/w ║ ║ #11 Magenta: BR+/n,n/w,n/w,,n/w █ █ ║ ║ #12 Yellow: RG+/n,n/w,n/w,,n/w ▀█▄█▀ ║ ║ #13 Blinking Cyan: BG/N,n/w,n/w,,n/w █ ║ ║ #14 Blinking Red: R+*/n,n/w,n/w,,n/w █ ║ ║ #15 Blinking Green: G+*/n,n/w,n/w,,n/w ║ ║ #16 Blinking White: W+*/n,n/w,n/w,,n/w ▄██▄ ║ ║ #17 Blinking Yellow: RG+*/n,n/w,n/w,,n/w █ █ ║ ║ #18 Blinking Magenta: BR+*/n,n/w,n/w,,n/w █ █ ║ ║ ▀██▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Colors Settings: STANDARD,ENHANCED,BORDER ie: W+/N,N/W,W/N Standard Main Screen Output Enhanced Prompts and Selection Highlights Border Border (Not on EGA & VGA Monitors...) Each of the above colors settings consists of 2 parts; the foreground and the background. The foreground and background is separated by a forward slash (/). The main colors are separated by a comma, ie: W+/N,N/W,W/N Foreground color settings can also have high intensity or blinking attributes. Add a plus sign '+' for high intensity; an asterisk '*' for blinking. High Intensity Example: W+/N Blinking Example: W*/N Blinking, High Intensity Example: W+*/N DAYO Smart Reports, TJS LAB Page: 58 ■ ITEM TRACKER This is perhaps one of the 'smartest' Smart Reports. Use this report to tracking Item movement within your company for a selected date range. 'Everything' about an Item is printed out from Inventory Adjustments (INVADJ.DBF), Receipts (REC.DBF) and Sales (ARD.DBF). The ONHAND quantity in the inventory database (INV.DBF), ONHAND quantity in the last inventory database (LASTINV.DBF) and the sum of the counted Items in the physical inventory is also printed. At the end of the report, the physical and last inventory databases are checked to see if they contain items not found in the inventory database. * Note, to insure proper sales reporting, be sure to perform the AR Post. This routine 'moves' closed/printed invoices into AR from DAYO POS. ╔═[ ITEM TRACKER ]═══════════════════════════════════╗ ║ ║ ║ Complete Period Item Summary - ITEM TRACKER. ║ ║ Print out start/end inventory quantity, receipts, ║ ║ sales, and inventory adjustments (by item). ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ This report may take 'quite a while' to run due to the large number of files and records it has to go through... DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐ ╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗ ║ ║ ║ This report prints out the starting and ending quantities for every item ║ ║ (from your current and physical inventory), receipts, sales (from posted ║ ║ invoices in AR), Work in Process (from MRP) and inventory adjustments. ║ ║ ║ ║ Use this report to track/determine 'variances' in the physical inventory. ║ ║ ║ ║ This report may take 'quite a while' to run due to the large number of ║ ║ files and records it has to go through... ║ ║ ║ ║ Enter Starting Date: 01/05/90 Ending Date: 02/04/91 ║ ║ ║ ║ ║ ║ ║ ║ ████████░ ██▄███░ ███░ ▄████░ ██░ ██░ █████░ ██▄███░ ║ ║ ██░ ██░ ██░ ██▀██░ ██░ ██░▄██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ║ ║ ██░ ██████░ ██░██░ ██░ ████░ ████░ ██████░ ║ ║ ██░ ██░██░ ██▄██░ ██░ ██░██░ ██░ ██░██░ ║ ║ ██░ ██░███░ ██▀ ▀██░ ██░ ██░▀██░ ██░ ██░▀██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ▀████░ ██░ ██░ █████░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 59 Options for this report include the start/end dates, track all or a specific item, specify the Physical Inventory or Last Inventory database file, number of lines per page and to direct output to printer or file. DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐ ╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗ ║ Enter Starting Date: 01/05/90 Ending Date: 02/04/91 ║ ║ ║ ║ Track ALL Items! ║ ║ ║ ║ Print all transactions for item? (Y/N) ║ ║ ║ ║ Physical Inventory Database: \DAYOEOP\PHYINV.DBF ║ ║ ║ ║ Last Inventory Database: \DAYOEOP\LASTINV.DBF ║ ║ ║ ║ Enter number of lines per page: 55 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: TRAC0291.TXT ║ ║ ████████░ ██▄███░ ███░ ▄████░ ██░ ██░ █████░ ██▄███░ ║ ║ ██░ ██░ ██░ ██▀██░ ██░ ██░▄██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ║ ║ ██░ ██████░ ██░██░ ██░ ████░ ████░ ██████░ ║ ║ ██░ ██░██░ ██▄██░ ██░ ██░██░ ██░ ██░██░ ║ ║ ██░ ██░███░ ██▀ ▀██░ ██░ ██░▀██░ ██░ ██░▀██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ▀████░ ██░ ██░ █████░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 60 The progress of this report is scrolled onto the screen for the 1st pass through the inventory database (INV.DBF). After reporting all items in the inventory database, the physical inventory and last inventory databases are checked for items not in the inventory database. DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐ ╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗ ║ ████████░ ██▄███░ ███░ ▄████░ ██░ ██░ █████░ ██▄███░ ║ ║ ██░ ██░ ██░ ██▀██░ ██░ ██░▄██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ║ ║ ██░ ██████░ ██░██░ ██░ ████░ ████░ ██████░ ║ ║ ██░ ██░██░ ██▄██░ ██░ ██░██░ ██░ ██░██░ ║ ║ ██░ ██░███░ ██▀ ▀██░ ██░ ██░▀██░ ██░ ██░▀██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ▀████░ ██░ ██░ █████░ ██░ ██░ ║ ║ Item Description Current Physical LastINV║ ║ A800470 T/A 16 X 25 X 2 501.49 4900 501.49║ ║ A800460 T/A 16 X 20 X 2 767.58 12300 491.25║ ║ A800460 T/A 16 X 20 X 2 491.25 12300 491.25║ ║ A800390 T/A 24 X 30 X 1 337.74 3300 337.74║ ║ A800070 T/A 10 X 20 X 1 777.81 7600 0.00║ ║ A800040 T/A 20 X 25 X 1 450.31 4400 450.31║ ║ A800030 T/A 20 X 20 X 1 798.28 7800 0.00║ ║ A200695 6-85D36 20X20X36 828.99 8100 0.00║ ║ A200122 AP-15 20 X 25 X 2 685.70 6700 685.70║ ║ A200041 AP-11 16 X 20 X 2 532.19 5200 532.19║ ║ A100230 30/30 18 X 24 X 2 788.05 7700 0.00║ ║ A100130 30/30 24 X 24 X 2 347.97 3400 347.97║ ║ A100110 30/30 20 X 25 X 2 757.35 7400 0.00║ ╚════════════════════════════════════════════════════════════════════════════╝ Record: 30/ 138 Esc (Exit/Abort) DAYO Smart Reports, TJS LAB Page: 61 ■ AR DISCREPANCIES This reports invoices (receivables), that may have a error in the SUBTOTAL as compared to the sum of the detail. Note, some receivables may not have any detail... ╔═[ AR Discrepancies ]═══════════════════════════════╗ ║ ║ ║ AR Detail/Subtotal Discrepancy Report. ║ ║ Prints out receivables that have a SUBTOTAL not ║ ║ equal to the sum of the line items. ║ ║ Use to display/debug manual AR adjustments. ║ ║ ║ ╚════════════════════════════════════════════════════╝ Options include a start & end date and to direct the output to printer or file. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║ ║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║ ║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║ ║ ██▄██░█░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║ ║ █░ █░█░██░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report will print out invoice and customer information for any ║ ║ receivable which has a SUBTOTAL value not equal to the sum of its detail ║ ║ line items. This happens when the SUBTOTAL is adjusted after the record ║ ║ is posted into the AR database (ARH.DBF) ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║Enter Start Date: 04/20/91 End Date: 05/20/91 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ARBUG.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Smart Reports, TJS LAB Page: 62 The progress of the report is scrolled upon the screen. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║ ║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║ ║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║ ║ ██▄██░█░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║ ║ █░ █░█░██░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report will print out invoice and customer information for any ║ ║ receivable which has a SUBTOTAL value not equal to the sum of its detail ║ ║ line items. This happens when the SUBTOTAL is adjusted after the record ║ ║ is posted into the AR database (ARH.DBF) ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Invoice Customer Ship To Name ADJUSTMENT ║ ║ 100020 35111 ESHLEY ALUMINUM,INC. 348.33 ║ ║ 100019 32504 ESHE INDUSTRIES,INC. 64.88 ║ ║ 100018 23507 ERMSTRONG ALUMINUM 2.48 ║ ║ 100017 53296 EMERICAN LIFESTYLE, INC. 34.66 ║ ║ 100016 23579 ELUMINUM SPECIALTIES 88.55 ║ ║ 100015 52779 ELUMINUM SPECIALTIES .77 ║ ║ 100014 15359 ELUMINUM SPECIALTIES 252.55 ║ ║ 100013 15379 ELUMINUM SPECIALTIES 316.49 ║ ║ 100012 51351 ELUMINUM ACCENTS 327.44 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, Printing Report! Esc (Abort/Exit) ■ EXAMPLE OF AR BUG REPORT ACCOUNTS RECEIVABLE DISCREPANCIES Page 1 From 04/20/91 to 05/20/91 Date 05/20/91 CD Codes: O -> Open C -> Closed D -> Deleted/Voided Invoice Customer Ship To Name SUBTOTAL DETAIL ADJUSTMENT CD ------- -------- ------------------------- ---------- ---------- ---------- -- 100002 7999 ALL SCREEN SERVICE 1.00 1.50 .50 O 100003 7999 ALL SCREEN SERVICE 2.00 2.50 .50 O 100004 7999 ALL SCREEN SERVICE 3.00 2.50 -.50 O ------- -------- ------------------------- ---------- ---------- ---------- -- *** Totals *** 6.00 6.50 .50 DAYO Smart Reports, TJS LAB Page: 63 ■ AP DISCREPANCIES Use this report to find discrepancies in your payables. It reports any payables with a SUBTOTAL not equal to the sum of the detail. Note, many payables may not have any detail records. ╔═[ AP Discrepancies ]═══════════════════════════════╗ ║ ║ ║ AP Detail/Subtotal Discrepancy Report. ║ ║ Prints out payables that have a SUBTOTAL not equal ║ ║ to the sum of the line items. ║ ║ Use to display/debug manual AP adjustments. ║ ║ ║ ╚════════════════════════════════════════════════════╝ Options include a start & end date and to direct the output to printer or file. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║ ║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║ ║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║ ║ ██▄██░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║ ║ █░ █░█░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report will print out invoice and PO information for any payable ║ ║ which has a SUBTOTAL value not equal to the sum of its detail line items. ║ ║ This happens when the SUBTOTAL is adjusted after the record is posted into ║ ║ the AP database (APH.DBF) ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║Enter Start Date: 04/20/91 End Date: 05/20/91 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: APBUG.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Smart Reports, TJS LAB Page: 64 The progress of the report is scrolled upon the screen. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║ ║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║ ║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║ ║ ██▄██░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║ ║ █░ █░█░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report will print out invoice and PO information for any payable ║ ║ which has a SUBTOTAL value not equal to the sum of its detail line items. ║ ║ This happens when the SUBTOTAL is adjusted after the record is posted into ║ ║ the AP database (APH.DBF) ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Journal PO Vendor Name ADJUSTMENT ║ ║ 16 70007 SOUTH DISTRIBUTORS 337.84 ║ ║ 15 70007 SOUTH DISTRIBUTORS 485.82 ║ ║ 14 70007 SOUTH DISTRIBUTORS 68.70 ║ ║ 13 70007 SOUTH DISTRIBUTORS 485.57 ║ ║ 12 70007 SOUTH DISTRIBUTORS 668.60 ║ ║ 11 70007 SOUTH DISTRIBUTORS 056.05 ║ ║ 10 70007 SOUTH DISTRIBUTORS 470.71 ║ ║ 9 70005 SOUTH DISTRIBUTORS 30.10 ║ ║ 0 70006 SOUTH DISTRIBUTORS 50.26 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, Printing Report! Esc (Abort/Exit) ■ EXAMPLE OF AP BUG REPORT ACCOUNTS PAYABLE DISCREPANCIES Page 1 From 04/20/91 to 05/20/91 Date 05/20/91 CD Codes: O -> Open C -> Closed D -> Deleted/Voided Journal PO Name SUBTOTAL DETAIL ADJUSTMENT CD ------- -------- ------------------------- ---------- ---------- ---------- -- 2 1001 GEORGE MOONILAL 100.00 77.00 23.00 O 3 1001 GEORGE MOONILAL 200.00 180.00 20.00 C 4 1001 SOUTH DISTRIBUTORS 300.00 306.00 -6.00 O ------- -------- ------------------------- ---------- ---------- ---------- -- *** Totals *** 600.00 563.00 37.00 DAYO Smart Reports, TJS LAB Page: 65 ■ RENTAL REPORT, RENTALS OUT This report is tied to the DAYO RENTAL POS module. It specifically reports only invoice TYPE: 'REN'. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░ ███░ █░ █░ █████░ █░ █░ █▄██░ ███░ █▄██░ ▄██▄ █▄██░ █████░ ║ ║ █░ █░ █░ ██░█░ █░ █▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ ████░ ██░ ████░ █░ █░█░ █░ ████░ ██░ █▀██░ █░ █░ ████░ █░ ║ ║ █░█░ █░ █░██░ █░ █████░ █░ █░█░ █░ █░ █░ █░ █░█░ █░ ║ ║ █░██░ ███░ █░ █░ █░ █░ █░ ███░ █░██░ ███░ █░ ▀██▀ █░██░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report prints out invoices (from the database: INVOICE.DBF) with the ║ ║ type of 'REN'. The option to print only those that are late and/or past ║ ║ due is given. You also have the option to print 'Header' information ║ ║ with 'Detail' information, or just the 'Detail' information. ║ ║ ║ ║ Select Report Option -> Rental Header with Detail - Late Only ║ ║ Rental Header with Detail - All Open ║ ║ Rental Detail - Late Only ║ ║ Rental Detail - All Open ║ ║ Exit ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Many options exists, ie: index, number of lines per page, and direct output to printer or disk file. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░ ███░ █░ █░ █████░ █░ █░ █▄██░ ███░ █▄██░ ▄██▄ █▄██░ █████░ ║ ║ █░ █░ █░ ██░█░ █░ █▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ ████░ ██░ ████░ █░ █░█░ █░ ████░ ██░ █▀██░ █░ █░ ████░ █░ ║ ║ █░█░ █░ █░██░ █░ █████░ █░ █░█░ █░ █░ █░ █░ █░█░ █░ ║ ║ █░██░ ███░ █░ █░ █░ █░ █░ ███░ █░██░ ███░ █░ ▀██▀ █░██░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report prints out invoices (from the database: INVOICE.DBF) with the ║ ║ type of 'REN'. The option to print only those that are late and/or past ║ ║ due is given. You also have the option to print 'Header' information ║ ║ with 'Detail' information, or just the 'Detail' information. ║ ║ ║ ║ Select Report Option -> Rental Header with Detail - Late Only ║ ║ ║ ║ Select Index -> Invoice Number ║ ║ ║ ║ Enter Number of Lines Per Page: 55 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: RENTAL.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO Smart Reports, TJS LAB Page: 66 ■ CHANGE ITEM NUMBER This routine makes changing an item number(s) easier. Use this option to change item numbers in batch, or in the inventory AND the current invoice detail database (DETAIL.DBF). Note, it is not recommended that item numbers be changed... ╔═[ Change ITEM Number ]═════════════════════════════╗ ║ ║ ║ Change Item Number. Use this option to change ║ ║ existing Item Numbers in the Inventory (INV.DBF), ║ ║ and (optionally), the Invoice Detail database ║ ║ (DETAIL.DBF). ║ ║ ║ ╚════════════════════════════════════════════════════╝ A browse screen of the entire inventory database is presented to you to find and then select an item to be changed. ╔════════════════════════════════════════════════════════════════════════════╗ ║▄████░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██████░ ████░ ██░ ██░║ ║██░ ██░ ██░ ████░ ███░██░ ██░ ██░ ██░ ██░ ██░ ███░███░║ ║██░ ██████░ ██░ ██░ ██████░ ██░███░ ███░ ██░ ██░ ███░ ███████░║ ║██░ ██░ ██░ ██████░ ██▀███░ ██░ ██░ ██░ ██░ ██░ ██░ ██░█░██░║ ║▀████░ ██░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██░ ████░ ██░ ██░║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This routine will allow you to change an existing Inventory Item ║ ║ Number. Option to change the Description, Vendor, and Venditem. ║ ║ Will optionally change open invoice detail records. NOT A REPORT. ║ ╟─────────────────────────[ SELECT ITEM TO CHANGE ]──────────────────────────╢ ║ITEM DESC ONHAND ONORDER BO ║ ║─────────────╥────────────────────────────────╥─────────╥─────────╥─────────║ ║1051232P1 ║ 1051232P1 LAMP ║ 10 ║ 0 ║ 3 ║ ║1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 0 ║ 0 ║ 0 ║ ║1246G1 ║ A2251246G1 REGISTER ASSEMBLY ║ 0 ║ 4 ║ 2 ║ ║1247G1 ║ A2251247G1 ║ 0 ║ 4 ║ 0 ║ ║1257791G51 ║ 1B32083-1S ║ 0 ║ 1 ║ 0 ║ ║45FB-45 ║ 24X24X8-3/4 FILT. W.HOUSING ║ 22 ║ 0 ║ 0 ║ ║6-40A16 ║ 24X24X15 ║ 0 ║ 0 ║ 0 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) Enter/Return (Select) Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type) 1372/1400 DAYO Smart Reports, TJS LAB Page: 67 The option to change the description, second description, vendor, and vendor part number also exists... ╔════════════════════════════════════════════════════════════════════════════╗ ║▄████░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██████░ ████░ ██░ ██░║ ║██░ ██░ ██░ ████░ ███░██░ ██░ ██░ ██░ ██░ ██░ ███░███░║ ║██░ ██████░ ██░ ██░ ██████░ ██░███░ ███░ ██░ ██░ ███░ ███████░║ ║██░ ██░ ██░ ██████░ ██▀███░ ██░ ██░ ██░ ██░ ██░ ██░ ██░█░██░║ ║▀████░ ██░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██░ ████░ ██░ ██░║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This routine will allow you to change an existing Inventory Item ║ ║ Number. Option to change the Description, Vendor, and Venditem. ║ ║ Will optionally change open invoice detail records. NOT A REPORT. ║ ╟─────────────────────────[ SELECT ITEM TO CHANGE ]──────────────────────────╢ ║ ║ ║ Item: 1245G1-S ║ ║ Description #1: A2251245G1 REGISTER ASSEMBLY ║ ║ #2: ║ ║ Vendor: TTT ║ ║ Vendor Item: ║ ║ ║ ║ Do you wish to update the Invoice Detail Database; Open Invoices? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO Smart Reports, TJS LAB Page: 68 ■ CREDIT CARDS & CHECKS Use this report to list all invoices or receivables that contain a credit card number or authorization. ╔═[ Credit Cards & Checks ]══════════════════════════╗ ║ ║ ║ Credit Card & Check Authorization Number Report. ║ ║ This reports all invoices in either the Invoice ║ ║ or AR Header Databases with Credit Card or Check ║ ║ Terms. Reports includes Authorization Number. ║ ║ ║ ╚════════════════════════════════════════════════════╝ The report can run for a specified date range and directed to printer or file. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █████░ █████░ █████░ █▄██░ ███░ █▄██░ ▄██▄ █▄██░ █████░ ║ ║ ██░ ██░ ██ ██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ ██░ ██░ ████ ██░ ████░ ██░ █▀██░ █░ █░ ████░ █░ ║ ║ ██░ ██░ ██ ██░ █░█░ █░ █░ █░ █░ █░█░ █░ ║ ║ █████░ █████░ █████░ █░██░ ███░ █░ ▀██▀ █░██░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ This report prints out an Invoice Summary of Credit Card and Check ║ ║ Invoices for a selected date range. ║ ║ ║ ║ Select Database -> Invoices (INVOICE.DBF) ║ ║ ║ ║ Start Date: 04/20/91 End Date: 05/20/91 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: AUTHORZ.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO Smart Reports, TJS LAB Page: 69 ■ INVENTORY PRICES This is just a simple list of all your cost and price fields for every inventory item. ╔═[ Inventory Prices ]═══════════════════════════════╗ ║ ║ ║ Inventory Prices Reports. This is a list of all ║ ║ items with its cost, average cost, average price, ║ ║ price, and price1 to price5. ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════╝ Options include the ability to select from multiple indexes, specify a date range (for average cost & price), number of lines per page, and to direct the output to printer or file. ╔═[ Inventory Prices ]═══════════════════════════════╗ ║ Select the Index -> ITEM (ITEM) ║ ║ Start Date: 05/18/90 End Date: 05/18/91 ║ ║ Enter Number of Lines per Page: 55 ║ ║ Send Output to Printer? (Y/N) ║ ║ Enter File Name: PRICES.TXT ║ ║ ║ ╚════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 70 ■ SALES COMMISSION REPORT This is a report of all your sales (receivables), indexed by the sales person. The total of each invoice with the commission of the sales person is printed. The commission is based on the RATE field found in the sales person database 'SALESPER.DBF'. ╔═[ Sales Commission Report ]════════════════════════╗ ║ ║ ║ Sales Commission Report. The commissions are based ║ ║ on the sales person's RATE (found in the database ║ ║ SALESPER.DBF), applied to the SUBTOTAL of sales ║ ║ (AR Header records), for a specific date range. ║ ║ ║ ╚════════════════════════════════════════════════════╝ The options to select a date range, determine the number of lines per page and to direct the output to printer or file exist. ╔════════════════════════[ SALES COMMISSION REPORT ]═════════════════════════╗ ║ ███ ███ █ ███ ███ ███ ████ █ █ █ █ ███ ███ ███ ███ ████ █ █ ███║ ║ █ █ █ █ █ █ █ █ █ ██ ██ ██ ██ █ █ █ █ █ █ ██ █ █ ║ ║ ███ █████ █ ██ ███ █ █ █ █████ █████ █ ███ ███ █ █ █ ████ ███║ ║ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ ██ █║ ║ ███ █ █ ███ ███ ███ ███ ████ █ █ █ █ ███ ███ ███ ███ ████ █ █ ███║ ║ ║ ║ Start Date: 05/18/90 End Date: 05/18/91 ║ ║ ║ ║ Enter Number of Lines per Page: 55 ║ ║ ║ ║ Send Output to Printer? (Y/N) ║ ║ ║ ║ Enter File Name: COMRPT.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 70.1 ■ DAILY 'DOLLAR' (AR RECEIPTS) REPORT Use this report to print out all AR invoice amounts and Cash Receipts for a specific day. The options to select a date, determine the number of lines per page and to direct the output to printer or file exist. ╔══════════════════[ DAILY 'DOLLAR' (AR RECEIPTS) REPORT ]═══════════════════╗ ║ █▄███ █ ███ █ █ █ █▄███ ▄███▄ █ █ █ █▄██ ║ ║ █ █ █▀█ █ █ █▄ ▄█ █ █ █ █ █ █ █▀█ █ █ ║ ║ █ █ █ █ █ █ ███ █ █ █ █ █ █ █ █ ████ ║ ║ █ █ █▀▀▀█ █ █ █ █ █ █ █ █ █ █▀▀▀█ █ █ ║ ║ █▀███ █ █ ███ ████ █ █▀███ ▀███▀ ████ ████ █ █ █ ██ ║ ║ ║ ║ Enter Date to Report: 06/13/91 ║ ║ Enter Number of Lines per Page: 55 ║ ║ Send Output to Printer? (Y/N) ║ ║ Enter File Name: DAYDOL.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ JEWELRY TAGS - INVENTORY PRICE TAGS Use this routine to print inventory price tag labels. The following fields are printed onto the label: ITEM, PRICE, VENDITEM & DESCRIPTION. The labels form consists of labels 3 across, ie: │■┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐■│ │■│B-T34242W└──┘BATTERY -│ │B-T34242W└──┘BATTERY -│ │B-T34242 └──┘BATTERY -│■│ │■│ 233.04 DMX-4545X│ │ 233.04 DMX-4545X│ │ 233.04 DMX-4545X│■│ │■│4A-10444 ┌──┐3.6V -LIT│ │4A-10444 ┌──┐3.6V -LIT│ │4A-10444 ┌──┐3.6V -LIT│■│ │■└─────────┘ └─────────┘ └─────────┘ └─────────┘ └─────────┘ └─────────┘■│ ╔════════════════════════════════════════════════════════╗ ║ This routine prints inventory price tags onto jewelry ║ ║ tag labels (3 across). Product: SHARK SKIN 929537 ║ ║ Blank tags can be purchased from Jeremiah's & Assoc. ║ ║ Tampa, Florida (813) 539-1195 ║ ║ ║ ║ Set printer to 16.7 Pitch and 8 LPI. ║ ║ │■┌──────────┐ ┌──────────┐ ║ ║ │■│12TL5242W │ │BATTERY - │ ║ ║ │■│ └─────────┘ │ ║ ║ │■│ 21.95 TL5242W - │ ║ ║ │■│ ┌─────────┐ │ ║ ║ │■│LA-108-4 │ │3.6V -LITH│ ║ ║ │■└──────────┘ └──────────┘ ║ ║ Select ITEM DESC ║ ║ Item -> B634643684 SYSGEN - ADAPTER CARD ║ ║ B366343414 SYSGEN - ADAPTER CARD#3 ║ ║ B346423444 TAPE - CNTRL CARD FOR 342-2333 ║ ║ 12TL5242W4 BATTERY - 345242W - 3.4V ║ ║ B45435TER1 TAPE BACKUP - CDX 130M W/CNTRL ║ ╚════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Print) F5/F6/F7/F8/F9 (Find) DAYO Smart Reports, TJS LAB Page: 70.2 ■ INVOICE DETAIL HISTORY Use this report as a general purpose report for reporting detail sales for a specific CUSTOMER, SALES PERSON, CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ╔═════════════════════════[ INVOICE DETAIL HISTORY ]═════════════════════════╗ ║ This report prints out all invoice detail records for a specific ║ ║ CUSTOMER, SALES PERSON, CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, ║ ║ SHIPPER, TAXCODE or ITEM. This is NOT a Report Form!... ║ ║ ║ ║ Enter Start Date: 06/16/90 Ending Date: 06/16/91 ║ ║ Enter Report Title: ACME PARTS SUPPLY, INC. ║ ║ Enter Number of Lines Per Page: 55 ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: HISTORY.TXT ║ ║ ║ ║ Select Option -> CUSTOMER ║ ║ SALES PERSON CODE ║ ║ CLASS CODE (ARH.DBF) ║ ║ BILL TO STATE ║ ║ SHIP TO STATE ║ ║ BILL TO ZIP CODE ║ ║ SHIP TO ZIP CODE ║ ║ SHIPPER CODE ║ ║ TAX CODE ║ ║ ITEM ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ INVOICE DETAIL HISTORY The progress of the report is displayed onto the screen, ie: ╔═════════════════════════[ INVOICE DETAIL HISTORY ]═════════════════════════╗ ║CUSTOMER = 100 ║ ║Item Description Cost Price Qty║ ║1245G1 A2251245Ga REGISTER ASSEMBLY 14.000 28.000 1.00║ ║1245G2 A2251245Gb REGISTER ASSEMBLY 12.000 24.000 1.00║ ║1245G3 A2251245Gc REGISTER ASSEMBLY 12.400 24.490 1.00║ ║1245G4 A2251245Ge REGISTER ASSEMBLY 14.240 22.990 1.00║ ║10X1TKB516 BRZ 10 X 1 5/16 TEK SCREWS 2.020 6.020 1.00║ ║10X1SZ ZINC 10 X 1 SCRULOX SCREWS 0.012 0.030 1.00║ ║10X1HXB BRZ 10 X 1 HEX HEAD SCREWS 2.010 4.060 300.00║ ║1051232P1 1051232Pa LAMP 0.230 0.550 5.00║ ║1051232P2 1051232Pb LAMP 0.420 0.990 1.00║ ║1051232P3 1051232Pc LAMP 0.450 0.990 1.00║ ║1051232P4 1051232Pd LAMP 0.400 0.850 1.00║ ║1051232P5 1051232Pe LAMP 0.400 0.850 1.00║ ║10-1 93 FUSE 0.500 1.990 1.00║ ║010-0800/S1* SPACE NUT 4.300 9.560 3.00║ ║010-0990/25 MARTIAN VASE 2.430 4.490 1.00║ ║010-0999/26 JUPITER BROTH 2.420 5.990 1.00║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Smart Reports, TJS LAB Page: 70.3 ■ EXPANDED DETAIL HISTORY Use this report to print out all AR Detail records with the following fields: Item, Description, Cost, Price, Qty, Ship To Name, Class, Salesper, Shipper, Taxcode, States, & Date. The options include the number of lines per page and to direct the output to printer or file exist. ╔══════════════[ INVOICE DETAIL HISTORY WITH BILLTO & SHIPTO ]═══════════════╗ ║ This report prints out all invoice detail records for a specific ║ ║ CUSTOMER, SALES PERSON, CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, ║ ║ SHIPPER, TAXCODE or ITEM. This is NOT a Report Form!... ║ ║ Report includes expanded information about the customer. ║ ║ Enter Start Date: 06/18/90 Ending Date: 06/18/91 ║ ║ Enter Report Title: ACME PARTS SUPPLY, INC. ║ ║ Enter Number of Lines Per Page: 55 ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: HISTORY2.TXT ║ ║ ║ ║ Select Option -> CUSTOMER ║ ║ SALES PERSON CODE ║ ║ CLASS CODE (ARH.DBF) ║ ║ BILL TO STATE ║ ║ SHIP TO STATE ║ ║ BILL TO ZIP CODE ║ ║ SHIP TO ZIP CODE ║ ║ SHIPPER CODE ║ ║ TAX CODE ║ ║ ITEM ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Smart Reports, TJS LAB Page: 71 ■ 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 any report written to disk. ║ ║Press Enter/Return on an empty prompt to display all files with the ║ ║extension of '.TXT'. ║ ║File size limited to 32,000 bytes. ║ ║ ║ ║Enter Report File Name to View On Screen: ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║LIABIL.TXT │ 1987 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO Smart Reports, TJS LAB Page: 72 ■ 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 Smart Reports, TJS LAB Page: 73 ■ 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 Smart Reports, TJS LAB Page: 74 ■ 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 Smart Reports, TJS LAB Page: 75 ■ 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 Smart Reports, TJS LAB Page: 76 ■ CONFIGURATION The configurations settings (14 of them), are all accessed from within the CONFIGURATION menu (first option from the main menu). ╔════════════════════════╗ ║ CONFIGURATION ║ ╟────────────────────────╢ ║ Company Name ║ ║ Company Address ║ ║ Company Telephone ║ ║ Inventory Location ║ ║ POS Location ║ ║ Customer Location ║ ║ AP Location ║ ║ Quotes Location ║ ║ Back Orders Location ║ ║ Price Book Location ║ ║ Report Printer Type ║ ║ Report Printer Port ║ ║ Color ║ ║ High Intensity ║ ║ ║ ╟────────────────────────╢ ║ Select Option ║ ╚════════════════════════╝ ■ CONFIGURATION LISTING Company Name Quotes Location Company Address Back Orders Location Company Telephone Price Book Location Inventory Location Report Printer Type POS Location Report Printer Port Customer Location Color AP Location High Intensity Margin Points vs % DAYO Smart Reports, TJS LAB Page: 77 ■ COMPANY NAME, ADDRESS & TELEPHONE Each field for this option is limited to 30 characters, 14 for the telephone... ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY, INC │ └────────────────────────────────────────────────────────────────────────────┘ ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Accounting │ │ Address Line 2: P.O. BOX 5555 │ │ City, State ZIP: ANYCITY, ST 55555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY LOCATION/DIRECTORY ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in the │ │ same drive/directory as DAYO Reports. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO Reports where to find │ │ the inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOINV\ │ │ The drive designation is optional (if same as DAYO Reports). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ┌────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]────────────┐ │ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be │ │ in the same drive/directory as DAYO Reports. If you have installed the │ │ DAYO POS Databases, into a different directory, you need to tell DAYO │ │ Reports where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO Reports). │ │ │ │ Enter Location: \DAYOPOS\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Smart Reports, TJS LAB Page: 78 ■ CUSTOMER DATABASE LOCATION/DIRECTORY ┌──────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]──────────────────┐ │ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │ │ in the same drive/directory as DAYO Reports. If you have installed the │ │ DAYO Customer Database (CUSTOMER.DBF), into a different directory, you need│ │ to tell DAYO Reports 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 Reports). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY ┌─────────────[ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY ]──────────────┐ │ The location of the DAYO AP files (ie: APH.DBF) does not have to be │ │ in the same drive/directory as DAYO Reports. If you have installed the │ │ DAYO AP Databases, into a different directory, you need to tell DAYO │ │ Reports where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAP\ │ │ The drive designation is optional (if same as DAYO Reports). │ │ │ │ Enter Location: \DAYOAP\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ QUOTES DATABASE LOCATION/DIRECTORY ┌───────────────────[ QUOTES DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Quotes Database (QUOTES.DBF) does not have to be │ │ in the same drive/directory as DAYO Reports. If you have installed DAYO │ │ Quotes into a different directory, you need to tell DAYO Reports 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 Reports). │ │ │ │ Enter Location: \DAYOQUO\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Smart Reports, TJS LAB Page: 79 ■ BACKORDERS DATABASE LOCATION/DIRECTORY ┌─────────────────[ BACKORDERS DATABASE LOCATION/DIRECTORY ]─────────────────┐ │ The location of the DAYO BackOrder Database (BO.DBF) does not have to │ │ be in the same drive/directory as DAYO Reports. If you have installed DAYO │ │ BO into a different directory, you need to tell DAYO Reports 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 Reports). │ │ │ │ Enter Location: \DAYOBO\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRICE BOOK DATABASE LOCATION/DIRECTORY ┌─────────────────[ PRICE BOOK DATABASE LOCATION/DIRECTORY ]─────────────────┐ │ The location of the DAYO Price Book Database (PB.DBF) does not have to be │ │ in the same drive/directory as DAYO Reports. If you have installed DAYOPB │ │ into a different directory, you need to tell DAYO Reports 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 Reports). │ │ │ │ Enter Location: \DAYOPB\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ 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 Smart Reports, TJS LAB Page: 80 ■ 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 computing multiple prices. │ │ 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) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR To activate a color change, you must completely exit DAYO Smart Reports, then reenter. ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Smart Reports, TJS LAB Page: 81 ■ 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: DAYORPT V3.0, TJS LAB ┌────[April 1990]────┐ ╔════════════════════╗ │S M T W T F S │ ║ MISC ROUTINES ║═══╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ BROWSE DATABASES ║ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ CREATE DATABASE ║ ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │ ║ DELETE RECORDS ║ ║ │ │ ║ ERASE FILE ║ ║ └────────────────────┘ ║ EXIT TO DOS ║ ╠═[ Misc Routines ]═════════════════════════════════╗ ║ INDEX A DATABASE ║ ║ ║ ║ LIST FIELDS ║ ║ Miscellaneous Database Management Routines. ║ ║ PACK DATABASE ║ ║ ║ ║ MODIFY DATABASE ║ ║ Browse, Edit, Append, Copy, Delete, Pack, ║ ║ RECALL RECORDS ║═══╣ Modify, and/or Create Databases. ║ ║ RETURN TO MENU ║ ║ ║ ║ RUN (DOS COMMAND) ║═══╩═══════════════════════════════════════════════════╝ ║ SIMPLE EDITOR ║ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ ║ SORT DATABASE ║ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ ║ TYPE (PRINT) FILE ║ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ║ ZAP DATABASE ║ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ ╟────────────────────╢ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░ ║ Select Option ║ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ ╚════════════════════╝ DAYO Smart Reports, TJS LAB Page: 82 ■ 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 Smart Reports, TJS LAB Page: 83 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENT.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Smart Reports, TJS LAB Page: 84 ■ 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 Smart Reports, TJS LAB Page: 85 - 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 Smart Reports, TJS LAB Page: 86 ■ 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 Smart Reports, TJS LAB Page: 87 - 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 Smart Reports, TJS LAB Page: 88 - 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 Smart Reports, TJS LAB Page: 89 * * * 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 Smart Reports, TJS LAB Page: 90 ■ 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 Smart Reports, TJS LAB Page: 91 ■ 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 Smart Reports, TJS LAB Page: 92 ■ 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 Smart Reports, TJS LAB Page: 93 - 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 Smart Reports, TJS LAB Page: 94 - 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 Smart Reports, TJS LAB Page: 95 - 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 Smart Reports, TJS LAB Page: 96 - 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 Smart Reports, TJS LAB Page: 97 *** 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 Smart Reports, TJS LAB Page: 98 ■ 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 Smart Reports, TJS LAB Page: 99 ■ 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 Smart Reports, TJS LAB Page: 100 - 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 Smart Reports, TJS LAB Page: 101 - 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 Smart Reports, TJS LAB Page: 102 - 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 Smart Reports, TJS LAB Page: 103 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanantly) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Smart Reports, TJS LAB Page: 104 ■ 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: ┌──────────────────────[ DAYORPT 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: ┌───────────────────────[ DAYORPT 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 Smart Reports, TJS LAB Page: 105 - Editor help: ┌──────────────────────[ DAYORPT 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 Smart Reports, TJS LAB Page: 106 ■ 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 HELP Called by Program: DAYORPT 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 DAYORPT. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ 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 Smart Reports, TJS LAB Page: 107 ┌───────[ DAYO HELP Called by Program: DAYORPT 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, DAYORPT.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 DAYORPT 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 Smart Reports, TJS LAB Page: 108 ■ DAYO SMART REPORTS MAINTENANCE & QUIRKS - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Backups of your data and configuration files should take place daily! You have no doubt heard many 'scare' stories about losing data. They are all true! The key files that need to be backed up all have the extension of .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files are notes/memos. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. - If you must use dBase (tm) with DAYO Smart Reports, and you are on a PC base network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO Smart Reports, TJS LAB Page: 109 ■ TJS 'Computer' LAB TJS LAB produces customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (ie: A/R, A/P, G/L). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are very reasonably priced! Custom/contract programming is available. We make program enhancements and changes very quickly; usually within 24 hours! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Call us for a quote or just for more information! Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858 Or call us, 08:00am to 11:00pm Mon-Sat Voice Mail between 11:00pm to 08:00am: (407) 291-3960/6987 ┌──────────────────────────────────────────────────────────────────────┐ │ Note that TJS LAB will not accept/take any support calls for │ │ UNregistered products! │ └──────────────────────────────────────────────────────────────────────┘