home *** CD-ROM | disk | FTP | other *** search
Text File | 1991-09-10 | 211.9 KB | 2,707 lines |
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ ║
- ║ ║
- ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
- ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
- ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
- ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
- ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ║ █▄████▄ ▄█████▄ ║
- ║ █▒░ █▒░ █▒░ █▒░ ║
- ║ █▒░ █▒░ █▒░ █▒░ ║
- ║ █▄▄▄▄█▀ █▒░ █▒░ ║
- ║ █▒░ ▀█▒░ █▒░ █▒░ ║
- ║ █▒░ █▒░ █▒░ █▒░ ║
- ║ █▀████▀ ▀█████▀ ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ║ BACK ORDERS ║
- ║ ║
- ║ MAINTENANCE MODULE FOR CUSTOMER'S UNFILLED ORDERS ║
- ║ ║
- ║ ║
- ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║
- ║ ║
- ║ ║
- ║ ║
- ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║
- ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║
- ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║
- ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║
- ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║
- ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║
- ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║
- ║ Applications ▐███████████ N R ║
- ║ ┌─┐ ┌─┐ ███████████▌ S E ║
- ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║
- ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║
- ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║
- ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║
- ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║
- ║ █ G ║
- ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║
- ║ ║
- ║ ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- DAYO BO, TJS LAB Orlando, Florida
-
-
-
-
-
-
-
- ■ SOFTWARE SUPPORT POLICY
-
-
- 1. TJS LAB does not support users of unregistered DAYO products with the
- exception of installation questions.
-
- 2. Support (included with registration) remains in effect for 1 year after
- date of registration or 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 BO, TJS LAB
-
-
-
- Table of Contents
-
- Page Subject
- ──── ──────────────────────────────────────────────────────────
- 1......INTRODUCTION
- 2......COPYRIGHT/LICENSE
- 2......DISCLAIMER
- 2......REQUIREMENTS ***
- 2......SETUP
- 3......MAIN MENU
- 3...... PASSWORD/NAME
- 4...... OPEN REGISTER
- 5...... CREATING ADDITIONAL REGISTERS
- 5...... CLOSE REGISTER
- 6......ALLOCATION
- 6...... ALLOCATE SCREEN
- 7...... ALLOCATION PROCESS
- 8......BACK ORDER BROWSE
- 8...... HELP - F1
- 9...... FULL SCREEN EDIT - F2
- 9...... INVOICE - F3
- 10...... FINAL EDIT SCREEN
- 10...... MULTIPLE SHIPTOS
- 11...... TYPE, TERMS, SHIPPER, TAXCODE/TAXRATES
- 11...... ENTER RECEIPT AMOUNT
- 12...... EXIT/FINISH
- 12...... WORK ORDER NOTES/COMMENTS
- 13...... DATABASE POSTING
- 14...... ADD BO RECORD
- 14...... DELETE BO RECORD
- 14...... FIND (F5/F6/F7/F8)
- 15......CUSTOMERS
- 15...... FIND (F5/F6/F7/F8)
- 16......CONFIGURATION
- 16...... CONFIGURATION MENU
- 17...... COMPANY NAME, ADDRESS & TELEPHONE
- 17...... AUTOMATICALLY PRINT THE INVOICE
- 18...... AUTOMATIC ALLOCATION
- 18...... LAST INVOICE NUMBER
- 18...... INVOICE PRINTER TYPE
- 18...... INVOICE PRINTER PORT
- 18...... INVOICE COPIES
- 19...... ALLOW BROWSE EDITING
- 19...... USE CREDIT LIMIT
- 19...... INVENTORY DATABASE LOCATION
- 19...... CUSTOMER DATABASE LOCATION
- 20...... POS DATABASE LOCATION
- 20...... GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY
- 20...... CURRENT DIRECTORY DATABASE LOCATION
- DAYO BO, TJS LAB
-
-
-
- Table of Contents
-
- Page Subject
- ──── ──────────────────────────────────────────────────────────
- 21...... CASH DRAWER
- 21...... CASH DRAWER SERIAL PORT
- 21...... PARALLEL CASH DRAWER
- 21...... PARALLEL CASH DRAWER PORT
- 22...... PARALLEL CASH DRAWER SETUP CODE
- 22...... REPORT PRINTER TYPE
- 22...... REPORT PRINTER PORT
- 22...... VISUAL INDEXING
- 23...... AUTOMATIC DAILY INDEXING
- 23...... AUTO PRINT PACKING LIST
- 23...... PACKING LIST PRINTER PORT
- 23...... PRINT PRICE ON PACKING LIST
- 24...... WORK ORDER COPIES
- 24...... WORK ORDER PRINTER TYPE
- 24...... WORK ORDER PRINTER PORT
- 24...... WORK ORDER NOTES PHRASE
- 25...... USE REGISTERS
- 25...... DEFAULT COMMENT
- 25...... AUTOMATIC GL POSTING
- 26...... EDIT CLASS CODE RECORD
- 26...... ADD NEW CLASS CODE RECORD
- 27...... FIND CLASS CODE
- 28...... COLOR MONITOR
- 28...... COLOR INTENSITY
- 29......REPORTS
- 30...... ALLOCATION REPORT
- 30...... BACK ORDER REPORT
- 31...... INVENTORY BACKORDER RESET & REPORT
- 31...... CUSTOMER SHIP TO ADDRESS LABELS
- 32...... DATABASE STATUS REPORT
- 33...... CONFIGURATION STATUS REPORT
- 35...... PRINTER DRIVER (SETUP)
- 35...... PRINTER DRIVER OPTIONS
- 36...... CHANGE DEFAULT PRINTER
- 37...... FULL SCREEN EDIT - F2
- 37...... PRINTER DRIVER DATABASE FIELD DEFINITIONS
- 38......HELP SCREENS
- 39...... EXPANDED HELP
- 40...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
- 41...... VIEW DOCUMENTATION ONSCREEN
- 42......DATABASE STRUCTURE
- 47......DATA DICTIONARY
- 51......DAYO BO MAINTENANCE & QUIRKS
- 53......TJS 'Computer' LAB
- DAYO BO, TJS LAB Page: 1
-
-
-
- ■ INTRODUCTION
-
- DAYO BO (BackOrder), is the maintenance module for customer's unfilled
- orders. BackOrders are created with the POS module just like you would an
- invoice. All invoice items not onhand in the inventory become a BackOrder. As
- products/items are received into your inventory, the BackOrder Allocation
- process is run to fill your BackOrders. BackOrders are filled, 'first
- come, first serve', based on the date and time of the original order. The
- Allocation process has 2 modes of operation: AUTO or VERIFY.
-
- DAYO BO is totally integrated with the DAYO POS and DAYO Inventory
- modules.
-
- Like all DAYO applications, DAYO BO is multiuser when used on a PC based
- LAN/Network. It can, however be run as a 'standalone' application.
-
-
- Some of the DAYO BO highlights are:
-
- Multiuser (ie: Novell)
- Registers
- Work Orders
- Allocation Process
- BackOrder Reset
- Cash Drawers
- Databases are dBase (tm) compatible
- HP Laser Special Invoices
- Preprinted Invoices
- Standard Invoices
- Packing/Shipping Lists
- Customer Ship To/Mailing Address Labels
- 24 Configuration Settings
- Credit Limits
- Passwords (with DAYO Passwords)
- Reports
-
-
- Other DAYO Products:
-
- DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
- DAYO POS Point of Sale
- DAYO Quotes Sales Quoting System
- DAYO Price Books Special pricing for your customers as well as a wide
- range of product catalogs/reports
- DAYO AR Accounts Receivable
- DAYO AP Accounts Payable
- DAYO EOP End Of Period Posting
- DAYO Passwords Password protect your DAYO system
- DAYO Smart Reports A variety of reports pertaining to the above modules
- DAYOX Network/LAN Index Maintenance Utility
- DAYO BO, 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 BO 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 BO.
-
-
-
- ■ REQUIREMENTS ***
-
-
- IBM or Compatible CPU
-
- 640K memory
-
- * DOS 3.3 or above
-
- Hard Disk
-
-
-
- ■ SETUP
-
- To setup DAYO BO, run the SETUP program found on the Menu and/or Update
- disk, or copy and 'decompress' the contents of the DAYO BO floppy disk into
- a directory on your hard disk (ie: \DAYOBO). When you run DAYOBO 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 BO configuration.
-
- DAYO BO, TJS LAB Page: 3
-
-
-
- ■ MAIN MENU
-
-
- After a few moments and possibly a reindex, the main menu will appear:
-
-
- DAYO Back Orders Version 3.50 TJS LAB ┌───[February 1991]──┐
- Copyright (c) 1989-1991, All Rights Reserved │S M T W T F S │
- ╓─────────────────────────╖ ├────────────────────┤
- ║ 1 REGISTER ║ ████▄ ▄█▄ █░ █░ ▄███▄ │ 1 2│
- ╟─────────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 3 4 5 6 7 8 9│
- ║ 2 ALLOCATE ║ █░ █░ █░█░ ▀█░██░ █░ █░ │10 11 12 13 14 15 16│
- ╟─────────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │17 18 19 20 21 22 23│
- ║ 3 BROWSE ║ █░ █░ █░ █░ █░ █░ █░ │24 25 26 27 28 │
- ╟─────────────────────────╢ ████▀ █░ █░ █░ ▀███▀ │ │
- ║ 4 CUSTOMERS ║ └────────────────────┘
- ╟─────────────────────────╢
- ║ 5 CONFIGURATION ║
- ╟─────────────────────────╢╓────────────────────────────────────────────────╖
- ║ 6 REPORTS ║║ DAYO BO STATISTICS Register Open ║
- ╟─────────────────────────╢╟────────────────────────────────────────────────╢
- ║ 7 EXIT ║║ DATABASE NAME RECORDS SIZE ║
- ╚═════════════════════════╝╟────────────────────────────────────────────────╢
- Select Option ║ INV.DBF Inventory 1 1K ║
- █▄███▄ ▄████▄ ║ INVOICE.DBF Invoice Header 51 24K ║
- █░ █░ █░ █░ ║ DETAIL.DBF Invoice Detail 237 33K ║
- █▄▄▄█▀ █░ █░ ║ BACKORDER.DBF BackOrders 0 0K ║
- █░ ▀█░ █░ █░ ║ CUSTOMER.DBF Customers 309 154K ║
- █░ █░ █░ █░ ║ REGISTER.LOG Register Log 762 67K ║
- █▀███▀ ▀████▀ ╚════════════════════════════════════════════════╝
- Open, ReOpen, or Close Your Register
-
-
- The left side of the screen is the actual main menu. The calendar and
- logos are just 'art'. The DAYO BO STATISTICS box (bottom right) contains
- the number of records and size (in kilo bytes) of the main databases (there
- are many others!).
-
-
-
- ■ PASSWORD/NAME
-
- From the main menu you can enter any of the modules, but not until you
- enter your name (or password if using DAYO Password):
-
- ┌────────────────────────────────────────────────────────────────────────────┐
- │┌──────────────────────────────────────────────────────────────────────────┐│
- ││ Enter Your Name: TOM JOHNSON ││
- │└──────────────────────────────────────────────────────────────────────────┘│
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 4
-
-
-
- ■ OPEN REGISTER
-
- Before you can enter the ALLOCATE or the BROWSE options, you must
- open/reopen a register. Opening a register means the recording of the amount
- of money you start the day (period) with. Subsequent invoices will be
- 'posted' to this register thus creating a reliable means of auditing your
- daily sales. You are required to close this register at the end of day (or
- period). It is recommended (and common sense), that you reconcile your
- register at this time. Note there are various Register Reports that can aid
- you in your audit. These reports are found in the DAYO POS module.
-
- To open a register, select the REGISTER option from the main menu. You
- will then be prompted to open (or reopen), a register.
-
-
- ┌───────────────────[ OPEN/CLOSE REGISTER ]──────────────┐
- │ │
- │ Select the Register you wish to Open, Re-open, or │
- │ Close. You can not create an invoice unless you │
- │ open a Register first! │
- │ Select Register to OPEN/RE-OPEN/CLOSE... │
- │ │
- │ Register Open Open Date Close Date Start $ │
- │──────────╥──────╥───────────╥────────────╥─────────────│
- │ 1 ║ F ║ 12/28/89 ║ 12/28/89 ║ 100.00 │
- │ 2 ║ T ║ 12/26/89 ║ / / ║ 0.00 │
- │ ║ ║ ║ ║ │
- └────────────────────────────────────────────────────────┘
-
-
- DAYO BO starts off with only one register (1), but you can create
- others. Note, it is recommended that DAYO BO use the same REGISTER.DBF as
- does DAYO POS. This is accomplished by insuring that the Configuration
- setting for the POS Database Location is correctly entered.
-
- You can have many registers, but you can not open a register on more than
- one machine at a time. When you open the register, it prompts you to enter
- the amount of money you wish to start the day with.
-
-
- ┌─────────────────────[ OPEN REGISTER 1 ]────────────────┐
- │ │
- │ Select the Register you wish to Open, Re-open, or │
- │ Close. You can not create an invoice unless you │
- │ open a Register first! │
- │ Select Register to OPEN/RE-OPEN/CLOSE... │
- │ │
- │ │
- │ │
- │ Enter Starting Register Amount: 100.00 │
- │ [ Press Esc to Abort ] │
- │ │
- └────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 5
-
-
-
- When a register is opened/reopened, the file is 'locked'. This prevents
- another machine/CPU from opening it.
-
-
- ■ CREATING ADDITIONAL REGISTERS
-
- To create additional registers, go into the MISC ROUTINES of the DAYO
- POS module, and select the BROWSE DATABASES option. At the prompt for
- database, just press Enter/Return to bring up a list of the databases in the
- current directory. Select the REGISTER.DBF. Press 'Ctrl N' simultaneously
- to add another record. The record number of that new record becomes the
- new register number.
-
-
-
- ■ CLOSE REGISTER
-
- At the end of the day or period, you need to close the register. Do this
- by entering the REGISTER option off the main menu. You will be given a
- a prompt to input the amount of money in the register/cash drawer.
-
-
- ┌───────────────────[ CLOSE REGISTER 1 ]─────────────────┐
- │ │
- │ Select the Register you wish to Open, Re-open, or │
- │ Close. You can not create an invoice unless you │
- │ open a Register first! │
- │ │
- │ │
- │ │
- │ │
- │ Enter Ending Register Amount: 10493.00 │
- │ [ Press Esc to Abort ] │
- │ │
- └────────────────────────────────────────────────────────┘
-
-
-
- After entering your closing balance, a window will appear letting you
- know the differences (if any), between what you ended with, and what the
- register calculates you should have (starting amount plus received payments
- amount).
-
-
- ┌───────────────────────────────────┐
- │ │
- │ Started With: 23.10 │
- │ Ended With: 123.10 │
- │ Difference: 100.00 │
- │ Invoice Receipts: 100.11 │
- │ ────────────────- ─────────- │
- │ Variance: -.11 │
- └───────────────────────────────────┘
- DAYO BO, TJS LAB Page: 6
-
-
-
- ■ ALLOCATION
-
- To complete your BackOrders, you must first fill them. You can use the
- Allocation process (option 2 from the main menu), or 'manually' fill orders
- by editing the field FILLED in the BackOrder Browse (option 3 from the main
- menu). The Allocation process takes the BackOrders (in the order they were
- created 'first in, first out') and updates the FILLED field with ONHAND
- quantity from the inventory database (INV.DBF).
-
-
- ■ ALLOCATE SCREEN
-
- The option to reset the backorder quantity in the inventory database is
- before starting the Allocation process is presented upon initial entry into
- this routine. The backorder quantity (BO field) will be reset only for those
- items found to be backordered. If you decide to reset the backorder (BO)
- field, a progress graph will be displayed.
-
-
-
-
- DAYO Back Orders Version 3.0 TJS LAB ALLOCATE
- Back Order
- ▄█▄ █░ █░ ▄██▄ ▄██▄ ▄█▄ ▄███▄ ▀█▀ ▄██▄ ██░ █░
- █░█░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █▀█░█░
- ▄███▄ █░ █░ █░ █░ █░ ▄███▄ █░ █░ █░ █░ █░▀██░
- █░ █░ ███░ ███░ ▀██▀ ▀██▀ █░ █░ █░ ▄█▄ ▀██▀ █░ ▀█░
-
-
- Do you wish to Zero the backorder quantity field (BO) in the inventory
- database (INV.DBF)? (Y/N) *
-
-
-
-
-
- ╔═════════════════════════════════════╤═════════════════════════════════════╗
- ╟████████████████████████████████████████─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─╢
- ╚═════════════════════════════════════╧═════════════════════════════════════╝
- 0% 50% Finis
- DAYO BO, TJS LAB Page: 7
-
-
-
- ■ ALLOCATION PROCESS
-
- The progress of the Allocation process is displayed with a graph and a
- scroll of all items filled. The total value of the backorders and the total
- value of the filled backorders is displayed at the bottom of the screen.
-
-
- DAYO Back Orders Version 3.0 TJS LAB ALLOCATE
- Back Order
- ▄█▄ █░ █░ ▄██▄ ▄██▄ ▄█▄ ▄███▄ ▀█▀ ▄██▄ ██░ █░
- █░█░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █▀█░█░
- ▄███▄ █░ █░ █░ █░ █░ ▄███▄ █░ █░ █░ █░ █░▀██░
- █░ █░ ███░ ███░ ▀██▀ ▀██▀ █░ █░ █░ ▄█▄ ▀██▀ █░ ▀█░
-
- Starting the Allocation Process
-
- Updating the filled (FILLED) field in database BO.DBF
-
- ITEM DESCRIPTION INVOICE CUSTOMER ORDERED FILLED
- 102939-343 Red Velvet 10950 342300 4 0
- 102939-344 Yellow Velvet 10950 342300 2 0
-
-
-
-
-
- ╔═════════════════════════════════════╤═════════════════════════════════════╗
- ╟████████████████████████████████████████─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─╢
- ╚═════════════════════════════════════╧═════════════════════════════════════╝
- 0% Total $ BackOrdered: 17999.00 50% Total $ Filled: 288.00 Finis
- DAYO BO, TJS LAB Page: 8
-
-
-
- ■ BACK ORDER BROWSE
-
- The BO Browse routine allows access to the BackOrder database (BO.DBF)
- so that you can view and/or edit the BO line items. It is from here that you
- will also print the Invoices and/or Work Orders for the backorders. Key
- information relating to the currently highlighted record is displayed onto
- screen:
-
-
- DAYO Back Orders Version 3.0 TJS LAB BO BROWSE
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ BILL TO: SHIP TO: ║
- ║ Joe Smith Automobiles Joe Smith Automobiles ║
- ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
- ║ 342300 REG NET 30 TRUCK ║
- ║ PHONE ATTN CREDIT LASTDATE ║
- ║ 40673.50 07/13/90 ║
- ║ INVOICE DATE TIME PAID TAXABLE TERMS ║
- ║ 10950 05/08/90 No Yes/0.0170 NET 30 ║
- ║ ITEM DESCRIPTION QTY PRICE COST ║
- ║ 102939-343 Red Velvet 4 5.00 3.02 ║
- ║ AVAILABLE ONHAND ON ORDER TOTAL BO ║
- ║ 3 12 4 9 ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- INVOICE ITEM DESC QTY FILLED
- ─────────╥──────────────╥────────────────────────────────╥─────────╥──────────
- 10950 ║ 102939-343 ║ Red Velvet ║ 4 ║ 0
- 10951 ║ 102939-344 ║ Yellow Velvet ║ 2 ║ 0
- 10952 ║ 102939-345 ║ Green Velvet ║ 4 ║ 0
- 10953 ║ 102939-346 ║ White Velvet ║ 8 ║ 5
- 10954 ║ 102939-347 ║ Hollow White Velvet ║ 4 ║ 0
- 10955 ║ 102939-348 ║ Purple Orange Velvet ║ 4 ║ 0
- Esc (Exit) F1 (Help) F2 (Edit) F3 (Invc) Ctrl N (Add) Ctrl U (Del)
- Find: F5 (Original Invoice) F6 (Item) F7 (Date) F8 (Item+Date)
-
-
-
- ■ HELP - F1
-
- Press F1 to view what the special keys are while in a BROWSE. More on
- HELP later in this document...
- DAYO BO, TJS LAB Page: 9
-
-
- ■ FULL SCREEN EDIT - F2
-
- If the 'Allow Browse Editing' Configuration setting is set to 'Y', then
- you can edit any field while in the browse, or by pressing the F2 key. The
- Full Screen option will allow you to edit in a more traditional format. Note,
- no data validation takes place in BO Browse.
-
-
-
- DAYO Back Orders Version 3.0 TJS LAB BO BROWSE
- ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
- │ INVOICE: 12305 │
- │ ITEM: 102000-HIGA │
- │ DESC: TACTICAL INFORMATION SYSTEM │
- │ QTY: 35 │
- │ PRICE: 21000.00 │
- │ COST: 15600.18 │
- │ TAXABLE: T │
- │ DATE: 01/14/90 │
- │ PAY: F │
- │ TIME: 13:49:00 │
- │ │
- │ │
- │ │
- └────────────────────────────────────────────────────────────────────────────┘
- Press Esc to Abort, PgUp/PgDn to Save and Exit
-
-
-
- ■ INVOICE - F3
-
- Press F3 when you wish to print an Invoice or Work Order. There must
- exist quantity in the filled field (FILLED) or you can not print either.
- A beep and a message will appear on the bottom of the screen reminding you...
- DAYO BO, TJS LAB Page: 10
-
-
-
- ■ FINAL EDIT SCREEN
-
- If there are filled items, the following screen will be displayed:
-
-
- DAYO Back Orders Version 3.0 TJS LAB BO BROWSE
- Customer Number 342300
- Bill To Name Joe Smith Automobiles
- Edit/Alter Invoice Header
- Ship To Name Joe Smith Automobiles
- Address 1 3800 East River Road
- Address 2
- City Augusta
- State GA
- Zip 30909
- Phone
- Type REG
- Terms NET 30
- Shipper TRUCK
- Sales Person KKP
- Tax Rate 0.0500
- Customer PO ABC-100001
- Adjustment 10.00
- Freight 3.00
- Amount Paid 0.00
- Taxes 0.00
- Detail Subtotal 288.00
- Comment Original Invoice:10950
- SSC
- Esc (Exit) Enter/Return (Edit/Alter)
-
-
- If any field or value needs to be changed, then highlight it and then
- press enter/return.
-
-
-
- ■ MULTIPLE SHIPTOS
-
- If any Ship Tos exist (other than the one on the customer's record), a
- selection box of all other ShipTos will appear onto the screen:
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ Select the Ship To Address & Data ║
- ╠════════════════════════════════════════════════════════════════════════════╣
- ║1 Joe Smith Autos, Site #1 1209 East River Road, Augusta GA 30902 ║
- ║2 Joe Smith Autos, Site #2 PO Box 450023 West Madison Harper Va 90102 ║
- ║3 Joe Smith Autos, Site #3 30 Harver Street North Augusta SC 29841 ║
- ║4 Joe Smith Autos, Site #4 5002 Senic Lake Road Winter Park FL 39392 ║
- ║5 Joe Smith Automobiles, #5 (PICKUP) ║
- ║6 Joe Smith (Home) 1985 Lincoln Heights Pomeroy Ohio 89130 ║
- ║7 *** Create New ShipTo *** ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- DAYO BO, TJS LAB Page: 11
-
-
-
- ■ TYPE, TERMS, SHIPPER, TAXCODE/TAXRATES
-
- The 'Type', 'Terms', 'Shipper', and 'Tax Rate' fields will bring up a
- list of only the valid choices, ie:
-
-
- TYPE: TERMS:
- ┌─────────────────────────────────────┐ ┌────────────────────┐
- │ Select Type │ │ Select Terms │
- │REG - REGULAR SALE │ │COD │
- │Ret - RETURN │ │CASH │
- │Ref - REFUND │ │MASTERCARD │
- │SPC - SPECIAL │ │VISA │
- │LON - LOANED │ │DISCOVER │
- │EXC - EXCHANGE │ │NET 7 │
- │TRN - TRANSFER │ │NET 10 │
- │VOD - VOIDED │ │NET 15 │
- │DIR - DIRECT SHIPMENT │ │NET 30 │
- └─────────────────────────────────────┘ │NET 60 │
- └────────────────────┘
- SHIPPER:
- ┌────────────────────┐
- │ Select Shipper │
- │DELIVER │ TAXCODE/TAXRATE:
- │UPS GROUND │ ┌──────────────────┐
- │UPS BLUE │ │ Select Tax Rate │
- │UPS RED │ │0 - 0.0000 │
- │AIRBORNE │ │1 - 0.0600 │
- │FEDERAL EXPRESS │ │2 - 0.0625 │
- │TRUCK │ └──────────────────┘
- │SPECIAL DELIVERY │
- │US MAIL │
- │PICKUP │
- └────────────────────┘
-
-
-
- ■ ENTER RECEIPT AMOUNT
-
- If any money is to be received, press enter/return on the 'Amount Paid'
- prompt, ie:
-
- ╔═══════════════════════════════════╗
- ║ Receive From Customer: 301.00 ║
- ╚═══════════════════════════════════╝
- DAYO BO, TJS LAB Page: 12
-
-
-
- ■ EXIT/FINISH
-
- Press Esc once when finished with editing the header record. If the
- customer has exceeded his credit limit (option set from configuration), not
- found, or is marked Not Active (ACTIVE) in the customer database
- (CUSTOMER.DBF), the following will be displayed:
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ Amount Due: 0.00 ║
- ║ Amount Due this Invoice: 301.00 ║
- ║ Subtotal: 301.00 ║
- ║ Credit Limit: 0.00 ║
- ║ ║
- ║ Customer NOT ACTIVE! ║
- ║ ║
- ║ Press any key to continue... ║
- ╚════════════════════════════════════════════════════════════════════════════╝
-
-
-
- Finally the following display will appear prompting you to print an
- Invoice, Work Order, Redo the header record, or Abort:
-
-
- ╔══════════════════════════════════════╗
- ║ Order Total: 288.00 ║
- ║ ║
- ║ Total Due: 0.00 ║
- ║ ──────────────────────────────────── ║
- ║ Select Option -> Print Invoice ║
- ║ Print Work Order ║
- ║ Redo ║
- ║ Abort ║
- ║ ║
- ╚══════════════════════════════════════╝
-
-
-
- ■ WORK ORDER NOTES/COMMENTS
-
- If you selected Work Order, you are given the option to edit/create
- any note/comment up to 21 lines long.
-
- ╔═════════════════════════════════════════════════════════════════════╗
- ║ Do you wish to add any comments to the Work Order? (Y/N) ■ ║
- ╚═════════════════════════════════════════════════════════════════════╝
-
-
- If you select Y (Yes) to the prompt, a simple text editor will appear
- at center screen. Remember to keep the comment to less than 21 lines...
- DAYO BO, TJS LAB Page: 13
-
-
-
- *** Note !!! Be sure to press Ctrl W to save and exit. Pressing Esc will only
- abort (lose) anything just typed in. ***
-
-
- ────────────────────────────[ WORK ORDER COMMENTS ]───────────────────────────
-
- Send The Yellow one as soon as possible!
-
-
-
-
-
-
- ──────────────────────────────────────────────────────────────────────────────
- Esc (Exit) Ctrl W (SAVE & Exit) F1 (Help) 2/1
-
-
-
- ■ DATABASE POSTING
-
- Database posting means the updating of all databases affected by the
- creation of an invoice. DAYO BO will post to 7 databases (depending on
- the type of invoice and configuration). The databases that get data posted
- to them are displayed on the top right of the screen, ie:
-
-
- ╔═[ Posting Progress ]════╗
- ║ Invoice Header ║
- ║ Invoice Detail ║
- ║ Inventory Database ║
- ║ Customer Database ║
- ║ Salesper Database ║
- ║ Serial Number Database ║
- ║ BackOrder Database ║
- ╚═════════════════════════╝
- DAYO BO, TJS LAB Page: 14
-
-
-
- Database Name File Name Fields Remarks
- ────────────────────── ──────────────── ────────────── ───────────────────
- Invoice Header INVOICE.DBF All
- Invoice Detail DETAIL.DBF All
- Inventory Database INV.DBF ONHAND Onhand quantity
- BO BackOrdered Quantity
- LASTDATE Date of Last Access
- SOLDPTD Period to Date Sold
- SOLDYTD Year to Date Sold
- Customer Database CUSTOMER.DBF ACTIVE
- LASTDATE Date of Last Access
- SALESPTD Period to Date Sales
- SALESYTD Year to Date Sales
- PAID_PURC Total Paid
- DUE Total Due
- Salesper Database SALESPER.DBF SALESPTD Period to Date Sales
- SALESYTD Year to Date Sales
- LASTDATE Date of Last Access
- Serial Number Database SERIALNO.DBF All If Any...
- BackOrder Database BO.DBF All QTY field is
- adjusted
-
-
-
- ■ ADD BO RECORD
-
- To add an item/record to the BackOrder database (DB.DBF), it is highly
- recommended that only DAYO POS be used (create an invoice). When, for
- whatever reason you deem it necessary to add one (by pressing Ctrl N),
- remember that the invoice number must match an invoice header record in the
- invoice header database (INVOICE.DBF).
-
-
-
- ■ DELETE BO RECORD
-
- Press Ctrl U to delete a BO record.
-
-
-
- ■ FIND (F5/F6/F7/F8)
-
-
- To find a BO item, utilize the F5, F6, F7, F8 keys. Note, the use of
- these keys sets the order/index of the displayed records
- DAYO BO, TJS LAB Page: 15
-
-
-
- ■ CUSTOMERS
-
- This menu option is a browse screen of the customer records. No editing
- of the database (CUSTOMER.DBF) is possible...
-
-
- DAYO Back Orders Version 3.0 TJS LAB CUSTOMER
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ BILL TO: SHIP TO: ║
- ║ INDIA MOLRY MOLRY'S STORE ║
- ║ PO BOX 382066 PO BOX 545556 ║
- ║ 3449 LAKEMONT DRIVE DOOR 39 ║
- ║ Lakemont, ST 55555-5555 Maryville, ST 55555-5555 ║
- ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
- ║ 1 REG TJ COD UPS GROUND ║
- ║ PHONE ATTN CREDIT LASTDATE ║
- ║ (800) 555-5555 Tom 394.56 01/20/90 ║
- ╚═══════════════════[ View/Browse the Customer Database ]════════════════════╝
- CUSTOMER NAME ATTN
- ───────────╥────────────────────────────────╥─────────────────────────────────
- 6741 ║ INDIA MOLRY ║
- 17901 ║ CCS SAVINGS AND LOAN ║
- 23662 ║ UNCLE SAM PINTO BEANS ║ JOSE
- 29673 ║ DAIRY ASSOCIATION ║ JOE
- 30345 ║ SALLEY MORGAN ║
- 31235 ║ HERMANS COMPUTER SHOP ║
- 34564 ║ HARPER TELEPHONES ║
- 34565 ║ MIC, INC ║ SHELLA JONES
- Esc (Exit) F1 (Help)
- Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code)
- 1/18
-
-
- ■ FIND (F5/F6/F7/F8)
-
-
- Utilize the F5, F6, F7, F8 keys to find a customer record. Note, the use
- of these keys sets the order/index of the displayed records.
- DAYO BO, TJS LAB Page: 16
-
-
- ■ CONFIGURATION
-
- DAYO BO configuration contains many configurable options that will
- hopefully make DAYO BO better able to meet your specific needs. There are
- 32+ DAYO BO configuration settings:
-
- Company Name Parallel Drawer Port
- Company Address Parallel Drawer Code
- Company Telephone Report Printer Type
- Auto Allocation Report Printer Port
- Auto Print Invoice Visual Indexing
- Last Invoice Number Auto Daily Indexing
- Invoice Printer Type Print Packing List
- Invoice Printer Port Packing List Port
- Invoice Copies Price on Packing List
- Allow Browse Edit Work Order Copies
- Use Credit Limit W.O. Printer Type
- Inventory Location W.O. Printer Port
- Customer Location W.O. Notes Phrase
- POS Location Open/Close Registers
- Cash Drawer Attached Default Comment
- Cash Drawer Com Port Color
- Parallel Cash Drawer High Intensity
- GL Database Location Automatic GL Posting
-
-
- ■ CONFIGURATION MENU
-
- The CONFIGURATION menu is a selection box that appears on the left side
- of the main menu screen, ie:
-
- DAYO Back Orders Version 3.0 TJS LAB CONFIG ┌───[February 1991]──┐
- ╔════════════════════════╗ │S M T W T F S │
- ║ CONFIGURATION ║╖ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
- ╟────────────────────────╢║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
- ║ Company Name ║╢ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
- ║ Company Address ║║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
- ║ Company Telephone ║╢ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
- ║ Auto Allocation ║║ ████▀ █░ █░ █░ ▀███▀ │29 30 │
- ║ Auto Print Invoice ║╢ │ │
- ║ Last Invoice Number ║║ └────────────────────┘
- ║ Invoice Printer Type ║╢
- ║ Invoice Printer Port ║║
- ║ Invoice Copies ║╢╓────────────────────────────────────────────────╖
- ║ Allow Browse Edit ║║║ DAYO BO STATISTICS Register Closed ║
- ║ Use Credit Limit ║╢╟────────────────────────────────────────────────╢
- ║ Inventory Location ║║║ DATABASE NAME RECORDS SIZE ║
- ║ Customer Location ║╝╟────────────────────────────────────────────────╢
- ║ POS Location ║ ║ INV.DBF Inventory 1 1K ║
- ║ Cash Drawer Attached ║ ║ INVOICE.DBF Invoice Header 0 1K ║
- ║ Cash Drawer Com Port ║ ║ DETAIL.DBF Invoice Detail 0 0K ║
- ║ Parallel Cash Drawer ║ ║ BACKORDER.DBF BackOrders 0 0K ║
- ║ Parallel Drawer Port ║ ║ CUSTOMER.DBF Customers 1 1K ║
- ╟────────────────────────╢ ║ REGISTER.LOG Register Log 90 8K ║
- ║ Select Option ║ ╚════════════════════════════════════════════════╝
- ╚════════════════════════╝
- DAYO BO, TJS LAB Page: 17
-
-
-
- To access any of the options (you can scroll down to others), highlight
- the option, then press Enter/Return.
-
- Before doing any invoicing, it is highly recommended that you read this
- section to get a better understanding of the meanings of every configuration
- setting. After determining how you wish to set/run DAYO BO, make the
- changes.
-
-
-
- ■ COMPANY NAME, ADDRESS & TELEPHONE
-
- Each field for these options is limited to 30 characters, 14 for the
- telephone...
-
-
- ┌──────────────────────────────[ COMPANY NAME ]─────────────────────────────┐
- │ Enter Your Company Name: YOUR COMPANY NAME HERE │
- └───────────────────────────────────────────────────────────────────────────┘
-
-
- ┌─────────────────────────────[ COMPANY ADDRESS ]───────────────────────────┐
- │ Address Line 1: Attn: Accounts Receivable │
- │ Address Line 2: P.O. BOX 55555 │
- │ City, State ZIP: ANYCITY, ST 55555-5555 │
- └───────────────────────────────────────────────────────────────────────────┘
-
-
- ┌────────────────────────────[ COMPANY TELEPHONE ]──────────────────────────┐
- │ Enter Your Company Telephone: 800-555-5555 │
- └───────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ AUTOMATICALLY PRINT THE INVOICE
-
- ┌──────────────[ AUTOMATICALLY PRINT INVOICES AFTER INVOICING ]──────────────┐
- │ If you want your invoices to automatically print after invoicing, then │
- │ change this option to Y (YES). │
- │ Default is to automatically print the invoices. │
- │ │
- │ Automatically Print Invoices? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 18
-
-
-
- ■ AUTOMATIC ALLOCATION
-
- ┌─────────────────────[ AUTOMATIC ALLOCATION & INVOICING ]───────────────────┐
- │ If this option is set to Y (YES), then no data entry prompts for │
- │ serial numbers will occur at the time of Allocation (filling/ │
- │ invoicing backorders). Backorders are filled, posted then invoices │
- │ printed! Default is NOT to Automatically Allocate Backorders. │
- │ │
- │ Automatically Allocate Backorders? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ LAST INVOICE NUMBER
-
- ┌──────────────────────────[ LAST INVOICE NUMBER ]───────────────────────────┐
- │ Enter Last Invoice Number: 4999 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ INVOICE PRINTER TYPE
-
- ┌──────────────────────────[ INVOICE PRINTER TYPE ]──────────────────────────┐
- │ There are 3 types of DAYO BO printed invoices: STANDARD, LASER, and │
- │ the DATA ONLY invoice. │
- │ The STANDARD invoice prints standard characters with headings. │
- │ The LASER invoice prints a special invoice onto a Hewlett Packard │
- │ compatible laser printer. │
- │ The DATA ONLY invoice is the same as the STANDARD with the exception │
- │ of the headings (for use with pre-printed forms). │
- │ │
- │ Enter Your Invoice Printer Type -> STANDARD │
- │ LASER │
- │ DATA ONLY │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ INVOICE PRINTER PORT
-
- ┌──────────────────────────[ INVOICE PRINTER PORT ]──────────────────────────┐
- │ Enter Your Invoice Printer Port (1,2,3): 1 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ INVOICE COPIES
-
- ┌───────────────────[ Number of Invoice Copies To Print ]────────────────────┐
- │ This option determines the number of invoice copies to print at the │
- │ time of invoicing. Default is to print one copy of the invoice. │
- │ │
- │ Enter Number of Invoice Copies: 1 │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 19
-
-
-
- ■ ALLOW BROWSE EDITING
-
- ┌─────────────────────────[ ALLOW BROWSE EDITING ]───────────────────────────┐
- │ To disable the editing of the BO Invoice Detail Records, select N (NO) │
- │ to this option. Default is to allow it. │
- │ │
- │ Allow Editing of BO Invoice Detail Records? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ USE CREDIT LIMIT
-
- ┌────────────────────────────[ USE CREDIT LIMIT ]────────────────────────────┐
- │ If you wish to place credit limits on your customers, then set this │
- │ option to Y (YES). Default is N (NO). If set to Y, then no 'Net' │
- │ sales/invoice can be made if that invoice amount plus the amount due │
- │ on other sales is greater than the customers credit limit. The credit │
- │ limit is the value of the LIMIT field in the customer database │
- │ (CUSTOMER.DBF). │
- │ │
- │ Limit Credit? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ INVENTORY DATABASE LOCATION
-
- ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐
- │ The location of the DAYO Inventory (INV.DBF) does not have to be in │
- │ the same drive/directory as DAYO BO. If you have installed DAYO Inventory │
- │ into a different directory, you need to tell DAYO BO where to find the │
- │ inventory database (INV.DBF). Default is nil (current directory). │
- │ Be sure to include the rightmost slash, ie: \DAYO\ │
- │ The drive designation is optional (if same as DAYO BO). │
- │ │
- │ Enter Location: \DAYOINV\ │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ CUSTOMER DATABASE LOCATION
-
- ┌─────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]───────────────────┐
- │ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │
- │ in the same drive/directory as DAYO BO. If you have installed the DAYO │
- │ Customer Database (CUSTOMER.DBF), into a different directory, you need │
- │ to tell DAYO BO 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 BO). │
- │ │
- │ Enter Location: \DAYOAR\ │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 20
-
-
-
- ■ POS DATABASE LOCATION
-
- For DAYO BO to function, it requires the use of the DAYO POS invoice
- databases (INVOICE.DBF & DETAIL.DBF) as well as the common databases (ie,
- TERMS, TYPE, TAXCODE, SHIPPER, REGISTER). If DAYO BO is not installed into
- the same drive/directory as DAYO POS, then insure that the location of DAYO
- POS is correctly entered:
-
- ┌─────────────────────[ POS DATABASE LOCATION/DIRECTORY ]────────────────────┐
- │ The location of the DAYO POS Invoice files (INVOICE.DBF & DETAIL.DBF) │
- │ does not have to be in the same drive/directory as DAYO BO. If you have │
- │ installed the DAYO POS Databases into a different directory, you need │
- │ to tell DAYO BO where to find them. Default is nil (current directory). │
- │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │
- │ The drive designation is optional (if same as DAYO BO). │
- │ │
- │ Enter Location: \DAYOPOS\ │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY
-
- ┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐
- │ The location of DAYO General Ledger Databases does not have to be │
- │ in the same drive/directory as this module. If you have installed DAYO GL │
- │ into a different directory, you need to tell this module where to find │
- │ the GL databases. Default is nil (current directory). │
- │ Be sure to include the rightmost slash, ie: \DAYOGL\ │
- │ The drive designation is optional (if same as this module). │
- │ │
- │ Enter Location: \DAYOGL\ │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ CURRENT DIRECTORY DATABASE LOCATION
-
- Note, this option is usually left empty...
-
- ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐
- │ This module's databases can be located in a different location other │
- │ than the current directory. If you have and wish to use ALL the │
- │ databases currently found in this directory from a different drive and │
- │ directory, then you need to tell this module where to find them. │
- │ Be sure to include the rightmost slash, ie: C:\DAYOBO\ │
- │ The drive designation is optional if same as this module. │
- │ │
- │ Enter Location: │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 21
-
-
-
- ■ CASH DRAWER
-
- ┌──────────────────────────────[ CASH DRAWER ]───────────────────────────────┐
- │ The default for DAYO BO is that a cash drawer is NOT attached. │
- │ The type of cash drawer that works with DAYO BO connects via the │
- │ serial port. It will open when a signal is sent to it via the │
- │ communications port (COM1:, COM2:, or COM3:). │
- │ Note, an error will occur if you set this to Y (Yes), and you │
- │ do not have a cash drawer attached. │
- │ │
- │ Do you have a cash drawer attached? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ CASH DRAWER SERIAL PORT
-
- ┌────────────────────────[ CASH DRAWER SERIAL PORT ]─────────────────────────┐
- │ Enter Your Cash Drawer Serial Port (1,2,3): 1 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
- ■ PARALLEL CASH DRAWER
-
- ┌──────────────────────────[ PARALLEL CASH DRAWER ]──────────────────────────┐
- │ The default for DAYO BO is that a parallel cash drawer is NOT attached. │
- │ The parallel cash drawer connects via the parallel/printer port: LPT1, │
- │ LPT2, or LPT3. It will open when a signal (Setup Code), is sent to it │
- │ at invoice time. │
- │ Note, an error will occur if you set this to Y (Yes), and you │
- │ do not have a cash drawer attached, or have it off/offline. │
- │ │
- │ Do you have a parallel cash drawer attached? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ PARALLEL CASH DRAWER PORT
-
- ┌───────────────────────[ PARALLEL CASH DRAWER PORT ]────────────────────────┐
- │ Enter Your Cash Drawer Parallel Port (1,2,3): 1 │
- └────────────────────────────────────────────────────────────────────────────┘
-
- DAYO BO, TJS LAB Page: 22
-
-
-
- ■ PARALLEL CASH DRAWER SETUP CODE
-
- ┌────────────────────[ PARALLEL CASH DRAWER SETUP CODE ]─────────────────────┐
- │ If you have a parallel cash drawer, it is required that some character │
- │ string (setup code), be sent as a signal to the cash drawer instructing │
- │ it to open. When entering the setup code, you must enter a valid │
- │ character string in the format: 'OPEN SAYS ME' or 'CHR(1)+CHR(1)' │
- │ Check your cash drawer manual for the correct Setup Code! │
- │ │
- │ Enter Your Cash Drawer Parallel Setup Code On The Next Line: │
- │ Setup Code: CHR(1)+CHR(1) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ 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 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ VISUAL INDEXING
-
- ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐
- │ If you desire to see a progress graph each time your indexes are │
- │ created, then select Y (YES). Note, the process can slow the indexing │
- │ routine down; especially with larger databases. │
- │ │
- │ Do you wish to have Visual Indexing? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 23
-
-
-
- ┌──────────────────────────────────────────────────────────┐
- │ Database Name: DETAIL.DBF │
- │ Index Name: DETITEM.NTX │
- │ Number of Records: 394 │
- │ ┌──────────────────────────────────────────────────┐ │
- │ │████████████████████████████████████████ │ │
- │ └──────────────────────────────────────────────────┘ │
- │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
- └──────────────────────────────────────────────────────────┘
-
-
-
- ■ AUTOMATIC DAILY INDEXING
-
- ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐
- │ If this option is set to Y (YES), then all DAYO Indexes accessed by │
- │ DAYO BO will be recreated once daily. This will occur when the first │
- │ DAYO BO program is run. The default is to recreate all the indexes. │
- │ │
- │ Recreate all DAYO BO Indexes? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
- The DAYO Indexing program (DAYOX) was created for this purpose.
-
-
-
- ■ AUTO PRINT PACKING LIST
-
- ┌────────────[ AUTOMATICALLY PRINT PACKING LIST AFTER INVOICING ]────────────┐
- │ If you want a packing list to print automatically after invoicing, then │
- │ change this option to Y (YES). │
- │ Default is not to print packing lists. │
- │ │
- │ Automatically Print Packing Lists? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ PACKING LIST PRINTER PORT
-
- ┌───────────────────────[ PACKING LIST PRINTER PORT ]────────────────────────┐
- │ Enter Your Packing List Printer Port (1,2,3): 1 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ PRINT PRICE ON PACKING LIST
-
- ┌────────────────────[ PRINT PRICE ON THE PACKING LIST ]─────────────────────┐
- │ If you want to print the PRICE on the packing list, the set this option │
- │ to Y (YES). Default is NOT to print the price on the packing lists. │
- │ │
- │ Print Price On The Packing List? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 24
-
-
-
- ■ WORK ORDER COPIES
-
- ┌──────────────────[ Number of Work Order Copies To Print ]──────────────────┐
- │ This option determines the number of Work Order copies to print at the │
- │ time of invoicing. Default is to print one copy of the work order. │
- │ │
- │ Enter Number of Work Order Copies: 1 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ WORK ORDER PRINTER TYPE
-
- ┌────────────────────────[ WORK ORDER PRINTER TYPE ]─────────────────────────┐
- │ Work Orders are printed according to this selection. │
- │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │
- │ The LASER printer type is a Hewlett Packard Laser compatible printer. │
- │ Special Laser codes are sent to the LASER option. │
- │ │
- │ Enter Your Work Order Printer Type -> STANDARD │
- │ LASER │
- │ PREPRINTED │
- │ │
- │ │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ WORK ORDER PRINTER PORT
-
- ┌────────────────────────[ WORK ORDER PRINTER PORT ]─────────────────────────┐
- │ Enter Your Work Order Printer Port (1,2,3): 1 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ WORK ORDER NOTES PHRASE
-
- ┌─────────────────────────[ WORK ORDER NOTE PHRASE ]─────────────────────────┐
- │ This 'Phrase' or 'Leading Comment' is printed at the beginning of all │
- │ Work Order Notes/Comments. Examples are 'Shipping Instructions:', │
- │ 'Notes:' or 'Special Instructions:' │
- │ Default is not to print anything! │
- │ │
- │ Enter Work Order Notes Phrase: Shipping Instructions: │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 25
-
-
- ■ USE REGISTERS
-
- ┌──────────────────────────[ OPEN/CLOSE REGISTERS ]──────────────────────────┐
- │ This option determines whether the prompt to open and/or close the │
- │ registers is activated. Default (Yes) is to require that you │
- │ open/close the registers. │
- │ │
- │ Open/Close Registers? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
- ■ DEFAULT COMMENT
-
- ┌────────────────────────────[ DEFAULT COMMENT ]─────────────────────────────┐
- │ This comment is printed onto every Invoice and Work Order. │
- │ │
- │ Enter Default Comment: Thank You! │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ AUTOMATIC GL POSTING
-
- This Configuration routine was added to allow you to post your
- transactions (ie: Invoice Posting, Cash Receipts, and Credit Memos),
- automatically into General Ledger (GL). If this option is set to 'Y' (Yes),
- each time you adjust or edit key accounting fields (ie: COST, AMOUNT,
- SUBTOTAL, FREIGHT, ADJUST, QTY...), a GL transaction records will be created.
-
- This routine includes an option to browse, edit, add, and/or delete
- records in the General Ledger Class Code Table/Database (GLCLASS.DBF).
-
- ╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗
- ║ If you are using General Ledger (GL), you can automatically update ║
- ║ or create GL transactions every time you make an accounting adjustment. ║
- ║ ║
- ║ Do you want Automatic GL Posting? (Y/N) ║
- ║ ║
- ║ Default CLASS Code: INV Name: INVENTORY ADJUSTMENT ║
- ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║
- ║ Database: INVADJ.DBF Field: COST*QTY ║
- ╟─────────────[ SELECT DEFAULT ACCOUNTS RECEIVABLE CLASS CODE ]──────────────╢
- ║ CLASS NAME DEBIT CREDIT ║
- ║──────────╥────────────────────────────────╥──────────────╥─────────────────║
- ║ AR ║ Invoice Freight *** ║ 10000-000000 ║ 40000-000000 ║
- ║ AR ║ 1st Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║
- ║ AR ║ 2nd Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║
- ║ AR ║ Invoice Paid/Collected *** ║ 10000-000000 ║ 40000-000000 ║
- ║ REC ║ RECIPTS INTO INVENTORY ║ 91000-000000 ║ 20000-000000 ║
- ║ INV ║ INVENTORY ADJUSTMENT ║ 91000-000000 ║ 11000-000000 ║
- ║ AR ║ RECEIPTS ║ 10000-000000 ║ 20000-000000 ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
- Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE)
- DAYO BO, TJS LAB Page: 26
-
-
-
- ■ EDIT CLASS CODE RECORD
-
- Press 'F2' to edit a Class Code record. Note, valid entries are crucial
- to making this posting process work correctly...
-
- ╔═════════════════════════[ EDIT CLASS CODE RECORD ]═════════════════════════╗
- ║ CLASS Code: INV ║
- ║ Name: INVENTORY ADJUSTMENT ║
- ║ Debit Account: 11000-000000 ║
- ║ Credit Account: 10000-000000 ║
- ║ Database (.DBF): INVADJ.DBF ║
- ║ Field: COST*QTY ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit)
-
-
-
- ■ ADD NEW CLASS CODE RECORD
-
- Press 'Ctrl N' to add a new CLASS code record.
-
- ╔═══════════════════════[ ADD NEW CLASS CODE RECORD ]════════════════════════╗
- ║ CLASS Code: ║
- ║ Name: ║
- ║ Debit Account: 00000-000000 ║
- ║ Credit Account: 00000-000000 ║
- ║ Database (.DBF): INVADJ.DBF ║
- ║ Field: ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit)
- DAYO BO, TJS LAB Page: 27
-
-
-
- ■ FIND CLASS CODE
-
-
- Use the 'F5' through 'F9' keys to locate a desired CLASS code record
-
-
- Press 'F5' to locate a CLASS code record based on the CLASS field, ie:
-
- ┌─────────────────────────────────────────────────────────────┐
- │ Enter CLASS+DATABASE: │
- └───────────────────────────────────────────────────TJS LAB───┘
-
-
- Press 'F6' to locate a CLASS code record based on the DEBIT field, ie:
-
- ┌─────────────────────────────────────────────────────────────┐
- │ Enter DEBIT: 30000-200000 │
- └───────────────────────────────────────────────────TJS LAB───┘
-
-
- Press 'F7' to locate a CLASS code record based on the CREDIT field, ie:
-
- ┌─────────────────────────────────────────────────────────────┐
- │ Enter CREDIT: 10000-200000 │
- └───────────────────────────────────────────────────TJS LAB───┘
-
-
- Press 'F8' to locate a CLASS code record based on the NAME field, ie:
-
- ┌─────────────────────────────────────────────────────────────┐
- │ Enter NAME: │
- └───────────────────────────────────────────────────TJS LAB───┘
-
-
- Press 'F9' to locate a CLASS code record based on the DATABASE field, ie:
-
- ┌─────────────────────────────────────────────────────────────┐
- │ Enter DATABASE: │
- └───────────────────────────────────────────────────TJS LAB───┘
-
- DAYO BO, TJS LAB Page: 28
-
-
-
- ■ COLOR MONITOR
-
- ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
- │ If you have a color monitor and wish to display colors, then select Y, │
- │ (YES), else select N (NO) for monochrome and others. │
- │ The default is color, high intensity │
- │ │
- │ Do you have a color monitor? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ COLOR INTENSITY
-
- ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
- │ Intensity is only applicable with color set to Y. │
- │ It will make your colors brighter... │
- │ │
- │ Set Color Intensity On? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO BO, TJS LAB Page: 29
-
-
-
- ■ REPORTS
-
-
- The REPORTS menu contains 5 reports, many with different options and a
- printer setup/driver routine. Note that other reports can be created using
- dBase III+/IV as well as other compatible report writers. Use the DAYO POS
- module to print out Register Reports. The MISC Routines even has the LIST
- function in it that allows the creation of simple lists/reports...
-
- All the reports can be printed to the printer, or to a text/ASCII file.
-
-
- The Reports menu:
-
- ╔═════════════════════════════╗
- ║ DAYO BACK ORDER REPORTS ║
- ║ Allocation Report ║
- ║ Back Order Report ║
- ║ Inventory Reset & Report ║
- ║ Customer Address Labels ║
- ║ Config Status ║
- ║ Printer Setup ║
- ║ SELECT REPORT ║
- ╚═════════════════════════════╝
-
-
-
- The Allocation, BackOrder, and the Inventory (BO) Reports all use a
- 'report form'. These report forms all have the extension of '.FRM', and are
- dBase (tm) compatible.
-
-
- Report Form Uses
- Name Database
- ────────────── ───────────────
- ALLOCATE.FRM ALLOCATE.DBF
-
- BO.FRM BO.DBF
- CUSTOMER.DBF
- INVOICE.DBF
-
- BORESET.FRM BO.DBF
- INV.DBF
-
- DAYO BO, TJS LAB Page: 30
-
-
-
- ■ ALLOCATION REPORT
-
-
- ╔═══════════════════════════════════════════════════════╗
- ║The Allocation Report lists all BackOrdered items ║
- ║that were allocated/'filled' during the last ║
- ║Allocation Process. Uses Report Form: ALLOCATE.FRM ║
- ║ ║
- ║Select Index -> INVOICE+ITEM ║
- ║ ║
- ║Send Output to Printer? (Y/N) ( No -> To File) ║
- ║ ║
- ║Enter File Name: ALLOCATE.TXT ║
- ║ ║
- ║Enter Report Title: TJS LAB ║
- ║ ║
- ╚═══════════════════════════════════════════════════════╝
-
-
-
-
- ■ BACK ORDER REPORT
-
- This report has the option to all BackOrders, or for a specific customer.
-
- ╔═══════════════════════════════════════════════════════╗
- ║The Detail Back Order Report lists all BackOrdered ║
- ║items that exist in the BackOrder Database (BO.DBF). ║
- ║Uses Report Form: BO.FRM. ║
- ║ ║
- ║Print Entire Report... ║
- ║ ║
- ║Select Index -> ITEM ║
- ║ ║
- ║Send Output to Printer? (Y/N) ( No -> To File) ║
- ║Enter File Name: BO.TXT ║
- ║ ║
- ║Enter Report Title: TJS LAB ║
- ╚═══════════════════════════════════════════════════════╝
- DAYO BO, TJS LAB Page: 31
-
-
-
- ■ INVENTORY BACKORDER RESET & REPORT
-
- This report routine can optionally reset/recalculate the BO (back order)
- field in the inventory database (INV.DBF). It is recommended that this option
- be run anytime there is a question about the accuracy of the BO field.
-
- ╔═══════════════════════════════════════════════════════╗
- ║The Inventory BackOrder Reset & Report will ║
- ║optionally reset the BackOrder field (BO) in the ║
- ║Inventory database (INV.DBF), then print a list ║
- ║containing all inventory line items that have ║
- ║Sales Order BackOrders ( BO > 0 ). ║
- ║Uses Report Form: BORESET.FRM. ║
- ║ ║
- ║Will reset the BackOrder field! ║
- ║ ║
- ║Send Output to Printer? (Y/N) ( No -> To File) ║
- ║Enter File Name: BORESET.TXT ║
- ║ ║
- ║Enter Report Title: TJS LAB ║
- ║ ║
- ║Inventory File Zero Reset Process (Pass 1) ║
- ║╞█████████████████████████████████████████████████████╡║
- ║ ║
- ║Inventory File BackOrder Reset Process (Pass 2) ║
- ║╞███████████████████████████████████══════════════════╡║
- ╚═══════════════════════════════════════════════════════╝
-
-
-
- ■ CUSTOMER SHIP TO ADDRESS LABELS
-
- This report option prints out labels containing the Ship To address of
- the customer/client. Find the customer/client you want to create a label for,
- then press Enter/Return. Press Enter/Return for as many labels you desire.
- To assist you in locating a customer/client, the FIND function keys F5, F6,
- F7, and F8 are available.
-
- ╔═══════════════════════════════════════════════════════╗
- ║Use this option to print the Customer SHIP TO address ║
- ║Labels. The Address Label is the standard size of ║
- ║ 3.5x15/16, 6LPI, and contains the following fields: ║
- ║ SHIPNAME SHIPPADDR1 SHIPADDR2 ║
- ║ SHIPCITY SHIPSTATE SHIPZIP ║
- ║ ║
- ║ ┌──────────────────────────────┐ ║
- ║ │JOSE L MARTINEZ │ ║
- ║ │90 VEEGE │ ║
- ║ │MEXICO CITY, MEXICO │ ║
- ║ │ │ ║
- ║ │ │ ║
- ║ ╘══════════════════════════════╛ ║
- ║ CUSTOMER ║
- ║Select Customer -> 3444 ║
- ║ 3445 ║
- ║ 3446 ║
- ║Esc (Exit) Enter/Return (Print) F5/F6/F7/F8 (Find) ║
- ╚═══════════════════════════════════════════════════════╝
- DAYO BO, TJS LAB Page: 32
-
-
-
- ■ DATABASE STATUS REPORT
-
- This report prints out the structure, number of records and sizes of
- all major DAYO BO database. This report does not use a report form. Like the
- TEMPLATE Report, this one only gives you the option to print to the printer
- or to a disk file, ie:
-
-
- ╔═══════════════════════════════════════════════════════╗
- ║The Database Status Report lists the DAYO BO ║
- ║databases with their current fields, sizes and number ║
- ║of records. Index files included. Not a Report Form. ║
- ║ ║
- ║Send Output to Printer? (Y/N) ( No -> To File) ║
- ║ ║
- ║Enter File Name: DATABASE.TXT ║
- ╚═══════════════════════════════════════════════════════╝
-
-
-
- An example of a Database Status Report follows. Note, only one database
- is listed (there are more!):
-
-
-
- ++++++++++++++++++++++++
- + DAYO DATABASE REPORT +
- ++++++++++++++++++++++++
- 12/28/89
- 22:14:39
-
-
- Inventory Database: \DAYOINV\INV.DBF
- Number of Records: 74
- File Size: 13,138
- FIELD NAME TYPE LENGTH DECIMALS
- ============ ==== ====== ========
- ITEM C 12 0
- DESC C 30 0
- ONHAND N 7 0
- ONORDER N 7 0
- SOLDPTD N 7 0
- SOLDYTD N 7 0
- VENDITEM C 12 0
- VENDOR C 10 0
- DATE D 8 0
- LASTDATE D 8 0
- COST N 10 2
- RETAIL N 10 2
- PRICE N 10 2
- STOCKLEVEL N 7 0
- DAYO BO, TJS LAB Page: 33
-
-
- Database Status Report Continuation...
-
-
-
- TYPE C 3 0
- CLASS C 3 0
- TAXABLE L 1 0
- SERIALNO L 1 0
- WEIGHT N 8 2
- UNIT C 3 0
- LOCATION C 3 0
- ======
- 167
-
- Index Files: INV.NTX Index Key: ITEM
- DESC.NTX Index Key: DESC
- VENDOR.NTX Index Key: VENDOR
- VENDITEM.NTX Index Key: VENDITEM
- INVTYPE.NTX Index Key: TYPE
-
-
-
- ■ CONFIGURATION STATUS REPORT
-
- The Configuration Status Report is just a list of the current
- configuration settings. It is not a report form. The only option is to print
- it to a printer or to a disk file, ie:
-
-
- ╔═══════════════════════════════════════════════════════╗
- ║The Configuration Status Settings Report lists all of ║
- ║configuration settings (found in file DAYOBO.CFG). ║
- ║This is Not a Report Form. ║
- ║ ║
- ║Send Output to Printer? (Y/N) ( No -> To File) ║
- ║ ║
- ║Enter File Name: CONFIG.TXT ║
- ╚═══════════════════════════════════════════════════════╝
- DAYO BO, TJS LAB Page: 34
-
-
-
- ++++++++++++++++++++++++++++++++++++++++++
- + DAYO BACK ORDER CONFIGURATION REPORT +
- ++++++++++++++++++++++++++++++++++++++++++
- 04/07/90
- 20:57:20
-
-
- Company Name: YOUR COMPANY, INC
- Address Line 1: Attn: Accounts Receivable
- Address Line 2: P.O. BOX 5555
- City, State Zip: ANYCITY, ST 55555-5555
- Telephone: 800-555-5555
- Auto Allocation: No
- Auto Print Invoice: Yes
- Last Invoice Number: 0
- Invoice Printer Type: STANDARD
- Invoice Printer Port: LPT1
- Number of Invoice Copies: 1
- Default Tax Code: 1
- Default Invoice Type: STANDARD
- Allow Negative Onhand: No
- Allow Editing In Browse: Yes
- Use Credit Limits: Yes
- Inventory Database Location:
- Customer Database Location:
- POS Database Location:
- Serial Cash Drawer Attached: No
- Serial Cash Drawer Com Port: COM1
- Parallel Cash Drawer: No
- Parallel Cash Drawer Port: LPT1
- Parallel Cash Drawer Code: CHR(1)+CHR(1)
- Report Printer Type: LASER PRINTER
- Report Printer Port: LPT1
- Visual Indexing: Yes
- Automatically Reindex Daily: Yes
- Auto Print Packing List: No
- Packing List Printer Port: LPT1
- Color: Yes
- High Intensity: Yes
-
- DAYO BO, TJS LAB Page: 35
-
-
-
- ■ PRINTER DRIVER (SETUP)
-
- This routine was added to preclude you from having to get out of your
- seat to change (mess with) the printer to get it to print correctly.
-
- The most important printer selections (ie: font size, lines per inch,
- orientation, ...) are made easy to evoke.
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
- ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
- ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
- ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
- ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
- ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
- ║ ║
- ║ Select Option -> Eject ║
- ║ Line feed ║
- ║ Normal Size ║
- ║ Use this routine to set your Small/Condensed ║
- ║ printer up with one or more Bold On ║
- ║ of the setup strings and Bold Off ║
- ║ commands listed to the right. 6 Lines per Inch ║
- ║ 8 Lines per Inch ║
- ║ Select the 'Change Printer Print Landscape (Laser Only) ║
- ║ Default' option to change Print Portrait (Laser Only) ║
- ║ printer types. Reset Printer ║
- ║ Current printer is set to: Print Special String 1 ║
- ║ Okidata Print Special String 2 ║
- ║ Print Special String 3 ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- Esc (Exit)
-
-
-
- ■ PRINTER DRIVER OPTIONS
-
- There are 18 printer driver options to select from. The last option is
- to set the default printer, and the next to last is a 'SHELL' function that
- runs a DOS command or program. The remainder are strings/codes that are sent
- to the printer.
-
-
- Eject Print Portrait (Laser Only)
- Line feed Reset Printer
- Normal Size Print Special String 1
- Small/Condensed Print Special String 2
- Bold On Print Special String 3
- Bold Off Print Special String 4
- 6 Lines per Inch Print Special String 5
- 8 Lines per Inch Run DOS Command/Program
- Print Landscape (Laser Only) Change Default Printer
- DAYO BO, TJS LAB Page: 36
-
-
-
- ■ CHANGE DEFAULT PRINTER
-
- The last option is to change/set the default printer. This printer
- driver routine comes with 4 default printer types, Epson, HP Laser, Star,
- and Okidata.
-
- You can add (Ctrl N) as many as you want.
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
- ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
- ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
- ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
- ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
- ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
- ╟────────────────────────────────────────────────────────────────────────────╢
- ║ Current Default Printer is set to: Okidata ║
- ╟────────────────────────────────────────────────────────────────────────────╢
- ║ NAME LINEFEED ║
- ║─────────────────────────────────────╥──────────────────────────────────────║
- ║ Epson & Compatibles ║ CHR(10) ║
- ║ HP Laser & Compatibles ║ CHR(10) ║
- ║ Star Micro Gemini ║ CHR(10) ║
- ║ Okidata ║ CHR(10) ║
- ║ ║ ║
- ║ ║ ║
- ║ ║ ║
- ║ ║ ║
- ║ ║ ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
- 1/4
- DAYO BO, TJS LAB Page: 37
-
-
-
- ■ FULL SCREEN EDIT - F2
-
-
- When entering the printer codes, the string must be in the valid format
- or it will not be printed later when requested...
-
- ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
- │ NAME: Epson & Compatibles │
- │ LINEFEED: CHR(10) │
- │ NORMAL: CHR(27)+CHR(18) │
- │ SMALL: CHR(27)+CHR(15) │
- │ BOLDON: CHR(27)+CHR(69) │
- │ BOLDOFF: CHR(27)+CHR(70) │
- │ _6LPI: CHR(27)+CHR(50) │
- │ _8LPI: CHR(27)+CHR(48) │
- │ PORTRAIT: │
- │ LANDSCAPE: │
- │ RESET: CHR(27)+CHR(64) │
- │ SPEC_STR1: │
- │ SPEC_STR2: │
- │ SPEC_STR3: │
- │ SPEC_STR4: │
- │ SPEC_STR5: │
- │ RUN_CMD: │
- │ │
- │ │
- └────────────────────────────────────────────────────────────────────────────┘
- Press Esc to Abort, PgUp/PgDn to Save and Exit
-
-
-
- ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
-
- NAME - Name of printer. Type in anything you wish here
- LINEFEED - Code to advance printer one line
- NORMAL - Normal font/character size
- SMALL - Small font/character size
- BOLDON - Bold/Emphasized
- BOLDOFF - Bold/Emphasized off
- _6LPI - Code to set printer to print 6 lines per inch
- _8LPI - Code to set printer to print 8 lines per inch
- PORTRAIT - Code to set laser printer to print upright (normal)
- LANDSCAPE - Code to set laser printer to print sideways
- RESET - Reset printer code
- SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
- SPEC_STR2 - print very tiny, ...
- SPEC_STR3 - "
- SPEC_STR4 - "
- SPEC_STR5 - "
- RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
- DAYO BO, TJS LAB Page: 38
-
-
-
- ■ 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:
-
- ┌──────────────────────[ DAYOBO 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:
-
- ┌───────────────────────[ DAYOBO 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 BO, TJS LAB Page: 39
-
-
-
- - Editor help:
-
- ┌──────────────────────[ DAYOBO 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 BO, TJS LAB Page: 40
-
-
-
- ■ 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 Back Orders Version 3.0 TJS LAB
- ┌──────[ DAYO HELP Called by Program: DAYOBO 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 DAYOBO. ║ │
- │ ║ ║ │
- │ ║ ║ │
- │ ║ 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 BO, TJS LAB Page: 41
-
-
-
- DAYO Back Orders Version 3.0 TJS LAB ┌───[February 1991]──┐
- ┌───────[ DAYO HELP Called by Program: DAYOBO 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, DAYOBO.DOC.
- Press F1 in the User Defined & Inputted Help Message screen to display the
- document (user manual). The special keys in this option are displayed in the
- Help Screen (press F1 again) for this option:
-
-
- ╔══════════════════════════════════════════════════════════════════════════╗
- ║ While viewing the document for DAYOPAY the keyboard is configured ║
- ║ as followed: ║
- ║ ║
- ║ Esc Exit ║
- ║ F5 Find a string. This search is not case sensitive ║
- ║ Examples: PAGE: 50 ║
- ║ INTRODUCTION ║
- ║ REPORTS ║
- ║ Home Return to the beginning of the document ║
- ║ End Go to the bottom of the document ║
- ║ PgUp Page up ║
- ║ ║
- ║ Any other key moves acts like PgDn (page down) ║
- ║ ║
- ║ Press any key to continue... ║
- ╚══════════════════════════════════════════════════════════════════════════╝
- DAYO BO, TJS LAB Page: 42
-
-
-
- ■ DATABASE STRUCTURE
-
-
- Database: BO.DBF
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 INVOICE Numeric 6 1 6
- 2 ITEM Character 12 7 18
- 3 DESC Character 30 19 48
- 4 QTY Numeric 7 49 55
- 5 PRICE Numeric 10 2 56 65
- 6 COST Numeric 10 2 66 75
- 7 TAXABLE Logical 1 76 76
- 8 DATE Date 8 77 84
- 9 PAY Logical 1 85 85
- 10 TIME Character 8 86 93
- ─────
- Total 94
-
-
-
- DAYO BO, TJS LAB Page: 43
-
-
-
- Database: CUSTOMER.DBF
-
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 CUSTOMER Numeric 6 1 6
- 2 NAME Character 30 7 36
- 3 ATTN Character 30 37 66
- 4 ADDR1 Character 30 67 96
- 5 ADDR2 Character 30 97 126
- 6 CITY Character 22 127 148
- 7 STATE Character 2 149 150
- 8 ZIP Character 10 151 160
- 9 SHIPNAME Character 30 161 190
- 10 SHIPADDR1 Character 30 191 220
- 11 SHIPADDR2 Character 30 221 250
- 12 SHIPCITY Character 22 251 272
- 13 SHIPSTATE Character 2 273 274
- 14 SHIPZIP Character 10 275 284
- 15 PHONE Character 14 285 298
- 16 SALESPER Character 3 299 301
- 17 TAXRATE Numeric 5 3 302 306
- 18 TERMS Character 20 307 326
- 19 SHIPPER Character 20 327 346
- 20 DATE Date 8 347 354
- 21 LASTDATE Date 8 355 362
- 22 TYPE Character 3 363 365
- 23 CLASS Character 3 366 368
- 24 PBM Numeric 6 3 369 374
- 25 PBL Numeric 6 3 375 380
- 26 SALESPTD Numeric 10 2 381 390
- 27 SALESYTD Numeric 10 2 391 400
- 28 DUE Numeric 10 2 401 410
- 29 PAID_PURC Numeric 10 2 411 420
- 30 LIMIT Numeric 10 2 421 430
- 31 ACTIVE Logical 1 431 431
- ─────
- Total 432
- DAYO BO, TJS LAB Page: 44
-
-
-
- Database: INVOICE.DBF
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 INVOICE Numeric 6 1 6
- 2 CUSTOMER Numeric 6 7 12
- 3 SHIPNAME Character 30 13 42
- 4 SHIPADDR1 Character 30 43 72
- 5 SHIPADDR2 Character 30 73 102
- 6 SHIPCITY Character 17 103 119
- 7 SHIPSTATE Character 2 120 121
- 8 SHIPZIP Character 10 122 131
- 9 PHONE Character 14 132 145
- 10 TYPE Character 3 146 148
- 11 TERMS Character 20 149 168
- 12 SHIPPER Character 20 169 188
- 13 DATE Date 8 189 196
- 14 TIME Character 8 197 204
- 15 REG Character 3 205 207
- 16 BY Character 30 208 237
- 17 SALESPER Character 3 238 240
- 18 CUST_PO Character 15 241 255
- 19 TAXRATE Numeric 5 3 256 260
- 20 TAXES Numeric 10 2 261 270
- 21 ADJUST Numeric 10 2 271 280
- 22 FREIGHT Numeric 10 2 281 290
- 23 SUBTOTAL Numeric 10 2 291 300
- 24 OPEN Logical 1 301 301
- 25 PAID Numeric 10 2 302 311
- 26 COMMENT Character 50 312 361
- 27 PRINTED Logical 1 362 362
- 28 BO Numeric 6 363 368
- 29 SC Logical 1 369 369
- ─────
- Total 370
-
-
-
- Database: DETAIL.DBF
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 INVOICE Numeric 6 1 6
- 2 ITEM Character 12 7 18
- 3 DESC Character 30 19 48
- 4 QTY Numeric 7 49 55
- 5 PRICE Numeric 10 2 56 65
- 6 COST Numeric 10 2 66 75
- 7 TAXABLE Logical 1 76 76
- 8 DATE Date 8 77 84
- 9 CLASS Character 3 85 87
- ─────
- Total 88
- DAYO BO, TJS LAB Page: 45
-
-
- Database: INV.DBF
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 ITEM Character 12 1 12
- 2 DESC Character 30 13 42
- 3 ONHAND Numeric 7 43 49
- 4 ONORDER Numeric 7 50 56
- 5 BO Numeric 7 57 63
- 6 SOLDPTD Numeric 7 64 70
- 7 SOLDYTD Numeric 7 71 77
- 8 VENDITEM Character 12 78 89
- 9 VENDOR Character 10 90 99
- 10 DATE Date 8 100 107
- 11 LASTDATE Date 8 108 115
- 12 COST Numeric 10 2 116 125
- 13 RETAIL Numeric 10 2 126 135
- 14 PRICE Numeric 10 2 136 145
- 15 STOCKLEVEL Numeric 7 146 152
- 16 TYPE Character 3 153 155
- 17 CLASS Character 3 156 158
- 18 TAXABLE Logical 1 159 159
- 19 SERIALNO Logical 1 160 160
- 20 WEIGHT Numeric 8 2 161 168
- 21 UNIT Character 3 169 171
- 22 LOCATION Character 3 172 174
- ───── ────────── ───────── ───── ─── ───── ───
- Total 175
-
-
-
- Database: REGISTER.DBF
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 OPEN Logical 1 1 1
- 2 OPENDATE Date 8 2 9
- 3 OPENTIME Character 8 10 17
- 4 CLOSEDATE Date 8 18 25
- 5 CLOSETIME Character 8 26 33
- 6 STARTSUM Numeric 10 2 34 43
- 7 ENDSUM Numeric 10 2 44 53
- 8 BY Character 30 54 83
- ─────
- Total 84
- DAYO BO, TJS LAB Page: 46
-
-
-
- Database: REGISTER.LOG
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 REGISTER Numeric 3 1 3
- 2 OPENCLOSE Character 1 4 4
- 3 OPENDATE Date 8 5 12
- 4 OPENTIME Character 8 13 20
- 5 CLOSEDATE Date 8 21 28
- 6 CLOSETIME Character 8 29 36
- 7 STARTSUM Numeric 10 2 37 46
- 8 ENDSUM Numeric 10 2 47 56
- 9 BY Character 30 57 86
- ─────
- Total 87
-
-
-
- Database: SERIALNO.DBF
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 ITEM Character 12 1 12
- 2 INVOICE Numeric 6 13 18
- 3 SERIALNO Character 30 19 48
- 4 CUSTOMER Numeric 6 49 54
- 5 DATE Date 8 55 62
- ─────
- Total 63
-
- DAYO BO, TJS LAB Page: 47
-
-
-
- ■ DATA DICTIONARY
-
- Field Name Type Len Dec Database Description/Comments
- ────────── ──── ─── ─── ──────────── ──────────────────────────────────
- ACTIVE L 1 0 CUSTOMER.DBF Denotes customer as being Active
- ADDR1 C 30 0 CUSTOMER.DBF Customer Bill To address line 1
- ADDR2 C 30 0 CUSTOMER.DBF Customer Bill To address line 2
- ADJUST N 10 2 INVOICE.DBF Amount of Adjustment ($)
- ATTN C 30 0 CUSTOMER.DBF Customer contact (POC) name
- BO N 6 0 INVOICE.DBF Original Invoice number
- BO N 7 0 INV.DBF BackOrdered quantity
- BY C 30 0 REGISTER.LOG User responsible for opening or
- REGISTER.DBF closing the register
- INVOICE.DBF User that created the invoice
- CITY C 22 0 CUSTOMER.DBF Customer Bill To city
- CLASS C 3 0 INV.DBF Items classification
- CUSTOMER.DBF Customers classification
- CLOSEDATE D 8 0 REGISTER.LOG Date register closed
- REGISTER.DBF
- CLOSETIME C 8 0 REGISTER.DBF Time register closed
- REGISTER.LOG
- COMMENT C 50 0 INVOICE.DBF Comment to appear onto the
- invoice when it is printed
- COST N 10 2 INV.DBF Cost (from Vendor) of an item
- DETAIL.DBF
- BO.DBF
- CUSTOMER N 6 0 SERIALNO.DBF Customer number
- INVOICE.DBF
- CUSTOMER.DBF
- CUST_PO C 15 0 INVOICE.DBF Customers Purchase Order number
- DATE D 8 0 DETAIL.DBF Date record was created
- SERIALNO.DBF
- INV.DBF
- BO.DBF
- INVOICE.DBF
- CUSTOMER.DBF
- DESC C 30 0 BO.DBF Description of an item
- DETAIL.DBF
- INV.DBF
- DUE N 10 2 CUSTOMER.DBF Amount the customer owes your
- company (Accounts Receivable)
- ENDSUM N 10 2 REGISTER.LOG Closing total of dollars received
- REGISTER.DBF into a register
- FREIGHT N 10 2 INVOICE.DBF Amount of freight charged ($)
- DAYO BO, TJS LAB Page: 48
-
-
-
- ■ DATA DICTIONARY
-
- Field Name Type Len Dec Database Description/Comments
- ────────── ──── ─── ─── ──────────── ──────────────────────────────────
- INVOICE N 6 0 INVOICE.DBF Invoice Number
- SERIALNO.DBF
- BO.DBF
- DETAIL.DBF
- ITEM C 12 0 INV.DBF Product/Part/Item number
- BO.DBF
- DETAIL.DBF
- SERIALNO.DBF
- LASTDATE D 8 0 CUSTOMER.DBF Last Date Accessed
- INV.DBF
- LIMIT N 10 2 CUSTOMER.DBF Credit Limit for the customer
- LOCATION C 3 0 INV.DBF Bin or physical location of an
- item in the inventory 'warehouse'
- NAME C 30 0 CUSTOMER.DBF Customers Bill To name
- ONHAND N 7 0 INV.DBF Quantity of an item that is
- physically in the inventory
- ONORDER N 7 0 INV.DBF Quantity on Purchase Order from
- a Vendor
- OPEN L 1 0 REGISTER.DBF Register is open/closed
- INVOICE.DBF Invoice is open/closed (A/R)
- OPENCLOSE C 1 0 REGISTER.LOG Used to determine if register is
- opened or closed
- OPENDATE D 8 0 REGISTER.DBF Date register was opened
- REGISTER.LOG
- OPENTIME C 8 0 REGISTER.DBF Time register was opened
- REGISTER.LOG
- PAID N 10 2 INVOICE.DBF Amount received from the customer
- as payment on the invoice
- PAID_PURC N 10 2 CUSTOMER.DBF Total amount of receipts from the
- customer for all open orders
- PAY L 1 0 BO.DBF Flag to denote whether the
- BackOrdered item has been paid
- for in advance
- PBL N 6 3 CUSTOMER.DBF Price Book List Factor
- PBM N 6 3 CUSTOMER.DBF Price Book Margin Factor
- PHONE C 14 0 CUSTOMER.DBF Customers telephone number
- INVOICE.DBF
- PRICE N 10 2 BO.DBF Price of item to the customer
- INV.DBF
- DETAIL.DBF
- PRINTED L 1 0 INVOICE.DBF Flag to denote that an invoice
- has been printed
- DAYO BO, TJS LAB Page: 49
-
-
-
- ■ DATA DICTIONARY
-
- Field Name Type Len Dec Database Description/Comments
- ────────── ──── ─── ─── ──────────── ──────────────────────────────────
- QTY N 7 0 BO.DBF Quantity BackOrdered
- DETAIL.DBF Quantity Invoiced
- REG C 3 0 INVOICE.DBF Register number
- REGISTER N 3 0 REGISTER.LOG Register number
- RETAIL N 10 2 INV.DBF Manufacturer recommended
- Retail/List price
- SALESPER C 3 0 CUSTOMER.DBF Sales Person to get credit for
- INVOICE.DBF the sale
- SALESPTD N 10 2 CUSTOMER.DBF Period to Data sales
- SALESYTD N 10 2 CUSTOMER.DBF Year to Data sales
- SC L 1 0 INVOICE.DBF Ship Complete flag
- SERIALNO C 30 0 SERIALNO.DBF Serial number
- SERIALNO L 1 0 INV.DBF Serial number required flag
- SHIPADDR1 C 30 0 INVOICE.DBF Ship To address line 1
- CUSTOMER.DBF
- SHIPADDR2 C 30 0 INVOICE.DBF Ship To address line 2
- CUSTOMER.DBF
- SHIPCITY C 22 0 CUSTOMER.DBF Ship To city
- SHIPCITY C 17 0 INVOICE.DBF Ship To city
- SHIPNAME C 30 0 INVOICE.DBF Ship To name
- CUSTOMER.DBF
- SHIPPER C 20 0 INVOICE.DBF Shipper or Method of Shipment
- CUSTOMER.DBF
- SHIPSTATE C 2 0 INVOICE.DBF Ship To state
- CUSTOMER.DBF
- SHIPZIP C 10 0 INVOICE.DBF Ship To zip
- CUSTOMER.DBF
- SOLDPTD N 7 0 INV.DBF Quantity sold Period to Date
- SOLDYTD N 7 0 INV.DBF Quantity sold Year to Date
- STARTSUM N 10 2 REGISTER.DBF Amount of money that a register
- REGISTER.LOG started with
- STATE C 2 0 CUSTOMER.DBF Bill To state
- STOCKLEVEL N 7 0 INV.DBF Inventory stockage level
- SUBTOTAL N 10 2 INVOICE.DBF Total of invoice detail line
- items
- TAXABLE L 1 0 DETAIL.DBF Charge tax flag
- INV.DBF
- BO.DBF
- TAXES N 10 2 INVOICE.DBF Total amount of invoice taxes
- TAXRATE N 5 3 INVOICE.DBF Tax rate
- CUSTOMER.DBF
- TERMS C 20 0 CUSTOMER.DBF Terms of payment for an invoice
- INVOICE.DBF ie: CASH, CHECK, NET 30
- DAYO BO, TJS LAB Page: 50
-
-
-
- ■ DATA DICTIONARY
-
- Field Name Type Len Dec Database Description/Comments
- ────────── ──── ─── ─── ──────────── ──────────────────────────────────
- TIME C 8 0 BO.DBF Time record was created
- INVOICE.DBF
- TYPE C 3 0 CUSTOMER.DBF Type of customer
- INV.DBF Type of inventory item
- INVOICE.DBF Type of invoice
- UNIT C 3 0 INV.DBF Unit of issue, ie: EA, BOX, KIT
- VENDITEM C 12 0 INV.DBF Vendor/Manufacturer Item/Part/
- Product number
- VENDOR C 10 0 INV.DBF Vendor number/code
- WEIGHT N 8 2 INV.DBF Weight of 1 each item
- ZIP C 10 0 CUSTOMER.DBF Bill To zip
-
- DAYO BO, TJS LAB Page: 51
-
-
-
- ■ DAYO BO MAINTENANCE & QUIRKS
-
- - After using DAYO BO for any period of time, you will need to 'clean out'
- deleted and closed invoices (INVOICE.DBF, DETAIL.DBF), BackOrder (BO.DBF),
- and Register (REGISTER.LOG), records/entries. This task can be accomplished
- with the DAYO End of Period program (DAYO EOP), but if you are not using it,
- then you will have to use the DAYO POS MISC ROUTINES to DELETE, then PACK
- the databases. This task is often called the 'End of Month' (EOM), or 'End
- of Period' (EOP) purge. The period may be daily, weekly, monthly, quarterly,
- or yearly. Deleted records should remain in their respected databases until
- this time to allow for organized record keeping. At this time, reports
- covering the period could be printed as well as backups of the databases
- being made. The backup is especially important since you will be
- permanently removing the records with the PACK option in the MISC routines.
-
- - At EOM/EOP time, the SOLDPTD field in the inventory database (INV.DBF), the
- SALESPTD field in the customer and sales persons database (CUSTOMER.DBF &
- SALESPER.DBF), should be set to zero. Note that these fields are maintained/
- adjusted by the use of the Inventory Adjustments option in the inventory
- browse screen, and by using DAYO BO.
-
- - On occasion (maybe an under statement), index files will get corrupted,
- especially on networks. To 'fix' a corrupted index requires that everyone
- 'get out of' the DAYO databases, and then perform a reindexing (actually a
- recreation of the indexes). The reindex is accomplished by running the DAYO
- BO program with a parameter of 'INDEX' (or using DAYO X).
-
- ie:
-
- C:\>DAYOO INDEX
-
- - If you are on a multiuser network, you must 'flag' (change file attributes)
- of all files to make them sharable, readable and writable. Note that the
- command/program 'flag' may be called by a different name on your network.
-
-
- ie:
-
- E:\>FLAG *.NTX SRW
-
- or just to be safe, go ahead and flag all files in the DAYO directory:
-
- E:\>FLAG *.* SRW
-
-
- - Indexes are recreated once every day. This is automatically performed by the
- first user to run DAYO BO. This process will take more time as your files
- get larger. This process should take place daily, but you can run it at
- night with a batch file that waits until after midnight (ie: DAYO Clock),
- or a with most scheduling programs. All other users and computers must be
- out of the databases, or the procedure will not occur properly. Remember to
- 'flag' the files sharable, readable and writable.
- DAYO BO, TJS LAB Page: 52
-
-
-
- - Backups of your data and configuration files should take place daily! You
- have no doubt heard many scare stories. They are all true! The key files
- that need to be backed up, all have the extension of .DBF, and .CFG. The
- .DBF files are your databases. The .CFG is the file that contains 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 BO, and you are on a PC based
- network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases.
- This will allow the opened databases to be shared, and more importantly,
- prevent a user (or all users!) from 'crashing'!
-
- - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then
- do not use it... Hope to fix this 'feature' with the next upgrade...
- DAYO BO, TJS LAB Page: 53
-
-
-
- ■ TJS 'Computer' LAB
-
- TJS LAB is an association of programmers and technicians that produce
- customized, multiuser software for the PC based network (ie: Novell and
- others). Our specialties include Inventory Control, PC Communications/EDI,
- Management, Reports (standard and graphic), Data Conversions, and
- Accounting (A/R, A/P).
-
- A unique feature of TJS LAB is that our software is by default, multiuser.
- 'Standalone' applications are the exception! All our applications are
- written in Clipper, Basic, or C (preferably Basic or Clipper). We will
- license all our application source codes. We produce applications that work,
- are easy to use, and are inexpensive!
-
- Want a change?
- Want an enhancement!
- Want a completely new product/application?
- Want to make your idea a reality?
-
- Custom/contract programming, by TJS LAB, and our associates is available.
-
- Standard rate is $35.00 per hour (our sites). Guaranteed quality and timely
- work is our number one policy.
-
- We make program enhancements/changes/fixes at our location(s), but can/do
- make 'house calls' via special software and a modem.
-
-
- Write us at:
-
- TJS LAB
- PO Box 585366
- Orlando, Florida 32858-5366
-
- Or call us (8:00 am - 11:00 pm):
-
- (407) 291-3960
-
-
- * Note that TJS LAB, nor any of the associates accept/take any support
- calls for unregistered Shareware products.
-
-
-
- TJS LAB, Computer Division
-
- In an effort to provide the 'total solution', TJS LAB now offers personal
- computer systems, printers, software and accessories at a much discounted
- price. All equipment is warranted by the manufacturer for at least one year.
- Call or write us for more information...
-
-