Another nice feature of your solution is I don't need the first letter of the SKU to agree with the vendor name. In fact, one vendor was just acquired by another company, now their codes and name do NOT agree, and we have no intention of changing the SKUs. This solution circumvents that mess as well as the possibility that we might have two vendors with the same first letter in the future.
|