New part numbering schema

Yahoo Archive
1
Thanks so much for this great idea - I've been battling a similar situation
here for a LONNNNNGGGGG time...Can't believe this just never occurred to
me...

Lydia Coffman
Canyon Engineering Products
lcoffman@...


-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Thursday, September 09, 2004 1:02 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] New part numbering schema

Why not put the old part number information into the new part number's
description? That way the "it's worked like that for years" folks could do
a quick search for the part using the search field "part description
contains" and entering the old part number.

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Thursday, September 09, 2004 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] New part numbering schema



We are implementing 6.10 and have created a new part numbering
schema that defines the parts into part families and sub groups. We
would like an easy way to document the old part number in case there
is a need to find something quickly. (The new schema was designed
so this isn't necessary, but I need to have this feature as a backup
so the "it's worked like that for years" folks would by in.)

My initial idea was to create a memo for each part with the
appropriate old part number. We did the same with our customer and
vendor numbers without any problems, but we are much more likely to
use other memos with the parts. It would be nice to have the Memo
Button only changed to indicate a note if it was one of these
special notes. (With the original plan, all parts would indicate a
memo and the Memo Button would be more likely to be ignored.)

Another suggestion is to use the Substitutes feature and add all the
old numbers to the system. Ideally, the old parts would be set
to "inactive", but that removes them from the Substitues list.
Another option would be to put the old parts on Hold, but they will
continue to show up in the parts list (doubling the list).

A third idea would be use to use the VB Forms to capture the info.

Suggestions??? Success stories???


Mike Randolph
Purchasing Manager
American Magnetics, Inc.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
We are implementing 6.10 and have created a new part numbering
schema that defines the parts into part families and sub groups. We
would like an easy way to document the old part number in case there
is a need to find something quickly. (The new schema was designed
so this isn't necessary, but I need to have this feature as a backup
so the "it's worked like that for years" folks would by in.)

My initial idea was to create a memo for each part with the
appropriate old part number. We did the same with our customer and
vendor numbers without any problems, but we are much more likely to
use other memos with the parts. It would be nice to have the Memo
Button only changed to indicate a note if it was one of these
special notes. (With the original plan, all parts would indicate a
memo and the Memo Button would be more likely to be ignored.)

Another suggestion is to use the Substitutes feature and add all the
old numbers to the system. Ideally, the old parts would be set
to "inactive", but that removes them from the Substitues list.
Another option would be to put the old parts on Hold, but they will
continue to show up in the parts list (doubling the list).

A third idea would be use to use the VB Forms to capture the info.

Suggestions??? Success stories???


Mike Randolph
Purchasing Manager
American Magnetics, Inc.
3
Why not put the old part number information into the new part number's
description? That way the "it's worked like that for years" folks could do
a quick search for the part using the search field "part description
contains" and entering the old part number.

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Thursday, September 09, 2004 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] New part numbering schema



We are implementing 6.10 and have created a new part numbering
schema that defines the parts into part families and sub groups. We
would like an easy way to document the old part number in case there
is a need to find something quickly. (The new schema was designed
so this isn't necessary, but I need to have this feature as a backup
so the "it's worked like that for years" folks would by in.)

My initial idea was to create a memo for each part with the
appropriate old part number. We did the same with our customer and
vendor numbers without any problems, but we are much more likely to
use other memos with the parts. It would be nice to have the Memo
Button only changed to indicate a note if it was one of these
special notes. (With the original plan, all parts would indicate a
memo and the Memo Button would be more likely to be ignored.)

Another suggestion is to use the Substitutes feature and add all the
old numbers to the system. Ideally, the old parts would be set
to "inactive", but that removes them from the Substitues list.
Another option would be to put the old parts on Hold, but they will
continue to show up in the parts list (doubling the list).

A third idea would be use to use the VB Forms to capture the info.

Suggestions??? Success stories???


Mike Randolph
Purchasing Manager
American Magnetics, Inc.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
I think I would opt for VB Form field and with 6.1 Customization capability place the field directly on the main Part screen. Also, because the VB form fields are supposedly immune to trigger issues I might feel comfortable writing to it (via ODBC?) from some other application (MS-Access?) to populate it.

Another thought might be to put it at the end of the part description field inside something like square brackets which would make it easy enough to extract with string functions or to inhibit printing on things like invoices. Then the search description part of lookups might be of use.

-Todd C.

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Thursday, September 09, 2004 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] New part numbering schema



We are implementing 6.10 and have created a new part numbering
schema that defines the parts into part families and sub groups. We
would like an easy way to document the old part number in case there
is a need to find something quickly. (The new schema was designed
so this isn't necessary, but I need to have this feature as a backup
so the "it's worked like that for years" folks would by in.)

My initial idea was to create a memo for each part with the
appropriate old part number. We did the same with our customer and
vendor numbers without any problems, but we are much more likely to
use other memos with the parts. It would be nice to have the Memo
Button only changed to indicate a note if it was one of these
special notes. (With the original plan, all parts would indicate a
memo and the Memo Button would be more likely to be ignored.)

Another suggestion is to use the Substitutes feature and add all the
old numbers to the system. Ideally, the old parts would be set
to "inactive", but that removes them from the Substitues list.
Another option would be to put the old parts on Hold, but they will
continue to show up in the parts list (doubling the list).

A third idea would be use to use the VB Forms to capture the info.

Suggestions??? Success stories???


Mike Randolph
Purchasing Manager
American Magnetics, Inc.




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1292e9cv0/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1094846011/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=391135054>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
Do you have a lot of P/Ns that need to be changed?
The reason I am asking is that we have a lot of problem with generating
wrong P/N's and making them inactive and so on.
Finally I contacted Epicor Custom programming dept. on getting a custom
program that changes the old P/N with a new one. They are working on the
quote as of now. It's possible to do for sure. We chose to change one P/N at
a time, instead of a batch process.
This approach may help you too.

Mike Tonoyan / All American Products Co.
e-mail: miket@...


----- Original Message -----
From: "ami_miker" <michael.randolph@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, September 09, 2004 12:52 PM
Subject: [Vantage] New part numbering schema


>
> We are implementing 6.10 and have created a new part numbering
> schema that defines the parts into part families and sub groups. We
> would like an easy way to document the old part number in case there
> is a need to find something quickly. (The new schema was designed
> so this isn't necessary, but I need to have this feature as a backup
> so the "it's worked like that for years" folks would by in.)
>
> My initial idea was to create a memo for each part with the
> appropriate old part number. We did the same with our customer and
> vendor numbers without any problems, but we are much more likely to
> use other memos with the parts. It would be nice to have the Memo
> Button only changed to indicate a note if it was one of these
> special notes. (With the original plan, all parts would indicate a
> memo and the Memo Button would be more likely to be ignored.)
>
> Another suggestion is to use the Substitutes feature and add all the
> old numbers to the system. Ideally, the old parts would be set
> to "inactive", but that removes them from the Substitues list.
> Another option would be to put the old parts on Hold, but they will
> continue to show up in the parts list (doubling the list).
>
> A third idea would be use to use the VB Forms to capture the info.
>
> Suggestions??? Success stories???
>
>
> Mike Randolph
> Purchasing Manager
> American Magnetics, Inc.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
6
We put the old part numbers in the "search field". The search field
defaults to the begining of the description anyway so we wern't gaining
anything by leaving the description there. Now we have an option of
searching be part number (new), descrpition, and the search field which is
the old part number. Even if the entire part number does not fit, it gets
them close enough to scroll and find the correct part.

-----Original Message-----
From: ami_miker
To: vantage@yahoogroups.com
Sent: 9/9/04 2:52 PM
Subject: [Vantage] New part numbering schema


We are implementing 6.10 and have created a new part numbering
schema that defines the parts into part families and sub groups. We
would like an easy way to document the old part number in case there
is a need to find something quickly. (The new schema was designed
so this isn't necessary, but I need to have this feature as a backup
so the "it's worked like that for years" folks would by in.)

My initial idea was to create a memo for each part with the
appropriate old part number. We did the same with our customer and
vendor numbers without any problems, but we are much more likely to
use other memos with the parts. It would be nice to have the Memo
Button only changed to indicate a note if it was one of these
special notes. (With the original plan, all parts would indicate a
memo and the Memo Button would be more likely to be ignored.)

Another suggestion is to use the Substitutes feature and add all the
old numbers to the system. Ideally, the old parts would be set
to "inactive", but that removes them from the Substitues list.
Another option would be to put the old parts on Hold, but they will
continue to show up in the parts list (doubling the list).

A third idea would be use to use the VB Forms to capture the info.

Suggestions??? Success stories???


Mike Randolph
Purchasing Manager
American Magnetics, Inc.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links