How does one handle an item that has two different vendor item numbers for the same vendor?
Examples:
Cook Medical, Dilator, the Catalog Nbr is G01471, but the Product Nbr is JCD20.0-38-20.
Boston Scient, Stent, the Catalog Nbr is 38937-1225, but the Product Nbr is H7493893712250.
From a Purchasing standpoint, the item is ordered via the Catalog Nbr.
From a Nursing standpoint, the item is searched for via the Product Nbr.
I've been adding the second number the the Desc3 field, but that only seems to work half the time.
Has anyone out there found a better way to handle this issue, with both users finding their item?