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

Please consider this for 2.0.
If a user can search for an item by Supplier, they should be able to search
by Supplier Reorder Number.
The need is obvious by how many ISV's have created software to fill in the
big hole.
Peter Johnson
American Retail Supply
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
formatting link
Reply to
Peter Johnson
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.
Reply to
double sweet! thanks Jeff, an acknowledgement that it will get addressed AND a workaround.
formatting link
Reply to
Peter Johnson
Jeff: Could you make that into a TRIGGER? On INSERT of a new SupplierReorderNumber, insert a new entry in the alias table.........
My purchasing guy makes new ILCs all day long and would use the 'alias feature' almost immediately. He wouldn't want to wait for me to run your script to update the Alias table.
BTW: What happens when 2 suppliers have the same SupplierReorderNumber for the same ItemLookupCode? ILC# MyItem1 -> vendorA -> SupplierReorderNumber is Widget234 ILC# MyItem1 -> vendorB -> SupplierReorderNumber is Widget234 (This happens with many common items in the bicycle business. E.g., all my suppliers sell the same kickstand, and most call it 'KS-1')
Wouldn't the uniqueness be violated in the alias table?
Thanks, Tim
formatting link
Reply to

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.