Thanks all for your responses. It certainly has given me better
direction and strengthens my position for when I am asked why we did
what we did :o)
Matt
direction and strengthens my position for when I am asked why we did
what we did :o)
Matt
--- In vantage@yahoogroups.com, "Sherer, Rhonda" <rhonda@r...> wrote:
> We have done the same here. I inherited the numbering system, but
it works
> so I have no desire to change it.
> Purchasing holds the key, no one else can create a number, if
engineering
> needs one they ask purchasing.
> We use a six digit number, the category being represented by the
first 2
> digits. The description is descriptive of the item and the vendor
number is
> in the appropriate field as well. This allows the search feature
to be a
> real aid.
> 010000 - 019999 is miscellaneous
> 020000 - 029999 is something else, Drills, Endmills, Inserts,
Chemicals,
> office supplies all have a different group.
> etc.
> We don't use very much hardware except for machines and
maintenance. I have
> a generic Hardware number in the system for those purchases.
>
> Purchased material for production has a completely different
system. It
> relates to the manufactured part, which is customer specific.
> XXXX-YYY-M01 This is something the shop would modify or use as a
raw
> material for the jobs.
> In one case we had an unusual job where we bought parts to help
assemble a
> larger machine, this isn't our usual operation, and we want to
segregate
> these from the general hardware population. So a new 800000
series was
> created, and these items located in a place of their own.
>
> Maybe this will help.
> Rhonda
>
> -----Original Message-----
> From: Sims, Shawn [mailto:ssims@h...]
> Sent: Monday, April 25, 2005 8:11 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Vendor Part number vs. Created part Number
>
>
> I have always felt very strongly as a purchasing manager and an
inventory
> manager to set up your own part number. I went so far as to
create a part
> numbering system using a consistent logical alpha and numeric
structure that
> would identify the physical characteristics of the items being
numbered.
> This method greatly enhances the end user's ability to locate
parts in your
> database and prevents items from being duplicated. I would also
include in
> your argument that if you develop Bills Of Materials, you will not
have to
> continually change the part numbers of your BOM if your vendors or
vendor
> part numbers change over time. By the way I have been fighting
this issue
> for 10 years. Good luck.
>
>
> Shawn Sims
> Business Applications Manager
> Hydromat Inc.
> 314-432-0070 x4646
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Jim Feetterer
> Sent: Monday, April 25, 2005 7:56 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Vendor Part number vs. Created part Number
>
>
>
> Hello,
>
> Generally you want to set up your own part number as this will
help with
> tracking sales/history and allows you to control the part number.
>
> Jf
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of msgvantage
> Sent: Monday, April 25, 2005 7:25 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vendor Part number vs. Created part Number
>
>
>
> Hello all,
>
> During the course of setting up a new system, we have come across
an
> issue which has people on two sides of the fence.
>
> We have quite a few vendors and quite a few parts we purchase from
> these vendors. Up until now, everything has been maintained on
> spreadsheets. Purchasing just used the vendor part number as
_the_
> part number.
>
> It is my opinion (as a DB programmer) that we create our own part
> number for each part within Vantage, and put the vendor part
number...
> in the vendor part number field!
>
> My reasoning is:
> 1. There are too many different formats for part numbers
among
> the vendors (159; DX89992-01; 00-223394-21-33451AXC112)
> 2. There is a possibility of having more than one part number
> for two different parts for two different vendors. Ie. Bob's
Kiwi's
> Small Kiwi bird is part 234; Sam's Large brown egg is part 234
> also. (We don't really deal in birds :o)
>
> Now my question... How do others do this? Vendor or Personal
part
> Number?
>
> If Personal Part number, what happens when someone adds a new
part?
> How does the purchasing person determine what part number to give
it?
>
> If Vendor part, have you had many issues doing this? How do you
> handle the 20 character limitation Vantage 6.1 has for part
numbers?
>
> I have opened a ticket with tech support because we have a number
of
> part numbers (vendors) which are more than 20 characters long. No
> response as of yet.
>
> Thanks!
>
> Matt
>
>
>
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <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]