Hi there -
We manufacture hundreds of different but very similar products for distribution. Our issue is that 3 of our largest customers require we use their item codes which have a completely different nomenclature than our own. When we receive a purchase order from one of these customers it won't reference our part # but instead only will reference theirs. Without duplicating our item with the customers item code, our sales staff would be forced to look up each line on the order. We've been force to duplicate our own item codes 2, 3 sometimes 4 times in our system to accommodate them. Where it gets even trickier is that we also sell a repackaged brand, like Costco's Kirkland products, of our same exact product but packaged differently to display the customers brand.
We've been doing this for a long time but with all of these duplicates our database is getting large and unorganized. Ideally I would like our sales staff to be able to enter in any item code received from any of these customers and it be linked to our standard product. (Example: if our itemcode is DESK010-BLACK, and our customer sends us a PO for item 9888222709 and another send us a PO for the same item but with code BLACK-DESK11122, we'd like it to just link to our DESK010-BLACK item) Thus getting rid of all the duplicates. I'd have no problem revising the reports to reflect an alias item but I don't know if what I am looking for is actually possible with Sage 100. Any thoughts? I appreciate any insight.