'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
;dg=microsoft.public.pos
Reply to
Peter Johnson
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.
--
*
Get Secure! - www.microsoft.com/security
 Click to see the full signature
Reply to
Jeff
double sweet! thanks Jeff, an acknowledgement that it will get addressed AND a workaround.
Peter
formatting link
;dg=microsoft.public.pos > > >
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
;dg=microsoft.public.pos > > >
Reply to
timgale
This is a multi-part message in MIME format.
------=_NextPart_000_04C7_01C6F2C5.6164E880 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable
Tim,
Not using the code I sent.
The supplier's number is unique for that supplier only. Assume the same = Greenfield kickstand is sold by J&B, Trek, QBP, Giant, etc using the = same number (KS1), but that KS1 is unique to J&B, Trek or QBP for that = part, not for any other kickstand or part they sell.
If you're in the bicycle business, why aren't you using DRS' Bicycle = Bundle? As part of the bundle, it includes this exact function = (AutoGen). Also if you are a subscriber to Bike'alog, using their = JumpStart, also included in the bundle, allows for direct importing. =
formatting link

--=20 * Get Secure! -
formatting link

You must be using Outlook Express or some other type of newsgroup reader = to see and download the file attachment. If you are not using a reader, = follow the link below to setup Outlook Express. Click on "Open with = newsreader" under the MS Retail Management System on the right.
formatting link

**********
"timgale" wrote in message = news:
formatting link
Jeff: Could you make that into a TRIGGER? On INSERT of a new=20 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=20 script to update the Alias table.=20
BTW: What happens when 2 suppliers have the same SupplierReorderNumber = for=20 the same ItemLookupCode?=20 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=20 suppliers sell the same kickstand, and most call it 'KS-1')
Wouldn't the uniqueness be violated in the alias table?
Thanks, Tim
item.
| Query=20
Item)
''
reader to
reader, follow
newsreader"
message=20
search
in the
the
the "I
follow this
and then
formatting link
;dg=3Dmicro= soft.public.pos=20
------=_NextPart_000_04C7_01C6F2C5.6164E880 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
=EF=BB=BF
Tim,   Not using the code I sent.   The supplier's number is unique for that = supplier=20 only.  Assume the same Greenfield kickstand is sold by = J&B, Trek,=20 QBP, Giant, etc using the same number (KS1), but that KS1 is unique to = J&B,=20 Trek or QBP for that part, not for any other kickstand or part they=20 sell.     If you're in the bicycle business, why aren't = you using=20 DRS' Bicycle Bundle?  As part of the bundle, it includes this exact =
function (AutoGen).  Also if you are a subscriber to Bike'alog, = using their=20 JumpStart, also included in the bundle, allows for direct = importing. 
formatting link
-- *Get Secure! -
formatting link

  You must be using Outlook Express or some other type of newsgroup = reader=20 tosee and download the file attachment.  If you are not using a = reader,=20 followthe link below to setup Outlook Express.  Click on "Open = with=20 newsreader"under the MS Retail Management System on the right.  
formatting link
  **********
"timgale" < snipped-for-privacy@discussions.mic=
formatting link
;gt;=20
formatting link
Could you make that into a TRIGGER? On INSERT of a new=20 SupplierReorderNumber, insert a new entry in the alias=20
formatting link
purchasing guy makes new ILCs all day long = and would=20 use the 'alias feature' almost immediately. He wouldn't want to = wait for=20 me to run your script to update the Alias table. BTW: What = happens=20 when 2 suppliers have the same SupplierReorderNumber for the same=20 ItemLookupCode? ILC# MyItem1  -> vendorA ->=20 SupplierReorderNumber is Widget234ILC# MyItem1  -> vendorB = ->=20 SupplierReorderNumber is Widget234(This happens with many common = items in=20 the bicycle business. E.g., all my suppliers sell the same = kickstand, and=20 most call it 'KS-1')Wouldn't the uniqueness be violated in the = > = Peter,>=20 > It is scheduled, don't remember if 2.0 or 3.0.> = > For=20 now, a workaround is to put the re-order # as an Alias for the = item.>=20 > SO Admin | File | Connect | put in your password | Database | = Backup=20 | Query > | New | copy the following into the Query & press =
F5> > INSERT INTO Alias (Alias, ItemID) SELECT=20 SupplierList.ReorderNumber,> SupplierList.ItemID>  = FROM=20 SupplierList>  WHERE SupplierList.ReorderNumber NOT IN = (Select=20 ItemLookupCode from Item)>   AND = SupplierList.ReorderNumber=20 NOT IN (Select Alias from Alias)> > DELETE Alias WHERE = Alias IN=20 (SELECT Alias FROM Alias WHERE Alias <> ''> GROUP BY = Alias HAVING=20 COUNT(Alias) > 1)> > DELETE Alias WHERE Alias =3D = ''>=20 > > Close and do not save the query, unless you want to = use it=20 again.> -- > *> Get Secure! -
formatting link
>=20 > You must be using Outlook Express or some other type of = newsgroup=20 reader to> see and download the file attachment.  If you = are not=20 using a reader, follow> the link below to setup Outlook = Express. =20 Click on "Open with newsreader"> under the MS Retail Management = System=20 on the right.> >
formatting link
;gt; = >=20 **********> > "Peter Johnson" <PeterJohnson@discu=
formatting link
;gt;=20 wrote in message > news:923=
formatting link
;gt;=20 Please consider this for 2.0.> If a user can search for an item = by=20 Supplier, they should be able to search> by Supplier Reorder=20 Number.> > The need is obvious by how many ISV's have = created=20 software to fill in the> big hole.> > Peter=20 Johnson> American Retail Supply> >=20 ----------------> This post is a suggestion for Microsoft, and=20 Microsoft responds to the> suggestions with the most votes. To = vote for=20 this suggestion, click the "I> Agree" button in the message = pane. If=20 you do not see the button, follow this> link to open the = suggestion in=20 the Microsoft Web-based Newsreader and then> click "I Agree" in = the=20 message pane.> >
formatting link
;amp;dg=3Dmicrosoft.public.pos=20 > > >
------=_NextPart_000_04C7_01C6F2C5.6164E880--
Reply to
Jeff

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.