'Find Item' in RMS store & HQ needs Supplier Reorder Number

Peter,

It is scheduled, don't remember if 2.0 or 3.0.

For now, a workaround is to put the re-order # as an Alias for the item.

SO Admin | File | Connect | put in your password | Database | Backup | Query | New | copy the following into the Query & press F5

INSERT INTO Alias (Alias, ItemID) SELECT SupplierList.ReorderNumber, SupplierList.ItemID FROM SupplierList WHERE SupplierList.ReorderNumber NOT IN (Select ItemLookupCode from Item) AND SupplierList.ReorderNumber NOT IN (Select Alias from Alias)

DELETE Alias WHERE Alias IN (SELECT Alias FROM Alias WHERE Alias '' GROUP BY Alias HAVING COUNT(Alias) > 1)

DELETE Alias WHERE Alias = ''

Close and do not save the query, unless you want to use it again.

soft.public.pos > > >