Can I create file with Item Lookup Codes in one column and Aliases in another and associate the two somehow?
I have looked at the Alias table and it's fairly straightforward--only three columns of data: ID, ItemID, Alias. I tried to see if EMS MS SQL Data Import would open the Alias table, but it won't. So if this is going to happen, it's going to have to be a series of queries. Can I append a text file to my Alias table with a Query? Could use something like this: INSERT into Alias (ID,ItemID,Alias) VALUES (from file)--where the 'from file' data is simply copied and pasted into the query?
I'm trying to get 2B-Inventory working with RMS for PO receiving and physical inventory. The 2B software seems to work fairly well--it's my suppliers that aren't cooperating...
My three primary appliance suppliers are Frigidaire, Maytag and Whirlpool. Appliances come in big boxes with big barcode labels that provide both model and serial numbers.
Frigidaire, most pleasantly, uses a barcode model number that is exactly the same as the model number in the catalog. Hooray!
Whirlpool adds a suffix to their model numbers, usually one or two digits. These extra characters probably indicate the factory or production run. I could, without too much trouble, change my Item Lookup Codes to reflect the barcodes, since the beginning of the number is more important for looking up items.
Maytag, OTOH, adds a single character prefix to their model numbers. A prefix is bad. My sales reps will never find that washer in the database if the model number starts with an X instead of a W.
Thanks, Tom