home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
finance
/
dayooe.zip
/
DAYOBO.DOC
< prev
next >
Wrap
Text File
|
1990-12-02
|
149KB
|
2,571 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
"Try before you buy..."
┌─────────┐
┌─────┴───┐ │ (tm)
──│ │o │──────────────────
│ ┌─────┴╨──┐ │ Association of
│ │ │─┘ Shareware
└───│ o │ Professionals
──────│ ║ │────────────────────
└────╨────┘ MEMBER
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware principle
works for you. If you are unable to resolve a shareware-related problem with
an ASP member by contacting the member directly, ASP may be able to help.
The ASP Ombudsman can help you resolve a dispute or problem with an ASP
member, but does not provide technical support for members' products. Please
write to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a
Compuserve message via easyplex to ASP Ombudsman 70007,3536
■ 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 Page: 1
Table of Contents
Page Subject
──── ───────────────────────────────────────
3 ............... INTRODUCTION
4 ............... COPYRIGHT/LICENSE
4 ............... DISCLAIMER
4 ............... REQUIREMENTS
4 ............... SETUP
5 ............... MAIN MENU
5 ............... PASSWORD/NAME
6 ............... OPEN REGISTER
7 ............... CREATING ADDITIONAL REGISTERS
7 ............... CLOSE REGISTER
8 ............... ALLOCATION
8 ............... ALLOCATE SCREEN
9 ............... ALLOCATION PROCESS
10 ............... BACK ORDER BROWSE
10 ............... HELP - F1
11 ............... FULL SCREEN EDIT - F2
11 ............... INVOICE - F3
12 ............... FINAL EDIT SCREEN
12 ............... MULTIPLE SHIPTOS
13 ............... TYPE, TERMS, SHIPPER, TAXCODE/TAXRATES
13 ............... ENTER RECEIPT AMOUNT
14 ............... EXIT/FINISH
14 ............... WORK ORDER NOTES/COMMENTS
15 ............... DATABASE POSTING
16 ............... ADD BO RECORD
16 ............... DELETE BO RECORD
16 ............... FIND (F5/F6/F7/F8)
17 ............... CUSTOMERS
17 ............... FIND (F5/F6/F7/F8)
18 ............... CONFIGURATION
18 ............... CONFIGURATION MENU
19 ............... COMPANY NAME, ADDRESS & TELEPHONE
19 ............... AUTOMATICALLY PRINT THE INVOICE
20 ............... AUTOMATIC ALLOCATION
20 ............... LAST INVOICE NUMBER
20 ............... INVOICE PRINTER TYPE
20 ............... INVOICE PRINTER PORT
20 ............... INVOICE COPIES
21 ............... ALLOW BROWSE EDITING
21 ............... USE CREDIT LIMIT
21 ............... INVENTORY DATABASE LOCATION
21 ............... CUSTOMER DATABASE LOCATION
22 ............... POS DATABASE LOCATION
22 ............... CASH DRAWER
22 ............... CASH DRAWER SERIAL PORT
22 ............... PARALLEL CASH DRAWER
23 ............... PARALLEL CASH DRAWER PORT
23 ............... PARALLEL CASH DRAWER SETUP CODE
DAYO BO, TJS LAB Page: 2
Table of Contents
Page Subject
──── ───────────────────────────────────────
23 ............... REPORT PRINTER TYPE
23 ............... REPORT PRINTER PORT
23 ............... VISUAL INDEXING
24 ............... AUTOMATIC DAILY INDEXING
24 ............... AUTO PRINT PACKING LIST
24 ............... PACKING LIST PRINTER PORT
24 ............... PRINT PRICE ON PACKING LIST
25 ............... COLOR MONITOR
25 ............... COLOR INTENSITY
26 ............... REPORTS
27 ............... ALLOCATION REPORT
27 ............... BACK ORDER REPORT
28 ............... INVENTORY BACKORDER RESET & REPORT
28 ............... CUSTOMER SHIP TO ADDRESS LABELS
29 ............... DATABASE STATUS REPORT
30 ............... CONFIGURATION STATUS REPORT
31 ............... AN EXAMPLE OF A CONFIGURATION STATUS REPORT
34 ............... PRINTER DRIVER (SETUP)
34 ............... PRINTER DRIVER OPTIONS
35 ............... CHANGE DEFAULT PRINTER
36 ............... FULL SCREEN EDIT - F2
36 ............... PRINTER DRIVER DATABASE FIELD DEFINITIONS
37 ............... HELP SCREENS
38 ............... EXPANDED HELP
39 ............... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
40 ............... VIEW DOCUMENTATION ONSCREEN
41 ............... DATABASE STRUCTURE
46 ............... DATA DICTIONARY
50 ............... DAYO BO MAINTENANCE & QUIRKS
52 ............... TJS LAB, CUSTOM CODING
DAYO BO, TJS LAB Page: 3
■ 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: 4
■ 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.
Read the Order Form (last page), for more information on Source Codes...
Authorization to distribute the Shareware Version (unregistered) is
granted.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware
and/or software systems as a result of using DAYO BO.
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
■ SETUP
To setup DAYO BO, copy the contents of the DAYO BO floppy disks into a
directory on your hard disk (ie: \DAYOBO). If this is the Shareware Version,
you need to UnZip/UnArc the files here. 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. Type and
enter 'DAYOO' at the DOS prompt to run the program (ie: C:\DAYOO ).
DAYO BO, TJS LAB Page: 5
■ MAIN MENU
After a few moments and possibly a reindex, the main menu will appear:
DAYOBO V1.3, TJS LAB ┌─────[July 1990]────┐
│S M T W T F S │
╓─────────────────────────╖ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
║ 1 REGISTER ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
╟─────────────────────────╢ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
║ 2 ALLOCATE ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
╟─────────────────────────╢ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
║ 3 BROWSE ║ ████▀ █░ █░ █░ ▀███▀ │29 30 31 │
╟─────────────────────────╢ │ │
║ 4 CUSTOMERS ║ └────────────────────┘
╟─────────────────────────╢
║ 5 CONFIGURATION ║
╟─────────────────────────╢╓────────────────────────────────────────────────╖
║ 6 REPORTS ║║ DAYO BO STATISTICS Register Open ║
╟─────────────────────────╢╟────────────────────────────────────────────────╢
║ 7 EXIT ║║ DATABASE NAME RECORDS SIZE ║
╚═════════════════════════╝╟────────────────────────────────────────────────╢
Select Option ║ INV.DBF Inventory 5 2K ║
█▄███▄ ▄████▄ ║ INVOICE.DBF Invoice Header 77 30K ║
█░ █░ █░ █░ ║ DETAIL.DBF Invoice Detail 166 16K ║
█▄▄▄█▀ █░ █░ ║ BACKORDER.DBF BackOrders 22 3K ║
█░ ▀█░ █░ █░ ║ CUSTOMER.DBF Customers 217 95K ║
█░ █░ █░ █░ ║ REGISTER.LOG Register Log 753 66K ║
█▀███▀ ▀████▀ ╚════════════════════════════════════════════════╝
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: 6
■ 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: 7
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: 8
■ 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.
DAYOBO V1.3, 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: 9
■ 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.
DAYOBO V1.3, 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: 10
■ 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:
DAYOBO V1.3, 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: 11
■ 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.
DAYOBO V1.3, 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: 12
■ FINAL EDIT SCREEN
If there are filled items, the following screen will be displayed:
DAYOBO V1.3, 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: 13
■ 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: 14
■ 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: 15
*** 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: 16
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: 17
■ CUSTOMERS
This menu option is a browse screen of the customer records. No editing
of the database (CUSTOMER.DBF) is possible...
DAYOBO V1.3, 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: 18
■ 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
■ CONFIGURATION MENU
The CONFIGURATION menu is a selection box that appears on the left side
of the main menu screen, ie:
DAYOBO V1.3, TJS LAB CONFIG ┌────[April 1990]────┐
╔════════════════════════╗ │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: 19
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: 20
■ 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: 21
■ 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: 22
■ 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\ │
└────────────────────────────────────────────────────────────────────────────┘
■ 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) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO BO, TJS LAB Page: 23
■ PARALLEL CASH DRAWER PORT
┌───────────────────────[ PARALLEL CASH DRAWER PORT ]────────────────────────┐
│ Enter Your Cash Drawer Parallel Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ 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: 24
┌──────────────────────────────────────────────────────────┐
│ 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: 25
■ 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: 26
■ 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! │
└────────────────────────────────────────────────────────────────────────────┘
■ 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: 28
■ 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: 29
■ 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: 30
■ 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: 31
■ 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: 32
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: 33
++++++++++++++++++++++++++++++++++++++++++
+ 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: 34
■ 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: 35
■ 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: 36
■ 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 lazer printer to print upright (normal)
LANDSCAPE - Code to set lazer 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: 37
■ 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: 38
- 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: 39
■ 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).
DAYOPAY V1.3, TJS LAB ┌────[August 1990]───┐
┌──────[ DAYO HELP Called by Program: DAYOPAY 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 DAYOPAY. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ 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: 40
DAYOPAY V1.3, TJS LAB ┌────[August 1990]──┐
┌───────[ DAYO HELP Called by Program: DAYOPAY Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ONSCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYOPAY the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: PAGE: 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO BO, TJS LAB Page: 41
■ 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: 42
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: 43
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: 44
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: 45
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: 46
■ 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: 47
■ 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: 48
■ 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: 49
■ 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: 50
■ 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: 51
- 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: 52
■ 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...