Laura D. Oliver
|
JFillmore, We too use serial #s in a way they weren't supposed to be used....But it works GREAT for us. Heres how: We rework, recover, fix, repair our customers' widgets. Over a yr period we might see the same widget 10-20 times. The cusomer has already named his widgets something like AZ01, AZ02, ...AZ87 etc. Everytime we do something to widget we use the customers number, add the inverted date, and then abbreviate the process. So when a customer calls and wants to know what we have done to AZ49....we just print the report which would look something like this: w# y/m/d process AZ49 20040113 grind AZ49 20040203 beari AZ49 20040228 grind AZ49 20040411 grind Az49 20040526 beari AZ49 20040730 grind We can tell the customer we ground it 4 times since January and put bearings on it twice. We are also able to print a neat concise for our customer. It also very easy to export to an EXCEL spreadsheet. As for editing serials #s, Idid it a few yrs back thru Maintain database, can't remember the file names though
|