Cash Register

PURCHASE ORDERS
The program PURCHASE.EXE will print out, or save to a text or data file, the stock items in your stock table with inventories so low that they should be reordered. It does this by comparing the value in the INVENTORY column of the stock table to the value in the MODEL column. Stock items with a lower INVENTORY than MODEL will be printed out.

EXTREMEY IMPORTANT! Once you assign a vendor to a slot in the vendor list this program will then file information to that vendor by the position in the list. For example if vendor #12 is Acme Industries then all purchase order information for Acme Industries will be stored by the number 12. If you later switch the slots 12 and 34 then all the purchases previously made from Acme Industries will now be assigned to the new occupant of slot 12 which could be Bebo Incorporated. Always assign new vendors to currently empty slots. It is a good idea to not assign anyone to slot zero.

For the purchase program to function each item in the stock table (that you want to use this program to order for your store) you must fill in the following columns.

STOCK NUMBER DESCRIPTION INVENTORY COST (What you pay to obtain the item) MODEL (How many you have when fully stocked) PACK (The minimum you can order) VENDOR STOCK NUMBER (If you want it printed on the PO) When you start the PURCHASE.EXE program you will see a couple of screens of instructions and then come to this main menu.

1. Enter header data
2. Create proof sheets
3. Create purchase orders
4. Manual purchase orders
5. Open purchase order file
6. Quit
Main menu

Enter header data

If you wish to print actual purchase orders you will have to enter a purchase order "header" for each vendor. To help you the program has this sample header template that you can edit.

BILLING: XYZ CORPORATION             SHIPPING: THE KEY HUT
         ATTN: DALE HARRIS                     9012 E. MAIN ST.
         1234 N. MAIN ST.                      OVERTHERE, IL 66666
         ANYWHERE, IL 60000                    PHONE (773) 555-5559
         PHONE (773) 555-5555                  FAX (773) 555-5550
         FAX (773) 555-5556
                                      TERMS: SHIPMENT MUST BE SENT TO
     TO: ABC COMPANY                  SHIPPING ADDRESS ONLY AND MUST
         5678 S. MAIN ST.             INCLUDE A PACKING SLIP WITH THE
         SOMEWHERE, IL 69999          PURCHASE ORDER NUMBER ON THIS
                                      FORM.
                                      INVOICES MUST BE MAILED TO THE
         PHONE (773) 555-5557         BILLING ADDRESS AND THE PURCHASE
         FAX (773) 555-5558           ORDER NUMBER ON THIS FORM MUST
                                      BE INCLUDED ON THE INVOICE.

The template and headers are 78 characters wide and up to 18 lines. Only lines from the top to the last non-blank line will be printed. The first step is to edit the template to what you want printed at the top of the first page of each purchase order. If you are using window envelopes you will want the vendor's name and address placed in the header so that it is behind the window when the purchase order is placed in the envelope.

Once you have the template the way you want it you can then select your vendors one by one and press [F1] to drop the template into each vendor's header. You can then edit the template for that vendor by changing the address for the vendor. Of course you can have totally different headers with different terms and instructions of you wish.

Create proof sheets
Proof sheets are to check your inventory against the model stock list before you decide if you actually want to make purchase orders. Proof sheets will not print the headers and will comprise the following columns; stock number, vendor stock number, description, inventory, model stock, order quantity, unit cost, cost all. You can create a proof sheet for all items sorted by vendor or you can choose to create a proof sheet for a specific vendor. Proof sheets will be created at 40 or 80 characters wide depending on how you have set that register on printing receipts. They can be printed on the printer.

Create purchase orders
Purchase orders are created to actually order merchandise from your vendors. You can put them in an envelope, fax them, or email them to have your vendor send you merchandise.

Purchase orders will have the header at the top of the first page. A purchase order number and the order date will be printed under the header and on the top of all following pages. Purchase orders are created only at 80 characters wide and will use the PAGE settings of the "Printer setup" for that computer even if the computer is set up for CONT. printing. If you cannot print the purchase order on this computer then you must save it to a floppy (or other storage device) to print out on a different computer. Purchase order numbers are 7 digits long. This means that there will be 10 million of them before they roll over to 0000000.

When you create a purchase order it will print on the printer and be saved in a disk file. Each purchase order will use the next sequential purchase order number. You may select to print one or two copies of each purchase order. If you are mailing the purchase orders to the vendor then you should print two copies so that you have one to file. Yes, paper files are a good idea. Even though this program will electronically file and store each purchase order you should keep a paper record. Purchase orders kept as computer files can be deleted or a file crash can erase them all. (Remember to backup your files frequently.)

Purchase orders will comprise the following columns; stock number, description, order quantity, unit cost, cost all. You may also select to have the vendor stock number printed for each item.

If you choose to use only the stock then each item will be listed on one line. If you choose to add vendor stock number then each item will be listed on 2 lines. The quantity ordered will be in the units that you sell them. If you sell wire by the meter then you will be told how many meters that you should order, NOT coils of wire. For example if wire comes in 250 meter coils (PACK = 250), and you normally should stock 3 coils (MODEL = 750) then if you have 350 meters of wire in stock you need 400 more meters of wire. However the PACK is 250 so you cannot order 400 meters of wire. The program will round up to the next PACK over 400, which is 500 meters or 2 coils of wire. If your vendor sells wire by the coil (even though you sell it by the meter) then you must make sure that you do not tell him that you want 500 or he will send you 500 coils (or 125,000 meters), way too much. This also applies to things sold to you by weight, case, box, etc. If you order 12 of something will your vendor think that you are ordering 12 pieces or 12 cases?

Rounding up is based on half a PACK. For example if a PACK is 10, MODEL is 40 and you have 36 or more, none will be ordered. If you have 26 to 35 then 10 will be ordered. If you have 16 to 25 then 20 will be ordered. If you have 6 to 15 then 30 will be ordered. If you have 0 to 5 then 40 will be ordered. Assuming you sell none before your shipment arrives you will be with in a half a pack (plus or minus) of your model stock when it does arrive.

Remember that INVENTORY, MODEL, PACK, and ORDER are in the units that you sell them. COST is the price for one unit in the units that you sell them, for example 12.95 is the cost for one piece, not one case, even if they are sold to you by the case (this assumes that you sell them by the piece.)

INVENTORY = How many you have in stock now.

MODEL = The minimum number of this item that you want in your store.

PACK = The minimum number that can be ordered, i.e. must a case of 12 be ordered in multiples of 12?

COST = How much it costs you to purchase this item from your vendor.

Manual purchase order
You may also create manual Purchase Orders. There are 2 reasons to use this program if you have to create manual purchase orders instead of just using your word processor or some other method. First of all it will be much easier to use this program. This program will put the same header at the top of the manual PO that is placed at the top of automatic POs. To enter an item all you have to type will be the stock number and the quantity you want to order. This feature will look up the description and the cost This feature will not allow you to enter an item that is not supplied from the vendor you select. It will not allow you to order a quantity that is not a multiple of the PACK for that item.

The second reason is that the PO will use the next PO# and be filed in the system just like an automatic PO. Since the automatic PO feature numbers the POs sequentially if you use another method to create manual POs you will have to use a different numbering system.

NOTE: Due to the general perversity of DOS the maximum number of different stock numbers you can order in one PO is 8,100. If you need more than 8100 different stock numbers you will have to split your order between 2 POs.

To make a manual PO from the main menu select option "4. Manual purchase orders" then select the vendor you wish to order from. On the next screen when you enter the stock number the program will look up and display the description, current inventory, MODEL, PACK, and the first 24 characters of the vendor stock number. When you enter the quantity you wish to order the line will be displayed on the list on the right of the screen. Only the last 24 items you entered will be displayed. You cannot scroll the list.

If you enter the same item more than once only the last time you enter it will count. For example if you enter 24 pieces for item 123456 and then later enter 15 pieces for item 123456 then only 15 pieces will be ordered for item 123456. This is also how you correct an item. If you order item 654321 by mistake then enter 0 pieces for item 654321 and you will order none, even if previously you had ordered 20.

If you press [F5] you will save the current worksheet you have entered. It is saved by vendor so you can save your work for each vendor and then come back to it later. Saving will not create a purchase order. If you press [F8] you will retrieve the last worksheet for this vendor. NOTE When you retrieve a worksheet it will be displayed in the order the items appear in the stock table, not the order you entered them.

Pressing [TAB] will format a purchase order and display it on he screen. This will not create a purchase order, but just show you what you have entered. Pressing [F1] will create the purchase order and add it to the file. You will then be returned to the main menu.

Press [ESC] to cancel the current work sheet and return to the main menu. Returning to the main menu is also how you change vendors.

Open purchase order file
This feature will allow you to view, print, delete, void, or update your purchase orders in the file. You may retrieve a specific purchase order by the purchase order number. You may retrieve all the purchase orders sent to a specific vendor with a maximum of the last 1000. You may retrieve the last 1000 purchase orders placed to all vendors.

Display

1. Enter PO #
2. Pick vendor
3. All purchase orders
4. Quit

From the above menu you may call up a specific PO, all the PO's from a specific vendor or all the PO's in the file.

When you are at this screen you can do several things once you highlight the purchase order you want.

If you press [TAB] you can put the full purchase order up on the screen. From there you can reprint the PO or save it as another text file that can be loaded in to any word processing program.

Pressing [DELETE] will allow you to delete the purchase order after a prompt. Pressing [CTRL]+[DELETE] will immediately delete the PO. Deleting PO's is a good idea. As the number of PO's in the file increases the program will take longer and longer to perform various functions. And of course all those PO's will take up space on your disk drive. I really cannot see any reason to keep them for years.

If you press [F1] this window will appear this will allow you to add the listed information to the purchase order. This information will also appear on the top of purchase order reprints.

PRICE CHECK
If you are running networked cash registers you can place additional computers out on your sales floor that customers may use to check prices and quantities in stock on items you stock. Press [F1] the check gift card balances.

To do this, connect additional computers to your network and run the program file LOOKUP.EXE. You must enter into the program the network PATH to the global folder on your server that holds your shared data files. It will be the exact same PATH that you entered into the "Network" feature of the POSCONFG.EXE program to set up each register to run over the network.

When you created your register you had to give your register a filename. You must also enter this filename into the LOOKUP.EXE program.

If you enter a password then the customers will not be able to exit this program or access its settings. When the program is actually looking up items press [ESC] to go to the program's menu. If you have entered a password then you will have to enter it before you can leave the "Price check" screen.

You may enter up to 3 pages of instructions for your customers to follow to use this program to look up items. I do not know what computer equipment you will be providing so it is up to you to write the instructions. Will you be running this on a laptop or desktop computer? Will you be providing a scanner? Make sure you tell them to press [ENTER] after typing in a stock number. Tell them how to find the stock number on your items. Are you using price stickers with the stock numbers on them or are you using the barcode numbers as you stock numbers?

You may use the 3 pages of instructions to write really long detailed instructions or you can use each page to write instructions in different languages. For example use page #1 for instructions in English, page #2 for instructions in Spanish, and page #3 for instructions in Polish. Make sure that you tell the customers to press either [PAGE UP] or [PAGE DOWN] to access other pages. Of course if the other pages have instructions in different languages you would want to post that information on the current page in the language of the other pages like from the English page you would print...

[PAGE UP] = Instrucciones en Espaņol

[PAGE DOWN] = Instrukcja po Polsku

When entering instructions you can enter accented characters by first pressing [F3] to display the "Alternate character set." Each character will have a 3 digit number to its left. To actually type in an alternate character hold down [ALT], use the numeric keypad on the right of your keyboard to type in the 3 digit code, and then when you release the [ALT] key the alternate character will appear in your text.

Once you have entered the required information you may select to "1. Go to the lookup screen." Now customers can type in stock numbers to check on prices and quantities in stock. Press [F1] the check gift card balances.

You may set up the program to lookup either regular stock numbers, vendor stock numbers, or both. If the program can check for both, it will lookup regular stock numbers first. If it finds a match it will then ask if you want to also look in the vendor stock numbers.

When checking vendor stock numbers you do not have to enter the entire stock number. If you enter just part of a vendor number the program will find the first vendor stock number that contains that part and then ask you if you want to continue to search.


Time Clock
If the file TIMECLOK.EXE is in the folder with the other POS program files you may press [F5] from the main menu of the POS.EXE program to access the time clock. If you remove the TIMECLOK.EXE file from the folder then pressing [F5] will do nothing and you will not be able to use the time clock feature. The time clock will run over a network and all registers on the network will access the same time clock. If you are using this program over a network the program file TIMECLOK.EXE will still have to be on any register from which you wish to use the time clock. The time clock uses the system clock of whatever register is being used to access the time clock feature. Make sure that all registers on the network have the system clock set to the correct time.

When you enter the time clock program it will ask you for your PIN number. Even if you do not use PIN numbers when running the register the time clock will require a PIN number for each employee. The purpose of PIN numbers is to make sure that only the employee can punch the time on his time card. After entering the proper PIN number the program will go to that employee's time card.

Note: All 56 possible employees will have their time card stored in the same file. The first time someone tries to access a time card in a new week the program will create a new file. This is automatic and you will not have to create this file. The filename for the file will consist of Saturday's date (or Sunday's date if you select to make Sunday the last day of the week) in YYYYMMDD format followed by ".CLK". For example if someone tries to punch in on Monday, March 9th, 2009 and no file exists the program will create the file 20090314.CLK. This file is stored in a sub-folder with the same name as the register file. For example if you store your POS program files in the folder C:\POS and your register's file name is KEYSHOP then the time clock files will be stored in the folder C:\POS\KEYSHOP. If you run the POS program over a network the time clock files will be in a sub-folder to the GLOBAL folder on the server.

When a new time clock file is created the current employees names and ID numbers will be added to the file. If during the week new employees are added their names and IDs must be manually added to the time card file using option "3. Associates" from the time clock program's supervisor menu.

Time card
Time cards always run from Sunday to Saturday. When the employee opens his time card he will be restricted to only the current day. He may use the left and right arrow keys to choose which column to punch in the current time. When the light bar is in the correct place, punch the time by holding down the [CTRL] key and pressing [F1]. Once a time has been punched it may not be changed.

While viewing the time card it may be printed out by pressing [TAB] assuming that the register has been setup to print receipts.

Screen shot of a time card.

SUPERVISORS
Supervisors will have access to additional features of the time clock. When the time clock is first used no one is a supervisor. This will allow anyone to have supervisor access so the first thing you will want to do is press [F8] from a time card to access the Supervisor Menu.

     Supervisor menu
1. Correct time punch
2. View time cards
3. Associates
4. Transmit time cards
5. Delete time card
6. Store # / Time display
7. Quit

By choosing option 3 you will see a list of employees. To make an employee a supervisor highlight the name and press [TAB]. Supervisors will have an asterisk placed to the left of their names. Once one or more employees have been made supervisors, only those employees will be able to access the supervisor menu.

Correct time punch.
This feature allows a supervisor to over-ride a time punch that may be incorrect or missed. When this feature is entered you must select the time clock file you wish to alter. Only the last two files may be selected. You then choose the employee time card you wish to access. While you may not change the actual time punch you will be able to enter a new time under the punch that will over-ride the actual punch. Under the correction the supervisor's number will be printed.

  Time punch ' 12:23
Corrected to ' 12:28
Corrected by '    4

When time worked is calculated normally the time punch will be used. However if there is a correction then the correction will be used.

By pressing [TAB] you will be able to enter the reason that the time was corrected. This also allows the supervisor to enter time for sick pay or vacation time, or any other reason. For example if an employee is due a day of vacation then a supervisor can enter the first time in as 09:00 and the following time out as 15:00 (8 hours) and enter the reason as "VACATION". If you print a time card at 40 characters per line the "reasons" will be printed on one line at the bottom of the card. In this case only the first 4 characters of the reason will be printed.

View time cards
This feature will allow a supervisor to load any time clock file and view any time card in the file. By pressing [TAB] you may print the displayed time card, save the card as a text file, or save the card as a comma delimited file that can be loaded into a spread sheet program like Excel. You may also select to automatically print or save all cards that have data on them. If all cards are printed or saved at once they will be saved into one file. However only cards that have data will be printed or saved, blank cards will be ignored.

If you save cards as a file you can save them to another drive by changing the drive letter or if you do not change the drive letter they will be saved to the folder that stores the time card files.

  Save file as...

       YYMMDD
   C:09032801.TMT

[TAB] = Change drive
    [ENTER]=Save
    [ESC]=Cancel

The standard file name used will be the Saturday date for the week followed by the card number (or AL if all cards are being saved) followed by the extension of .TMT for a text file or .TMD for a data file. However you may type in a different file name if you wish except for the extension. A sample file name would be 09032801.TMT for the first card in the 20090328.CLK file.

Associates
This feature will allow you to add or correct an associate's name, ID number, and if the associate is a time card supervisor. When a time card file is created this information will be added to the new file. However if an employee is added during the week the new information will not be imported to an existing file. You must use this feature to add new employees to an existing time card file. Adding a new employee to the time card file will not add that employee to the main POS program. You must add him in both files and you must make sure that the new employee is added to the same line number in both files. PIN numbers can only be added in the POS.EXE program. You can only use the "Associates" feature in the time card program to enter the employees' ID and make the person a time card supervisor. It is important that you do not add a new employee to the same line in the employee list that was used by a previous employee until the previous employee has been gone for at least 2 months.

While you are in this feature you can press [F5] to set up the program so that it requires the PIN number of a supervisor to access the time clock program. For this to actually take effect at lease one person must be a supervisor. This will mean that an employee cannot punch the time card unless a supervisor presses [F5] from the POS program and then enters his PIN. The employee would then enter his PIN.

If the last supervisor quits, gets run over by a kid on a big wheel, or transported to an alternate universe then you will not be able to access the time clock. Well you could make a new employee use the same slot as a former supervisor, go to the "Employee setup" feature of the POSCONFG.EXE program and delete the old PIN for that slot. Then have the new employee enter a new PIN in the POS.EXE program to make him a supervisor. But that is a pain.

Transmit time cards
This feature will create a text file or data file of your time cards that can then be sent over the internet by either email or FTP file transfer to any destination you wish. ALL non-blank cards will be the file. Transmitting files requires an internet connection and Windows '95 or higher.

The file will be placed in a \SEND folder that will be a sub-folder to the folder that holds your 'Cash Register' program files. For example if your 'Cash Register' program files are in the folder C:\POS then the files to be transmitted will be in the folder C:\POS\SEND. If you also use the feature that transmits the 'Automatic Reports', all the files in the \SEND folder will be transmitted when the register is closed.

Unlike the automatic reports you must come here to create a file of time cards to transmit every time you wish to transmit cards.

The file name used for the transmit file will consist of the store ID, followed by the date of the file, followed by either .TXT or .CSV depending on the file type. If the store ID was 88-2138 and the time card file you wish to send was 20090328 then the file will be saved in the /SEND folder as either 88-213820090328.TXT (a text file) or 88-213820090328.CSV a comma delimited data file.

If you are not using the "Automatic Reports" transmit feature then you will have to transmit the files manually as an attachment to an email or using your own FTP software.

Delete time card
This feature will delete entire time card files. However you cannot delete the current file.

To delete a file highlight the file you want from the list and press [DELETE]. Then press [F1] to actually remove the file or [ESC] to cancel. Deleted files cannot be recovered.

NOTE: This program can only store 525 (10 years worth) of time card files. If you try to store more than that the program will crash.

Store # / Time display
In this feature you may enter a store ID for your store. This is useful if your store is part of a chain and you need to send the time cards or time clock file to your home office. By entering a store ID they can tell which is yours. Since the store ID will become part of the file name do not use characters in your store ID that cannot be used as part of a file name.

Store ID's are always 12 characters long. If you enter a store ID shorter than 12 characters then the will be preceded by the number of zeros required to make them 12 characters long.

By pressing [TAB] you can toggle between printing / saving to file the time stamps in a HOURS:MINUTES format (09:50 = 9 hours and 50 minutes) or a DECIMAL TIME format (09.50 = 9.5 hours).

If printing is set to 40 characters per line the time stamps will be printed without the "." or ":" separators to allow 8 of them to fit on one line. This means that 1252 could mean 12 hours and 52 minutes or 12.52 hours depending on how you set up displaying printed time stamps.

Here is where you may select Saturday or Sunday as the last day of the week. This should be the very first thing you do when using the "Time Clock" feature for the first time and then leave it alone if you can. Since the file name for each time clock file is derived from the last day of the week changing it will create a new file. For example if you were using Saturday as the last day of the week and the current file is 20090613.CLK and you change to Sunday, the current file will become 20090614.CLK, a totally different file. When the 20090614.CLK file is created data from the 20090613.CLK file will not be transferred over to the new file. This is one reason that when you change the "end of week" that you will automatically be returned to the "Cash Register" program and must re-enter the "Time Clock" program.


Previous page | Table of contents | Next page