Hi,
I must start out by saying great little program you have here, does exactly what it says on the tin, and does it well. Got a few feature requests that would make it even better though, if theres a way of doing any of the below in the current version please let me know how).
1) The label/barcode printing idea is great, and works well when a barcode font is used, but currently is is quite limited being only single labels. My current project is to help out a company that sells very large items and its not ideal to have barcodes on each item. The shopstaff know the items there selling just by looking at them, so I want to use their knowledge alongside the barcode system. What would be fantastic is a section where you can print a selection of labels on one sheet, ie an index of barcodes with many items on it, so the staff can just scan the items of the index sheet. These could be manually seleted by the user, by category, entire, ect ect
2) For each item you have a quantity in stock and a reorder stock level, I couldn't find anywhere a report is generated to tell you what items are due to be reordered. So the request is for a report form that displays items that are currently below minimum stock levels. This will give you a quick and easy way to see items that need to be reorded, maybe on this form you could have supplier, supplier stock code, cost price and units needed. IF ITEMCODE(CURRENT_STOCK) < ITEMCODE(MINIMUM_STOCK) ADD TO REPORT
3) Moving on from number 2 this it could be made more advanced by adding form that cross checks sales history (editable) to current stock levels so you can do a report showing items based on sales history that will run out in the near future. IF SALES(LAST_7_DAYS) > ITEMCODE(CURRENT_STOCK) ADD TO REPORT
4) Better error trapping.I have had a few instances where data was entered outside out the database specified range, i.e. entering too many characters for a categories, and this gives an error and quits to destop. Is there any way these errors can be captured informing the user it is out of the specified range but letting the user reenter or just going back to the previous section.
5) Add a way to remove categories, customers, items, suppliers or at least have a hidden option so they can be globally turned on/off in config section. If the option is turned to hidden, then they will not be seen in PCTill/SCM. If this is not advisable due to audit history, how about a new table being formed, and deleted/hidden entries are moved to the new table so the audit history is still there, but the data is hidden from the main program. (I know you use the discontinued flag on items so they dont show up on certain reports, its a more advanced/extended idea from this)
Thanks for your time and keep up the fantastic work, it is appreachated!
Regards
Lee
Panther Computers