13000 item stock table BETA test
Posted: Wed Mar 31, 2004 9:23 pm
As some of you already know I am currently working on increasing the limit of different items in the stock table to 13000 items.
About 1/3 of the project is done and I have some files that could use some beta testing while I continue the project. The links is at the bottom of this post.
I am also adding some other new features that I could use some testing and comment on.
To do some testing of this version you MUST create a new folder and copy your stock table files ending with the extensions ??????.TBL and ??????.IDX into the new folder. THIS VERSION WILL REWRITE YOUR STOCK TABLE MAKING IT UNREADABLE BY THE CURRENT VERSION OF THE POS PROGRAM. So it will be a really good thing if the stock table being reformatted is NOT the one you are using.
The files that you will be downloading are new versions of the POSCONFG.EXE, FILEINFO.EXE, CONVERT.EXE programs and STOCK TABLE.XLS Download the file to your new folder and unzip / extract the files.
Start by running the POSCONFG.EXE program and using the "Stock table" feature. The first time you do this the CONVERT program will be run and it will convert your stock table to the new format.
SO WHAT'S NEW?
The first thing you will notice in the "Stock table" feature is that you will be able to select the size of your stock table from 0 (no stock table) to 13000 items in increments of 1000. Go to where the item number is displayed and press [TAB] to change it. At any time in the future you may resize the stock table either larger or smaller however if you make it smaller you will erase any items in the lines that will be deleted. If you choose zero items the entire stock table will be erased.
Press [F4] to be able to edit the stock table. You may notice that the stock number has been increased to 14 digits to be ready for the new international 14 digit barcode standard that will be implimented in 2005. "Pieces sold" and "inventory" have been expanded to 3 decimal places. There is a new column for "Sale price." There are now 3 pages to enter your items on (press [TAB] to see them) and "Stock number" and "Description" are on each page although you can edit them only on the first page.
At the bottom of the screen it will tell you to press [F8] to do something with "Prices." You will be able to either backup a price column (either regular prices or sale prices), or save, load, or erase a column. This will allow you to create a file with new prices and store it. Then when it is time for the sale all you have to do is to load the new price file.
There are a couple of steps to do this. First backup your current prices. Now erase the current prices from the screen. Enter your new prices. Save the new prices. Now reload the the current prices from the backups. If you save the new price file with a date filename in this format YYYYMMDD then when you start the POS program on that morning the file will automatically be loaded. If a "sale price" file is loaded all current sale prices will be erased first. If a "regular price" file is loaded the regular prices will NOT be erased first. In the POS program during a purchase the sale price will always override the regular price unless the sale price is zero. This means that the sale price can even be higher than the regular price.
Have fun with your new toy however if you want to go places in the POSCONFG.EXE program other than the stock table you will have to copt the CF2.EXE program from your regular folder to this new folder.
Next up is working on the POS.EXE program so that you can use the new stock table to actually ring up sales. And last will be the "Reports" feature.
And now, the link. http://keyhut.com/beta.htm
About 1/3 of the project is done and I have some files that could use some beta testing while I continue the project. The links is at the bottom of this post.
I am also adding some other new features that I could use some testing and comment on.
To do some testing of this version you MUST create a new folder and copy your stock table files ending with the extensions ??????.TBL and ??????.IDX into the new folder. THIS VERSION WILL REWRITE YOUR STOCK TABLE MAKING IT UNREADABLE BY THE CURRENT VERSION OF THE POS PROGRAM. So it will be a really good thing if the stock table being reformatted is NOT the one you are using.
The files that you will be downloading are new versions of the POSCONFG.EXE, FILEINFO.EXE, CONVERT.EXE programs and STOCK TABLE.XLS Download the file to your new folder and unzip / extract the files.
Start by running the POSCONFG.EXE program and using the "Stock table" feature. The first time you do this the CONVERT program will be run and it will convert your stock table to the new format.
SO WHAT'S NEW?
The first thing you will notice in the "Stock table" feature is that you will be able to select the size of your stock table from 0 (no stock table) to 13000 items in increments of 1000. Go to where the item number is displayed and press [TAB] to change it. At any time in the future you may resize the stock table either larger or smaller however if you make it smaller you will erase any items in the lines that will be deleted. If you choose zero items the entire stock table will be erased.
Press [F4] to be able to edit the stock table. You may notice that the stock number has been increased to 14 digits to be ready for the new international 14 digit barcode standard that will be implimented in 2005. "Pieces sold" and "inventory" have been expanded to 3 decimal places. There is a new column for "Sale price." There are now 3 pages to enter your items on (press [TAB] to see them) and "Stock number" and "Description" are on each page although you can edit them only on the first page.
At the bottom of the screen it will tell you to press [F8] to do something with "Prices." You will be able to either backup a price column (either regular prices or sale prices), or save, load, or erase a column. This will allow you to create a file with new prices and store it. Then when it is time for the sale all you have to do is to load the new price file.
There are a couple of steps to do this. First backup your current prices. Now erase the current prices from the screen. Enter your new prices. Save the new prices. Now reload the the current prices from the backups. If you save the new price file with a date filename in this format YYYYMMDD then when you start the POS program on that morning the file will automatically be loaded. If a "sale price" file is loaded all current sale prices will be erased first. If a "regular price" file is loaded the regular prices will NOT be erased first. In the POS program during a purchase the sale price will always override the regular price unless the sale price is zero. This means that the sale price can even be higher than the regular price.
Have fun with your new toy however if you want to go places in the POSCONFG.EXE program other than the stock table you will have to copt the CF2.EXE program from your regular folder to this new folder.
Next up is working on the POS.EXE program so that you can use the new stock table to actually ring up sales. And last will be the "Reports" feature.
And now, the link. http://keyhut.com/beta.htm