home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Share Gallery 1
/
share_gal_1.zip
/
share_gal_1
/
BF
/
BF174.ZIP
/
AUCTION.DOC
< prev
next >
Wrap
Text File
|
1992-02-07
|
19KB
|
481 lines
Auction Entry Report Generator
Documention
CopyRight (c) 1991
All Rights Reserved
Programed
and
Written
by
Lavern Smith
38 Stacey Drive
Alabaster, Al.
35007
Documention Directory
Description Page
License agreement ...............................................1
Database's Description and Program setup ........................2
Hot Key Tutoral .................................................5
Warranties and License
There are no warranties with this license or program. This program is
let out on license and remains the sole property of Lavern Smith. You
as a licensee do not have the right to sell, trade, bargin or lend to
another this property that is licensed to you. At no time shall this
program be used on more than one computer per licensee, per site without
the written consent of the owner. I shall not and will not be held
liable for any damages to any computer system, or for any mistakes
entered into the databases created by this program. Any failure to
comply with this agreement could result in losing site license and
possible prosecution by the owner of this program.
This program will conform to the published specification and to the
documentation, provided that it is used on a computer hardware and with
the operating system for which it was designed. Because programs are
inherently complex and may not be completely free of errors, you are
advised to validate your work. In no event will I be liable for direct,
indirect, special, incidental, or consequential damages arising out of
the use of or the inability to use the program or documentation.
The Warranty and License agreement set forth above are exclusive and in lieu of all
others, oral or written, express or implied.
This program can be used in an auction to keep a record of all the
buyers and sellers information and generate reports from that
information. It also keeps information on the tax percentage at your
location and holds the auction or house commission percentage along with
the auctioneer's commission, if any.
This program has been tested in an actual running auction to test the
data file integerty and it's ability to handle speed and accuracy of
reports generated by the program and has been found to be accurate with
the data in which it handled and with the hardcopy that was produced
from that data.
Program requirements:
DOS 3.0 or higher
Will run on disk drive system "alot slower and disk fills up fast"
A lot better on a hard drive system "because of increased speed and
more disk space"
286 computer system "althought would run slower on an XT"
A high speed DMP printer with a large buffer "IBM Compatiable"
and continuous computer paper
I will try to give a complete tutoral on the operation of running this
program from the very start to the finish. So lets get started.
First of all a little infomation on what the program databases do. The
first database is called "auction.dat". This database holds programs
information, such as sales tax percentage, auction or house commission
and auctioneer's commission. Lets stop here and look at auctioneer's
commission. In all the auctions that I have been to, the auctioneer's
commission is taken out of the house commission, so thats the way its
done here, even though in the program it is taken from the total sells
it still comes from the house commission. Next we have a database that
will hold all of the auctions daily information and its name will change
daily, because the name is derived from the date function. Because its
name changes daily I have decided to use the computers date that you
will enter in a special routine to start the program database up. So it
is very important that you enter the correct date into your system at
the start of running this program, so you will not add to an already
exsisting database. The database's name will look something like this
name "103191.dat" when you do DIR search on your directory. The next
database's name is derived from daily database's name. In short
"1091.dat", it is created at the end of the auction when you run the
house report. If this is not the first time you use this program in
this month it will then add to it. In other words it will keep up with
the monthly activity of the auction. The last database will hold all of
the information for the auction's expense's for that month, it's name
will look something like "1091.exp". In short we now have four
database's.
AUCTION.DAT "program database"
103191.DAT "example of an daily database"
1091.DAT "example of monthly database"
1091.EXP "example of monthly expense database"
All these database's are kelp in the same directoryas the program is in,
so for this reason alone it is best to have a hard drive system.
Now with this behind us we can get into how the program operates.
Things to do first.
First turn on the computer system and the printer. Make sure the
printer is on line. Now we can load the program. At the DOS prompt
type "AUCTION" and press enter. What'a you know it is up and running.
Now we can get down to the business at hand. The screen that you see is
a full working calander. First you have initsuate the daily database
your asked if the date is correct or not. Hilite the date that is
correct press Enter. At this point you will be brought back into the
program ready for the work at hand. If you need to load an old auction
date use the correct keys to find the month or day of the auction you
want hilite the day and press enter.
Now lets take a look at the screen. You will see at the top of the
screen
Sellers number
Description
Price
Quantity
Buyer
The screen at first might not look just like this, but the shadow area
is where you will be entering the auction database information. Here
again at all the auctions I've been to all the Sellers and all the
buyers have a number. In a few cases a buyer will not have a number and
will pay cash, but more on that a little later. The Sellers field is 4
wide, up to 4 numbers can be entered. Example "1234". Letters also if
you so choose.
Next Description, this field is 20 wide, in other words you can enter up
to 20 characters in this description field. Again any character will
go.
Next Price, this field is only 11 wide. In it you can only enter numbers
or " . " decimal.
Next Quantity, this field is only 4 wide and will take numbers only.
Next Buyer, this field is only 4 wide. Enter the Buyers number here.
Example "1234", it will except letters also if you choose.
These five fields are the heart of the program. This is where you will
make this program work or not work. So make sure that the information
that you enter is correct to start with for a better performing program
operation. But don't worry if you do enter mistake you can correct it.
More on this as we go thru this program.
Now look at the line that say "Record no. 0". This is correct for the
first time that you run the program with a new database. This is
letting you know what record number is up for input. The next thing on
this same line is the date and time. Next line you will see "Tax
percentage .00" this is what the taxes are at your location. Next you
you see "House Commission .00", this is the commission that the house
collects off the sellers. Next you see "Auctioneer Commission .00",
this is the commission that the auctioneer get for his job. Now at this
point if the tax percentage, House Commission or the Auctioneer's
Commission any or all are wrong can be changed by pressing ALT-F7 at the
same time. At this point the screen will clear and you will enter the
correct tax percentage. Example ".06" for 6% sales tax.
The screen is cleared again and ask for the House Commission. Example
".15" for 15% commission on the total sales.
The screen will clear again and the ask you for the Auctioneer's
Commission. Let me explain how this works. First of all normaly, the
Auctioneer's Commission is taken from the House Commission and that is
the way it works here, but is calulated from the total sales for better
operation of the program. Example if the House Commission is 15% and
the Auctioneer get 1/3 of that, which is normal, then the Auctioneer's
Commission will then be ".05" which will be 1/3 of the House Commission.
If the Auctioneer does not get a commission then you enter "0" for no
commission. To this routine there is a check in the program to make
sure that you do not enter an amount more than the House commssion.
Because the Auctioneers Commission is taken out of the House Commission
we do not want the House to lose any money.
Now some times the total sales will be a low total sales for that day
and the auctioneer will require a minimum fee and if so you would enter
it in the next question. Lets say that the Auctioneer requires a
mimimim of $15.00 then you would enter "15.00".
Now a word of caution, the last four routines alone with most of the
routines in the program do not have any error checking on them so for
this make sure that you enter the correct information that you need.
The middle half of the screen is showing some of the fuction keys that
help run the program. There are more, if at any time you need to see
them while in this screen you may press the "F1" fuction key to see a
list of them and press any key to return back to the main screen. These
Function keys are the Heart to running the routines behind the program.
I decided to use "Hot Keys" in the operation of the program than to use
a menu, because hot keys are faster than a menu and that is one of the
things we need is speed to make this program work well.
Now the the last half of the screen is setup to show some of the records
in the database for that day. For a first time run you will not have
anything in the database. As the database grows this part of the screen
will fill up. The first item label is "Record", this is what record
number the information to the left of it is. Example
Record Seller Description Price Quanitity Buyer
1 200 CHAIR 3.25 4 125
The above is an example of what one record will look like. There will
be a maximun of 6 on the screen. As the database grows the records will
scroll in the window and leave the top 6 records up. The purpose of
this is so you may look at what you have just entered and help you to
see any errors that might have occured.
KEYS
Now let's look at the HotKeys before we run the program. Heres what the
help screen looks like. Look at the center of the scrren to the fuction
key there and you will see F1 - More help on keys
ESC - Exit from program
F2 - Gets a selected record to edit
F4 - Prints an Auction Invoice Report
F6 - Print a Buyers Report
F7 - Prints Sellers Report
F8 - Prints to the screen the data file
F9 - Saves screen to file
ALT-F1 Prints report for buyers that have not paid
ALT-F3 Clears all flags for a selected record
ALT-F4 Clears all buyers paid flags for all records
ALT-F5 Clears a selected buyers paid flags
ALT-F6 Enter Monthly Expense items
ALT-F7 Enter Tax percentage-House Commission--Auctioneers's Commission
Alt-F8 Print Monthly Report
Alt-F9 Start a new selected Record
ALT-D Deletes a selected Record
ALT-T Prints a Buyer Report for Buyers with a Tax number
Once in any of these routines Please do not press any key other than
what you are requested to enter. Some of these routines read and
rewrite the database. If for some reason something does go wrong and
the flags in the database are massed up you can press ALT-F4 to clear
all flags.
Esc
The Esc key is for exiting form the program back to the DOS prompt.
F2
This Hot Key is used to recall a record number that is attached to
the information that is in the database. If at anytime you do recall a
record, make changes if necessary, then you must press F9 to update this
record before yu can contuine.
F4
This Hot Key is used to print a report at the end of an Auction.
This report is called the House Report. You will press N for the very
first time that you run this report using this date.
You press Y only if this is an updated report, only if this is not the
first time that you have run this report.
F6
This Hot Key is used to print a report for a selected buyer. Use
this key when a buyer is finished buying and wants to leave.
F7
This Hot Key prints a report for a seller at the end of the Auction
day. This Hot Key does two things, first it will check to see if the
seller bought anything under his(her) number.If he(she) did buy anything
it will generate a buyers report, if nothing was bought it will not
produce a buyers report. Second it will generate a Sellers report for
the items that was sold. If a buyers report was generated first it will
then at the end of the sellers report make the necessary calulations for
sellers total profit for his(her) sell.
F8
This Hot Key is used to view all the records in the auction
database. At the end of its screen you are asked to contuine or not.
Press Y or N. The purpose of this routine is so you may view all of the
records in the database for mistakes or to see if any changes are
needed.
F9
Use this Hot Key to save what has been entered into the entry
fields. This Hot Key has two functions. First it saves what you have
entered in the fields, next it is used to update a record that is
recalled by using the F2 Hot Key.
ALT-F1
Sometimes you will have a buyer that will leave the auction without
paying for his(her) merchandise. This routine will print a report for
all those people, giving totals for all that they bought.
Now for a little explaination of what happens in a database will help
you understand the next three Hot Keys. Everytime a buyer pays,
his(her) records are flaged in the database as such. For this reason if
a buyer pays out you cannot get another report for this buyer until you
clear his(her) flags.
ALT-F3
This routine will clear all flags for a selected buyer record.
Sometimes you only need to clear flags for just one record.
ALT-f4
This routine will clear all flags in all records for all buyers,
except for cash payers. Use this routine with caution. Sometimes you
will need this, lets say for an example you were printing a buyer report
and the lights went out for a moment and the computer went out, you
forgot where you were in the reports and needed to start all over with
the reports. This routine would be good in this situation.
ALT-F5
Lets say that a buyer has paid out and a little later that buyer
comes back and want an item or two taken off his receipt. Can you do
this? The answer is yes with this Hot Key. On the buyers report the
first item is record. This is for your information, it tells you what
record number each item is in. You can act accordingly to what needs to
be done at this point. If that item really belongs to another buyer you
would press F2 to get the record and make the changes, then F9 to save
the changes, if the buyer wants these items removed from his(her) ticket
then you would need to delete this record. To do this you would press
ALT-D and reply with the right buyer number.
ALT-F6
This routine is for the House information. You would use this
routine at some free time to enter items of expense that the House
needs. In other words House Expenses.
ALT-F7
This routine will be used at the start of the Auction to enter
sales taxes, House Commission, Auctioneers Commission, and the mimium
fee that the Auctioneer get if the total sales does not reach a preset
mimium.
ALT-F8
This routine will be used in some free time to print a monthly
report for tax purposes. If at this time you have monthly expense items
and have not entered them yet, you need to press ALT-F6 and make the
necessary entries before you run this report. This routine will run a
monthly report for that same month you entered in the start of the
program are if ALT-F9 is used.
ALT-F9
This routine will start a new or an old database accordingly to
what you need to do. This is the same routine that you see when you
first start this program up. If you are already in the program and lets
say that a buyer that has not paid at a previous date comes in and needs
to settle up, you can press ALT-F9 press ALT-F1 for a list of auction
dates, enter the correct date and the program will reload the database
for that date that you just enter, if it is in the directory. At this
point you would press F6 for a buyers report, collect the money, then
you will need to rerun the House Report for that database to update the
monthly database and press Y to the question is this an update report or
not. This will then update the monthly database instead of adding to
it. Then when and only when you have done this you would press ALT-F9
to reenter the correct date for the Auction at hand.
The condition that you just read should be done when you have a little
free time to do such. It would take about 3 to 5 minutes to run
according to the situation at hand.
ALT-D
This routine will not actually erase the record but will erase all
the information in that record that you choose.
ALT-T
This routine should be run after the Auction is over and you have
run all the buyers reports and sellers reports. You would use this
routine to get special report for all buyers that have a tax number. It
will give a report for each buyer that has a tax number one at a time
and giving totals for each.