home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
finance
/
dayovd.zip
/
DAYOAP.DOC
Wrap
Text File
|
1991-03-22
|
366KB
|
6,147 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ║
║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
║ ║
║ ║
║ ▀██▒░ ▀██▄███████▄ ║
║ ████▒░ ██▒░ ██▒░ ║
║ ██████▒░ ██▒░ ██▒░ ║
║ ██▒░██▒░ ██▒░ ██▒░ ║
║ ██▀ ▀██▒░ ██▄▄▄▄▄▄████▒░ ║
║ ██▒░ ██▒░ ██▀███████▀ ║
║ ▄██████████▄ ██▒ ║
║ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ║
║ ▄██▒░ ██▒░ ▄██▒░ ║
║ ║
║ ║
║ ║
║ ACCOUNTS PAYABLE FOR THE DAYO MODULES ║
║ ║
║ ║
║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║
║ ║
║ ║
║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║
║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║
║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║
║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║
║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║
║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║
║ ▀▓▓▓▀ & LAN █████■████▌ O A ║
║ Applications ▐███████████ N R ║
║ ┌─┐ ┌─┐ ███████████▌ S E ║
║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║
║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║
║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║
║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║
║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║
║ █ G ║
║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO AP, 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 AP, TJS LAB Page: 1
Table of Contents
Page Subject
──── ───────────────────────────────────────
4 ............... INTRODUCTION
5 ............... COPYRIGHT/LICENSE
5 ............... DISCLAIMER
5 ............... REQUIREMENTS
5 ............... SETUP
6 ............... MAIN MENU
6 ............... PASSWORD/NAME
7 ............... BROWSE
8 ............... ACCOUNTS PAYABLE HEADERS
9 ............... ACCOUNTS PAYABLE HEADERS - FULL SCREEN EDIT
10 ............... ACCOUNTS PAYABLE DETAIL
10 ............... ACCOUNTS PAYABLE DETAIL - FULL SCREEN EDIT
11 ............... VENDORS DATABASE
12 ............... VENDORS DATABASE - FULL SCREEN EDIT
13 ............... PURCHASE ORDER HEADERS
14 ............... PURCHASE ORDER HEADERS - FULL SCREEN EDIT
15 ............... PURCHASE ORDER DETAIL
16 ............... PURCHASE ORDER DETAIL - FULL SCREEN EDIT
17 ............... MAIN INVENTORY DATABASE
18 ............... MAIN INVENTORY DATABASE - FULL SCREEN EDIT
19 ............... MAIN INVENTORY DATABASE - WAREHOUSE TRANSFER
20 ............... MAIN INVENTORY DATABASE - INVENTORY ADJUSTMENT
21 ............... INVENTORY ADJUSTMENTS DATABASE
22 ............... INVENTORY ADJUSTMENTS DATABASE
FULL SCREEN EDIT
23 ............... WAREHOUSE INVENTORY DATABASE
24 ............... WAREHOUSE INVENTORY DATABASE
FULL SCREEN EDIT
25 ............... WAREHOUSE NAMES DATABASE
25 ............... WAREHOUSE NAMES DATABASE - FULL SCREEN EDIT
26 ............... RECEIVING DATABASE
27 ............... RECEIVING DATABASE - FULL SCREEN EDIT
28 ............... CHECKING ACCOUNTS DATABASE
29 ............... CHECKING ACCOUNTS DATABASE - FULL SCREEN EDIT
30 ............... CHECKS DATABASE
30 ............... CHECKS DATABASE - FULL SCREEN EDIT
31 ............... CHECK PRINTING FORMATS DATABASE
32 ............... CHECKING ACCOUNT DEPOSITS
32 ............... CHECKING ACCOUNT DEPOSITS - FULL SCREEN EDIT
33 ............... BATCH CHECKS
33 ............... PREPARE BATCH CHECKS
34 ............... SELECT CHECKING ACCOUNT NUMBER
35 ............... SELECT CHECK PRINTING FORMAT
36 ............... SELECT STARTING CHECK NUMBER
37 ............... BROWSE BATCH CHECKS
DAYO AP, TJS LAB Page: 2
Table of Contents
Page Subject
──── ───────────────────────────────────────
38 ............... BROWSE BATCH CHECKS - FULL SCREEN EDIT
39 ............... PRINT BATCH CHECKS DRAFT
40 ............... BROWSE RECURRING CHECKS
40 ............... SCHEDULE CODES
41 ............... BROWSE RECURRING CHECKS - FULL SCREEN EDIT
42 ............... MARK/UNMARK FOR PRINTING
43 ............... RECURRING CHECK SUMMARY
43 ............... PRINT RECURRING CHECKS DRAFT
44 ............... PRINT & POST RECURRING CHECKS
44 ............... HAND CHECKS
45 ............... SELECT ACCOUNT TYPE
45 ............... FINAL HAND CHECK EDIT
46 ............... APPLY TOWARDS MULTIPLE GL ACCOUNTS/ENTRIES
46.1 ............... APPLY TOWARDS AP PO/PAYABLE RECORDS
47 ............... POSTING
47 ............... POST TO AP FILES
48 ............... EXPANDED EXPLANATION OF AP POSTING
48.1 ............... AP POSTING FLOWCHART
48.1 ............... VENDOR BALANCE DUE RESET/RECALCULATE
49 ............... REPORTS
49 ............... REPORTS LIST
50 ............... ACCOUNTS PAYABLE SUMMARY
50 ............... PAYABLES SUMMARY (APH.DBF)
51 ............... DEPOSITS SUMMARY (DEPOSITS.DBF)
51 ............... CHECKS SUMMARY (CHECKS.DBF)
51 ............... ACCOUNT BALANCES (ACCOUNTS.DBF)
52 ............... MISCELLANEOUS EXPENSES SUMMARY (EXPENSES.DBF)
52 ............... PURCHASE ORDER HEADER REPORT
53 ............... PURCHASE ORDER DETAIL REPORT
53 ............... VENDORS REPORT
54 ............... VENDOR MAILING LABELS (BILLTO/SHIPTO)
55 ............... VENDOR FOLDER LABELS
55 ............... CHECKING ACCOUNTS REPORT
56 ............... AP CHECKS REPORTS
56 ............... CHECK FORMATS REPORT
57 ............... RECURRING CHECKS REPORT
57 ............... MISSING CHECKS REPORT
58 ............... DEPOSITS REPORTS
59 ............... 1099 MISC FORMS
60 ............... MISCELLANEOUS EXPENSES REPORT
61 ............... EXPANDED INVENTORY REPORT
61 ............... INVENTORY ADJUSTMENTS
62 ............... RECEIVING REPORT
62 ............... UNCLEARED RECEIVERS REPORT
63 ............... UNCLEARED AP RECORDS REPORT
63 ............... CLEARED RECEIVERS REPORT
64 ............... CLEARED AP RECORDS REPORT
64 ............... REPRINT CHECKS
65 ............... CONFIGURATION STATUS REPORT
65 ............... EXAMPLE OF CONFIGURATION STATUS REPORT
DAYO AP, TJS LAB Page: 3
Table of Contents
Page Subject
──── ───────────────────────────────────────
65.1 ............... VIEW REPORTS ON SCREEN
65.2 ............... REPORT VIEWING SCREEN
66 ............... PRINTER DRIVER (SETUP)
66 ............... PRINTER DRIVER OPTIONS
67 ............... CHANGE DEFAULT PRINTER
68 ............... FULL SCREEN EDIT - F2
68 ............... PRINTER DRIVER DATABASE FIELD DEFINITIONS
69 ............... CONFIGURATION
69 ............... CONFIGURATION LISTING
70 ............... COMPANY NAME, ADDRESS & TELEPHONE
70 ............... INVENTORY LOCATION/DIRECTORY
70 ............... POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY
71 ............... CUSTOMER (AR) DATABASE LOCATION/DIRECTORY
71 ............... FEDERAL (TAX) IDENTIFICATION NUMBER (FIN)
71 ............... FORM 1099 DEFAULT TAX CODE
71 ............... DEFAULT TAX RATE
72 ............... REPORT PRINTER TYPE
72 ............... REPORT PRINTER PORT
72 ............... HAND CHECKS PRINTER PORT
72 ............... BATCH CHECKS PRINTER PORT
72 ............... RECURRING CHECKS PRINTER PORT
72 ............... PARTIAL PAYMENT OF PURCHASE ORDERS
73 ............... PARTIAL PAYMENT OF PO FREIGHT & ADJUSTMENTS
73 ............... VISUAL INDEXING
73 ............... AUTOMATIC DAILY INDEXING
74 ............... COLOR MONITOR
74 ............... COLOR INTENSITY
75 ............... MISCELLANEOUS ROUTINES
75 ............... Misc Routines Menu:
76 ............... APPEND FROM
78 ............... BROWSE DATABASES
79 ............... COPY (.DBF) TO
82 ............... CREATE DATABASE
84 ............... DELETE RECORDS
85 ............... ERASE FILE
85 ............... EXIT TO DOS
86 ............... INDEX A DATABASE
87 ............... LIST FIELDS
90 ............... MODIFY DATABASE
91 ............... PACK DATABASE
92 ............... RECALL RECORDS
92 ............... RETURN TO MENU
92 ............... RUN (DOS COMMAND)
93 ............... SIMPLE EDITOR
94 ............... SORT DATABASE
95 ............... TYPE (PRINT) FILE
96 ............... ZAP DATABASE
98 ............... HELP SCREENS
100 ............... EXPANDED HELP
100 ............... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
101 ............... VIEW DOCUMENTATION ONSCREEN
102 ............... DATABASE STRUCTURE
113 ............... DATA DICTIONARY
121 ............... DAYO AP MAINTENANCE & QUIRKS
122 ............... TJS LAB, CUSTOM CODING
DAYO AP, TJS LAB Page: 4
■ INTRODUCTION
DAYO AP is the 'final chapter' in the processing and maintenance of all
your Payables. DAYO AP's primary task is to process your purchase orders,
however, routines have been provided to handle 'other' expenses. The ability
to print payable or miscellaneous checks has been incorporated in DAYO AP.
Many reports are included to aid you in your accounting. DAYO AP is by
default a multiuser system.
Some of the DAYO AP highlights are:
Multiuser (ie: Novell)
Hand/Manual Checks
Batch Checks
Recurring Checks
Unlimited Bank Accounts
Unlimited Check Printing Formats
25+ Reports
Print 1099 MISC Forms
Purchase Clearing
Vendor Maintenance
Inventory Maintenance/Adjustments
Data Entry Validation
Databases are dBase (tm) compatible
19 Configuration Settings
Passwords (with DAYO Passwords)
Other DAYO Products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO POS Point of Sales Billing & Invoicing
DAYO Quotes Sales Quoting System
DAYO Price Books Special pricing for your customers as well as a wide
range of product catalogs/reports
DAYO AR Accounts Receivable
DAYO EOP End of Period Post & Pack, Physical Inventory
DAYO BO Back Orders
DAYO Smart Reports A variety of reports pertaining to the above modules
DAYO Passwords Password protect your DAYO system
DAYOX Network/LAN Index Maintenance Utility
DAYO AP, TJS LAB Page: 5
■ 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 AP 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 AP.
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
■ SETUP
To setup DAYO AP, copy the contents of the DAYO AP floppy disk into a
directory on your hard disk (ie: \DAYOAP). If this is the Shareware Version,
UnZip/UnArc the files here. When running DAYO AP 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 AP configuration. Type and enter
'DAYOE' at the DOS prompt to run the program (ie: C:\DAYOE ).
*** Your CONFIG.SYS file must have the buffers set to a minimum of 10, and
your files must have a MINIMUM setting of 55! Failure to edit the CONFIG.SYS
file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is
created if there is a problem detected, in the directory that this DAYO
module is being run in. You may copy this file into your root/boot drive.
Refer to your DOS manual for more information on the CONFIG.SYS file!
DAYO AP, TJS LAB Page: 6
■ MAIN MENU
After a few moments, and possibly a reindex, the main menu will appear
(the left side of the screen is the actual main menu):
DAYO AP Version 2.0 TJS LAB ┌───[February 1991]──┐
╓──────────────────────╖ │S M T W T F S │
║ 1 BROWSE ║ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟──────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2│
║ 2 BATCH CHECKS ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│
╟──────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│
║ 3 MANUAL CHECKS ║ █░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│
╟──────────────────────╢ ████▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 │
║ 4 POSTING ║ │ │
╟──────────────────────╢ Copyright (c) 1989-1991 └────────────────────┘
║ 5 REPORTS ║ ╓────────────────────────────────────────────────╖
╟──────────────────────╢ ║ DAYO AP STATISTICS ║
║ 6 CONFIGURATION ║ ╟────────────────────────────────────────────────╢
╟──────────────────────╢ ║ DATABASE NAME RECORDS SIZE ║
║ 7 MISC ROUTINES ║ ╟────────────────────────────────────────────────╢
╟──────────────────────╢ ║ POH.DBF PO Headers 102 55K ║
║ 8 EXIT ║ ║ POD.DBF PO Detail 154 21K ║
╚══════════════════════╝ ║ APH.DBF AP Header 479 272K ║
█░ ▀█▄███▄ ║ APD.DBF AP Detail 426 60K ║
███░ █░ █░ ║ VENDORS.DBF Vendors 6 4K ║
█▀ ▀█░ █░ █░ ║ EXPENSES.DBF Misc Expenses 5 1K ║
▄█▄▄▄█▄ █████▀ ║ CHECKS.DBF Check Register 84 17K ║
█▀ ▀█░ █░ ║ DEPOSITS.DBF Deposits 0 0K ║
█░ █░ █░ ╚════════════════════════════════════════════════╝
Browse-Edit-Maintenance Your AP Databases
The size and number of records for your some of your key AP databases
are displayed in the box on the lower right of the screen.
■ PASSWORD/NAME
From the main menu you can enter any of the routines/options, but first
you must your name (or password if using DAYO Passwords):
┌────────────────────────────────────────────────────────────────────────────┐
│┌──────────────────────────────────────────────────────────────────────────┐│
││ Enter Your Name: George Moonilal ││
│└──────────────────────────────────────────────────────────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 7
■ BROWSE
Use the BROWSE routines to view, edit, and maintenance your AP databases.
There are 14 AP databases that this routines supports:
AP Header (APH.DBF) Warehouses (WAREHOUS.DBF)
AP Detail (APD.DBF) Warehouse Names (WARENAME.DBF)
Vendors (VENDORS.DBF) Receivers (REC.DBF)
PO Header (POH.DBF) Checking Accounts (ACCOUNTS.DBF)
PO Detail (POD.DBF) Checks (CHECKS.DBF)
Inventory (INV.DBF) Check Formats (CFORMAT.DBF)
Inventory Adjustments (INVADJ.DBF) Deposits (DEPOSITS.DBF)
Unlike the BROWSE in the MISC ROUTINES, these BROWSES are more
'controled'. The BROWSE in the MISC ROUTINES will not open all indexes for
a database, whereas the AP BROWSE does, and often opens other related
databases.
A few options are available while in the BROWSE. You can do a
Full Screen Edit, add a blank record, delete a record, and if there are
indexes for the selected databases, find a record based on any of the
indexes. Remember, there are usually more fields to the 'right' of the
screen (Press F1 for HELP - more information).
*** Adding a record (Ctrl N) will not, in all cases, update/create a new
'control number' (ie: PO number, Journal Number....).
*** Note! Very little data entry validation takes place in a BROWSE, so
be careful when making any edits!
DAYO AP, TJS LAB Page: 8
■ BROWSE ACCOUNTS PAYABLE HEADERS
The AP Header records are records of your payables. Generally, most of
these records are created from posting your closed Purchase Orders, but
some are created with the Check writing routines.
DAYO AP Version 2.0 TJS LAB
╔═══[ APH.DBF ]══════════════════════════════════════════════════════════════╗
║Journal # Name PO Vendor Open PurC║
║ 85 RON DAVIDSON 500030 RD-100 Yes No ║
║Date Receiver Check # PO Date Comment ║
║03/28/90 66440 23443 12/15/89 Hand Credit Check ║
║ Taxes Adjustment Freight Subtotal Total Amount ║
║ 0.00 1.00 10.00 200.00 211.00 65.00 ║
╚══════════════[ Browse the Accounts Payable Header Database ]═══════════════╝
JOURNAL PO VENDOR NAME
─────────────────╥────────╥────────────╥───────────────────────────────────────
77 ║ 500022 ║ HURCLE ║ HURCLE SUPPLIES
78 ║ 500023 ║ BORDEN ║ BORDEN SOFTDRINKS, INC
79 ║ 500024 ║ MAO A ║ MAO BUSINESS FORMS
80 ║ 500025 ║ HARPER BK ║ HARPER BOOKS
81 ║ 500026 ║ JOE MORGAN ║ JOE MORGAN ENTERPRISES
82 ║ 500027 ║ ZZZ ║ ZENTIL Z. ZEBULA PRINTING
83 ║ 500028 ║ ZZZ ║ ZENTIL Z. ZEBULA PRINTING
84 ║ 500029 ║ ZZZ ║ ZENTIL Z. ZEBULA PRINTING
85 ║ 500030 ║ RD ║ RON DAVIDSON
86 ║ 500031 ║ RD ║ RON DAVIDSON
87 ║ 500032 ║ MAO A ║ MAO BUSINESS FORMS
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5 (PO) F6 (Name) F7 (Vendor Number) F8 (Journal Number)
53/55
DAYO AP, TJS LAB Page: 9
■ BROWSE ACCOUNTS PAYABLE HEADERS - FULL SCREEN EDIT
DAYO AP Version 2.0 TJS LAB
┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐
│ JOURNAL: 85 SUBTOTAL: 200.00 │
│ PO: 0 TAXES: 0.00 │
│ VENDOR: RD ADJUST: 1.00 │
│ NAME: RON DAVIDSON FREIGHT: 10.00 │
│ ATTN: RON AMOUNT: 65.00 │
│ ADDR1: 9290 LAKELAND AVE PC: F │
│ ADDR2: CHECKNO: 23443 │
│ CITY: LAKELAND PODATE: 12/15/89 │
│ STATE: FL TYPE: AA │
│ ZIP: 39399 │
│ PHONE: (813)-555-2933 │
│ DATE: 03/28/90 │
│ ETA: / / │
│ TERMS: CHECK │
│ SHIPPER: MAIL │
│ BY: TJ │
│ PRINTED: F │
│ COMMENT: Hand Credit Check Or │
│ RECDATE: / / │
│ KEY: 66440 │
│ OPEN: T │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 10
■ BROWSE ACCOUNTS PAYABLE DETAIL
The AP Detail records are records of your detail payables, which are
are usually created from posting your closed Purchase Orders.
DAYO AP Version 2.0 TJS LAB
╔═══[ APD.DBF ]══════════════════════════════════════════════════════════════╗
║Journal # Name PO Vendor Open PurC║
║ 1077 RON DAVIDSON 1205 RD No Yes ║
║Date Receiver Check # PO Date Comment ║
║03/10/90 1245 02/25/90 ║
║ Taxes Adjustment Freight Subtotal Total Amount ║
║ 36.36 524.87 524.87 606.00 1692.10 1574.61 ║
║Item Description VendItem Cost Tax ║
║RD-34 CAR, 1989 (GENERAL) 34 303.00 Yes ║
╚══════════════[ Browse the Accounts Payable Detail Database ]═══════════════╝
JOURNAL PO VENDOR ITEM DESC
────────╥────────╥────────────╥──────────────╥───────────────────────────────
1072 ║ 1200 ║ MAO A ║ ║ * Voided while in Receiving *
1073 ║ 1201 ║ MAO A ║ 1900001 ║ PAPER, 12 BOND, UTILITY
1073 ║ 1201 ║ MAO A ║ ║ * Voided while in Receiving *
1074 ║ 1202 ║ RD ║ RD-3934 ║ 1978 MUSTANG, (NEEDS PAINT)
1074 ║ 1202 ║ RD ║ RD-0303 ║ 1966 CHEVY
1075 ║ 1203 ║ RD ║ RD-10100 ║ 1956 CHEVY, RED (NO MOTOR)
1076 ║ 1204 ║ RD ║ RD-838383 ║ PER HOUR LABOR (MISC)
1076 ║ 1204 ║ RD ║ RD-00001 ║ HAULER, MOBILE, 3 TON
1077 ║ 1205 ║ RD ║ RD-34 ║ CAR, 1989 (GENERAL)
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5 (PO) F6 (Item) F7 (Vendor) F8 (VendItem) F9 (Journal)
154/154
■ BROWSE ACCOUNTS PAYABLE DETAIL - FULL SCREEN EDIT
DAYO AP Version 2.0 TJS LAB
┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐
│ JOURNAL: 1077 │
│ PO: 1205 │
│ VENDOR: RD │
│ ITEM: RD-34 │
│ DESC: CAR, 1989 (GENERAL) │
│ VENDITEM: 34 │
│ QUANTITY: 2 │
│ COST: 303.00 │
│ DATE: 03/10/90 │
│ TYPE: CAR │
│ CLASS: U │
│ OPEN: T │
│ KEY: 1245 │
│ RECDATE: / / │
│ TAXABLE: T │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 11
■ BROWSE VENDORS DATABASE
The DAYO Inventory has a better routine for the maintenance of your
Vendors, however, at times this Browse may be more convenient...
DAYO AP Version 2.0 TJS LAB
╔═══[ \DAYOINV\VENDORS.DBF ]═════════════════════════════════════════════════╗
║Vendor # Name Phone LastDate Type ║
║ADDDD ABLE STORES 345-5050 03/06/90 MC ║
║Terms Shipper ║
║NET 30 DELIVER NEXT DAY ║
║TaxRate Open Purc Recv Purc Total Purc Due Paid TotalPaid║
║ 0.000 17590.23 340.07 23440.60 17161.34 4296.00 27329.25║
╚══════════════════════[ Browse the Vendors Database ]═══════════════════════╝
VENDOR NAME ADDR1
────────────╥────────────────────────────────╥───────────────────────────────
AAAAB ║ AL MORGAN ║ 68009 EAST LANCASTER RD
AAAAC ║ JON MORGAN, INC ║ RT. 3900
AAAAD ║ SUE MORGAN SUPPLIES ║ 4449 BEARMAN STREET
AAAAE ║ MARTIN JONES, INC ║ PO BOX 9090
ADDDD ║ ABLE STORES ║ 30 EAST CORNER, 3 POINTS
ADDDE ║ HOT STUFF, BUSINESS FORMS ║ 678 LEE ROAD
ADDDEF ║ DOLPHIN PAPER, INC. ║ PIER 9
ADDERT ║ STEVENS PRINTING AND SUPPLIES ║ 5395 BABLEE DRIVE
ADDERU ║ STEVENS PRINTING ║ PO BOX 9001
ADDH ║ ARLIE JOHNSON PAINTS ║ 90033 E. TROY ROAD
ADDJ200 ║ 2000 IDEAS, INC ║ 200 EAST LANE
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5 (Vendor Number) F6 (Vendor Name)
323/43021
DAYO AP, TJS LAB Page: 12
■ BROWSE VENDORS DATABASE - FULL SCREEN EDIT
DAYO AP Version 2.0 TJS LAB
┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐
│ VENDOR: ADDDD PAID: 4296.50 │
│ NAME: ABLE STORES TOTALPAID: 27329.25 │
│ ADDR1: 30 EAST CORNER, 3 POINTS │
│ ADDR2: │
│ CITY: LONGWOOD │
│ STATE: FL │
│ ZIP: 32749 │
│ PHONE: 831-4040 │
│ ATTN: SUE │
│ TERMS: NET 30 │
│ SHIPPER: DELIVER NEXT DAY │
│ DATE: 11/10/87 │
│ LASTDATE: 03/06/90 │
│ TYPE: MC │
│ CLASS: STO │
│ TAXRATE: 0.000 │
│ FED_ID: 9300-397845 │
│ OPEN_PURC: 17590.23 │
│ RECV_PURC: 340.07 │
│ TOT_PURC: 27329.25 │
│ DUE: 17161.34 │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 13
■ BROWSE PURCHASE ORDER HEADERS
Purchase Orders are created with the DAYO Inventory module, and can be
maintained with that program or with this DAYO AP Browse of the Purchase
Order Header records.
DAYO AP Version 2.0 TJS LAB
╔═══[ \DAYOINV\POH.DBF ]═════════════════════════════════════════════════════╗
║ PO Name Vendor Open Printed BY ║
║ 39 ACME JAR ACME JAR No Yes TIM ║
║Terms Shipper DATE ETA ║
║NET 60 ROADWAY 03/28/90 03/29/90 ║
║ Taxes Adjustment Freight Subtotal Paid Total Due ║
║ 0.18 0.00 0.00 6.00 0.00 6.18 ║
║Comment ║
║Fill back orders immediately! ║
╚════════════[ Browse the Purchase Orders (PO) Header Database ]═════════════╝
PO VENDOR NAME
────────────────────╥────────────╥───────────────────────────────────────────
31 ║ ACE ║ ACE SUPPLIES
32 ║ ACME JAR ║ ACME JAR
33 ║ ACME JAR ║ ACME JAR
34 ║ ACME JAR ║ ACME JAR
35 ║ ACME JAR ║ ACME JAR
36 ║ ACME JAR ║ ACME JAR
37 ║ ACME JAR ║ ACME JAR
38 ║ ACME JAR ║ ACME JAR
39 ║ ACME JAR ║ ACME JAR
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5 (PO) F6 (Name) F7 (Vendor Number)
22/22
DAYO AP, TJS LAB Page: 14
■ BROWSE PURCHASE ORDER HEADERS - FULL SCREEN EDIT
DAYO AP Version 2.0 TJS LAB
┌───────────────────────────[ FULL SCREEN EDIT ]─────────────────────────────┐
│ PO: 39 PRINTED: T │
│ VENDOR: ACME JAR COMMENT: Fill back orders immed │
│ NAME: ACME JAR │
│ ATTN: │
│ ADDR1: 400 WEST LAKE ROAD │
│ ADDR2: WAREHOUSE #10 │
│ CITY: WRIGHTSBORO │
│ STATE: GA │
│ ZIP: 23619 │
│ PHONE: (404) 932-1922 │
│ DATE: 03/28/90 │
│ ETA: 03/29/90 │
│ SUBTOTAL: 6.00 │
│ TAXES: 0.18 │
│ ADJUST: 0.00 │
│ FREIGHT: 0.00 │
│ PAID: 0.00 │
│ TERMS: NET 60 │
│ SHIPPER: ROADWAY │
│ BY: TIM │
│ OPEN: F │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 15
■ BROWSE PURCHASE ORDER DETAIL
The PO Detail records can be edited using this routine. Keep in mind
that any change in the detail record will not update the header record
(ie: changing the cost of an item will not adjust the subtotal in the header
record).
DAYO AP Version 2.0 TJS LAB
╔═══[ \DAYOINV\POD.DBF ]═════════════════════════════════════════════════════╗
║PO Name Vendor Open Printed BY ║
║ 39 ACME JAR ACME JAR No Yes TIM ║
║Terms Shipper DATE ETA ║
║NET 60 ROADWAY 03/28/90 03/29/90 ║
║ Taxes Adjustment Freight Subtotal Paid Total Due ║
║ 0.18 0.00 0.00 6.00 0.00 6.18 ║
║Comment ║
║Fill back orders immediately! ║
║Item Description VendItem Cost Tax ║
║JAR-1 Jar, Small, Red AJ-123456 1.00 Yes ║
╚════════════[ Browse the Purchase Orders (PO) Detail Database ]═════════════╝
PO VENDOR ITEM DESC
────────────╥────────────╥──────────────╥────────────────────────────────────
34 ║ ACME JAR ║ JAR-03 ║ Jar, Wide Mouth
39 ║ ACME JAR ║ JAR-1 ║ Jar, Small, Red
40 ║ ACME JAR ║ JAR-102 ║ Jar, #1 Blue
40 ║ ACME JAR ║ JAR-39 ║ Jar, #1 Red
40 ║ ACME JAR ║ JAR-3902 ║ Jar, Red
41 ║ ACME JAR ║ JAR-3904 ║ Jar, Green
41 ║ ACME JAR ║ JAR-3914 ║ Jar, Lavendar, Plastic
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5 (PO) F6 (Item) F7 (Vendor Name) F8 (Vendor Number)
37/38
DAYO AP, TJS LAB Page: 16
■ BROWSE PURCHASE ORDER DETAIL - FULL SCREEN EDIT
DAYO AP Version 2.0 TJS LAB
┌───────────────────────────[ FULL SCREEN EDIT ]─────────────────────────────┐
│ PO: 39 │
│ VENDOR: ACME JAR │
│ ITEM: JAR-1 │
│ DESC: Jar, Small, Red │
│ VENDITEM: AJ-123456 │
│ ORDERED: 2 │
│ RECEIVED: 0 │
│ COST: 1.00 │
│ DATE: 03/28/90 │
│ ETA: 03/29/90 │
│ LASTRECV: / / │
│ TYPE: XXX │
│ CLASS: JAR │
│ OPEN: T │
│ TAXABLE: T │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 17
■ BROWSE MAIN INVENTORY DATABASE
This BROWSE is the same as the routine found in the DAYO Inventory
module. Unlike other routines in AP BROWSE, this Inventory BROWSE also
adds 2 more options; to 'move/transfer' quantity between warehouses; and to
make inventory adjustments.
Note, only the first 3 warehouse fields (LOC1, LOC2, LOC3), are
displayed onto the top of the screen. You can see, but not edit, the rest
by moving the cursor to the rightmost fields (Press F1 for Help/more
information).
DAYO AP Version 2.0 TJS LAB BROWSE ┌───[February 1991]──┐
┌────[ \DAYOINV\INV.DBF ]──────────────────────────────┐│S M T W T F S │
│Item: JAR-1 Desc: Jar, #1 │├────────────────────┤
│Vendor Item: AJ-123456 Vendor: RD ││ 1 2 3 4 5 6 7│
│Onhand: 3 On Order: 302 ││ 8 9 10 11 12 13 14│
│PTD Sold: 2 YTD Sold: 340 ││15 16 17 18 19 20 21│
│Cost: 1.00 Price: 2.00 Retail: 3.00││22 23 24 25 26 27 28│
│Type: XXX Class: JAR Taxable: Y Serial No: N ││29 30 │
│Warehouses Loc1: 0 Loc2: 0 Loc3: 0 ││ │
└────────────────────────[ Inventory Database Browse ]─┘└────────────────────┘
ITEM DESC ONHAND ONORDER BO
───────────────╥────────────────────────────────╥─────────╥─────────╥─────────
JAR-1 ║ Jar, #1 ║ 3 ║ 302 ║ 100
JAR-2 ║ Jar, #2 ║ 1 ║ 606 ║ 20
JAR-3 ║ Jar, #2 ║ 1 ║ 901 ║ 430
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
Esc (Exit) F1 (Help) F2 (Edit) F4 (Warehouses) Shift F1 (Adjustment)
Ctrl N (Add) Ctrl U (Delete)
Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type)
1/3
DAYO AP, TJS LAB Page: 18
■ BROWSE MAIN INVENTORY DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB BROWSE ┌───[February 1991]──┐
┌───────────────────────────[ FULL SCREEN EDIT ]─────────────────────────────┐
│ ITEM: JAR-1 LOCATION: STO │
│ DESC: Jar, #1 │
│ ONHAND: 3 │
│ ONORDER: 302 │
│ BO: 100 │
│ SOLDPTD: 2 │
│ SOLDYTD: 0 │
│ VENDITEM: AJ-123456 │
│ VENDOR: SDF │
│ DATE: / / │
│ LASTDATE: / / │
│ COST: 1.00 │
│ RETAIL: 3.00 │
│ PRICE: 2.00 │
│ STOCKLEVEL: 66 │
│ TYPE: XXX │
│ CLASS: JAR │
│ TAXABLE: T │
│ SERIALNO: F │
│ WEIGHT: 4.25 │
│ UNIT: EA │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 19
■ BROWSE MAIN INVENTORY DATABASE - WAREHOUSE TRANSFER
Press F4 to 'move'/transfer item quantities from one warehouse into
another.
Valid warehouses include the Onhand field (for the main inventory -
INV.DBF), and all fields that start with 'LOC' (ie: LOC1, LOC2 ...), that
are located in the database WAREHOUS.DBF.
To move quantity, select a warehouse that has a quantity greater than
zero, and press enter/return.
DAYO AP Version 2.0 TJS LAB BROWSE ┌───[February 1991]──┐
┌────[ \DAYOINV\INV.DBF ]───────────────────┌─────────────────────┐ T F S │
│Item: JAR-1 Desc: Jar, #1 │ WAREHOUSE TRANSFERS │──────────┤
│Vendor Item: AJ-123456 Vendor: RD ╞═════════════════════╡4 5 6 7│
│Onhand: 3 On Order: 302 │ Warehouse Qty │1 12 13 14│
│PTD Sold: 2 YTD Sold: 340 │ Onhand 400 │8 19 20 21│
│Cost: 1.00 Price: 2.00 Retail:│ LOC1 0 │5 26 27 28│
│Type: XXX Class: JAR Taxable: Y Serial No:│ SLLOC1 1 │ │
│Warehouses Loc1: 0 Loc2: 0 Loc3: │ LOC2 0 │ │
└──────────────────────[ Inventory Database │ SLLOC2 0 │──────────┘
│ LOC3 0 │
ITEM DESC │ SLLOC3 0 │ BO
─────────────╥────────────────────────────│ LOC4 0 │───────────
JAR-1 ║ Jar, #1 │ SLLOC4 0 │ 101
JAR-2 ║ Jar, #2 │ LOC5 0 │ 43
JAR-3 ║ Jar, #3 │ SLLOC5 0 │ 23
║ │ LOC6 0 │
║ ╞═════════════════════╡
║ │ Select a Warehouse │
║ │ with a quantity > 0 │
║ │ to transfer quantity│
Esc (Exit) F1 (Help) F2 (Edit) F4 (W│ FROM... │justment)
Ctrl N (Add) Ctrl U (Delete) └─────────────────────┘
Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type)
1/3
A prompt will appear onto the screen requesting you to enter the
quantity that you wish to transfer. The default is the total quantity from
the warehouse that is losing the quantity. After making your edit, press
enter/return to log/post the change.
┌────────────────────────────────────────────────┐
│ Enter Quantity to be Transferred: 400 │
└────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 20
■ BROWSE MAIN INVENTORY DATABASE - INVENTORY ADJUSTMENT
Press Shift F1 to make an Inventory Adjustment. Inventory Adjustments
should only be made to make a correction to the normal, computer maintained
process of adjusting the inventory via the DAYO POS, Receiving, and AP
modules/programs.
To make an Inventory Adjustment permanent (post), you must enter a
reason for the edit/adjustment (anything, except spaces, is acceptable).
DAYO AP Version 2.0 TJS LAB BROWSE ┌───[February 1991]──┐
┌──────────────────────────────────────────────────────┐│S M T W T F S │
│Item: JAR-1 Desc: Jar, #1 │├────────────────────┤
│Vendor Item: AJ-123456 Vendor: SDF ││ 1 2 3 4 5 6 7│
│Onhand: 210 On Order: 302 ││ 8 9 10 11 12 13 14│
│PTD Sold: 2 YTD Sold: 0 ││15 16 17 18 19 20 21│
│Cost: 1.00 Price: 2.00 Retail: 3.00 ││22 23 24 25 26 27 28│
│Type: XXX Class: JAR Taxable: Y Serial No: N ││29 30 │
│Warehouses Loc1: 3 Loc2: 10 Loc3: 0 ││ │
│ INVENTORY ADJUSTMENT │└────────────────────┘
│ Cost: 1.00│ A positive Qty adds to the │
│ Price: 2.00│ inventory. │ ONORDER BO
│ Retail: 3.00│ A negative Qty removes from │╥─────────╥───────────
│ Qty: 1│ the inventory. │║ 302 ║ 100
│ Reason: Internal Use │║ 606 ║ 200
└──────────────────────────────────────────────────────┘║ 901 ║ 300
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
Esc (Abort)
You must Enter a REASON to complete the Adjustment!
DAYO AP, TJS LAB Page: 21
■ BROWSE INVENTORY ADJUSTMENTS DATABASE
All 'manual' Inventory Adjustments are found in the database INVADJ.DBF.
You can view and/or edit adjustments, however editing adjustments is not
recommended.
Note, the operator name that made the adjustment is included on the
record.
The VARIANCE field is computed as follows:
VARIANCE = ( INVENTORY COST - ADJUSTED COST ) * ( NEW ONHAND TOTAL )
Note, the VARIANCE equals zero if the COST remains the same...
DAYO AP Version 2.0 TJS LAB
╔═══[ \DAYOINV\INVADJ.DBF ]══════════════════════════════════════════════════╗
║Item VendItem Description Date ║
║JAR-1 AJ-123456 Jar, #1 02/18/90 ║
║ Qty Cost Price Retail Variance ║
║ 30 99.50 147.00 199.99 0.00 ║
║Reason By/Operator ║
║FOUND IN THE STORE ROOM Tim Johnson ║
╚═══════════════[ Browse the Inventory Adjustments Database ]════════════════╝
ITEM VENDITEM QTY COST PRICE RETAIL
──────────────╥──────────────╥─────────╥────────────╥────────────╥───────────
JAR-1 ║ AJ-123456 ║ 30 ║ 99.50 ║ 147.00 ║ 199.99
JAR-2 ║ AJ-123457 ║ 430 ║ 35.43 ║ 98.99 ║ 121.99
JAR-3 ║ AJ-123458 ║ 32 ║ 94.50 ║ 139.49 ║ 299.49
JAR-4 ║ AJ-123459 ║ 789 ║ 345.50 ║ 549.99 ║ 899.99
JAR-5 ║ AJ-223460 ║ 150 ║ 95.50 ║ 149.99 ║ 299.99
JAR-6 ║ AJ-223461 ║ 330 ║ 19.50 ║ 89.99 ║ 119.99
JAR-7 ║ AJ-223462 ║ 156 ║ 29.50 ║ 99.99 ║ 129.99
JAR-8 ║ AJ-223463 ║ 164 ║ 39.50 ║ 109.99 ║ 139.99
JAR-12 ║ AJ-223464 ║ 34 ║ 49.50 ║ 119.99 ║ 149.99
JAR-13 ║ AJ-223466 ║ 3 ║ 59.50 ║ 129.99 ║ 159.99
JAR-13A ║ AJ-323467 ║ 0 ║ 69.50 ║ 139.99 ║ 169.99
JAR-14 ║ AJ-453488 ║ 345 ║ 79.50 ║ 149.99 ║ 179.99
║ ║ ║ ║ ║
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
10/11
DAYO AP, TJS LAB Page: 22
■ BROWSE INVENTORY ADJUSTMENTS DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ ITEM: JAR-1 │
│ VENDITEM: AJ-123456 │
│ QTY: 30 │
│ COST: 99.50 │
│ PRICE: 147.00 │
│ RETAIL: 199.99 │
│ DOLLARS: 0.00 │
│ REASON: FOUND IN THE STORE │
│ BY: Tim Johnson │
│ DATE: 02/18/90 │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 23
■ BROWSE WAREHOUSE INVENTORY DATABASE
DAYO currently supports multiple warehouses to the extent that it
provides the mechanism to 'move'/transfer quantities into the database
WAREHOUS.DBF. DAYO does not have any computerized routine that will
automatically adjust the inventory (ie: DAYO POS, Receiving...).
DAYO AP Version 2.0 TJS LAB
┌────[ \DAYOINV\WAREHOUS.DBF ]───────────────────────────────────────────────┐
│ Item VendItem Description │
│ JAR-1 AJ-123456 Jar, #1 │
│ Cost Price Retail Onhand Main Warehouse │
│ 1.00 2.00 3.00 210 │
└───────────────────[ Inventory Warehouse Database Browse ]──────────────────┘
ITEM LOC1 SLLOC1 LOC2 SLLOC2 LOC3 SLLOC3
────────────────╥─────────╥─────────╥─────────╥─────────╥─────────╥──────────
JAR-1 ║ 0 ║ 1 ║ 0 ║ 10 ║ 0 ║ 0
JAR-2 ║ 3 ║ 3 ║ 0 ║ 10 ║ 3 ║ 0
JAR-4 ║ 30 ║ 2 ║ 0 ║ 10 ║ 0 ║ 0
║ ║ ║ ║ ║ ║
║ ║ ║ ║ ║ ║
║ ║ ║ ║ ║ ║
║ ║ ║ ║ ║ ║
║ ║ ║ ║ ║ ║
║ ║ ║ ║ ║ ║
║ ║ ║ ║ ║ ║
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
Find F5 (Item)
DAYO AP, TJS LAB Page: 24
■ BROWSE WAREHOUSE INVENTORY DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ ITEM: JAR-1 │
│ LOC1: 0 │
│ SLLOC1: 1 │
│ LOC2: 0 │
│ SLLOC2: 0 │
│ LOC3: 0 │
│ SLLOC3: 0 │
│ LOC4: 0 │
│ SLLOC4: 0 │
│ LOC5: 0 │
│ SLLOC5: 0 │
│ LOC6: 0 │
│ SLLOC6: 0 │
│ LOC7: 0 │
│ SLLOC7: 0 │
│ LOC8: 0 │
│ SLLOC8: 0 │
│ LOC9: 0 │
│ SLLOC9: 0 │
│ LOC10: 390 │
│ SLLOC10: 3 │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 25
■ BROWSE WAREHOUSE NAMES DATABASE
The names of your warehouses are found in the database WARENAME.DBF. For
each 'LOC' field in the database WAREHOUS.DBF, add a corresponding/related
record to this database. The names of the warehouses are used on some of the
DAYO Inventory reports.
DAYO AP Version 2.0 TJS LAB
┌────[ \DAYOINV\WARENAME.DBF ]───────────────────────────────────────────────┐
│ Warehouse Name │
│ LOC1 RETURN TO VENDOR FOR REPAIR │
│ Comments │
│ │
└─────────────────[ Inventory Warehouse Name Database Browse ]───────────────┘
LOC NAME
───────────────────────────╥────────────────────────────────────────────────
LOC1 ║ RETURN TO VENDOR FOR REPAIR
LOC2 ║ INTERNAL/OFFICE USE
LOC3 ║ DISCONTINUED
LOC4 ║ DAMAGED
LOC5 ║ BUILDING # 1001
LOC6 ║ IN USE, SHOP FLOOR
LOC7 ║ OUT ON LOAN
║
║
║
Find F5 (Name)
1/7
■ BROWSE WAREHOUSE NAMES DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ LOC: LOC1 │
│ NAME: RETURN TO VENDOR FOR │
│ COMMENTS: │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 26
■ BROWSE RECEIVING DATABASE
Each time items are received into your inventory from Vendors, a record
is created in the REC.DBF. This record is created by the RECEIVING routine
in the DAYO Inventory module. This record is often called a Receiver or
KeyRec.
These records should be maintain by the computer, and only used to view
the data, but you can edit the records.
DAYO AP Version 2.0 TJS LAB
┌───[ \DAYOINV\REC.DBF ]─────────────────────────────────────────────────────┐
│ PO Vendor Name Date ETA Open│
│ 30 ACME JAR 11/12/89 02/28/90 No │
│Terms Shipper Receiver Date Purc Cleared │
│NET 60 UPS 03/28/90 Yes │
│Receiver Item VendItem Description │
│ 38 JAR-1 RD1200 Jar, #1 │
│Received Cost Each Extended Cost By │
│ 10.00 4.54 45.40 TOM JOHNSON │
└──────────────[ Inventory Receipts/Receivers Database Browse ]──────────────┘
KEY PO VENDOR ITEM DESC
─────────╥────────╥────────────╥──────────────╥───────────────────────────────
38 ║ 30 ║ ACME JAR ║ JAR-1 ║ Jar, #1
38 ║ 30 ║ ACME JAR ║ JAR-4 ║ Jar, #4
38 ║ 30 ║ ACME JAR ║ JAR-5 ║ Jar, #5
39 ║ 33 ║ RD ║ LID, #04 ║ LID, #
39 ║ 33 ║ RD ║ LID, #09A ║ LID, #
39 ║ 33 ║ RD ║ LID, #72 ║ LID, #
39 ║ 33 ║ RD ║ LID, #758 ║ LID, #
39 ║ 33 ║ RD ║ LID, #84 ║ LID, #
40 ║ -999 ║ ║ ║ * Voided while in Receiving *
41 ║ 56 ║ AC MAURO ║ AC M123 ║ Jar, #1
Find F5 (Receiver/Key) F6 (PO) F7 (Item) F8 (VendItem)
95/106
DAYO AP, TJS LAB Page: 27
■ BROWSE RECEIVING DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ KEY: 38 │
│ PO: 30 │
│ VENDOR: ACME JAR │
│ ITEM: JAR-1 │
│ DESC: Jar, #1 │
│ VENDITEM: RD1200 │
│ RECEIVED: 10 │
│ COST: 4.54 │
│ DATE: 03/28/90 │
│ BY: CURTIS JOHNSON │
│ PC: T │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 28
■ BROWSE CHECKING ACCOUNTS DATABASE
For each Checking Account you should create a record in the database
ACCOUNTS.DBF. The presence of a unique account in this database is required
before any checks, or AP posting can be accomplished for that account.
This routine allows you to add/maintenance your Checking Accounts.
If you have only one Checking Account, you can overwrite the default one
as listed below:
Note, the current BALANCE for each account is computer maintained.
DAYO AP Version 2.0 TJS LAB
╔════[ ACCOUNTS.DBF ]════════════════════════════════════════════════════════╗
║ Number Account # Bank/Account Name Balance║
║ 1 Checking Account # Your Banks Name ║
║ Phone Type Date Last Date Last Deposit ║
║ / / / / ║
╚══════════════════[ Browse the Checking Accounts Database ]═════════════════╝
NUMBER NAME ACCTNUM BALANCE
─────────╥────────────────────────────────╥──────────────────────╥────────────
1 ║ Your Banks Name ║ Checking Account # ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
Find F5 (Journal #) F6 (Check #) F7 (Account #) F8 (Name) F9 (For)
1/2
DAYO AP, TJS LAB Page: 29
■ BROWSE CHECKING ACCOUNTS DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ NUMBER: 1 │
│ NAME: Your Banks Name │
│ ACCTNUM: Checking Account # │
│ BALANCE: │
│ ADDR1: │
│ ADDR2: │
│ CITY: │
│ STATE: │
│ ZIP: │
│ PHONE: │
│ TYPE: │
│ DATE: / / │
│ LASTDATE: / / │
│ LDEPOSIT: 0.00 │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 30
■ BROWSE CHECKS DATABASE
Each time a check is created, the record of it is recorded in the
database CHECKS.DBF.
DAYO AP Version 2.0 TJS LAB
╔════[ CHECKS.DBF ]══════════════════════════════════════════════════════════╗
║ Number Account # Bank/Account Name Balance ║
║ 1 12345-090909 Orlando National Bank 71061.87 ║
║ Journal Reason/For Type Amount ║
║ 87 Pay off Company Yacht XXX 1102000.10 ║
║ Date By/Operator Acct Type # ║
║ 03/28/90 JOHN SMITH AP - Vendor/Misc RD ║
╚══════════════[ Browse the (Posted & Printed) Checks Database ]═════════════╝
CHECKNO ACCTNUM NUMBER AMOUNT
───────────────────────╥──────────────────────╥────────╥──────────────────────
100017 ║ 12345-090909 ║ 1 ║ 1102000.10
100018 ║ 12345-090909 ║ 1 ║ 23440.60
100019 ║ 12345-090909 ║ 1 ║ 2000.00
100020 ║ 12345-090909 ║ 1 ║ 37.00
100021 ║ 12345-090909 ║ 1 ║ 57.00
100022 ║ 12345-090909 ║ 1 ║ 49.52
100023 ║ 12345-090909 ║ 1 ║ 80.22
100024 ║ 12345-090909 ║ 1 ║ 345.01
100025 ║ 12345-090909 ║ 1 ║ 7.16
100026 ║ 12345-090909 ║ 1 ║ 453.99
100027 ║ 12345-090909 ║ 1 ║ 23457.49
Find F5 (Journal #) F6 (Check #) F7 (Account #) F8 (Name) F9 (For)
35/35
■ BROWSE CHECKS DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ CHECKNO: 100017 │
│ ACCTNUM: Orlando National Bank │
│ NUMBER: 1 │
│ AMOUNT: 1102000.10 │
│ NAME: John Lawn │
│ WHATFOR: Confiscated Yacht (Drugs) │
│ DATE: 03/28/90 │
│ JOURNAL: 87 │
│ ACCOUNT: RD │
│ CV: F │
│ TYPE: 3 │
│ CFORMAT: 1 │
│ BY: tj │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 31
■ BROWSE CHECK PRINTING FORMATS DATABASE
For each check form you print (no limit), you must enter the printer
settings (ie: length, width, row/column of each printed field).
DAYO AP creates a record for one check format sold by NEBS, Computer
Forms Division, 500 Main Street, Groton, MA 01471 (800) 225-9550.
Their product number for the check that conforms to the Default settings is
Q9037. Note, this one was picked because it is a multipurpose check, and
TJS LAB staff liked its looks!
DAYO AP Version 2.0 TJS LAB
╔════[ CHECK PRINTING FORMATS ]══════════════════════════════════════════════╗
║ Format Name Check Length Width Voucher Start End║
║ 1 NEBBS RADIO SHACK CHECK 41 80 4 20 ║
║ Coordinate Row Column ║
║Amount (in Words): 29 6 █████░ ║
║ Amount (numeric): 34 64 █░ ║
║Payable To (Name): 34 6 █░ ║
║Payable To Address: 35 6 ████░ █░ ║
║Customer/Vendor #: 34 40 █░ ▄███▄ █▄██░ █▄█▄█░ ▀▀█▄ ▄███▄ ║
║ Date of Check: 34 52 █░ █░ █░ █▀ █▀█▀█░ █░ █░ ║
║ Reason for Check: 39 6 █░ █░ █░ █░ █░█ █░ █▀▀█░ █░ ║
║ Voucher Column Left: 0 █░ ▀███▀ █░ █░ █░ █▄▄█▄ █▄█░ ║
║ Voucher Column Right: 80 ──────────────────────────────────────── ║
║ Printer Setup String [ Use 'esc' in lieu of the escape code -> chr(27) ] ║
║ ║
╚════════════════[ Browse the Checking Account Print Formats ]═══════════════╝
CFORMAT NAME
───────────────────────────╥─────────────────────────────────────────────────
1 ║ NEBBS RADIO SHACK CHECK
║
║
║
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall)
1/4
The Full Screen Edit functions differently from the other AP BROWSE
screens. The data entry prompts replace the displayed values atop the
screen.
DAYO AP, TJS LAB Page: 32
■ BROWSE CHECKING ACCOUNT DEPOSITS
For each deposit made to any of your checking accounts, you need to add
and maintain a record of it in this database (DEPOSITS.DBF).
Note, data entry does update the current balance in the ACCOUNTS.DBF.
DAYO AP Version 2.0 TJS LAB
╔════[ DEPOSITS.DBF ]════════════════════════════════════════════════════════╗
║ Number Account # Bank/Account Name Balance║
║ 1 12345-090909 Orlando National Bank 76061.87║
║ Deposit Reason/For Type Amount ║
║ 10223 Operations Fees From KGB KGB 5000.00 ║
║ Date By/Operator ║
║ 03/10/90 JOHN SMITH ║
╚══════════════[ Browse the Checking Account Deposits Database ]═════════════╝
DEPOSIT ACCTNUM NUMBER
────────────────────────────╥──────────────────────╥──────────────────────────
10223 ║ 12345-090909 ║ 1
10224 ║ 12345-090909 ║ 1
10225 ║ 12345-090909 ║ 1
10226 ║ 12345-090909 ║ 1
10227 ║ 12345-090909 ║ 1
10228 ║ 12345-090909 ║ 1
10229 ║ 12345-090909 ║ 1
10230 ║ 12345-090909 ║ 1
10231 ║ 12345-090909 ║ 1
10232 ║ 12345-090909 ║ 1
Find F5 (Deposit) F6 (Account Number) F7 (Number) F8 (Reason/For)
21/22
■ BROWSE DEPOSITS DATABASE - FULL SCREEN EDIT
Press F2 to bring up a Full Screen data entry screen:
DAYO AP Version 2.0 TJS LAB
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ DEPOSIT: 10223 │
│ ACCTNUM: 12345-090909 │
│ NUMBER: 1 │
│ WHATFOR: Operations Fees From KGB │
│ TYPE: KGB │
│ AMOUNT: 5000.00 │
│ DATE: 03/10/90 │
│ BY: JOHN SMITH │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 33
■ BATCH CHECKS
Check writing in batch mode is accomplished with this option. You can
batch print all your 'open' Accounts Payable records, and/or batch print
your Recurring Checks.
╔══════════════════════════╗
║ BATCH CHECKS ║
╟──────────────────────────╢
║ Prepare Batch Checks ║
║ Browse Batch Checks ║
║ Print Batch Checks Draft ║
║ Print & Post Batch Check ║
║ Browse Recurring Checks ║
║ Print Recurring Draft ║
║ Print & Post Recurring ║
║ Exit ║
╟──────────────────────────╢
║ Select Option ║
╚══════════════════════════╝
■ PREPARE BATCH CHECKS
Before running the AP Batch Checks, you must post closed Purchase Order
data with the POSTING routine (from the main menu). The next step is to run
the 'Prepare Batch Checks' option. This option creates temporary check
records in the file TCHECKS.DBF for each Vendor. The amount of check is the
sum of that Vendors open payables.
After selecting the 'Prepare Batch Checks' option, you will be presented
with 3 prompts to enter your Checking Account Number, Check Printing Format,
and the starting Check Number.
DAYO AP, TJS LAB Page: 34
■ SELECT CHECKING ACCOUNT NUMBER
Only a valid Checking Account Number is accepted at the following
prompt. You can, however, enter nothing (spaces), or a wrong Checking
Account Number to bring up a browse screen of all the valid Checking
Accounts to select from:
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔══════════════════════════╗ │S M T W T F S │
╔═════════════════════════════════════════════════╗▄ ├────────────────────┤
║ PREPARE BATCH CHECKS ║█░ │ 1 2 3 4 5 6 7│
║ This routine will sum all the unpaid AP Header ║█░ │ 8 9 10 11 12 13 14│
║ records for each Vendor, and create a temporary ║█░ │15 16 17 18 19 20 21│
║ Check Record for it (that you can later edit). ║█░ │22 23 24 25 26 27 28│
║ ║▀ │29 30 │
║ Enter Checking Account Number: ║ │ │
║┌────────────────────────[ Select Checking Account ]───────────────────────┐┘
║│NUMBER NAME ACCTNUM BALANCE │
║│───────╥───────────────────────────────╥─────────────────────╥────────────│
║│1 ║ Your Banks Name ║ Checking Account # ║ 71061.87 │
║│ ║ ║ ║ │
║│ ║ ║ ║ │
║│ ║ ║ ║ │
║│ ║ ║ ║ │
║│ ║ ║ ║ │
║│ ║ ║ ║ │
║│ ║ ║ ║ │
╚└──────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 35
■ SELECT CHECK PRINTING FORMAT
Like the Checking Account Number prompt, the Check Printing Prompt must
be a valid one. Enter nothing, or a wrong Check Printing Format code to
bring up a browse screen of all the valid Check Printing Formats to select
from:
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔══════════════════════════╗ │S M T W T F S │
╔═════════════════════════════════════════════════╗▄ ├────────────────────┤
║ PREPARE BATCH CHECKS ║█░ │ 1 2 3 4 5 6 7│
║ This routine will sum all the unpaid AP Header ║█░ │ 8 9 10 11 12 13 14│
║ records for each Vendor, and create a temporary ║█░ │15 16 17 18 19 20 21│
║ Check Record for it (that you can later edit). ║█░ │22 23 24 25 26 27 28│
║ ║▀ │29 30 │
║ Enter Checking Account Number: 1 ║ │ │
║ ║ └────────────────────┘
║┌──────────────────────[ Select Check Printing Format ]────────────────────┐
║│ CFORMAT NAME │
║│──────────────────────────╥───────────────────────────────────────────────│
║│ 1 ║ NEBBS RADIO SHACK CHECK │
║│ ║ │
║│ ║ │
║│ ║ │
║│ ║ │
║│ ║ │
║│ ║ │
╚└──────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 36
■ SELECT STARTING CHECK NUMBER
A starting check number is required so that all checks can be
automatically numbered sequencially.
Be very sure to select the right starting number!
A progress graph will be displayed during the operation...
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔══════════════════════════╗ │S M T W T F S │
╔═════════════════════════════════════════════════╗▄ ├────────────────────┤
║ PREPARE BATCH CHECKS ║█░ │ 1 2 3 4 5 6 7│
║ This routine will sum all the unpaid AP Header ║█░ │ 8 9 10 11 12 13 14│
║ records for each Vendor, and create a temporary ║█░ │15 16 17 18 19 20 21│
║ Check Record for it (that you can later edit). ║█░ │22 23 24 25 26 27 28│
║ ║▀ │29 30 │
║ Enter Checking Account Number: 1 ║ │ │
║ ║ └────────────────────┘
║ Enter Check Format Number: NEBBS RADIO SHACK ║─────────────────────────╖
║ ║ ║
║ Enter Beginning Check Number: 32 ║─────────────────────────╢
║ Vendor Name Amount ║ RECORDS SIZE ║
║ ACME JAR JOHN SMITH 102.00 ║─────────────────────────╢
║ ║rs 22 9K ║
║ ║l 38 5K ║
║ ║r 55 24K ║
║ ║l 154 20K ║
║ ║ 14 5K ║
║ ║enses 7 1K ║
╟────────────────┬────────────────┬───────────────╢gister 35 7K ║
╟█████████████████████████████████████────────────╢ 22 3K ║
╚════════════════╧════════════════╧═══════════════╝═════════════════════════╝
Standby While I Prepare the Batch Checks! Checks Total: 102.00
DAYO AP, TJS LAB Page: 37
■ BROWSE BATCH CHECKS
You can browse the temporary batch checks until you 'Print & Post Batch
Checks' (the 4th option...).
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔══════════════════════════╗ │S M T W T F S │
╔════════════════════════════════════════════════════════════════════════════╗
║ BROWSE BATCH CHECKS ║
╟────────────────────────────────────────────────────────────────────────────╢
║ CHECKNO ACCTNUM NUMBER AMOUNT ║
║──────────────────────╥──────────────────────╥────────╥─────────────────────║
║ 10000 ║ 12345-909090 ║ 1 ║ 154.69 ║
║ 10001 ║ 12345-909090 ║ 1 ║ 134.99 ║
║ 10002 ║ 12345-909090 ║ 1 ║ 100.57 ║
║ 10003 ║ 12345-909090 ║ 1 ║ 39.59 ║
║ 10004 ║ 12345-909090 ║ 1 ║ 39.50 ║
║ 10005 ║ 12345-909090 ║ 1 ║ 397.75 ║
║ 10006 ║ 12345-909090 ║ 1 ║ 93.00 ║
║ 10007 ║ 12345-909090 ║ 1 ║ 193.47 ║
║ 10008 ║ 12345-909090 ║ 1 ║ 184.43 ║
║ 10009 ║ 12345-909090 ║ 1 ║ 235.74 ║
║ 10010 ║ 12345-909090 ║ 1 ║ 100.43 ║
║ ║ ║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl U (Delete) Ctrl N (Add)
<NONE>
■ BROWSE BATCH CHECKS - FULL SCREEN EDIT
Press F2 for a Full Screen Edit:
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
┌────────────────[ EDIT BATCH CHECK RECORD - FULL SCREEN EDIT ]──────────────┐
│ CHECKNO: 1230 │
│ ACCTNUM: 12345-909090 │
│ NUMBER: 1 │
│ AMOUNT: 340.00 │
│ NAME: ACME JAR │
│ WHATFOR: 12345,1029,93903 │
│ DATE: 11/02/89 │
│ JOURNAL: 110 │
│ ACCOUNT: XAD │
│ CV: F │
│ TYPE: │
│ CFORMAT: │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 38
■ PRINT BATCH CHECKS DRAFT
This routine provides you a means of printing checks onto plain paper,
in the same format as if they were printed onto the special check forms.
Since no posting of the data is done, you can run this option as many times
as you wish.
╔═════════════════════════════════════════════════╗
║ PRINT BATCH CHECKS DRAFT ║
║ This routine will print a DRAFT for each Batch ║
║ Check (on normal paper). Review this printout ║
║ before you print the actual checks! ║
║ ║
║ Enter Checking Account Number: 1 ║
║ ║
║ Enter Check Format Number: 1 ║
║ ║
║ Enter Beginning Check Number: 10000 ║
║ Checkno Name Amount ║
║ 10000 JOHN DOE 100.00║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╟────────────────┬────────────────┬───────────────╢
╟████████████████████████████████████████████████─╢
╚════════════════╧════════════════╧═══════════════╝
Standby While I Print The Draft Batch Checks! Checks Total: 100.00
DAYO AP, TJS LAB Page: 39
■ PRINT BATCH CHECKS DRAFT
Run this option when you are very sure that you want to print the final
check data (from the database TCHECKS.DBF).
The printing and posting progress is displayed by the display of the
Check number, Payee, and Amount, a graph, and the database getting data
posted to it.
It is critical that this process is not interrupted!
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔══════════════════════════╗ │S M T W T F S │
╔════════════════════════════════════════════════╗▄ ├────────────────────┤
║ PRINT BATCH CHECKS & POST ! ║█░ │ 1 2 3 4 5 6 7│
║This routine prints your Batch Checks, and Posts║█░ │ 8 9 10 11 12 13 14│
║the check amounts to the vendor/customer record.║█░ │15 16 17 18 19 20 21│
║Verify/browse the Batch Checks before printing! ║█░ │22 23 24 25 26 27 28│
║ ║▀ │29 30 │
║ Enter Checking Account Number: 1 ║ │ │
║ ║ └────────────────────┘
║ Enter Check Format Number: 1 ║─────────────────────────╖
║ ║ ║
║ Enter Beginning Check Number: 10000 ║─────────────────────────╢
║ Checkno Name Amount ║ RECORDS SIZE ║
║ 10000 JOHN DOE 100.00║─────────────────────────╢
║ ║╔══════════════════════════╗
║ ║║POSTING & PRINTING PROG. ║
║ ║╟──────────────────────────╢
║ ║║ Vendor/Customer Record ║
║ ║║»─>AP Header/AR Receipts ║
║ ║║ Check Register ║
╟────────────────┬────────────────┬──────────────╢║ Checking Account Bal. ║
╟████████████████████████████████████████████████╢║ Printing Check ║
╚════════════════╧════════════════╧══════════════╝╚══════════════════════════╝
Standby While I Print & Post The Batch Checks! Checks Total: 100.00
DAYO AP, TJS LAB Page: 40
■ BROWSE RECURRING CHECKS
All Recurring Checks must be added to the database RECHECK.DBF before a
check can be printed in the batch mode.
This 'colorful' browse routine displays a facsimile of the Recurring
Check atop the screen.
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔████████████████████████████████████████████████████████████████████████████│
║█░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┤
╟█░░░░░░░░░░░░░Bank Orlando National Bank ░░░░░░░░░░# 1232░░░░░░░░█│
║█░Pay Two Hundred Forty-Three Dollars & Thirty-Seven Cents░░░░░░░░░░░░░░░░░█│
║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ID░░░░░░░░░░Date░░░░░░Amount░░░░░░░░█│
║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ACME JAR ░░03/04/90░░$******243.37░█│
║█░To The JOHN SMITH ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│
║█░ Order PO BOX 10000 ░░░░░For Yacht █│
║█░ Of ░░░░░░░░░░░░░░░░░░░░BIMONTH ░░░░░░█┘
║█░░░░░░░░HOUSTON, TX 90900 ░░░░░░░░░░░░░░░░Due Now!░░░░░░░░█
║████████████████████████████████████████████████████████████████████████████
╟┌──────────────────────────────────────────────────────────────────────────┐
║│ Number 1 Account # 24 234 23 Check Format 1 Vendor Check │
╚└──────────────────────────────────────────────────────────────────────────┘
╔════════════════════════[ BROWSE RECURRING CHECKS ]═══════════════════════╗
║ RECURRING NAME VE LASTDATE SCHEDULE ║
║────────────╥────────────────────────────────╥────╥──────────╥────────────║
║ 2 ║ JOHN SMITH ║ T ║ 02/01/90 ║ BIMONTH ║
║ 3 ║ ACME JARS ║ T ║ 11/11/11 ║ MIDMONTH ║
╚══════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (* Help *) F2 (Edit) Ctrl U (Delete) Ctrl N (Add)
Ctrl F1 (Mark Print) Ctrl F2 (UnMark Print) Alt F1 (Summary)
Find: F5 (RECURRING) F6 (NAME) F7 (SCHEDULE) F8 (ACCOUNT)
■ SCHEDULE CODES
When you add/create a new Recurring Check record, always enter the
Schedule Code that determines the frequency that a check be made. Valid
Schedule Codes are:
SUNDAY Only on a Sunday
MONDAY Only on a Monday
TUESDAY Only on a Tuesday
WEDNESDAY Only on a Wednesday
THURSDAY Only on a Thursday
FRIDAY Only on a Friday
SATURDAY Only on a Saturday
MM/DD/YY On a Specific Date (ie: '01/31/91' for January 31, 1991)
DAYSxxx Every Few Days, (ie: 'DAYS 21' for every 21 days)
SEMIMONTH Every 2 Weeks
MIDMONTH Mid Month
EOM End of Month
BEGMONTH Beginning of the Month
BIMONTH Every 2 Months (60 Days)
QUARTERLY Every Quarter (90 Days)
ANNUAL Once a Year
DAYO AP, TJS LAB Page: 41
■ BROWSE RECURRING CHECKS - FULL SCREEN EDIT
Press F2 for a Full Screen Edit:
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
┌──────────────[ EDIT RECURRING CHECK RECORD - FULL SCREEN EDIT ]────────────┐
│ RECURRING: 2 ZIP: 30909 │
│ NAME: JOHN SMITH PHONE: (407) 295-1704 │
│ VE: T DATE: 03/06/90 │
│ LASTDATE: 03/01/90 COMMENT: CODE NAME CASEY │
│ SCHEDULE: MIDMONTH CFORMAT: 1 │
│ PRINT: T │
│ ACCOUNT: ACME JAR │
│ WHATFOR: TRAVEL EXPENSES │
│ TYPE: KGB │
│ AMOUNT: 5000.00 │
│ SUBTOTAL: 0.00 │
│ TAXES: 0.00 │
│ FREIGHT: 0.00 │
│ ADJUST: 0.00 │
│ TOTALPAID: 349000.00 │
│ ACCTNUM: 12345-909090 │
│ NUMBER: 1 │
│ ADDR1: PO BOX 10000 │
│ ADDR2: │
│ CITY: AUGUSTA │
│ STATE: GA │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO AP, TJS LAB Page: 42
■ MARK/UNMARK FOR PRINTING
Press Ctrl F1 to locate and mark all Recurring Checks that are payable.
All Recurring Check records that are found payable, will be marked ready to
be printed by setting the PRINT field to true (.T.). You can override the
printing by editing this field.
When you select this option, you must select the Check Printing Format
code. Note, only 1 code can be used for a batch print run...
Press Ctrl F2 to UNMARK ALL all Recurring Check records.
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
╔████████████████████████████████████████████████████████████████████████████│
║█░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┤
╟█░░░░░░░░░░░░░Bank Orlando National Bank ░░░░░░░░░░# 23400░░░░░░░░█│
║█░Pay Thirty-Four Dollars & Zero Cents░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│
║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ID░░░░░░░░░░Date░░░░░░Amount░░░░░░░░█│
║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ACME JAR ░░11/08/89░░$*******34.00░█│
║╔══════════════════════════════════════════════════════════════════════════╗│
║║*** Note, only 1 check format can be printed at once... ║│
║║ ║┘
║║Enter Check Format Number: 3 ║
║║ ║
╟║Check Format Selected: 3/NEBBS RADIO SHACK CHECK ║
║╚══════════════════════════════════════════════════════════════════════════╝
╚└──────────────────────────────────────────────────────────────────────────┘
╔════════════════════════[ BROWSE RECURRING CHECKS ]════════════════════════╗
║ RECURRING NAME VE LASTDATE SCHEDULE ║
║────────────╥────────────────────────────────╥────╥──────────╥─────────────║
║ 2 ║ JOHN SMITH ║ T ║ 02/01/90 ║ BIMONTH ║
║ 3 ║ ACME JARS ║ T ║ 11/11/11 ║ MIDMONTH ║
╚═══════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (* Help *) F2 (Edit) Ctrl U (Delete) Ctrl N (Add)
Ctrl F1 (Mark Print) Ctrl F2 (UnMark Print) Alt F1 (Summary)
Find: F5 (RECURRING) F6 (NAME) F7 (SCHEDULE) F8 (ACCOUNT)
Standby while I mark Due checks! (Set PRINT field to .T.)
DAYO AP, TJS LAB Page: 43
■ RECURRING CHECK SUMMARY
Press Alt F1 to list the Recurring Checks that are 'printable' onto
the screen:
╔════════════[ RECURRING CHECK SUMMARY ]═══════════════╗
║Name Amount Subtotal║
║JOHN SMITH 34.00 277.37║
║ANDY ANDREW ALTIZER, INC. 243.37 243.37║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚══════════════════════════════════════════════════════╝
2/3
■ PRINT RECURRING CHECKS DRAFT
This routine will print the Recurring Checks onto plain/regular paper.
Use this option to insure the accuracy of the data and format of the
Recurring Checks BEFORE the final step of 'Print & Post Recurring Checks'.
╔═════════════════════════════════════════════════╗
║ PRINT RECURRING CHECKS DRAFT ║
║ This routine will print a DRAFT check for each ║
║ Recurring Check. Review the printout before ║
║ you print the actual checks! ║
║ ║
║ Enter Checking Account Number: 1 ║
║ ║
║ Enter Check Format Number: 3 ║
║ ║
║ Enter Beginning Check Number: 10000 ║
║ Checkno Name Amount ║
║ 10000 JOHN DOE 3100.00║
║ 10001 JANE DOE 4100.00║
║ 10002 MARY DOE 5100.00║
║ 10003 JOSE DOE 4650.00║
║ 10004 HANK DOE 70.00║
║ ║
╟────────────────┬────────────────┬───────────────╢
╟█████████████████████████████████████████────────╢
╚════════════════╧════════════════╧═══════════════╝
Standby While I Print The Draft Recurring Checks! Checks Total: 17020.00
DAYO AP, TJS LAB Page: 44
■ PRINT & POST RECURRING CHECKS
This routine is the FINAL step in the printing of Recurring Checks.
╔═════════════════════════════════════════════════╗
║ PRINT & POST RECURRING CHECKS ║
║ This routine will print and post recurring ║
║ checks. Use with caution! ║
║ ║
║ Enter Checking Account Number: 1 ║
║ ║
║ Enter Check Format Number: 3 ║
║ ║
║ Enter Beginning Check Number: 35 ║
║ Checkno Name Amount ║
║ 10000 JOHN DOE 3100.00║
║ 10001 JANE DOE 4100.00║
║ 10002 MARY DOE 5100.00║
║ 10003 JOSE DOE 4650.00║
║ 10004 HANK DOE 70.00║
╟────────────────┬────────────────┬───────────────╢
╟████████████████████████████████─┼───────────────╢
╚════════════════╧════════════════╧═══════════════╝
Standby While I Print The Recurring Checks! Checks Total: 17020.00
■ HAND CHECKS
A Hand/Manual Check is created with this routine. Respond to 4 prompts
for:
Vendor, Customer, or Miscellaneous Expense number
Checking Account Number
Check Format Number
Check Number
╔════════════════════════════════════════════════════════╗
║ CREATE 'HAND' CHECKS ║
╟────────────────────────────────────────────────────────╢
║ Use this routine to create and print 'Hand' Checks to ║
║ make a payment for a vendor, miscellaneous expenses, ║
║ or a customer/client (ie: refund). ║
║ Vendor checks create an open 'Credit Check' record in ║
║ the database APH.DBF. Miscellaneous expense checks ║
║ create a closed 'Misc Expense' record in the database ║
║ APH.DBF. Customer/Client checks create an UnApplied ║
║ and negative (-) cash receipts record in the AR ║
║ database RECEIPTS.DBF ║
║ ║
║ Create a hand check for a VENDOR ║
║ VENDOR: ACME JAR, JOHN SMITH ║
║ Enter Checking Account Number: 1 ║
║ Enter Check Format Number: 1 ║
║ Enter Check Number: 32 ║
╚════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 45
■ SELECT ACCOUNT TYPE
The first prompt is for the type of account, Vendor (AP), Customer (AR),
or Miscellaneous Expense (AP). This selection is required so that the
amount of the check can be applied to the appropriate databases.
If the Vendor, Customer, or Miscellaneous Expense number is not known,
then a browse of the select check type will appear onto the screen as shown
below for Vendors:
DAYO AP Version 2.0 TJS LAB HAND CHECKS ┌───[February 1991]──┐
╔══════════════════════════════════════════════════════╗│S M T W T F S │
║ CREATE 'HAND' CHECKS ║├────────────────────┤
╟──────────────────────────────────────────────────────╢│ 1 2 3 4 5 6 7│
║ Use this routine to create and print 'Hand' Checks to║│ 8 9 10 11 12 13 14│
║ make a payment for a vendor, miscellaneous expenses, ║│15 16 17 18 19 20 21│
║ or a customer/client (ie: refund). ║│22 23 24 25 26 27 28│
║ Vendor checks create an open 'Credit Check' record in║│29 30 │
║ the database APH.DBF. Miscellaneous expense checks ║│ │
║ create a closed 'Misc Expense' record in the database║└────────────────────┘
║ APH.DBF. Customer/Client checks create an UnApplied ║──────────────────╖
║ and negative (-) cash receipts record in the AR ║ ║
║ database RECEIPTS.DBF ║──────────────────╢
║ ║ RECORDS SIZE ║
║ Create a hand check for a VENDOR ║──────────────────╢
║ Enter VENDOR Number: ║ 22 9K ║
║┌─────────────────────────────[ Select VENDOR ]─────────────────────────────┐
║│VENDOR NAME ADDR1 │
║│───────────╥────────────────────────────────╥──────────────────────────────│
║│ACME JAR ║ JOHN SMITH ║ PO BOX 10000 │
║│RD ║ RON DAVIDSON, INC ║ 1900 MAURY ROAD │
║│TJS LAB ║ TJS LAB ║ PO BOX 585366 │
║└───────────────────────────────────────────────────────────────────────────┘
Esc (Exit) F1 (Help)
Find: F5 (VENDOR) F6 (NAME)
■ FINAL HAND CHECK EDIT
After passing through the first 4 prompts, you will get one last chance
to make any final edits to the Hand Check. There are 5 final edit prompts:
The Payee can be changed from the default
For/Reason For the check
Amount
Check Type
Date
DAYO AP, TJS LAB Page: 46
A facsimile of the Hand Check is displayed atop the screen during this
process:
DAYO AP Version 2.0 TJS LAB HAND CHECKS ┌───[February 1991]──┐
╔████████████████████████████████████████████████████████████████████████████│
║█░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┤
╟█░░░░░░░░░░░░░░░░░░Your Banks Name░░░░░░░░░░░░░░░░░░░░░░░░░Check # 32░░░░░░█│
║█░Pay ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│
║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ID░░░░░░░░░░Date░░░░░░Amount░░░░░░░░█│
║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ACME JAR░░░░04/04/90░░ 100.00░░░░░░█│
║█░To The JOHN SMITH ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│
║█░ Order PO BOX 10000 ░░░░░For ░░░░░░░░░░░░░░░░░░░░░░░░░░░█│
║█░ Of ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┘
║█░░░░░░░░WESTVILLE, ST 55555 ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█
║████████████████████████████████████████████████████████████████████████████
║┌──────────────────────────────────────────────────────────────────────────┐
║│ Number 1 Account # Checking Account # Check Format 1/NEBBS RADIO SHACK│
║└──────────────────────────────────────────────────────────────────────────┘
║╔════════════════════════ ENTER THE HAND CHECK DATA ]══════════════════════╗
║║ All of the following prompts must be completed before a check can be ║
║║ completed/Printed. ║
║║ To The Order Of: JOHN SMITH ║
║║ For: Special Things... ║
║║ Amount: 100.00 ║
║║ Check Type: XXX ║
║║ Date: 04/04/90 ║
╚╚══════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
Press PgDn/PgUp or enter/return through all the prompts to continue...
■ APPLY TOWARDS MULTIPLE GL ACCOUNTS/ENTRIES
At this point you have the option to appling the amount of the check into
multiple GL Account Entries. Use this option if you are using DAYO General
Ledger (GL) and want to apply the amount of a check towards more than one
GL Account/Entry.
┌──────────────────────────────────────────────────────────────────────────┐
│ Do you wish to apply this Check Amount to multiple GL Entries? (Y/N) │
└──────────────────────────────────────────────────────────────────────────┘
If you selected Y (Yes) to the GL Entries prompt, you will be prompted
to enter a valid GL Class Code and the amount you wish to apply towards that
Class Code (corresponds to a GL Account/Entry).
DAYO AP, TJS LAB Page: 46.1
┌────────────────────────────────────────────────────────────────────────────┐
│ Total Amount: 1000.00 Class: AP Amount: 800.00 │
│ Enter Class Code & Amount -> AP 800.00 │
│ You can divide up the amount AP1 200.00 │
│ (as shown to the upper right) │
│ to not more than 50 Class Codes. │
│ You must continue until the │
│ amount is totally applied... │
│ The Last Class Code should be │
│ the intial one... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ APPLY TOWARDS AP PO/PAYABLE RECORDS
If the Manual/Hand check was for a vendor, you will be prompted to apply
the amount of the check towards open AP payable records (APH.DBF). You apply
the amount of the check towards the payable records. The balance of the check
amount is automatically reduced until it is fully applied.
╔══════[ Apply Total Amount (1000.00) of Check To PO/Invoice/Payable ]═══════╗
║JOURNAL PO VENDOR NAME AMOUNT ║
║────────╥────────╥────────────╥────────────────────────────────╥────────────║
║ 100039 ║ 61001 ║ TLJ ║ TOM JOHNSON ║ 332.00 ║
║ 100040 ║ 61021 ║ TLJ ║ TOM JOHNSON ║ 60.00 ║
║ 100041 ║ 61042 ║ TLJ ║ TOM JOHNSON ║ 332.00 ║
║ 100042 ║ 61013 ║ TLJ ║ TOM JOHNSON ║ 358.00 ║
║ 100043 ║ 61014 ║ TLJ ║ TOM JOHNSON ║ 1984.00 ║
║ 100049 ║ 62023 ║ TLJ ║ TOM JOHNSON ║ 10.00 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter (Apply to PO/Invoice/Payable)
Find: F5 (PO) F6 (Name) F7 (Vendor Number) F8 (Journal Number)
When applying a check to an open payable, you will be prompted to enter
an amount not to exceed the amount due:
╔═════════════════════════════════════════════════════════════════════╗
║ PO: 1003 ║
║ Journal: 100041 ║
║ Vendor: TLJ ║
║ Name: TOM JOHNSON ║
║ Date: 09/20/90 ║
║ Amount: 332.00 ║
║ (-) Apply Amount: 332.00 ║
╚════[ Balance: 1000.00 ]═════════════════════════════════════════════╝
When finished, a prompt will appear to press C to continue, or Esc to
abort the check:
┌───────────────────────────────────────────────────────────┐
│ Ready your printer (LPT1). ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ │
│ Press C to continue, or Esc to abort... │
└───────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 47
■ POSTING
There are 2 options in this routine; the Post of Purchase Orders to the
databases APH.DBF and APD.DBF, and the resetting of the Balance Due for all
Vendors.
AP POST
╔════════════════════════════════════════════════════════════════════════════╗
║ DAYO ACCOUNTS PAYABLE POST & VENDOR BALANCE DUE RESET/RECALCULATE ║
╟────────────────────────────────────────────────────────────────────────────╢
║ 1 - POST TO AP FILES ║
║ This job will perform the following: ║
║ ║
║ Move, Post, & Clear Purchase Order Receipts (RECEIVERS) from the REC.DBF ║
║ into the APH & APD databases. ║
║ Computes an amount to be paid to the vendor when/if you run Batch Checks. ║
╟────────────────────────────────────────────────────────────────────────────╢
║ 2 - RESET BALANCE DUE ON ALL VENDORS ║
║ This job will reset/recalculate the 'Balance Due' for each vendor. ║
║ It will reset the DUE & PAID fields in the database VENDORS.DBF. ║
║ The DUE field is computed as the sum of (SUBTOTAL+TAXES+ADJUST+FREIGHT) ║
║ minus the PAID amount for all OPEN records in the database POH.DBF. ║
║ The PAID field is computed as the sum of the PAID amount for all OPEN ║
║ records in the database POH.DBF. Also, all open credit records found in ║
║ the database APH.DBF will be summed and added to the PAID field. ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Select Option)
■ POST TO AP FILES
The progress of the AP Post is displayed onto the screen:
AP POST
╔══════════════════════════════════════════════════════════════════════════════╗
║ DAYO ACCOUNTS PAYABLE POST & VENDOR BALANCE DUE RESET/RECALCULATE ║
╟──────────────────────────────────────────────────────────────────────────────╢
║ 1 - POST TO AP FILES ║
║ This job will perform the following: ║
║ ║
║ Move, Post, & Clear Purchase Order Receipts (RECEIVERS) from the REC.DBF ║
║ into the APH & APD databases. ║
║ Computes an amount to be paid to the vendor when/if you run Batch Checks. ║
╟──────────────────────────────────────────────────────────────────────────────╢
║ ║
║ 0 Records 53 106 ║
║ ╔════════════════╦══════════════════╦═════════════════╦════════════════╗ ║
║ ╠██████████████████████████████████████████████═══════╬════════════════╣ ║
║ ╠════════════════╩══════════════════╬═════════════════╩════════════════╣ ║
║ 0% Completed 50% Done! ║
║ Receiver: 22 Record: 70 ║
║ ║
║ Standby while I do the AP POST! ║
╚══════════════════════════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 48
■ EXPANDED EXPLANATION OF AP POSTING
AP Posting is a term used to denote the 'closing' of Purchase Orders
that have been received into inventory (using the RECEIVE option in DAYO
Inventory), as well as the process of 'paying off' (usually by a check) of
the AP payable records (found in APH.DBF).
Running the AP POST routine creates AP Payable records/invoices based on
Purchase Orders that have been received, and hence ready to be 'paid off'. A
'copy' of the Purchase Order is created in the databases APH.DBF and APD.DBF
and the Purchase Order records (in PO.DBF and POD.DBF) are deleted if
completely received. The posting process is driven by data found in the
receiving database (REC.DBF).
You can create AP Payable records 'manually', by pressing Ctrl N while in
the AP Header Record Browse routine (in AP BROWSE). The amount of the AP
Payable is to be found/placed in the field 'AMOUNT' in the database APH.DBF.
AP Payables (APH.DBF) records are deemed open when the field 'OPEN' is
set to .T. (true) and the field 'PC' (Purchase Cleared) is set to .F.
(false). The payables are automatically closed via some of the check writing
routines (ie: Batch Checks & Vendor Manual/Hand Checks), but can be closed
'manually' by editing the OPEN & PC fields setting them to: OPEN = .F., and
PC = .T.
Everytime you write/print a check, a record of the transaction is
recorded in the database CHECKS.DBF. It is often necessary to use the check
writing capability to 'close' payables. The Batch Checks routine computes a
check amount for each vendor you owe money to. This is determined by the
presence of open payable records (in APH.DBF) with a PAYDATE less than or
equal to today's date. When/if a Batch Check is printed, the amount on the
check is 'applied' to all the payables that 'made up' that amount,
automatically closing any payables that have been 'paid off'. The printing
of a Manual/Hand Check for a vendor does pretty much the same thing, except
that you get to decide which payable record(s) are to be 'applied to' with
the amount of the check.
AP Payables with a negative value denotes a CREDIT for a vendor.
Though DAYO supports expenses and recurring expenses, it is recommended
that a vendor record be created for any/all expenses (ie: Electric Bill,
Mortgage, Rents, Shipping/UPS, MISC expense, and Employees that are
reimbursed). It makes 'things' simpler if all your expenses have a vendor
record.
DAYO AP, TJS LAB Page: 48.1
■ AP POSTING FLOWCHART
Create a PO
(in DAYO Inventory)
┌───────────┐ ┌───────────┐
│ Purchase │ │ PO │ Receiving routine found
│ Orders ├───────────>│ Received │ in DAYO Inventory
│ (PO.DBF ├────────┐ │ (REC.DBF) │
│ & POD.DBF)│ │ └┬──────────┘
└───────────┘ │ └─>>─┐
│ ┌─────┴───┐ AP Posting found in DAYO AP
└──>│ AP Post │
└┬────────┘ ┌───>>>>──────────┐
└──>>─┐ │ ┌─────┴──────┐
AP Payables ┌──────┴───────────┴──┐ │ Reports: │
found and │ AP Payables │ │■ AP Ageing │
maintained in │ (APH.DBF & APD.DBF) │ │■ AP Headers│
DAYO AP └─┬───────────────────┘ │■ AP Detail │
(AP BROWSE) └──>>──┐ └────────────┘
┌────────┴───────────────────────┐
│ Close ('pay off') Payables │
│ (OPEN = .F., PC = .T. ) │
│■ Batch Checks │
│■ Manual/Hand Checks │
│■ Manual Close (Browse APH.DBF) │
└────────────────────────────────┘
■ VENDOR BALANCE DUE RESET/RECALCULATE
The progress of the Vendors Balance Reset is displayed onto the screen,
as is the total Accounts Payable amount when it is finished!
AP POST
╔════════════════════════════════════════════════════════════════════════════╗
║ DAYO ACCOUNTS PAYABLE POST & VENDOR BALANCE DUE RESET/RECALCULATE ║
╟────────────────────────────────────────────────────────────────────────────╢
║ 0 Records 7 14 ║
║ ╔════════════════╦══════════════════╦═════════════════╦════════════════╗ ║
║ ╠██████████████████████████████████████████████████████████████████████╣ ║
║ ╠════════════════╩══════════════════╬═════════════════╩════════════════╣ ║
║ 0% Completed 50% Done!║
║ Done! Total Account Payable: 107406.60 ║
╟────────────────────────────────────────────────────────────────────────────╢
║ 2 - RESET BALANCE DUE ON ALL VENDORS ║
║ This job will reset/recalculate the 'Balance Due' for each vendor. ║
║ It will reset the DUE & PAID fields in the database VENDORS.DBF. ║
║ The DUE field is computed as the sum of (SUBTOTAL+TAXES+ADJUST+FREIGHT) ║
║ minus the PAID amount for all OPEN records in the database POH.DBF. ║
║ The PAID field is computed as the sum of the PAID amount for all OPEN ║
║ records in the database POH.DBF. Also, all open credit records found in ║
║ the database APH.DBF will be summed and added to the PAID field. ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 49
■ REPORTS
The AP Reports menu is displayed onto the left side of the screen:
DAYO AP Version 2.0 TJS LAB REPORTS ┌───[February 1991]──┐
╔═════════════════════════╗ │S M T W T F S │
║ AP REPORTS ║████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟─────────────────────────╢█░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
║ AP Summary ║█░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
║ Purchase Order Headers ║█░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
║ Purchase Order Details ║█░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
║ Vendors ║████▀ █░ █░ █░ ▀███▀ │29 30 │
║ Vendor Mailing Labels ║ │ │
║ Vendor Folder Labels ║ └────────────────────┘
║ Checking Accounts ║╓────────────────────────────────────────────────╖
║ AP Check Register ║║ DAYO AP STATISTICS ║
║ Check Formats ║╟────────────────────────────────────────────────╢
║ Recurring Checks ║║ DATABASE NAME RECORDS SIZE ║
║ Missing Checks Numbers ║╟────────────────────────────────────────────────╢
║ Deposits ║║ POH.DBF PO Headers 22 9K ║
║ 1099 Summary ║║ POD.DBF PO Detail 38 5K ║
║ Misc Expenses ║║ APH.DBF AP Header 59 26K ║
║ Inventory Expanded ║║ APD.DBF AP Detail 154 20K ║
║ Inventory Adjustments ║║ VENDORS.DBF Vendors 14 5K ║
║ Inventory Receivers ║║ EXPENSES.DBF Misc Expenses 7 1K ║
║ Uncleared Receivers ║║ CHECKS.DBF Check Register 39 7K ║
╟─────────────────────────╢║ DEPOSITS.DBF Deposits 22 3K ║
║ Select Option ║╚════════════════════════════════════════════════╝
╚═════════════════════════╝
■ REPORTS LIST
There are 23 AP reports/routines to select from:
AP Summary Deposits
Purchase Order Headers 1099 Summary
Purchase Order Details Misc Expenses
Vendors Inventory Expanded
Vendor Mailing Labels Inventory Adjustments
Vendor Folder Labels Inventory Receivers
Checking Accounts Uncleared Receivers
AP Check Register Uncleared AP Headers
Check Formats Purchase Clearing REC
Recurring Checks Purchase Clearing APH
Missing Checks Numbers Configuration Settings
Printer Setup/Drivers
DAYO AP, TJS LAB Page: 50
■ ACCOUNTS PAYABLE SUMMARY
The Accounts Payable Summary is a 5 part report:
Accounts Payable
Deposits
Checks
Accounts Balances
Expenses
╔════════════════════════════════════════════════════════╗
║ Accounts Payable Summary ║
║ ║
║ The Accounts Payable Summary is a 4 part report: ║
║ 1. Accounts Payable ║
║ 2. Deposits ║
║ 3. Checks ║
║ 4. Accounts Balances ║
║ 5. Expenses ║
║ ║
║ Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║ ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: APSUM.txt ║
║ ║
║ Enter Report Title: TJS LAB ║
║ ║
╚════════════════════════════════════════════════════════╝
■ PAYABLES SUMMARY (APH.DBF)
╔════════════════════════════════════════════════════════╗
║ Accounts Payable Summary ║
║ Payables Summary (APH.DBF) ║
║ ║
║ Purchase Cleared: 10 ║
║ Not Purchase Cleared: 30 ║
║ PC Amount: 35196.34 ║
║ Not PC Amount: 14251.14 ║
║ ║
║ Open: 31 ║
║ Closed: 9 ║
║ Open Amount: 8785.29 ║
║ Closed Amount: 29730.49 ║
║ ║
║ Purchase Orders Summary (POH.DBF) ║
║ ║
║ Open Purchase Orders: 10 ║
║ Open Purchase Orders Amount: 35196.34 ║
║ ║
╚════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 51
■ DEPOSITS SUMMARY (DEPOSITS.DBF)
╔════════════════════════════════════════════════════════╗
║ Accounts Payable Summary ║
║ Deposits Summary (DEPOSITS.DBF) ║
║ ║
║ # Account # Amount ║
║ Totals 953.26 ║
║ 1 12345-909090 43.33 ║
║ 2 2939-2929-002 909.93 ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════╝
■ CHECKS SUMMARY (CHECKS.DBF)
Note, the Check # is only a 'marker' to let you know the first number
for the period of the report.
╔════════════════════════════════════════════════════════╗
║ Accounts Payable Summary ║
║ Checks Summary (CHECKS.DBF) ║
║ ║
║ Check # # Account # Amount ║
║ Totals 43097.46 ║
║ 32 1 12345-909090 100.00 ║
║ 324 1 12345-909090 12454.34 ║
║ 546 1 12345-909090 30523.12 ║
║ 678 1 12345-909090 10.00 ║
║ 703 1 12345-909090 10.00 ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════╝
■ ACCOUNT BALANCES (ACCOUNTS.DBF)
╔════════════════════════════════════════════════════════╗
║ Accounts Payable Summary ║
║ Account Balances (ACCOUNTS.DBF) ║
║ ║
║ # Account # Balance ║
║ Totals 71257.87 ║
║ 1 12345-909090 -4.00 ║
║ 2 1234-000202 71261.87 ║
║ ║
║ ║
╚════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 52
■ MISCELLANEOUS EXPENSES SUMMARY (EXPENSES.DBF)
The Miscellaneous Expenses Summary Report requires a unique index
on the TYPE field:
┌──────────────────────────────────────────────────────────┐
│ Database Name: EXPENSES.DBF │
│ Index Name: EXPTYPE.NTX │
│ Number of Records: 7 │
│ ┌──────────────────────────────────────────────────┐ │
│ │███████████████████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
╔════════════════════════════════════════════════════════╗
║ Accounts Payable Summary ║
║ Miscellaneous Expenses Summary (EXPENSES.DBF) ║
║ ║
║ Type Amount Taxes ║
║ Totals 514467.62 354.53 ║
║ XXX 500000.00 0.00 ║
║ KGB 1500.01 0.00 ║
║ CIA 2003.13 7.07 ║
║ DEA 9032.09 343.03 ║
║ FBI 932.39 4.43 ║
║ NIS 1000.00 0.00 ║
║ ║
╚════════════════════════════════════════════════════════╝
■ PURCHASE ORDER HEADER REPORT
┌────────────────────────────────────────────────────────┐
│ The Purchase Order (PO) Header Report lists all Open │
│ and/or Closed POH.DBF records. │
│ │
│ The name of the PO Header Report Form is POH.FRM. │
│ │
│ Select the Index -> PURCHASE ORDER (PO) │
│ VENDOR NAME (NAME) │
│ VENDOR CODE (VENDOR) │
│ │
│ Enter Heading: TJS LAB │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: POHEADER.TXT │
│ │
│ Select the Option ->Open POs │
│ Closed POs │
│ All POs │
│ Start Date: 03/05/90 Ending Date: 04/04/90 │
└────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 53
■ PURCHASE ORDER DETAIL REPORT
┌────────────────────────────────────────────────────────┐
│ The Purchase Order (PO) Detail Report lists all Open │
│ and/or Closed POD.DBF records. │
│ │
│ The name of the PO Detail Report Form is POD.FRM. │
│ │
│ Select the Index -> PURCHASE ORDER (PO) │
│ ITEM (ITEM) │
│ VENDOR CODE (VENDOR) │
│ VENDOR ITEM (VENDITEM) │
│ Enter Heading: TJS LAB │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: PODETAIL.TXT │
│ │
│ Select the Option ->Open POs (Received <> Ordered) │
│ Closed POs (Received = Ordered) │
│ All POs │
│ Start Date: 03/05/90 Ending Date: 04/04/90 │
└────────────────────────────────────────────────────────┘
■ VENDORS REPORT
┌────────────────────────────────────────────────────────┐
│ The Vendors Report is a printout of your Vendors.dbf. │
│ │
│ The name of the Vendors Report Form is VENDORS.FRM. │
│ │
│ │
│ Select the Index -> VENDOR CODE (VENDOR) │
│ VENDOR NAME (NAME) │
│ │
│ │
│ Enter Heading: TJS LAB │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: VENDORS.TXT │
│ │
│ │
│ │
└────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 54
■ VENDOR MAILING LABELS (BILLTO/SHIPTO)
This report routine prints mailing labels (BILL TO or SHIP TO).
┌────────────────────────────────────────────────────────┐
│ │
│ │
│ BILL TO or SHIP TO Labels? │
│ │
│ (Select the 'Bill To', or 'Ship To' Label Option....) │
│ │
│ │
│ │
└────────────────────────────────────────────────────────┘
┌────────────────────────────────────────────────────────┐
│ Use this option to print Vendor Ship To labels. │
│ │
│ The Ship To Label is the standard size of 3.5x15/16, │
│ 10 Pitch, 6LPI, and contains the following fields: │
│ SHIPNAME SHIPADDR1 SHIPADDR2 │
│ SHIPCITY SHIPSTATE SHIPZIP │
│ ┌──────────────────────────────┐ │
│ │RON DAVIDSON │ │
│ │1200 LAKELAND ROAD │ │
│ │ │ │
│ │LAKELAND, FL │ │
│ │32608 │ │
│ └──────────────────────────────┘ │
│ │
│ VENDOR │
│ Select Vendor -> RD │
│ HURLEY │
│ ACME JAR │
│ FEEDER-1 │
└────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 55
■ VENDOR FOLDER LABELS
This report/routine will print folder labels.
┌────────────────────────────────────────────────────────┐
│ Use this option to print Vendor Folder labels. │
│ │
│ The Folder Label is the standard size of 3.5x15/16, │
│ 10 Pitch, 6LPI, and contains the following fields: │
│ VENDOR NAME ATTN PHONE │
│ │
│ ┌──────────────────────────────┐ │
│ │VENDORxxxx │ │
│ │NAMExxxxxxxxxxxxxxxx│ │
│ │ATTNxxxxxxxxxxxxxxxx│ │
│ │PHONExxxxxxxxx │ │
│ │ │ │
│ └──────────────────────────────┘ │
│ │
│ VENDOR │
│ Select Vendor -> RD │
│ ACME JAR │
│ HURLEY-A │
│ RRR │
└────────────────────────────────────────────────────────┘
■ CHECKING ACCOUNTS REPORT
╔═══════════════════════════════════════════════════════╗
║The Checking Accounts Report is a list of all your ║
║Checking Accounts (with current balances). ║
║ ║
║ ║
║ ║
║Select Index -> Number ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: ACCOUNTS.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
║ ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 56
■ AP CHECKS REPORTS
╔═══════════════════════════════════════════════════════╗
║The AP Checks Report is a listing of all your checks. ║
║Supports a date range... ║
║ ║
║ ║
║ ║
║Enter Checking Account: ALL ║
║ ║
║Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║Select Index -> Journal # ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: CHECKS.TXT ║
║ ║
║Enter Report Title: JOES PIZZA BARS ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
■ CHECK FORMATS REPORT
╔═══════════════════════════════════════════════════════╗
║The Check Format Report is a listing of all your ║
║Check Formats. Note, abbreviations are used in lieu ║
║of the field names. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: CFORMAT.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
║ ║
║ ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 57
■ RECURRING CHECKS REPORT
╔═══════════════════════════════════════════════════════╗
║ ║
║The Recurring Check Report lists all your recurring ║
║checks. ║
║ ║
║ ║
║Select Index -> Recurring ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: RECURPT.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
║ ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
■ MISSING CHECKS REPORT
This report requires a special index on ACCTNUM+CHECKNO.
╔════════════════════════════════════════════════════════╗
║ The Missing Check Numbers Reports will list any ║
║ check number (or range of), that is missing, or ║
║ in question for each account. ║
║ This is not a Report Form. ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ┌────────────────────────────────────────────────────────┐
║ Enter File Name│ Database Name: CHECKS.DBF │
║ │ Index Name: MISSCHK.NTX │
║ Enter Report Ti│ Number of Records: 39 │
║ │ ┌─────────────────────────────────────────────────┐ │
║ │ │█████████████████████████ │ │
║ │ └─────────────────────────────────────────────────┘ │
║ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
║ └────────────────────────────────────────────────────────┘
║ ║
╚════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 58
The progress of the report is displayed/scrolled upon the screen:
╔════════════════════════════════════════════════════════╗
║ The Missing Check Numbers Reports will list any ║
║ check number (or range of), that is missing, or ║
║ in question for each account. ║
║ This is not a Report Form. ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: MISSCHK.TXT ║
║ ║
║ Enter Report Title: TJS LAB ║
║ ║
║# Account From Checkno To ║
║1 12345-909090 5512 ║
║2 123849-30003 514 516 ║
║3 903030-20299 15514 15518 ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════╝
■ DEPOSITS REPORTS
╔═══════════════════════════════════════════════════════╗
║The Deposits Report is a list of all your checking ║
║account deposits for a selected date range. Default ║
║range is the past 30 days. You can select 1 or ALL ║
║checking accounts. ║
║ ║
║Enter Checking Account: ALL ║
║ ║
║Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║Select Index -> Deposit # ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: DEPOSITS.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 59
■ 1099 MISC FORMS
This report routine will print the Federal Form 1099 MISC to your
printer or file.
╔════════════════════════════════════════════════════════╗
║ This report option will print 1099 Misc Forms for ║
║ Accounts Payable records for a specified TYPE, ║
║ date range, and ALL or a specific Vendor/AP Account. ║
║ All data is derived from the database CHECKS.DBF. ║
║ The printer should be set to 6 LPI & 10 Pitch. ║
║ ║
║ Enter Type (Spaces for Any/All Types): 99 ║
║ Start Date: 04/04/89 Ending Date: 04/04/90 ║
║ Enter Vendor/Account: ALL ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: 1099.TXT ║
║ ║
║ ███░ ▄████▄ ▄███▄█░ ▄███▄█░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ▀█████░ ▀█████░ ║
║ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██░ ║
║ ▄██▄ ▀████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════╝
A special index (on ACCOUNT) is created
┌──────────────────────────────────────────────────────────┐
│ Database Name: CHECKS.DBF │
│ Index Name: F1099.NTX │
│ Number of Records: 39 │
│ ┌──────────────────────────────────────────────────┐ │
│ │████████████████████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 60
The progress of the printing is displayed/scrolled onto the screen:
╔════════════════════════════════════════════════════════╗
║ ███░ ▄████▄ ▄███▄█░ ▄███▄█░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ▀█████░ ▀█████░ ║
║ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██░ ║
║ ▄██▄ ▀████▀ ██░ ██░ ║
║ Enter Type (Spaces for Any/All Types): 99 ║
║ Start Date: 04/04/89 Ending Date: 04/04/90 ║
║ ║
║ Enter File Name: 1099.TXT ║
║ ║
║ Vendor Name Amount ║
║ Run Total Federal Form 1099 ----> 12077.34 ║
║ ACME JAR JOHN SMITH 10000.00 ║
║ HURLEY HURLEY, INC 0.00 ║
║ MORGAN-A JOE MORGAN ENTERPRISES 70.00 ║
║ RD RON DAVIDSON 2007.34 ║
║ ║
╚════════════════════════════════════════════════════════╝
■ MISCELLANEOUS EXPENSES REPORT
╔═══════════════════════════════════════════════════════╗
║The Miscellaneous Expenses Report lists all MISC ║
║expenses for a selected date range. Default range ║
║is the past 30 days. ║
║ ║
║Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║Select Index -> Expense # ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: MISCX.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 61
■ EXPANDED INVENTORY REPORT
┌────────────────────────────────────────────────────────┐
│ The Default Expanded Inventory Report (EXPANDED.FRM) │
│ contains the following fields/variables: │
│ ITEM COST │
│ DESC RETAIL │
│ ONHAND PRICE │
│ ONORDER TYPE │
│ VENDITEM CLASS │
│ VENDOR │
│ │
│ Select the Index -> ITEM (ITEM) │
│ DESCRIPTION (DESC) │
│ VENDOR CODE (VENDOR) │
│ VENDOR ITEM (VENDITEM) │
│ TYPE (TYPE) │
│ Enter Heading: EXPANDED REPORT │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ Enter File Name: EXPANDED.TXT │
│ │
│ │
└────────────────────────────────────────────────────────┘
■ INVENTORY ADJUSTMENTS
┌────────────────────────────────────────────────────────┐
│ This report prints out all recorded inventory │
│ adjustments for a given date range. │
│ The Report Form Name is INVADJ.FRM and reports │
│ the following fields (from the INVADJ.DBF): │
│ ITEM VENDITEM QTY │
│ COST PRICE RETAIL │
│ DOLLARS REASON DATE │
│ │
│ Enter Heading: TJS LAB │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: ADJUST.TXT │
│ │
│ │
│ Start Date: 03/05/90 Ending Date: 04/04/90 │
│ │
│ │
└────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 62
■ RECEIVING REPORT
┌────────────────────────────────────────────────────────┐
│ The Receiving Report is a printout of your Receivers; │
│ all receipts of your Items. │
│ │
│ The name of the Receiving Report Form is REC.FRM. │
│ │
│ Select the Index -> RECEIVER (KEY │
│ PURCHASE ORDER (PO) │
│ ITEM (ITEM) │
│ VENDOR ITEM (VENDITEM) │
│ Enter Heading: TJS LAB │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: REC.TXT │
│ │
│ │
│ Start Date: 04/05/85 Ending Date: 04/04/90 │
│ │
└────────────────────────────────────────────────────────┘
■ UNCLEARED RECEIVERS REPORT
╔════════════════════════════════════════════════════════╗
║ The Uncleared Receivers Report is 1 of 4 Purchase ║
║ Clearing Reports for DAYO AP. This reports lists ║
║ all uncleared receivers (PC=.F.), from the database ║
║ REC.DBF for a selected date range... ║
║ ║
║ Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║ Select Index -> KEY ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: UNPCREC.TXT ║
║ ║
║ Enter Report Title: TJS LAB ║
║ ║
╚════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 63
■ UNCLEARED AP RECORDS REPORT
╔════════════════════════════════════════════════════════╗
║ The UnCleared AP Records Report is 1 of 4 Purchase ║
║ Clearing Reports for DAYO AP. This reports lists ║
║ all uncleared AP Header Records (PC=.F.), from the ║
║ database APH.DBF for a selected date range... ║
║ ║
║ Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║ Select Index -> PO ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: UNPCAPH.TXT ║
║ ║
║ Enter Report Title: TJS LAB ║
║ ║
╚════════════════════════════════════════════════════════╝
■ CLEARED RECEIVERS REPORT
╔════════════════════════════════════════════════════════╗
║ The Cleared Receivers Report is 1 of 4 Purchase ║
║ Clearing Reports for DAYO AP. This reports lists ║
║ all cleared receivers (PC=.T.), from the database ║
║ REC.DBF for a selected date range... ║
║ ║
║ Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║ Select Index -> KEY ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: PCREC.TXT ║
║ ║
║ Enter Report Title: TJS LAB ║
║ ║
╚════════════════════════════════════════════════════════╝
DAYO AP, TJS LAB Page: 64
■ CLEARED AP RECORDS REPORT
╔════════════════════════════════════════════════════════╗
║ The Cleared AP Records Report is 1 of 4 Purchase ║
║ Clearing Reports for DAYO AP. This reports lists ║
║ all cleared AP Header Records (PC=.T.), from the ║
║ database APH.DBF for a selected date range... ║
║ ║
║ Start Date: 03/05/90 Ending Date: 04/04/90 ║
║ ║
║ Select Index -> PO ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: PCAPH.TXT ║
║ ║
║ Enter Report Title: TJS LAB ║
║ ║
╚════════════════════════════════════════════════════════╝
■ REPRINT CHECKS
╔═════════════════════════════════════════════════╗
║ REPRINT CHECKS ║
║ ║
║ This routine allows you to reprint checks found║
║ in the database CHECKS.DBF. Detailed voucher ║
║ information will not be printed. ║
║ ║
║ Enter Beginning Check Number: 324 ║
║ ║
║ ║
║ Enter Ending Check Number: 324 ║
║ ║
║ Checkno Name Amount ║
║ 324 George Moonilal 343.32║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╟────────────────┬────────────────┬───────────────╢
╟████████████████████████─────────┼───────────────╢
╚════════════════╧════════════════╧═══════════════╝
DAYO AP, TJS LAB Page: 65
■ CONFIGURATION STATUS REPORT
╔═══════════════════════════════════════════════════════╗
║The Configuration Status Settings Report lists all of ║
║configuration settings (found in file DAYOAP.CFG). ║
║This is Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: CONFIG.TXT ║
╚═══════════════════════════════════════════════════════╝
■ EXAMPLE OF CONFIGURATION STATUS REPORT
++++++++++++++++++++++++++++++++++++++++++++++
+ DAYO ACCOUNTS PAYABLE CONFIGURATION REPORT +
++++++++++++++++++++++++++++++++++++++++++++++
04/05/90
21:57:55
Company Name: YOUR COMPANY NAME HERE
Address Line 1: Attn: Accounts Payable
Address Line 2: P.O. Box 5555
City, State Zip: ANYCITY, ST 55555
Telephone: 800-555-5555
Inventory Database Location: \DAYOINV\
POS Database Location: \DAYOPOS\
Customer Database Location: \DAYOAR\
Federal (Tax) Id Number:
Default Form 1099 TYPE Code: 99
Default Tax Rate: 0.060
Report Printer Type: STANDARD PRINTER
Report Printer Port: LPT1
Hand Checks Port: LPT1
Batch Checks Port: LPT1
Recurring Checks Port: LPT1
Partial Payment POs: Yes
Partial Pay Freight: Partial Payment
Visual Indexing: Yes
Automatic Reindexing: Yes
Color: Yes
High Intensity: No
DAYO AP, TJS LAB Page: 65.1
■ VIEW REPORTS ON SCREEN
This routine was provided to aid the 'fight to stop the cutting down of
trees in the world' by offering you the option to view your reports on your
screen. The only limitation is on the size of the report. No reports can be
viewed if they are over 32,000 bytes. (Just kidding about those trees...)
Due to compiler problems (handling of memory), this routine tends to
'hang' your computer. It is not recommended you use this option if your
machine is performing multitasking programs.
At the first prompt, type and enter the name of the report you wish to
view.
╔══[ View Reports Onscreen ]═════════════════════════════════════════════════╗
║Use this option to view any report written to disk. ║
║Press Enter/Return on an empty prompt to display all files with the ║
║extension of '.TXT'. ║
║File size limited to 32,000 bytes. ║
║ ║
║Enter Report File Name to View On Screen: ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
If the file does not exist, or you press enter on an empty prompt, a
window will appear showing all reports in the current directory. It is
assumed that all reports will have the extension of '.TXT', which is the
DAYO standard.
All reports are displayed in the window, even if they are too large...
╔═══════════════════════════════════════╗
║ File Name Size Date Used ║
╟──────────────┬────────────┬───────────╢
║DAYOERR.TXT │ 1090 │ 06/15/90 ║
║BALANCE.TXT │ 3555 │ 06/15/90 ║
║GL900615.TXT │ 79 │ 06/15/90 ║
║CONFIG.TXT │ 1209 │ 06/15/90 ║
║BUDGETSC.TXT │ 4129 │ 06/15/90 ║
║CLASSRPT.TXT │ 1058 │ 06/02/90 ║
║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐
║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │
║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │
║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │
║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │
║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘
║TRANS1.TXT │ 659 │ 06/15/90 ║
║ASSETS.TXT │ 1300 │ 06/15/90 ║
║LIABIL.TXT │ 1987 │ 06/15/90 ║
║EQUITY.TXT │ 714 │ 06/15/90 ║
╚══════════════╧════════════╧═══════════╝
DAYO AP, TJS LAB Page: 65.2
■ REPORT VIEWING SCREEN
The report viewing screen uses the complete screen. The top line
displays the report name. The bottom lines show you the function keys,
all 2 of them. Also displayed at the bottom of the screen is the current
row/column of the cursor position.
DAYOAP View Reports │ File Name: COA.TXT
Page No. 1
07/27/90
INVENTORY ITEM LISTING
Vendor or
Item Mfg Item Description
------------ ------------ ------------------------------
2" GUTTER 2" GUTTER SYSTEM _____________
2ALM518 2" ALMOND COIL _____________
2ALM519 2" ALMOND COIL _____________
2ALM527 2" ALMOND COIL _____________
2ALM533 2" ALMOND COIL _____________
2ANT123 2" ANT IVORY COIL _____________
Esc (Exit) F1 (Help)
DAYO AP, TJS LAB Page: 66
■ 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 AP, TJS LAB Page: 67
■ 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 AP, TJS LAB Page: 68
■ 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 AP, TJS LAB Page: 69
■ CONFIGURATION
The configurations settings (19) are all accessed from within the
CONFIGURATION menu (option 6 from the main menu).
╔════════════════════════╗
║ CONFIGURATION ║
╟────────────────────────╢
║ Company Name ║
║ Company Address ║
║ Company Telephone ║
║ Inventory Location ║
║ POS Location ║
║ Customer (AR) Location ║
║ Federal Id Number ║
║ Default 1099 TYPE Code ║
║ Default Tax Rate ║
║ Report Printer Type ║
║ Report Printer Port ║
║ Hand Checks Port ║
║ Batch Checks Port ║
║ Recurring Checks Port ║
║ Partial Payment POs ║
║ Partial Pay Freight ║
║ Visual Indexing ║
║ Auto Daily Indexing ║
║ Color ║
╟────────────────────────╢
║ Select Option ║
╚════════════════════════╝
■ CONFIGURATION LISTING
Company Name Report Printer Port
Company Address Hand Checks Port
Company Telephone Batch Checks Port
Inventory Location Recurring Checks Port
POS Location Partial Payment POs
Customer (AR) Location Partial Pay Freight
Federal Id Number Visual Indexing
Default 1099 TYPE Code Auto Daily Indexing
Default Tax Rate Color
Report Printer Type
DAYO AP, TJS LAB Page: 70
■ COMPANY NAME, ADDRESS & TELEPHONE
Each field for this option is limited to 30 characters, 14 for the
telephone...
┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐
│ Enter Your Company Name: YOUR COMPANY NAME HERE │
└────────────────────────────────────────────────────────────────────────────┘
┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐
│ Address Line 1: Attn: Accounting │
│ Address Line 2: P.O. BOX 5555 │
│ City, State ZIP: ANYCITY, ST 55555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐
│ Enter Your Company Telephone: 800-555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ INVENTORY LOCATION/DIRECTORY
┌───────────────────────[ INVENTORY LOCATION/DIRECTORY ]─────────────────────┐
│ The location of the DAYO Inventory (INV.DBF) does not have to be in the │
│ same drive/directory as DAYO AP. If you have installed DAYO Inventory │
│ into a different directory, you need to tell DAYO AP where to find │
│ the inventory database (INV.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOINV\ │
│ The drive designation is optional (if same as DAYO AP). │
│ │
│ Enter Location: \DAYOINV\ │
└────────────────────────────────────────────────────────────────────────────┘
■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY
┌─────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]───────────┐
│ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be │
│ in the same drive/directory as DAYO AP. If you have installed the │
│ DAYO POS Databases, into a different directory, you need to tell DAYO │
│ AP where to find it. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOPOS\ │
│ The drive designation is optional (if same as DAYO AP). │
│ │
│ Enter Location: \DAYOPOS\ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 71
■ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY
┌────────────────[ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ]───────────────┐
│ The location of the DAYO Customer and other AR databases does not have to │
│ be in the same drive/directory as DAYO AP. If you have installed the │
│ DAYO Customer/AR Databases, into a different directory, you need to tell │
│ DAYO End of Period 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 AP). │
│ │
│ Enter Location: \DAYOAR\ │
└────────────────────────────────────────────────────────────────────────────┘
■ FEDERAL (TAX) IDENTIFICATION NUMBER (FIN)
┌────────────────[ FEDERAL (TAX) IDENTIFICATION NUMBER (FIN) ]───────────────┐
│ This entry is your Federal Identification Number for tax reporting. │
│ It is included on various reports, ie: Form 1099s. │
│ │
│ Enter Your FIN: 74567456 4565oo │
└────────────────────────────────────────────────────────────────────────────┘
■ FORM 1099 DEFAULT TAX CODE
┌────────────────────────[ FORM 1099 DEFAULT TAX CODE ]──────────────────────┐
│ This entry is use when determining which Accounts Payable Records should │
│ be used in the calculation of Federal Form 1099 Misc. Default is '99 '. │
│ The field containing the type code is TYPE, in the database APH.DBF. │
│ │
│ Enter Your Default 1099 Tax Code: 99 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT TAX RATE
┌────────────────────────────[ DEFAULT TAX RATE ]────────────────────────────┐
│ │
│ This Tax Rate will be the default tax rate at prompts for same. │
│ │
│ Enter Default Tax Rate: 0.060 │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 72
■ 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 │
└────────────────────────────────────────────────────────────────────────────┘
■ HAND CHECKS PRINTER PORT
┌────────────────────────[ HAND CHECKS PRINTER PORT ]────────────────────────┐
│ Enter Your Hand Checks Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ BATCH CHECKS PRINTER PORT
┌───────────────────────[ BATCH CHECKS PRINTER PORT ]────────────────────────┐
│ Enter Your Batch Checks Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ RECURRING CHECKS PRINTER PORT
┌─────────────────────[ RECURRING CHECKS PRINTER PORT ]──────────────────────┐
│ Enter Your Recurring Checks Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ AP POSTING - PARTIAL PAYMENT OF PURCHASE ORDERS
┌────────────[ AP POSTING - PARTIAL PAYMENT OF PURCHASE ORDERS ]─────────────┐
│ Select Y to this prompt if you wish your Purchase Orders to be paid │
│ partially (as they are received), otherwise POs are paid upon full │
│ receipt. │
│ Do you wish to Partial Pay your Purchase Order Receipts? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 73
■ AP POSTING - PARTIAL PAYMENT OF PO FREIGHT & ADJUSTMENTS
┌────────[ AP POSTING - PARTIAL PAYMENT OF PO FREIGHT & ADJUSTMENTS ]────────┐
│ Payment of Freight and Adjustments (FREIGHT & ADJUST), upon receipt of │
│ product, can be paid to the Vendor based on one of the following options.│
│ │
│ Select Option: │
│ 1 - Partial Payment of PO FREIGHT & ADJUST │
│ 2 - Complete Payment of PO FREIGHT & ADJUST on First Receipt │
│ 3 - Complete Payment of PO FREIGHT & ADJUST on Final Receipt │
└────────────────────────────────────────────────────────────────────────────┘
■ 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) │
└────────────────────────────────────────────────────────────────────────────┘
■ AUTOMATIC DAILY INDEXING
┌─────────────────────────[ AUTOMATIC DAILY INDEXING ]───────────────────────┐
│ If this option is set to Y (YES), then all DAYO Indexes accessed by │
│ DAYO AP will be recreated once daily. This will occur when the first │
│ DAYO AP program is run. The default is to recreate all the indexes. │
│ │
│ Recreate all DAYO AP Indexes? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 74
■ COLOR MONITOR
To activate a color change, you must completely exit DAYO AP, and
reenter.
┌──────────────────────────────[ COLOR MONITOR ]─────────────────────────────┐
│ If you have a color monitor and wish to display colors, then select Y, │
│ (YES), else select N (NO) for monochrome and others. │
│ The default is color, low intensity │
│ │
│ Do you have a color monitor? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR INTENSITY
┌─────────────────────────────[ COLOR INTENSITY ]────────────────────────────┐
│ Intensity is only applicable with color set to Y. │
│ It will make your colors brighter... │
│ │
│ Set Color Intensity On? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 75
■ MISCELLANEOUS ROUTINES
- The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ MISC ROUTINES MENU:
DAYO AP Version 2.0 TJS LAB ┌───[February 1991]──┐
╔════════════════════╗─╖ │S M T W T F S │
║ MISC ROUTINES ║ ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟────────────────────╢─╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
║ BROWSE DATABASES ║─╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
║ CREATE DATABASE ║─╢ █▀██▀ █░ █░ █░ ▀███▀ │29 30 │
║ DELETE RECORDS ║ ║ │ │
║ ERASE FILE ║─╢ └────────────────────┘
║ EXIT TO DOS ║ ║
║ INDEX A DATABASE ║─╢ ████░ █░ █░ █▄██▄ ▄███▄ ████░
║ LIST FIELDS ║ ║ █░ ██░ █░ █░ █░ █░ █░ █░
║ PACK DATABASE ║─╢ ███░ ███░█░ █░ █░ █░ █░ ████░
║ MODIFY DATABASE ║ ║ █░ █▀███░ █░ █░ █░ █░ █░
║ RECALL RECORDS ║─╢ █░ █░▀██░ █░ █░ █░ █░ █░
║ RETURN TO MENU ║ ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░
║ RUN (DOS COMMAND) ║═╝
║ SIMPLE EDITOR ║04/01/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄
║ SORT DATABASE ║12:06:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░
║ TYPE (PRINT) FILE ║1 █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░
║ ZAP DATABASE ║3 █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░
╟────────────────────╢3.00 █░ █░ █░ ▀█░ █░ █░ █░ █░ █░
║ Select Option ║TLJ █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀
╚════════════════════╝
DAYO AP, TJS LAB Page: 76
■ APPEND FROM
- Used to copy records from one database into another database, or to create
records from ASCII files (SDF or DELIMITED).
- The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
- If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 77
- If you are appending from another database (.DBF) then select 'Standard'.
- Select the SDF option if you are appending from a 'flat' ASCII file.
- Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
- If you select a Standard Append, you will then be prompted to enter the name
of the database you wish to get the data from. If you selected the SDF or
DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
- The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENT.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 78
■ BROWSE DATABASES
- Used to edit/view records in a database. Enter the database name you wish to
edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- If there exists an index (.NDX or .NTX), with the same name as the database,
it will be utilized... The DAYO Inventory indexes are the exception. They
are automatically set/used.
- An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO AP, TJS LAB Page: 79
- To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
- Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
- Remember that there are many more fields to the right of the screen. Press
the right arrow key to view them...
DAYO AP, TJS LAB Page: 80
■ COPY (.DBF) TO
- Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (EG: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
- The Standard option is simply creating another database (.DBF). The SDF and
DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
DAYO AP, TJS LAB Page: 81
- The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
- This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 82
- The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
- Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO AP, TJS LAB Page: 83
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO AP, TJS LAB Page: 84
■ DELETE RECORDS
- Delete selected records from databases. The first prompt is for the name of
the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
- After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
- The number of records deleted will be displayed upon the screen as depicted
just above...
DAYO AP, TJS LAB Page: 85
■ ERASE FILE
- Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
- The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
- This option will close all open files and databases and exit to DOS without
having to return to the main menu exit routine.
DAYO AP, TJS LAB Page: 86
■ INDEX A DATABASE
- You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
- You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 87
- At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
- List fields to screen or printer. This routine is a great tool for providing
simple reports and lists. The first prompt will be for the database you wish
to work with. Type the name of the file, or press Enter on an empty prompt
to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 88
- The next prompt is for a condition or filter. This makes it possible to list
only specific records that meet that condition you enter. The condition must
be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
- A window box appears next displaying all the fields in the selected database
and an option to list all fields. Highlight any combination of fields ( or
ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 89
- The fields you select will be displayed at center top of screen. Press Esc
to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
- At the next prompt, you can send the list to the SCREEN, PRINTER OR
FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 90
- The list is very simple, and if displayed onto the screen, may look like the
following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
- Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO AP, TJS LAB Page: 91
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
- Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- After selecting the database, you will be prompted to respond with a Yes or
No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 92
■ RECALL RECORDS
- Recalls records previously marked for deletion. This option is identical to
the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
- Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
- Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
- One useful option is to type and Enter: COMMAND at this prompt. You will be
running another DOS Shell totally out of the program (it still is in memory
though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
- Press and Enter: EXIT to return to your Clipper Application.
EG:
The COMPAQ Personal Computer MS-DOS
Version 3.31
(C) Copyright Compaq Computer Corp. 1982, 1987
(C) Copyright Microsoft Corp. 1981, 1987
C:\KISBBS>EXIT
DAYO AP, TJS LAB Page: 93
■ SIMPLE EDITOR
- A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
- If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those
changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO AP, TJS LAB Page: 94
- Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
- This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 95
- The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
- Prints an ASCII/text file to screen or printer. The first prompt is for the
file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 96
- The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
- Totally erase all records in database (forever!). When you
want to remove every record from a database, then use this option. Use with
EXTREME CAUTION! The first prompt is for the file name. Enter the name of
the database you are to 'clean out', or press Enter to select the database
from a window containing all databases in the current directory.
DAYO AP, TJS LAB Page: 97
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- You will be prompted one last time as to whether you still want to ZAP the
selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanently) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 98
■ 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:
┌──────────────────────[ DAYOAP 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:
┌────────────────────────[ DAYOAP 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 AP, TJS LAB Page: 99
- Editor help:
┌───────────────────────[ DAYOAP 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... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
- Recurring Check Browse Help:
DAYO AP Version 2.0 TJS LAB CHECKS ┌───[February 1991]──┐
┌─────────────────[ DAYO AP - RECURRING CHECK BROWSE HELP ]──────────────────┐
│ │
│ SCHEDULE CODES For Scheduling Recurring Checks To Become 'DUE': │
│ SUNDAY Only on a Sunday │
│ MONDAY Only on a Monday │
│ TUESDAY Only on a Tuesday │
│ WEDNESDAY Only on a Wednesday │
│ THURSDAY Only on a Thursday │
│ FRIDAY Only on a Friday │
│ SATURDAY Only on a Saturday │
│ MM/DD/YY On a Specific Date (ie: '01/31/91' for January 31, 1991) │
│ DAYSxxx Every Few Days, (ie: 'DAYS 21' for every 21 days) │
│ SEMIMONTH Every 2 Weeks │
│ MIDMONTH Mid Month │
│ EOM End of Month │
│ BEGMONTH Beginning of the Month │
│ BIMONTH Every 2 Months (60 Days) │
│ QUARTERLY Every Quarter (90 Days) │
│ ANNUAL Once a Year │
└────────────────────────────────────────────────────────────────────────────┘
DAYO AP, TJS LAB Page: 100
■ 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).
■ 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 AP Version 2.0 TJS LAB ┌───[February 1991]──┐
┌──────[ DAYO HELP Called by Program: DAYOAP 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 DAYOAP. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ 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 AP, TJS LAB Page: 101
DAYO AP Version 2.0 TJS LAB ┌───[February 1991]──┐
┌───────[ DAYO HELP Called by Program: DAYOAP 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, DAYOAP.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 DAYOAP 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 AP, TJS LAB Page: 102
■ DATABASE STRUCTURE
Database: ACCOUNTS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 NUMBER Character 2 1 2
2 NAME Character 30 3 32
3 ACCTNUM Character 20 33 52
4 BALANCE Numeric 10 2 53 62
5 ADDR1 Character 30 63 92
6 ADDR2 Character 30 93 122
7 CITY Character 22 123 144
8 STATE Character 2 145 146
9 ZIP Character 10 147 156
10 PHONE Character 14 157 170
11 TYPE Character 3 171 173
12 DATE Date 8 174 181
13 LASTDATE Date 8 182 189
14 LDEPOSIT Numeric 10 2 190 199
15 CLASS Character 3 200 202
16 TRANSACT Character 12 203 214
────────── ─────
Total 215
Database: APD.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 JOURNAL Numeric 6 1 6
2 PO Numeric 6 7 12
3 VENDOR Character 10 13 22
4 ITEM Character 12 23 34
5 DESC Character 30 35 64
6 VENDITEM Character 12 65 76
7 QUANTITY Numeric 7 77 83
8 COST Numeric 10 2 84 93
9 DATE Date 8 94 101
10 TYPE Character 3 102 104
11 CLASS Character 3 105 107
12 OPEN Logical 1 108 108
13 KEY Numeric 6 109 114
14 RECDATE Date 8 115 122
15 TAXABLE Logical 1 123 123
16 TRANSACT Character 12 124 135
────────── ─────
Total 136
DAYO AP, TJS LAB Page: 103
Database: APH.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 JOURNAL Numeric 6 1 6
2 PO Numeric 6 7 12
3 VENDOR Character 10 13 22
4 NAME Character 30 23 52
5 ATTN Character 30 53 82
6 ADDR1 Character 30 83 112
7 ADDR2 Character 30 113 142
8 CITY Character 22 143 164
9 STATE Character 2 165 166
10 ZIP Character 10 167 176
11 PHONE Character 14 177 190
12 TYPE Character 3 191 193
13 DATE Date 8 194 201
14 PODATE Date 8 202 209
15 TERMS Character 20 210 229
16 SHIPPER Character 20 230 249
17 SHIPNAME Character 30 250 279
18 SHIPADDR1 Character 30 280 309
19 SHIPADDR2 Character 30 310 339
20 SHIPCITY Character 22 340 361
21 SHIPSTATE Character 2 362 363
22 SHIPZIP Character 10 364 373
23 SHIPPHONE Character 14 374 387
24 BY Character 5 388 392
25 PRINTED Logical 1 393 393
26 KEY Numeric 6 394 399
27 OPEN Logical 1 400 400
28 SUBTOTAL Numeric 10 2 401 410
29 TAXES Numeric 10 2 411 420
30 ADJUST Numeric 10 2 421 430
31 FREIGHT Numeric 10 2 431 440
32 AMOUNT Numeric 10 2 441 450
33 PC Logical 1 451 451
34 CHECKNO Character 12 452 463
35 CLASS Character 3 464 466
36 PAYDATE Date 8 467 474
37 TRANSACT Character 12 475 486
38 COMMENT Character 50 487 536
────────── ─────
Total 537
DAYO AP, TJS LAB Page: 104
Database: CFORMAT.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 CFORMAT Character 2 1 2
2 NAME Character 30 3 32
3 SETUP Character 50 33 82
4 C_LENGTH Numeric 2 83 84
5 C_WIDTH Numeric 3 85 87
6 V_1ST_LINE Numeric 2 88 89
7 V_END_LINE Numeric 2 90 91
8 V_LCOLUMN Numeric 2 92 93
9 V_RCOLUMN Numeric 3 94 96
10 WORD_ROW Numeric 2 97 98
11 WORD_COL Numeric 2 99 100
12 AMOUNT_ROW Numeric 2 101 102
13 AMOUNT_COL Numeric 3 103 105
14 NAME_ROW Numeric 2 106 107
15 NAME_COL Numeric 2 108 109
16 ADDR_ROW Numeric 2 110 111
17 ADDR_COL Numeric 2 112 113
18 CV_NUM_ROW Numeric 2 114 115
19 CV_NUM_COL Numeric 3 116 118
20 DATE_ROW Numeric 2 119 120
21 DATE_COL Numeric 3 121 123
22 FOR_ROW Numeric 2 124 125
23 FOR_COL Numeric 2 126 127
────────── ─────
Total 128
Database: CHECKS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 CHECKNO Character 12 1 12
2 ACCTNUM Character 20 13 32
3 NUMBER Character 2 33 34
4 AMOUNT Numeric 10 2 35 44
5 NAME Character 30 45 74
6 WHATFOR Character 40 75 114
7 DATE Date 8 115 122
8 JOURNAL Numeric 6 123 128
9 ACCOUNT Character 10 129 138
10 CV Logical 1 139 139
11 TYPE Character 3 140 142
12 CFORMAT Character 2 143 144
13 BY Character 30 145 174
14 TRANSACT Character 12 175 186
15 CLASS Character 3 187 189
────────── ─────
Total 190
DAYO AP, TJS LAB Page: 105
Database: DEPOSITS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 DEPOSIT Numeric 6 1 6
2 ACCTNUM Character 20 7 26
3 NUMBER Character 2 27 28
4 WHATFOR Character 40 29 68
5 TYPE Character 3 69 71
6 AMOUNT Numeric 10 2 72 81
7 DATE Date 8 82 89
8 BY Character 30 90 119
9 CLASS Character 3 120 122
10 TRANSACT Character 12 123 134
────────── ─────
Total 135
Database: EXPENSES.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 EXPENSE Numeric 6 1 6
2 WHATFOR Character 40 7 46
3 TYPE Character 3 47 49
4 AMOUNT Numeric 10 2 50 59
5 TAXES Numeric 10 2 60 69
6 CHECKNO Character 12 70 81
7 ACCTNUM Character 20 82 101
8 NUMBER Character 2 102 103
9 DATE Date 8 104 111
10 SUBTOTAL Numeric 10 2 112 121
11 FREIGHT Numeric 10 2 122 131
12 ADJUST Numeric 10 2 132 141
13 CLASS Character 3 142 144
14 TRANSACT Character 12 145 156
────────── ─────
Total 157
DAYO AP, TJS LAB Page: 106
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 AVGCOST Numeric 10 2 126 135
14 REALCOST Numeric 10 2 136 145
15 RETAIL Numeric 10 2 146 155
16 PRICE Numeric 10 2 156 165
17 STOCKLEVEL Numeric 7 166 172
18 TYPE Character 3 173 175
19 CLASS Character 3 176 178
20 TAXABLE Logical 1 179 179
21 SERIALNO Logical 1 180 180
22 WEIGHT Numeric 8 2 181 188
23 UNIT Character 3 189 191
24 LOCATION Character 3 192 194
────────── ─────
Total 195
Database: INVADJ.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 ITEM Character 12 1 12
2 VENDITEM Character 12 13 24
3 QTY Numeric 7 25 31
4 COST Numeric 10 2 32 41
5 PRICE Numeric 10 2 42 51
6 RETAIL Numeric 10 2 52 61
7 DOLLARS Numeric 10 2 62 71
8 REASON Character 30 72 101
9 LOC Character 10 102 111
10 BY Character 30 112 141
11 DATE Date 8 142 149
12 CLASS Character 3 150 152
13 TRANSACT Character 12 153 164
────────── ─────
Total 165
DAYO AP, TJS LAB Page: 107
Database: POD.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 PO Numeric 6 1 6
2 VENDOR Character 10 7 16
3 ITEM Character 12 17 28
4 DESC Character 30 29 58
5 VENDITEM Character 12 59 70
6 ORDERED Numeric 7 71 77
7 RECEIVED Numeric 7 78 84
8 COST Numeric 10 2 85 94
9 DATE Date 8 95 102
10 ETA Date 8 103 110
11 LASTRECV Date 8 111 118
12 TYPE Character 3 119 121
13 CLASS Character 3 122 124
14 OPEN Logical 1 125 125
15 TAXABLE Logical 1 126 126
────────── ─────
Total 127
DAYO AP, TJS LAB Page: 108
Database: POH.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 PO Numeric 6 1 6
2 VENDOR Character 10 7 16
3 NAME Character 30 17 46
4 ATTN Character 30 47 76
5 ADDR1 Character 30 77 106
6 ADDR2 Character 30 107 136
7 CITY Character 22 137 158
8 STATE Character 2 159 160
9 ZIP Character 10 161 170
10 PHONE Character 14 171 184
11 SHIPNAME Character 30 185 214
12 SHIPADDR1 Character 30 215 244
13 SHIPADDR2 Character 30 245 274
14 SHIPCITY Character 22 275 296
15 SHIPSTATE Character 2 297 298
16 SHIPZIP Character 10 299 308
17 SHIPPHONE Character 14 309 322
18 DATE Date 8 323 330
19 ETA Date 8 331 338
20 SUBTOTAL Numeric 10 2 339 348
21 TAXES Numeric 10 2 349 358
22 ADJUST Numeric 10 2 359 368
23 FREIGHT Numeric 10 2 369 378
24 PAID Numeric 10 2 379 388
25 TERMS Character 20 389 408
26 SHIPPER Character 20 409 428
27 BY Character 30 429 458
28 OPEN Logical 1 459 459
29 PRINTED Logical 1 460 460
30 CLASS Character 3 461 463
31 COMMENT Character 50 464 513
────────── ─────
Total 514
DAYO AP, TJS LAB Page: 109
Database: REC.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 KEY Numeric 6 1 6
2 PO Numeric 6 7 12
3 VENDOR Character 10 13 22
4 ITEM Character 12 23 34
5 DESC Character 30 35 64
6 VENDITEM Character 12 65 76
7 RECEIVED Numeric 7 77 83
8 COST Numeric 10 2 84 93
9 DATE Date 8 94 101
10 BY Character 30 102 131
11 PC Logical 1 132 132
12 COSTADJ Numeric 10 2 133 142
────────── ─────
Total 143
Database: RECHECK.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 RECURRING Numeric 6 1 6
2 NAME Character 30 7 36
3 VE Logical 1 37 37
4 LASTDATE Date 8 38 45
5 SCHEDULE Character 10 46 55
6 PRINT Logical 1 56 56
7 ACCOUNT Character 10 57 66
8 WHATFOR Character 40 67 106
9 TYPE Character 3 107 109
10 AMOUNT Numeric 10 2 110 119
11 SUBTOTAL Numeric 10 2 120 129
12 TAXES Numeric 10 2 130 139
13 FREIGHT Numeric 10 2 140 149
14 ADJUST Numeric 10 2 150 159
15 TOTALPAID Numeric 10 2 160 169
16 ACCTNUM Character 20 170 189
17 NUMBER Character 2 190 191
18 ADDR1 Character 30 192 221
19 ADDR2 Character 30 222 251
20 CITY Character 22 252 273
21 STATE Character 2 274 275
22 ZIP Character 10 276 285
23 PHONE Character 14 286 299
24 DATE Date 8 300 307
25 COMMENT Character 50 308 357
26 CFORMAT Character 2 358 359
────────── ─────
Total 360
DAYO AP, TJS LAB Page: 110
Database: TCHECKS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 CHECKNO Character 12 1 12
2 ACCTNUM Character 20 13 32
3 NUMBER Character 2 33 34
4 AMOUNT Numeric 10 2 35 44
5 NAME Character 30 45 74
6 WHATFOR Character 40 75 114
7 DATE Date 8 115 122
8 JOURNAL Numeric 6 123 128
9 ACCOUNT Character 10 129 138
10 CV Logical 1 139 139
11 TYPE Character 3 140 142
12 CFORMAT Character 2 143 144
────────── ─────
Total 145
DAYO AP, TJS LAB Page: 111
Database: VENDORS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 VENDOR Character 10 1 10
2 NAME Character 30 11 40
3 ADDR1 Character 30 41 70
4 ADDR2 Character 30 71 100
5 CITY Character 22 101 122
6 STATE Character 2 123 124
7 ZIP Character 10 125 134
8 PHONE Character 14 135 148
9 ATTN Character 30 149 178
10 TERMS Character 20 179 198
11 SHIPPER Character 20 199 218
12 DATE Date 8 219 226
13 LASTDATE Date 8 227 234
14 TYPE Character 3 235 237
15 CLASS Character 3 238 240
16 TAXRATE Numeric 5 3 241 245
17 FED_ID Character 15 246 260
18 OPEN_PURC Numeric 10 2 261 270
19 RECV_PURC Numeric 10 2 271 280
20 TOT_PURC Numeric 10 2 281 290
21 DUE Numeric 10 2 291 300
22 PAID Numeric 10 2 301 310
23 TOTALPAID Numeric 10 2 311 320
24 SHIPNAME Character 30 321 350
25 SHIPADDR1 Character 30 351 380
26 SHIPADDR2 Character 30 381 410
27 SHIPCITY Character 22 411 432
28 SHIPSTATE Character 2 433 434
29 SHIPZIP Character 10 435 444
30 SHIPPHONE Character 14 445 458
────────── ─────
Total 459
DAYO AP, TJS LAB Page: 112
Database: WAREHOUS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 ITEM Character 12 1 12
2 LOC1 Numeric 7 13 19
3 SLLOC1 Numeric 7 20 26
4 LOC2 Numeric 7 27 33
5 SLLOC2 Numeric 7 34 40
6 LOC3 Numeric 7 41 47
7 SLLOC3 Numeric 7 48 54
8 LOC4 Numeric 7 55 61
9 SLLOC4 Numeric 7 62 68
10 LOC5 Numeric 7 69 75
11 SLLOC5 Numeric 7 76 82
12 LOC6 Numeric 7 83 89
13 SLLOC6 Numeric 7 90 96
14 LOC7 Numeric 7 97 103
15 SLLOC7 Numeric 7 104 110
────────── ─────
Total 111
Database: WARENAME.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 LOC Character 10 1 10
2 NAME Character 30 11 40
3 COMMENTS Character 40 41 80
────────── ─────
Total 81
DAYO AP, TJS LAB Page: 113
■ DATA DICTIONARY
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
ACCOUNT C 10 0 RECHECK.DBF Account number (VENDOR, EXPENSE,
or CUSTOMER number)
CHECKS.DBF
TCHECKS.DBF
ACCTNUM C 20 0 DEPOSITS.DBF Checking Account number assigned
by the bank
ACCOUNTS.DBF
EXPENSES.DBF
TCHECKS.DBF
CHECKS.DBF
RECHECK.DBF
ADDR1 C 30 0 ACCOUNTS.DBF Address line 1
POH.DBF
RECHECK.DBF
APH.DBF
VENDORS.DBF
ADDR2 C 30 0 RECHECK.DBF Address line 2
ACCOUNTS.DBF
POH.DBF
VENDORS.DBF
APH.DBF
ADDR_COL N 2 0 CFORMAT.DBF Starting column of address when
printing a check
ADDR_ROW N 2 0 CFORMAT.DBF Starting row of address when
printing a check
ADJUST N 10 2 RECHECK.DBF Adjustment charges
POH.DBF
APH.DBF
AMOUNT N 10 2 DEPOSITS.DBF Amount of Deposit
EXPENSES.DBF Amount of Expense
APH.DBF Amount of Payable
CHECKS.DBF Amount of Check
TCHECKS.DBF
RECHECK.DBF
AMOUNT_COL N 3 0 CFORMAT.DBF Starting column of the check
amount when printed on check
AMOUNT_ROW N 2 0 CFORMAT.DBF Starting row of the check amount
when printed on check
ATTN C 30 0 POH.DBF Attention/Point of Contact
VENDORS.DBF
APH.DBF
BALANCE N 10 2 ACCOUNTS.DBF Checking account balance
BO N 7 0 INV.DBF Quantity on BackOrder (Placed by
your customers, using POS)
DAYO AP, TJS LAB Page: 114
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
BY C 30 0 CHECKS.DBF Operator Name
APH.DBF
REC.DBF
POH.DBF
INVADJ.DBF
DEPOSITS.DBF
CFORMAT C 2 0 CHECKS.DBF Check Printing Format number
CFORMAT.DBF
TCHECKS.DBF
RECHECK.DBF
CHECKNO C 12 0 CHECKS.DBF Check number
EXPENSES.DBF
TCHECKS.DBF
APH.DBF
CITY C 22 0 ACCOUNTS.DBF Address city
RECHECK.DBF
POH.DBF
APH.DBF
VENDORS.DBF
CLASS C 3 0 APD.DBF Class of item
INV.DBF
POD.DBF
VENDORS.DBF Class of Vendor
ACCOUNTS.DBF Bank Account Class
POH.DBF
APH.DBF
CHECKS.DBF
EXPENSES.DBF
INVADJ.DBF
COMMENT C 50 0 APH.DBF Comments or notes
POH.DBF
RECHECK.DBF
COMMENTS C 40 0 WARENAME.DBF Comments or notes
COST N 10 2 INVADJ.DBF Cost of an item
APD.DBF
REC.DBF
INV.DBF
POD.DBF
CV L 1 0 CHECKS.DBF Logical flag to denote type of
TCHECKS.DBF account, ie: 'CV=.T.' means
Customer, else Vendor/Expense
CV_NUM_COL N 3 0 CFORMAT.DBF Account type starting column when
printing to check
CV_NUM_ROW N 2 0 CFORMAT.DBF Account type starting row when
printing to check
C_LENGTH N 2 0 CFORMAT.DBF Length of the check
C_WIDTH N 3 0 CFORMAT.DBF Width of the check
DAYO AP, TJS LAB Page: 115
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
DATE D 8 0 TCHECKS.DBF Date of transaction, or date the
INV.DBF record was created
DEPOSITS.DBF
APH.DBF
ACCOUNTS.DBF
CHECKS.DBF
APD.DBF
INVADJ.DBF
POH.DBF
EXPENSES.DBF
RECHECK.DBF
VENDORS.DBF
REC.DBF
POD.DBF
DATE_COL N 3 0 CFORMAT.DBF Starting column of the check date
when printing
DATE_ROW N 2 0 CFORMAT.DBF Starting row of the check date
when printing
DEPOSIT N 6 0 DEPOSITS.DBF Deposit number (a control number)
DESC C 30 0 POD.DBF Description of item
REC.DBF
APD.DBF
INV.DBF
DOLLARS N 10 2 INVADJ.DBF Cost variance
DUE N 10 2 VENDORS.DBF Amount still due (balance due to
Vendor)
ETA D 8 0 POH.DBF Estimated Time (date) of Arrival
POD.DBF
APH.DBF
EXPENSE N 6 0 EXPENSES.DBF Expense number (a control number)
FED_ID C 15 0 VENDORS.DBF Federal Identification Number
(for tax purposes, ie 1099 forms)
FOR_COL N 2 0 CFORMAT.DBF Starting column for the printing
of the check reason/for
FOR_ROW N 2 0 CFORMAT.DBF Starting row for the printing of
the check reason/for
FREIGHT N 10 2 POH.DBF Freight charges
APH.DBF
RECHECK.DBF
ITEM C 12 0 INV.DBF Item/Product/Part Number/Code
APD.DBF
REC.DBF
INVADJ.DBF
WAREHOUS.DBF
POD.DBF
DAYO AP, TJS LAB Page: 116
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
JOURNAL N 6 0 APD.DBF Journal number (a control number)
CHECKS.DBF
APH.DBF
TCHECKS.DBF
KEY N 6 0 APD.DBF Key/Receiver number (a control
REC.DBF number)
APH.DBF
LASTDATE D 8 0 INV.DBF Date last accessed
RECHECK.DBF
ACCOUNTS.DBF
VENDORS.DBF
LASTRECV D 8 0 POD.DBF Date of last receipt
LDEPOSIT N 10 2 ACCOUNTS.DBF Date of last deposit into
checking account
LOC C 10 0 WARENAME.DBF Warehouse/Location name,
ie: LOC1, LOC2, LOC3 ...
LOC1 N 7 0 WAREHOUS.DBF Warehouse/Location #1
LOC2 N 7 0 WAREHOUS.DBF Warehouse/Location #2
LOC3 N 7 0 WAREHOUS.DBF Warehouse/Location #3
LOC4 N 7 0 WAREHOUS.DBF Warehouse/Location #4
LOC5 N 7 0 WAREHOUS.DBF Warehouse/Location #5
LOC6 N 7 0 WAREHOUS.DBF Warehouse/Location #6
LOC7 N 7 0 WAREHOUS.DBF Warehouse/Location #7
LOCATION C 3 0 INV.DBF Location 'Bin' code
NAME C 30 0 WARENAME.DBF Literal name of a warehouse,
ie: OBSOLETE, INTERNAL USE ...
CHECKS.DBF Payee
TCHECKS.DBF
CFORMAT.DBF Check style
APH.DBF Vendor name
RECHECK.DBF Payee
ACCOUNTS.DBF Bank name
POH.DBF Vendor name
VENDORS.DBF
NAME_COL N 2 0 CFORMAT.DBF Starting column when printing the
Payee name onto a check
NAME_ROW N 2 0 CFORMAT.DBF Starting row when printing the
Payee name onto a check
NUMBER C 2 0 DEPOSITS.DBF Checking account sequence number,
ACCOUNTS.DBF ie, the first account would be '1'
EXPENSES.DBF
RECHECK.DBF
CHECKS.DBF
TCHECKS.DBF
ONHAND N 7 0 INV.DBF Main warehouse quantity
ONORDER N 7 0 INV.DBF Quantity on order with a Vendor
DAYO AP, TJS LAB Page: 117
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
OPEN L 1 0 APD.DBF Logical flag used when posting
POD.DBF
APH.DBF
POH.DBF
OPEN_PURC N 10 2 VENDORS.DBF Amount of Open Purchase Orders
ORDERED N 7 0 POD.DBF Total quantity originally ordered
PAID N 10 2 POH.DBF Amount paid on this PO
VENDORS.DBF Amount paid to a Vendor
PC L 1 0 APH.DBF Purchase Clearing flag
REC.DBF
PHONE C 14 0 ACCOUNTS.DBF Telephone number
POH.DBF
RECHECK.DBF
APH.DBF
VENDORS.DBF
PO N 6 0 APH.DBF Purchase Order number
POD.DBF
POH.DBF
APD.DBF
REC.DBF
PODATE D 8 0 APH.DBF Purchase Order date
PRICE N 10 2 INVADJ.DBF Price of an item
INV.DBF
PRINT L 1 0 RECHECK.DBF Logical flag to mark a Recurring
check to be printed
PRINTED L 1 0 POH.DBF Logical flag to show if the
APH.DBF Purchase Order has been printed
QTY N 7 0 INVADJ.DBF Inventory adjustment quantity
QUANTITY N 7 0 APD.DBF Quantity received/AP detail
quantity
REASON C 30 0 INVADJ.DBF Reason for the Inventory
Adjustment
RECDATE D 8 0 APD.DBF Date received
APH.DBF
RECEIVED N 7 0 REC.DBF Quantity received
POD.DBF
RECURRING N 6 0 RECHECK.DBF Recurring check number (a control
number)
RECV_PURC N 10 2 VENDORS.DBF Amount of Vendors product
RETAIL N 10 2 INVADJ.DBF Retail/List price for an item
INV.DBF
SCHEDULE C 10 0 RECHECK.DBF Recurring schedule code
SERIALNO L 1 0 INV.DBF Logical flag to denote that this
item has a serial number that
requires recording when invoicing
SETUP C 50 0 CFORMAT.DBF Printer setup string that is
printed at start of checks
SHIPPER C 20 0 POH.DBF Shipper/Method of shipment
APH.DBF
VENDORS.DBF
DAYO AP, TJS LAB Page: 118
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
SHIPNAME C 30 0 POH.DBF Ship to Name and Address
APH.DBF
SHIPADDR1 C 30 0 POH.DBF
APH.DBF
SHIPADDR2 C 30 0 POH.DBF
APH.DBF
SHIPCITY C 22 0 POH.DBF
APH.DBF
SHIPSTATE C 2 0 POH.DBF
APH.DBF
SHIPZIP C 10 0 POH.DBF
APH.DBF
SHIPPHONE C 14 0 POH.DBF
APH.DBF
SLLOC1 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #1
SLLOC2 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #2
SLLOC3 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #3
SLLOC4 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #4
SLLOC5 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #5
SLLOC6 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #6
SLLOC7 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #7
SOLDPTD N 7 0 INV.DBF Quantity sold Period to Date
SOLDYTD N 7 0 INV.DBF Quantity sold Year to Date
STATE C 2 0 APH.DBF Address state code, ie: FL, CA...
VENDORS.DBF
POH.DBF
RECHECK.DBF
ACCOUNTS.DBF
STOCKLEVEL N 7 0 INV.DBF Stocking Level for the main
warehouse
SUBTOTAL N 10 2 RECHECK.DBF Check subtotal
POH.DBF Purchase Order subtotal
APH.DBF Payable subtotal
TAXABLE L 1 0 INV.DBF Taxable flag
POD.DBF
APD.DBF
TAXES N 10 2 APH.DBF Tax subtotal
POH.DBF
EXPENSES.DBF
RECHECK.DBF
TAXRATE N 5 3 VENDORS.DBF Tax rate
TERMS C 20 0 POH.DBF Terms, ie: NET 30, CASH, COD
VENDORS.DBF
APH.DBF
TOTALPAID N 10 2 VENDORS.DBF Total amount paid to this Vendor
RECHECK.DBF Total amount paid to this
Recurring check Payee
TOT_PURC N 10 2 VENDORS.DBF Total amount of purchases from
the Vendor
DAYO AP, TJS LAB Page: 119
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
TRANSACT C 12 APH.DBF GL Transaction Number
APD.DBF
VENDORS.DBF
INVADJ.DBF
CHECKS.DBF
ACCOUNTS.DBF
DEPOSITS.DBF
EXPENSES.DBF
TYPE C 3 0 APH.DBF Type, user defined
EXPENSES.DBF
DEPOSITS.DBF
INV.DBF
ACCOUNTS.DBF
TCHECKS.DBF
APD.DBF
POD.DBF
RECHECK.DBF
CHECKS.DBF
VENDORS.DBF
UNIT C 3 0 INV.DBF Unit of issue, ie: EA, BOX, KIT
VE L 1 0 RECHECK.DBF Logical flag to denote whether
the Recurring check is for a
Vendor or Expense
VENDITEM C 12 0 REC.DBF Vendor or Manufacturer product
APD.DBF number
POD.DBF
INV.DBF
INVADJ.DBF
VENDOR C 10 0 INV.DBF Vendor number
APH.DBF
VENDORS.DBF
REC.DBF
POH.DBF
APD.DBF
POD.DBF
V_1ST_LINE N 2 0 CFORMAT.DBF Starting line of Check Voucher
(enter '0' for Check only)
V_END_LINE N 2 0 CFORMAT.DBF Ending line of Check Voucher
(enter '0' for Check only)
V_LCOLUMN N 2 0 CFORMAT.DBF Starting column (left side) of
Voucher
(enter '0' for Check only)
V_RCOLUMN N 3 0 CFORMAT.DBF Ending column (right side) of
Voucher
(enter '0' for Check only)
WEIGHT N 8 2 INV.DBF Weight of an item
DAYO AP, TJS LAB Page: 120
WHATFOR C 40 0 CHECKS.DBF Reason for the Check
DEPOSITS.DBF Reason/Comment for the Deposit
TCHECKS.DBF Reason for the Check
RECHECK.DBF Reason/Expense name
EXPENSES.DBF
WORD_COL N 2 0 CFORMAT.DBF Starting column for the printing
of the dollar amount onto the
Check
WORD_ROW N 2 0 CFORMAT.DBF Starting row for the printing of
the dollar amount onto the Check
ZIP C 10 0 ACCOUNTS.DBF Address Zip code
POH.DBF
VENDORS.DBF
RECHECK.DBF
APH.DBF
DAYO AP, TJS LAB Page: 121
■ DAYO AP MAINTENANCE & QUIRKS
- If you are on a multiuser network, you must 'flag' (change file attributes)
of all files to make them sharable, readable and writable. Note that the
command/program 'flag' may be called by a different name on your network.
ie:
E:\>FLAG *.NTX SRW
or just to be safe, go ahead and flag all files in the DAYO directory:
E:\>FLAG *.* SRW
- Backups of your data and configuration files should take place daily! You
have no doubt heard many 'scare' stories about losing data. They are all
true! The key files that need to be backed up all have the extension of
.DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files
are notes/memos. The .CFG file(s) contain your configuration information
(as seen in the Configuration module).
- If you are on a network, it is NOT recommended that you use dBase III+ with
the databases. It may write an end of file marker not always recognized by
DAYO. Appending additional records to the database after this point often
leads/creates a 'bad record' in the database.
- If you must use dBase (tm) with DAYO AP, 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 AP, TJS LAB Page: 122
■ 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...
