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

Posted by Peter Johnson on April 19, 2006, 1:54 pm

Please log in for more thread options

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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=92313879-258f-4399-99c7-0875a2663cd9&dg=microsoft.public.pos

Posted by Jeff on April 19, 2006, 2:16 pm

Please log in for more thread options

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

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.

http://tinyurl.com/75bgz

**********

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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=92313879-258f-4399-99c7-0875a2663cd9&dg=microsoft.public.pos

Posted by Peter Johnson on April 19, 2006, 2:39 pm

Please log in for more thread options

double sweet!
thanks Jeff,
an acknowledgement that it will get addressed AND a workaround.

Peter

"Jeff" wrote:

> 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.

> | 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

> 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.

> http://tinyurl.com/75bgz

> **********

> 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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=92313879-258f-4399-99c7-0875a2663cd9&dg=microsoft.public.pos

Posted by timgale on October 18, 2006, 10:52 am

Please log in for more thread options

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

"Jeff" wrote:

> 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.

> | 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

> 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.

> http://tinyurl.com/75bgz

> **********

> 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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=92313879-258f-4399-99c7-0875a2663cd9&dg=microsoft.public.pos

Posted by Jeff on October 18, 2006, 5:54 pm

Please log in for more thread options

: 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. =
http://www.digitalretailer.com/rmsaddins/index.htm

--=20
*
Get Secure! - www.microsoft.com/security

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.

http://tinyurl.com/75bgz

**********

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

"Jeff" wrote:

> Peter,
>=20
> It is scheduled, don't remember if 2.0 or 3.0.
>=20
> For 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 =
| Query=20
> | New | copy the following into the Query & press F5
>=20
> 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)
>=20
> DELETE Alias WHERE Alias IN (SELECT Alias FROM Alias WHERE Alias <> =
''
> GROUP BY Alias HAVING COUNT(Alias) > 1)
>=20
> DELETE Alias WHERE Alias =3D ''
>=20
>=20
> Close and do not save the query, unless you want to use it again.
> --=20
> *
> Get Secure! - www.microsoft.com/security
>=20
> 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.
>=20
> http://tinyurl.com/75bgz
>=20
> **********
>=20
message=20
> 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.
>=20
> The need is obvious by how many ISV's have created software to fill =
in the
> big hole.
>=20
> Peter Johnson
> American Retail Supply
>=20
> ----------------
> 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.
>=20
> =
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser=
/en-us/default.mspx?mid=3D92313879-258f-4399-99c7-0875a2663cd9&dg=3Dmicro=
soft.public.pos=20
>=20
>=20
>
------=_NextPart_000_04C7_01C6F2C5.6164E880
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Tim,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Not using the code I sent.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>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.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>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.  <A=20
href=3D"http://www.digitalretailer.com/rmsaddins/index.htm">http://www.di=
gitalretailer.com/rmsaddins/index.htm</A></FONT></DIV>
<DIV><FONT color=3D#008000></FONT><FONT color=3D#008000></FONT><FONT=20
color=3D#008000></FONT><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"timgale" <<A=20
=
rosoft.com</A>>=20
wrote in message <A=20
=
038D2-11D8-48EA-9224-0E655665C0EB@microsoft.com</A>...</DIV>Jeff:=20
Could you make that into a TRIGGER? On INSERT of a new=20
<BR>SupplierReorderNumber, insert a new entry in the alias=20
table.........<BR><BR>My purchasing guy makes new ILCs all day long =
and would=20
use the 'alias <BR>feature' almost immediately. He wouldn't want to =
wait for=20
me to run your <BR>script to update the Alias table. <BR><BR>BTW: What =
happens=20
when 2 suppliers have the same SupplierReorderNumber for <BR>the same=20
ItemLookupCode? <BR>ILC# MyItem1  -> vendorA ->=20
SupplierReorderNumber is Widget234<BR>ILC# MyItem1  -> vendorB =
->=20
SupplierReorderNumber is Widget234<BR>(This happens with many common =
items in=20
the bicycle business. E.g., all my <BR>suppliers sell the same =
kickstand, and=20
most call it 'KS-1')<BR><BR>Wouldn't the uniqueness be violated in the =
alias=20
table?<BR><BR>Thanks,<BR>Tim<BR><BR>"Jeff" wrote:<BR><BR>> =
Peter,<BR>>=20
<BR>> It is scheduled, don't remember if 2.0 or 3.0.<BR>> =
<BR>> For=20
now, a workaround is to put the re-order # as an Alias for the =
item.<BR>>=20
<BR>> SO Admin | File | Connect | put in your password | Database | =
Backup=20
| Query <BR>> | New | copy the following into the Query & press =

F5<BR>> <BR>> INSERT INTO Alias (Alias, ItemID) SELECT=20
SupplierList.ReorderNumber,<BR>> SupplierList.ItemID<BR>>  =
FROM=20
SupplierList<BR>>  WHERE SupplierList.ReorderNumber NOT IN =
(Select=20
ItemLookupCode from Item)<BR>>   AND =
SupplierList.ReorderNumber=20
NOT IN (Select Alias from Alias)<BR>> <BR>> DELETE Alias WHERE =
Alias IN=20
(SELECT Alias FROM Alias WHERE Alias <> ''<BR>> GROUP BY =
Alias HAVING=20
COUNT(Alias) > 1)<BR>> <BR>> DELETE Alias WHERE Alias =3D =
''<BR>>=20
<BR>> <BR>> Close and do not save the query, unless you want to =
use it=20
again.<BR>> -- <BR>> *<BR>> Get Secure! - <A=20
=
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
<BR>>=20
<BR>> You must be using Outlook Express or some other type of =
newsgroup=20
reader to<BR>> see and download the file attachment.  If you =
are not=20
using a reader, follow<BR>> the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>> under the MS Retail Management =
System=20
on the right.<BR>> <BR>> <A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>> =
<BR>>=20
**********<BR>> <BR>> "Peter Johnson" <<A=20
=
ssions.microsoft.com</A>>=20
wrote in message <BR>> <A=20
=
13879-258F-4399-99C7-0875A2663CD9@microsoft.com</A>...<BR>>=20
Please consider this for 2.0.<BR>> If a user can search for an item =
by=20
Supplier, they should be able to search<BR>> by Supplier Reorder=20
Number.<BR>> <BR>> The need is obvious by how many ISV's have =
created=20
software to fill in the<BR>> big hole.<BR>> <BR>> Peter=20
Johnson<BR>> American Retail Supply<BR>> <BR>>=20
----------------<BR>> This post is a suggestion for Microsoft, and=20
Microsoft responds to the<BR>> suggestions with the most votes. To =
vote for=20
this suggestion, click the "I<BR>> Agree" button in the message =
pane. If=20
you do not see the button, follow this<BR>> link to open the =
suggestion in=20
the Microsoft Web-based Newsreader and then<BR>> click "I Agree" in =
the=20
message pane.<BR>> <BR>> <A=20
=
href=3D"http://www.microsoft.com/Businesssolutions/Community/NewsGroups/d=
gbrowser/en-us/default.mspx?mid=3D92313879-258f-4399-99c7-0875a2663cd9&am=
p;dg=3Dmicrosoft.public.pos">http://www.microsoft.com/Businesssolutions/C=
ommunity/NewsGroups/dgbrowser/en-us/default.mspx?mid=3D92313879-258f-4399=
-99c7-0875a2663cd9&dg=3Dmicrosoft.public.pos</A>=20
<BR>> <BR>> <BR>></BLOCKQUOTE></BODY></HTML>

------=