home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-387-Vol-3of3.iso
/
p
/
posmenu.zip
/
POS.DOC
< prev
next >
Wrap
Text File
|
1993-03-18
|
56KB
|
1,152 lines
The NFC Point-of-Sale System
You are looking at a simple and powerful Point-of-Sale System developed
to meet the needs of people who do not require a full blown General
Ledger, Accounts Receivable, Order Entry system. Specifically, vendors
at shows will find this a useful product. It can be preloaded with
inventory data before the show, installed on a laptop, and used as a
quick data entry, invoice printer, and payment tracking system.
Software, hardware, and service vendors, as well as stamp, card,
comic book, coin, and others, will like the simplicity of this system.
It does not require a great amount of training and can be learned in a
very short time. The following documentation should be the only item
needed to learn the system.
The intent of placing this application into the shareware market is two
fold. First, it gives prospective users access to a quality product at
a very small cost. Second, it will "test the market" for other
applications which we are considering putting into the shareware arena.
All the products we create and market are in use in commercial
companies today. The source code for each is available for an
additional small fee so that developers can modify the product for
their own client's individual use.
DISCLAIMER:
Use of this program acknowledges this disclaimer of warranty: "This
program is supplied as is. NFC disclaims all warranties, express
or implied, including, without limitation, the warranties of
merchantability and of fitness of this program for any purpose.
NFC assumes no liability for damages direct or consequential,
which may result from the use of this program."
T A B L E O F C O N T E N T S
1. SYSTEM OVERVIEW.......................................1
2. INSTALLATION..........................................2
2.1. SYSTEM CONFIGURATION............................2
2.1.1. Hardware.................................2
2.1.2. Software.................................2
2.1.3. Supplies.................................2
2.2. PROCEDURE.......................................2
3. USING POS.............................................3
3.1. STARTING POS....................................3
3.2. MAIN MENU.......................................3
3.2.1 Getting/Creating Help.....................3
3.3. ITEM FILE MAINTENANCE...........................3
3.4. DEFAULT FILE PARAMETERS.........................4
3.5. ORDER ENTRY.....................................5
3.6. DAILY CASHOUT AND CLOSING.......................7
3.7. BACKUP DATA FILES TO DISKETTE...................8
3.8. REINDEX ALL DATA FILES..........................8
3.9. EXIT THE SYSTEM.................................8
3.10. Print Price List................................8
3.11. Sales Summary Report............................9
3.12. Physical Inventory Worksheet....................9
3.13. Print Product Labels............................10
Data Entry & Report Commands.............................10
Summary..................................................12
Data Dictionary..........................................13
1. SYSTEM OVERVIEW
The NFC Point-of-Sale (POS) System is a real-time inventory control
and order entry system. Developed, using Clipper 5.2, POS is designed
to provide an efficient and reliable means of tracking product sales
and revenues for a variety of companies.
As orders are entered and processed, the database files are updated to
reflect changes in income and quantities sold. A numbered sales
receipt is printed immediately after each order is completed with full
details of the transaction.
Sales transactions are categorized by the method of payment (i.e.
cash, check, Visa, P.O., etc.) A number of various reports can be
printed by the system providing both detailed and summary information.
A price list can be printed, on demand, for distribution to customers.
You can define various system-wide parameters such as starting
transaction number, sales tax percent, and any messages to be printed on
the invoice. All file maintenance programs allow for adding,
modifying, deleting, and listing records in the database file. Data
entered into the POS is verified to aid in the correctness and
completeness of information. Certain prompts such as payment type and
item will produce a pick list of available choices when incorrect
information is entered. Other prompts display error messages when an
improper or invalid response is made.
To assist in the daily reconciliation of the cash drawer, POS prints a
detailed cashout report with a breakdown of each transaction by payment
method with subtotals and also a report grand total. During the
cashout procedures, a backup of the daily ORDERS is made to the summary
database file, OLDORDER. A backup selection is available to backup the
database files to a floppy drive and a reindex function can be run to
reindex all the database files in the POS.
A "HELP" system is implemented through-out the POS. When delivered,
the help is blank so that the user can define help screens to their
specific individual needs.
Page 1
2. INSTALLATION
2.1. SYSTEM CONFIGURATION
Following is the recommended configuration for using
the POS System:
2.1.1. Hardware
ANY IBM compatible with 640 KB of RAM, at least 1 MB
free hard disk space, Monochrome or color monitor, and a
printer. (The system can be installed and run on a high
density floppy, but a hard disk increases speed and is
recommended.
2.1.2. Software
MS-DOS V3.3x or higher
PKWARE's PKUNZIP version 2.04g (or higher)
POS System
2.1.3. Supplies
Paper, 9.5x11", fanfold (or regular 8.5x11" for a laser
printer) - for printing invoices and reports
Formatted diskettes - for daily backups
2.2. PROCEDURE
1. At the "C:>" prompt, or whatever your drive specification is, make a
directory where POS should reside. (i.e. MD POS)
2. Change to that directory. (i.e. CD POS)
3. Insert the POS disk into a diskette drive and type:
PKUNZIP A:*.ZIP
(Replace A: with B: if the B drive is being used)
This will transfer all the files to the hard disk.
5. Remove the POS disk from the drive and store them in a safe place.
Your installation is complete.
Page 2
3. USING POS
3.1. STARTING POS
To start the POS System, make sure that you are in the POS directory
that you made in the installation instructions on page 2.
At the C:\POS> prompt, type:
POSMENU <ENTER>
3.2. MAIN MENU
After a few seconds, the "MAIN MENU" screen will appear.
╔═ Point of Sale Main Menu ═══════════════════════════════════════════╗
║ O R D E R S R E P O R T S ║
║ A. Order Entry G. Print Price List ║
║ B. Daily Cashout & Closing H. Sales Summary Report ║
║ I. Physical Inventory Worksheet ║
║ F I L E M A I N T E N A N C E J. Print Product Labels ║
║ C. Item File Maintenance ║
║ D. Change System Defaults ║
║ E. Backup Data Files To Diskette ║
║ F. Reindex ALL Data Files X. Exit The System ║
╚═════════════════════════════════════════════════════════════════════╝
Table 3-1: MAIN MENU
To make a menu selection, you can either press the letter key of the
selection or use the up and down arrow keys to highlight your choice and
then press the ENTER key.
3.2.1 GETTING/CREATING HELP
Pressing the F1 key will either show the user the help available or
display an option to create a help screen for this area. If the user
wants to create a new help screen, they simply answer yes to the
"create" question, enter the text, and read the prompts on the bottom
of the help window. Modifications and additions to individual help
screens can be made at any time.
3.3. ITEM FILE MAINTENANCE
Assuming you are starting POS for the first time, it is
necessary to enter inventory information into the ITEM data file.
From the Main Menu, select Option C for Item File Maintenance.
This is the first step in creating a working system. The Item File
Maintenance screen will appear as follows:
╔═ Item File Maintenance ═══════════════════════════════════════════════╗
║ Part Number ▒▒▒▒▒▒▒▒▒▒▒ Description ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║ List Price ▒▒▒▒▒▒▒ Cost ▒▒▒▒▒▒▒ Beginning Quantity ▒▒▒▒▒▒▒ ║
║ Discount ▒▒▒▒ Disc. Qty. ▒▒▒▒ Quantity Sold ▒▒▒▒▒▒▒ ║
╚═══════════════════════════════════════════════════════════════════════╝
Table 3-3: ITEM FILE MAINTENANCE SCREEN
Page 3
If this is your first time into this selection, you will see a box
asking:
Database Empty, Add Records ? Yes or No
Press ENTER on Yes to add your records. If you select No, you will be
returned to the Main Menu where you can make another selection.
After selecting Yes, the system will prompt you to enter the required
information as shown on the screen in Table 3-3.
Part Number is an 11 place alphanumeric field. You can put any part
identifiers in that you wish. Use ones that make sense to you so that
you can remember them without looking at a listing. Description, List
Price, Cost, and Beginning Quantity are self explanatory. Discount is
a percentage for volume purchases. You might want the customer to pay
list price for all items up to a quantity of ten. If they purchase
more than ten at one time you might want to give them a 10% discount.
To do this, you would enter .10 in the Discount field and 10 in the
Disc. Qty. field. The system will automatically compute the discount
when the purchases go over this quantity. Quantity sold is an
accumulator field that will track sales of each item. Prior to any
sales, this number will always be zero.
Enter your information and press ENTER after completing each field
unless the information fills the entire field in which case the cursor
will move automatically to the next field. If you make a mistake, use
the arrow keys to move up or down to the appropriate field to make your
correction. After all the data is correct, please respond with a "Y",
or highlight the YES and press ENTER, to the screen prompt "Save Record?
Yes or No". If you realize that there is a mistake after you have
added the item to the data file, note the Part Number and use the
Modify function to correct it.
Make sure that you enter a part number "END" into your inventory
file. This part will be used later to tell the system when the order
is complete. No other information for this special part number is
necessary.
When you are done entering new items to the MASTER file, press the ESC
key and choose another file option or QUIT to the Main Menu.
3.4. DEFAULT FILE PARAMETERS
You are almost ready to start using POS. The last step to setting up
the system is to establish certain defaults used by POS during order
time.
There are three defaults that can be set or reset from the DEFAULT FILE
PARAMETERS selection, the starting transaction number, the state sales
tax percentage, and the messages that will appear on every invoice.
Page 4
Choose selection D from the Main Menu. The screen appears as follows:
╔═ Defaults File Maintenance ══════════════════════════════╗
║ ║
║ Next Transaction Number ▒▒▒▒ ║
║ ║
║ Sales Tax Percentage ▒▒▒▒▒▒▒ ║
║ ║
║ Invoice Message: ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║ ║
╚══════════════════════════════════════════════════════════╝
Table 3-4: DEFAULTS FILE MAINTENANCE SCREEN
The next transaction number is displayed on the order entry screen as
well as printed on the invoice. This number is also used on the
various reports for tracking purposes. It is incremented automatically
on each order. The Sales Tax Percentage is the sales tax charged for
regular customers. Each order will ask whether or not each sale is tax
exempt. If it is, the sales tax computation will be overridden. The
Invoice Message lines can include any information that you want printed
on ALL the invoices.
Enter the information in the same way as you did for the item screen.
There is only one record in this file so when the data is entered, you
will be bounced back to the file menu at the top of the screen, you
select another choice or Quit to the Main Menu.
Now all the databases and parameters have been set for the working POS.
The next step is the order entry itself.
3.5. ORDER ENTRY
Before processing orders, make sure that your printer is plugged in, on
line, and has paper in it.
Select Option A from the Main Menu to start order processing. The
following Order Entry screen will appear.
Page 5
╔═ Order Entry ═════════════════════════════════════════════════════════╗
║Invoice # ▒▒▒▒ Date ▒▒▒▒▒▒▒▒ Contact ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒║
║Company ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║Address ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒║
║ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒, ▒▒ ▒▒▒▒▒ Telephone ▒▒▒▒▒▒▒▒▒▒▒▒║
║Payment Type ▒▒ Number ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║Resale? ▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
║ Item Description Qty. Price Total ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
║ SUBTOTAL ▒▒▒▒▒▒▒▒▒▒▒ TAX ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ║
╚═══════════════════════════════════════════════════════════════════════╝
Table 3-5: ORDER ENTRY SCREEN
In the upper left corner of the screen, you will notice an invoice
number. This is the transaction number from the defaults database
file. It will increment by one after every transaction has completed
and will be recorded in the ORDERS data file. The date will display
the current system date but can be overridden if it needs to be
corrected. (You should have the correct date on your system. If you
don't, you can fix it using the DOS date command.)
The Contact, Company, Address, and Telephone fields are filled in for
each order. None of this information is required to be entered by the
system. You can simply press ENTER to bypass any unfilled field.
Payment Type is the next field. To see a selection of choices, press
"ENTER". A popup pick list will be displayed. Use you arrow keys to
highlight your choice and press ENTER to select it. The type will be
filled in and you will be brought back to the order screen. Next is
the number field. This is used in conjunction with the payment type.
That is, if the customer is paying by charge card, you may want to put
the number of the card in here for later tracking purposes. For a
check, enter the check number, and so on.
Next is Resale. This is a Y/N field. If the customer is a reseller,
enter Y here and fill in the next field with the reseller number. If
not, enter N. That completes the customer portion of the form.
Page 6
The cursor should now be on the first line Item field. Enter a valid
item number. The system will check it against the ITEM file. If
found, the description and list price will show on the screen. If it
is an invalid item number, a popup pick list of available items will be
shown. Use the arrow keys to highlight the desired choice and press the
ENTER key. Next, enter the quantity for this item. The system will
calculate the extended Totals, and running Subtotal, Tax, and Total
according to the data on the top of the screen and the discount
information in the ITEM file. The cursor will then move to the next
line for more entries.
Enter the rest of the items that the customer wants to buy in the same
way you did before, or up to a maximum of twelve (12) line items. If
the customer has more than 12 items, simply create another order for
the remainder. When you are finished, or have filled in the entire 12
order lines, enter "END" in the item number field. You will be asked
to "Save the Record". Answer Yes or No. At that point, a calculated
invoice is printed, the files are updated, and the screen is ready for
the next order.
The order entry screen can also be used to "return" or refund items
from the customer. The only difference in the order processing
procedure is that a NEGATIVE quantity is entered in the "QTY" field.
If there was a price override on the original transaction, override the
price accordingly. The extended line total will display a negative
dollar amount based on the quantity and price.
If, for any reason, the customer changes their mind and decides not to
purchase, the entire order may be cancelled by deleting the order. All
calculations for that order will be reversed including the inventory
available and sold.
To exit the order entry mode, press the ESC key. You can now make
another choice from the file maintenance menu or Quit back to the Main
Menu.
3.6. DAILY CASHOUT AND CLOSING
The Daily Cashout & Closing choice is used to close each day's
transactions for cash drawer reconciliation. This function should be
performed before any additional order processing on following days.
This choice does the following:
1. Prints a Daily Cashout Report that details all the transactions that
were recorded, by payment method and transaction number. Totals of
each payment type and a grand total are printed. The format of the
report is:
Daily Cashout Report Date ▒▒▒▒▒▒▒▒ Page ▒▒▒
Inv# Contact Date Subtotal Tax Total
▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ Total ▒▒▒▒▒▒▒▒▒▒▒
Table 3-6: DAILY CASHOUT REPORT
2. Copies all the transactions from the ORDERS file to the OLDORDER
file.
Page 7
3. Clears the ORDERS file for the next day's processing.
From the Main Menu, select choice B. Choose Go from the menu on the
top. The rest of the functions necessary are automatic.
3.7. Backup Data Files To Diskette
It is a good idea to backup your data files on a regular basis (at
least daily) to prevent loss of data. Selection E of the Main Menu is
used for that purpose. Make sure that you have a FORMATTED diskette in
the appropriate drive, select choice E, and answer the question of
which diskette drive to copy the files. The rest is automatic. All
the database files will be copied. Since your data is cumulative, all
the information prior to backing up will be stored. Write the date of
the backup on the diskette label and store the diskettes in a safe
place in case you need to restore them later.
3.8. Reindex ALL Data Files
Main Menu selection F is in case you need to reindex the data files on
the system. You may be required to do this if your system hangs or
crashes or if there is a power outage. If it appears at anytime when
you are using POS that the data is somehow just not coming up correctly
(i.e. descriptions don't match part numbers, etc.), try reindexing the
data file before doing anything else. This may save you time and the
frustration of restoring a back up of the data and reentering the
information not included on that backup just when you don't need it --
at order time. There are no prompts in this selection, all processing
is automatic.
3.9. Exit The System
When you are finished using POS, you can either press the ESC key, the
X key, or arrow down and highlight the Exit The System choice and press
ENTER. Any of these will put you at the DOS prompt.
3.10. Print Price List
The Price List can be printed at any time. It uses the ITEM file
information and shows the item number, description, list price,
discount percentage, and discount amount. The layout of the report is:
Item Price List Date ▒▒▒▒▒▒▒▒ Page ▒▒▒
Item Item List Discount Discount
Number Description Price Quantity Percentage
▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒ ▒▒▒▒ ▒▒▒▒
Table 3-10: PRINT PRICE LIST
Using the filter choice of the report menu, you can define a range of
items to print.
Page 8
3.11. Sales Summary Report
This report prints a report that lists all sales for a specified date
range. As with the price list, you can use the filter report menu
command to further limit what records are chosen for selection. The
date entry information and report layout look like:
╔═══════════════════════════════════╗
║ ║
║ Enter Beginning Date ▒▒▒▒▒▒▒▒ ║
║ ║
║ Enter Ending Date ▒▒▒▒▒▒▒▒ ║
║ ║
╚═══════════════════════════════════╝
Sales Summary Report Date ▒▒▒▒▒▒▒▒ Page ▒▒▒
Invoice Order
Number Date Contact Company
Item Quantity Price Total
▒▒▒▒ ▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒
Table 3-11: SALES SUMMARY REPORT
3.12. Physical Inventory Worksheet
The Physical Inventory Worksheet is used to physically count ending
inventory and correct any discrepancies in the ITEM file. The report
is printed in part number order and includes a space on the end of each
line where you can put the actual on hand quantity. This report can
then be used as the entry form to correct the inventory items to
actual. Below is a snapshot of the report form:
Physical Item Worksheet Date ▒▒▒▒▒▒▒▒ Page ▒▒▒
Item Item Quantity In Quantity
Number Description Inventory Counted
▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ __________
Table 3-12: PHYSICAL INVENTORY WORKSHEET
Page 9
3.13. Print Product Labels
This selection is used to print standard 15/16 by 3 1/2 inch labels to
be used as product identifiers for the inventory items you are selling.
POS can print any number across. As in the other reports, use the
filter report command to limit the range of items you want to print.
The data input and report layout is below:
╔══════════════════════════════════╗
║ ║
║ How Many Labels Across ? ▒ ║
║ ║
╚══════════════════════════════════╝
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
Table 3-13: PRINT PRODUCT LABELS
Data Entry & Report Commands
Data Entry/Maintenance Command Menu
Ret = Retrieve - The retrieve command is used to retrieve
and display a specific data record on the screen.
Begin = The begin command resets the record pointer to the
first record in the database and displays the record on the screen.
End = The end command resets the record pointer to the last
record in the database and displays the record on the screen.
Next = The next command moves the record pointer one record
forward and displays the record on the screen. If end of file is
reached the user is alerted by an End of File message.
Prev = Previous - The previous command moves the record
pointer back one record and displays the record on the screen. If
begin of file is reached the user is alerted by a Begin of File
message.
Add = The add command is used to add new records to the
database.
Copy = The copy command is used to add new records containing
similar data fields as existing records. The data cannot be saved
unless the record key is unique, since the system will not save
duplicate records.
Modify = The modify command is used to edit existing records. The user
will be stepped through the entire screen and edit records as needed.
Once editing is complete the use is prompted to save the modified
record. Select Yes to save and No to return to modify record.
Page 10
Del = Delete - The delete command is used to delete record
from the database. The system will prompt the user to confirm the
deletion. Answer Yes to delete and No to exit without deleting the
record.
List = The list command is used to browse the database. On
selecting list a browse window will open and records can be examined
by using the arrow keys or the page up/page down keys to browse
records. To browse all the data fields in the data base use the
control arrows keys to pan left and right across the browse screen.
Filter = The filter command allows the user to predefine and
use selected user defined record selection filters. A filter can be
any valid logical expression like SUBSTR(CONTACT,1,1) = "A". If you
need help with available choices for your filters, consult either an
xBase book or someone with xBase background. Selecting Filter results in
the appearance of a secondary command menu listing the following
commands:
Set - The set command is used to define a specific record
selection filter
Cancel - The cancel command deselects the record filter
selected by using the set command.
Edit - The edit command is used to modify previously defined
record selection filters.
Add - The add command allows the user to add the current user
defined record selection filter to an library listing
previously created filters.
Lists - The list command is used to list on the screen and
previously defined and saved record selection filters.
Delete - the delete command delete the currently selected
record filter from the filter library.
Quit - The quit command is used to exit the Filter submenu.
You can also exit the function by pressing the Esc key.
Quit = The quit command exits the record selection/maintenance
screen. you can also exit the function by pressing the Esc key.
Report Command Menu
Go = The go command initiates processing of the selected
report. On entering, you will be prompted to select the output media.
You can send the report to the Screen, File or Printer.
Tally = The tally command counts the number of records
included in the database and/or report.
Quit = The quit command exit the report function.
Page 11
Summary
POS is designed to provide a fast and accurate method of tracking
product sales. Considerable effort has gone into this product to
provide enhanced ease-of-use, increase speed within the order entry
function and still maintain a high level of data integrity.
Any problems or suggested enhancements to POS should be forwarded
directly to me.
You can reach me at:
Neil Freeman
Neil Freeman Consultants
45-449 Hoene Place
Kaneohe, HI 96744
CIS: 72330,222
Page 12
NFC POINT OF SALE SYSTEM -- Data Dictionary
Database: DEFAULTS Alias: DEFAULTS Description: System defaults file
Field name Type Len Dec Filt Options
---------- ---- --- --- --- ------------------------------------------
TRANSNUM N 4 0 N Picture: 9999
List header: Trans Num
Description: NEXT TRANSACTION NUMBER
SALESTPER N 7 5 N Picture: 9.99999
List header: Sales Tax
Description: SALES TAX PERCENTAGE
MESSAGE1 C 30 0 N Picture:
List header: Message 1
Description: INVOICE MESSAGE LINE 1
MESSAGE2 C 30 0 N Picture:
List header: Message 2
Description: INVOICE MESSAGE LINE 2
MESSAGE3 C 30 0 N Picture:
List header: Message 3
Description: INVOICE MESSAGE LINE 3
MESSAGE4 C 30 0 N Picture:
List header: Message 4
Description: INVOICE MESSAGE LINE 4
Index Dupl Auto Index Expression
-------- ---- ---- ------------------------------------------------------------
DEFAULTS N Y TRANSNUM
Page 13
Database: ITEM Alias: ITEM Description: Item file
Field name Type Len Dec Filt Options
---------- ---- --- --- --- ------------------------------------------
PARTNO C 11 0 Y Picture:
List header: Part Num.
Description: ITEM PART NUMBER
DESCRIPT C 30 0 Y Picture:
List header: Descript.
Description: ITEM DESCRIPTION
LISTPRICE N 7 2 N Picture: 9999.99
List header: List Price
Description: ITEM LIST PRICE
COST N 7 2 N Picture: 9999.99
List header: Cost
Description: ITEM COST
DISCOUNT N 4 2 N Picture: 9.99
List header: Discount
Description: ITEM QUANTITY DISCOUNT
DISCSTART N 4 0 N Picture: 9999
List header: Disc. Qty.
Description: ITEM DISCOUNT STARTS AT
BEGQTY N 7 0 N Picture: 9999999
List header: Beg. Qty.
Description: BEGINNING QUANTITY ON HAND
QTYSOLD N 7 0 N Picture: 9999999
List header: Qty. Sold
Description: QUANTITY SOLD
Index Dupl Auto Index Expression
-------- ---- ---- ------------------------------------------------------------
ITEM N Y PARTNO
Page 14
Database: OLDORDER Alias: OLDORDER Description: Closed orders file
Field name Type Len Dec Filt Options
---------- ---- --- --- --- ------------------------------------------
INVNUM N 4 0 Y Picture: 9999
List header: Invoice
Description: INVOICE NUMBER
CONTACT C 30 0 Y Picture:
List header: Contact
Description: CONTACT PERSON
COMPANY C 30 0 Y Picture:
List header: Company
Description: COMPANY NAME
ADDRESS1 C 30 0 N Picture:
List header: Address 1
Description: ADDRESS LINE 1
ADDRESS2 C 30 0 N Picture:
List header: Address2
Description: ADDRESS LINE 2
CITY C 20 0 N Picture:
List header: City
Description: CITY
STATE C 2 0 N Picture:
List header: State
Description: STATE
ZIPCODE C 5 0 N Picture:
List header: Zip Code
Description: ZIP CODE
PHONE P 10 0 N Picture: @R ###/999-9999
List header: Phone
Description: TELEPHONE NUMBER
PAYMTTYPE N 2 0 N Picture: 99
List header: Pay Type
Description: PAYMENT TYPE (CASH, CC, PO)
Valid values: PTYPE in database PAYMENT
Error Messg: Payment type not found in file
PAYNUMBER C 20 0 N Picture:
List header: Pay Number
Description: CC, CHECK, OR PO NUMBER
ITEM1 C 11 0 N Picture:
List header: Item 1
Description: ITEM 1
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM2 C 11 0 N Picture:
List header: Item 2
Description: ITEM 2
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM3 C 11 0 N Picture:
List header: Item 3
Description: ITEM 3
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
Page 15
ITEM4 C 11 0 N Picture:
List header: Item 4
Description: ITEM 4
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM5 C 11 0 N Picture:
List header: Item 5
Description: ITEM 5
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM6 C 11 0 N Picture:
List header: Item 6
Description: ITEM 6
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM7 C 11 0 N Picture:
List header: Item 7
Description: ITEM 7
Valid values: PARTNO in database ITEM
Error Messg: Part Number not found in file
ITEM8 C 11 0 N Picture:
List header: Item 8
Description: ITEM 8
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM9 C 11 0 N Picture:
List header: Item 9
Description: ITEM 9
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM10 C 11 0 N Picture:
List header: Item 10
Description: ITEM 10
Valid values: PARTNO in database ITEM
Error Messg: Part Number not found in file
ITEM11 C 11 0 N Picture:
List header: Item 11
Description: ITEM 11
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM12 C 11 0 N Picture:
List header: Item 12
Description: ITEM 12
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
QTY1 N 5 0 N Picture: 99999
List header: Qty 1
Description: QUANTITY FOR ITEM 1
QTY2 N 5 0 N Picture: 99999
List header: Qty 2
Description: QUANTITY FOR ITEM 2
QTY3 N 5 0 N Picture: 99999
List header: Qty 3
Description: QUANTITY FOR ITEM 3
QTY4 N 5 0 N Picture: 99999
List header: Qty 4
Description: QUANTITY FOR ITEM 4
Page 16
QTY5 N 5 0 N Picture: 99999
List header: Qty 5
Description: QUANTITY FOR ITEM 5
QTY6 N 5 0 N Picture: 99999
List header: Qty 6
Description: QUANTITY FOR ITEM 6
QTY7 N 5 0 N Picture: 99999
List header: Qty 7
Description: QUANTITY FOR ITEM 7
QTY8 N 5 0 N Picture: 99999
List header: Qty 8
Description: QUANTITY FOR ITEM 8
QTY9 N 5 0 N Picture: 99999
List header: Qty 9
Description: QUANTITY FOR ITEM 9
QTY10 N 5 0 N Picture: 99999
List header: Qty 10
Description: QUANTITY FOR ITEM 10
QTY11 N 5 0 N Picture: 99999
List header: Qty 11
Description: QUANTITY FOR ITEM 11
QTY12 N 5 0 N Picture: 99999
List header: Qty 12
Description: QUANTITY FOR ITEM 12
PRICE1 N 7 2 N Picture: 9999.99
List header: Price 1
Description: PRICE FOR ITEM 1
PRICE2 N 7 2 N Picture: 9999.99
List header: Price 2
Description: PRICE FOR ITEM 2
PRICE3 N 7 2 N Picture: 9999.99
List header: Price 3
Description: PRICE FOR ITEM 3
PRICE4 N 7 2 N Picture: 9999.99
List header: Price 4
Description: PRICE FOR ITEM 4
PRICE5 N 7 2 N Picture: 9999.99
List header: Price 5
Description: PRICE FOR ITEM 5
PRICE6 N 7 2 N Picture: 9999.99
List header: Price 6
Description: PRICE FOR ITEM 6
PRICE7 N 7 2 N Picture: 9999.99
List header: Price 7
Description: PRICE FOR ITEM 7
PRICE8 N 7 2 N Picture: 9999.99
List header: Price 8
Description: PRICE FOR ITEM 8
PRICE9 N 7 2 N Picture: 9999.99
List header: Price 9
Description: PRICE FOR ITEM 9
PRICE10 N 7 2 N Picture: 9999.99
List header: Price 10
Description: PRICE FOR ITEM 10
Page 17
PRICE11 N 7 2 N Picture: 9999.99
List header: Price 11
Description: PRICE FOR ITEM 11
PRICE12 N 7 2 N Picture: 9999.99
List header: Price 12
Description: PRICE FOR ITEM 12
ORDDATE D 8 0 N Picture: @D
List header: Order Date
Description: ORDER DATE
Default: DATE()
FORRESALE L 1 0 N Picture: Y
List header: For Resale
Description: IS FOR RESALE ?
EXEMPTNUM C 20 0 N Picture:
List header: Exempt #
Description: EXEMPTION NUMBER (RESALE #)
TAXAMOUNT N 7 2 N Picture: 9999.99
List header: Tax
Description: TAX AMOUNT FOR INVOICE
Index Dupl Auto Index Expression
-------- ---- ---- ------------------------------------------------------------
OLDORDER N Y INVNUM
Page 18
Database: ORDERS Alias: ORDERS Description: Order entry file
Field name Type Len Dec Filt Options
---------- ---- --- --- --- ------------------------------------------
INVNUM N 4 0 Y Picture: 9999
List header: Invoice
Description: INVOICE NUMBER
CONTACT C 30 0 Y Picture:
List header: Contact
Description: CONTACT PERSON
COMPANY C 30 0 Y Picture:
List header: Company
Description: COMPANY NAME
ADDRESS1 C 30 0 N Picture:
List header: Address 1
Description: ADDRESS LINE 1
ADDRESS2 C 30 0 N Picture:
List header: Address2
Description: ADDRESS LINE 2
CITY C 20 0 N Picture:
List header: City
Description: CITY
STATE C 2 0 N Picture:
List header: State
Description: STATE
ZIPCODE C 5 0 N Picture:
List header: Zip Code
Description: ZIP CODE
PHONE P 10 0 N Picture: @R ###/999-9999
List header: Phone
Description: TELEPHONE NUMBER
PAYMTTYPE N 2 0 N Picture: 99
List header: Pay Type
Description: PAYMENT TYPE (CASH, CC, PO)
Valid values: PTYPE in database PAYMENT
Error Messg: Payment type not found in file
PAYNUMBER C 20 0 N Picture:
List header: Pay Number
Description: CC, CHECK, OR PO NUMBER
ITEM1 C 11 0 N Picture:
List header: Item 1
Description: ITEM 1
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM2 C 11 0 N Picture:
List header: Item 2
Description: ITEM 2
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM3 C 11 0 N Picture:
List header: Item 3
Description: ITEM 3
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
Page 19
ITEM4 C 11 0 N Picture:
List header: Item 4
Description: ITEM 4
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM5 C 11 0 N Picture:
List header: Item 5
Description: ITEM 5
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM6 C 11 0 N Picture:
List header: Item 6
Description: ITEM 6
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM7 C 11 0 N Picture:
List header: Item 7
Description: ITEM 7
Valid values: PARTNO in database ITEM
Error Messg: Part Number not found in file
ITEM8 C 11 0 N Picture:
List header: Item 8
Description: ITEM 8
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM9 C 11 0 N Picture:
List header: Item 9
Description: ITEM 9
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM10 C 11 0 N Picture:
List header: Item 10
Description: ITEM 10
Valid values: PARTNO in database ITEM
Error Messg: Part Number not found in file
ITEM11 C 11 0 N Picture:
List header: Item 11
Description: ITEM 11
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
ITEM12 C 11 0 N Picture:
List header: Item 12
Description: ITEM 12
Valid values: PARTNO in database ITEM
Error Messg: Part number not found in file
QTY1 N 5 0 N Picture: 99999
List header: Qty 1
Description: QUANTITY FOR ITEM 1
QTY2 N 5 0 N Picture: 99999
List header: Qty 2
Description: QUANTITY FOR ITEM 2
QTY3 N 5 0 N Picture: 99999
List header: Qty 3
Description: QUANTITY FOR ITEM 3
Page 20
QTY4 N 5 0 N Picture: 99999
List header: Qty 4
Description: QUANTITY FOR ITEM 4
QTY5 N 5 0 N Picture: 99999
List header: Qty 5
Description: QUANTITY FOR ITEM 5
QTY6 N 5 0 N Picture: 99999
List header: Qty 6
Description: QUANTITY FOR ITEM 6
QTY7 N 5 0 N Picture: 99999
List header: Qty 7
Description: QUANTITY FOR ITEM 7
QTY8 N 5 0 N Picture: 99999
List header: Qty 8
Description: QUANTITY FOR ITEM 8
QTY9 N 5 0 N Picture: 99999
List header: Qty 9
Description: QUANTITY FOR ITEM 9
QTY10 N 5 0 N Picture: 99999
List header: Qty 10
Description: QUANTITY FOR ITEM 10
QTY11 N 5 0 N Picture: 99999
List header: Qty 11
Description: QUANTITY FOR ITEM 11
QTY12 N 5 0 N Picture: 99999
List header: Qty 12
Description: QUANTITY FOR ITEM 12
PRICE1 N 7 2 N Picture: 9999.99
List header: Price 1
Description: PRICE FOR ITEM 1
PRICE2 N 7 2 N Picture: 9999.99
List header: Price 2
Description: PRICE FOR ITEM 2
PRICE3 N 7 2 N Picture: 9999.99
List header: Price 3
Description: PRICE FOR ITEM 3
PRICE4 N 7 2 N Picture: 9999.99
List header: Price 4
Description: PRICE FOR ITEM 4
PRICE5 N 7 2 N Picture: 9999.99
List header: Price 5
Description: PRICE FOR ITEM 5
PRICE6 N 7 2 N Picture: 9999.99
List header: Price 6
Description: PRICE FOR ITEM 6
PRICE7 N 7 2 N Picture: 9999.99
List header: Price 7
Description: PRICE FOR ITEM 7
PRICE8 N 7 2 N Picture: 9999.99
List header: Price 8
Description: PRICE FOR ITEM 8
PRICE9 N 7 2 N Picture: 9999.99
List header: Price 9
Description: PRICE FOR ITEM 9
PRICE10 N 7 2 N Picture: 9999.99
List header: Price 10
Description: PRICE FOR ITEM 10
Page 21
PRICE11 N 7 2 N Picture: 9999.99
List header: Price 11
Description: PRICE FOR ITEM 11
PRICE12 N 7 2 N Picture: 9999.99
List header: Price 12
Description: PRICE FOR ITEM 12
ORDDATE D 8 0 N Picture: @D
List header: Order Date
Description: ORDER DATE
Default: DATE()
FORRESALE L 1 0 N Picture: Y
List header: For Resale
Description: IS FOR RESALE ?
EXEMPTNUM C 20 0 N Picture:
List header: Exempt #
Description: EXEMPTION NUMBER (RESALE #)
TAXAMOUNT N 7 2 N Picture: 9999.99
List header: Tax
Description: TAX AMOUNT FOR INVOICE
Index Dupl Auto Index Expression
-------- ---- ---- ------------------------------------------------------------
ORDERPMT Y Y PAYMTTYPE
ORDERS N Y INVNUM
Database: PAYMENT Alias: PAYMENT Description: Payment type file
Field name Type Len Dec Filt Options
---------- ---- --- --- --- ------------------------------------------
PTYPE N 2 0 Y Picture: 99
List header: Pay Type
Description: PAYMENT TYPE NUMBER
PDESCRIP C 20 0 N Picture:
List header: Pay Descr.
Description: PAYMENT TYPE DESCRIPTION
Index Dupl Auto Index Expression
-------- ---- ---- ------------------------------------------------------------
PAYMENT N Y PTYPE