How to handle hardware (bolts, nuts, etc.)

We run a Min/Max system for all hardware. Each item is in the part master and some are specified on the BOM, some are not. We created a compromise work around to eliminate needless inventory transactions as all of these items are expensed. For reference, we have approximately 1,000 individual parts in this system and they include fasteners, pneumatic fittings, electrical connectors and such. We even use this system for drill bits in our machine shop and shipping crates as well. We set each part up as follows and have been using the system without many issues for almost two years. We have been using Vantage for 4-1/2 years.

1) Create Prod Group and Part Class Min/Max and expense to G/L Account upon receipt.

2) Use a User Decimal field to establish the order quantity for each part and a custom Crystal report to print tags for each part.

3) Create card based system for re-order based on safety quantity in bin box. (These are in open stock on the assembly floor)

4) Each time a part is replenished the purchase quantity is bagged with the re-order tag inside. When bag is opened, tag goes to materials for purchasing. We review purchase frequency to insure that re-order quantity is correct based on current consumption.

5) Add a letter suffix (we use M) to base part number on purchase order so receipt transaction does not increase inventory. This will remove purchasing visibility from part tracker but the data is easily viewed in purchase order tracker. Parts are then matched to re-order tag in stockroom and processed as above.

6) We changed the type to "Mfg" on all of these parts with no operations. They are on the BOM as "Pull as Assembly" "View as Assembly". This way engineering can specify the exact item and quantity to be used without the job module creating any requirements to issue or purchase.

I hope this will give you a feel for how we solved this issue. Since we did this while on version 3.1, there may be better ways to prevent the job requirement and inventory transactions now than when we put the system in place. The biggest problem we had was re-training everyone to look on the "Mfg" side of part tracker for parts that should have been a type "Purch". This did not really cause too many problems and the benefits have more than made up for the liabilities.

Ford Garratt
Kinematic Automation, Inc.

-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, April 15, 2004 8:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to handle hardware (bolts, nuts, etc.)


Thanks for the info, Kim. It seems we are in about the same situation.

Is there anyone else out there who deals with hardware that has found a way that works well?

Eric L. Tyira
Software Engineer
Tamglass Tempering Systems, Inc.

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Kim Trapp [mailto:ktrapp@...]
Sent: Tuesday, April 13, 2004 9:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to handle hardware (bolts, nuts, etc.)

We do not use the MRP, but we do stock hardware and issue it to jobs. All hardware items are part masters for us. Standard ones are stocked with min order qty's and safety stock. Specials are marked as non-stock items and bought directly to the job. We also have an outside vendor stock the bins for us. We give him a printout of the items we want stocked and the min's. He gives us a list of what he stocked and we issue a PO.

We have the same ongoing discussions about whether it is worth tracking for the cost of the items. And we are in a similar industry. We make tooling, fixtures, and special machines. I guess our philosophy is we don't want to have the customer in for a tool tryout and find we can't run the tool, or make the modifications they want on the fly, because we ran out of some screws or nuts.


Kim Trapp
Hawk Technology Ltd

ver 5.1.131

-----Original Message-----
From: tiggle92869 [mailto:eric.tyira@...]
Sent: Monday, April 12, 2004 9:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to handle hardware (bolts, nuts, etc.)


Hey all.

We are running 5.2 and have an ongoing debate over how to handle
hardware. Some feel since we have an MRP, we should be using it to
control the hardware stocking and issuing since that is what it is
designed to do. Others feel it is too much hastle for the minimal
costs involved.

We currently have divided the hardware into 2 groups: standard and
special. The standard items are monitored and refilled by an outside
company who just sends us their invoice. The specials (Stainless,
Structural, etc.) items are handled as individual parts.

We are an OEM that manufactures industrial machinery.

Does anyone have a solution that works for them?

I'm sure this has been brought up in the past, but I am new to this
discussion group and didn't find anything in the search
for "hardware".

Thanks.



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


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



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
* 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 < http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]



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


* 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]
Hey all.

We are running 5.2 and have an ongoing debate over how to handle
hardware. Some feel since we have an MRP, we should be using it to
control the hardware stocking and issuing since that is what it is
designed to do. Others feel it is too much hastle for the minimal
costs involved.

We currently have divided the hardware into 2 groups: standard and
special. The standard items are monitored and refilled by an outside
company who just sends us their invoice. The specials (Stainless,
Structural, etc.) items are handled as individual parts.

We are an OEM that manufactures industrial machinery.

Does anyone have a solution that works for them?

I'm sure this has been brought up in the past, but I am new to this
discussion group and didn't find anything in the search
for "hardware".

Thanks.
We do not use the MRP, but we do stock hardware and issue it to jobs. All hardware items are part masters for us. Standard ones are stocked with min order qty's and safety stock. Specials are marked as non-stock items and bought directly to the job. We also have an outside vendor stock the bins for us. We give him a printout of the items we want stocked and the min's. He gives us a list of what he stocked and we issue a PO.

We have the same ongoing discussions about whether it is worth tracking for the cost of the items. And we are in a similar industry. We make tooling, fixtures, and special machines. I guess our philosophy is we don't want to have the customer in for a tool tryout and find we can't run the tool, or make the modifications they want on the fly, because we ran out of some screws or nuts.


Kim Trapp
Hawk Technology Ltd

ver 5.1.131

-----Original Message-----
From: tiggle92869 [mailto:eric.tyira@...]
Sent: Monday, April 12, 2004 9:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to handle hardware (bolts, nuts, etc.)


Hey all.

We are running 5.2 and have an ongoing debate over how to handle
hardware. Some feel since we have an MRP, we should be using it to
control the hardware stocking and issuing since that is what it is
designed to do. Others feel it is too much hastle for the minimal
costs involved.

We currently have divided the hardware into 2 groups: standard and
special. The standard items are monitored and refilled by an outside
company who just sends us their invoice. The specials (Stainless,
Structural, etc.) items are handled as individual parts.

We are an OEM that manufactures industrial machinery.

Does anyone have a solution that works for them?

I'm sure this has been brought up in the past, but I am new to this
discussion group and didn't find anything in the search
for "hardware".

Thanks.



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


* 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]
Thanks for the info, Kim. It seems we are in about the same situation.

Is there anyone else out there who deals with hardware that has found a way that works well?

Eric L. Tyira
Software Engineer
Tamglass Tempering Systems, Inc.

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Kim Trapp [mailto:ktrapp@...]
Sent: Tuesday, April 13, 2004 9:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to handle hardware (bolts, nuts, etc.)

We do not use the MRP, but we do stock hardware and issue it to jobs. All hardware items are part masters for us. Standard ones are stocked with min order qty's and safety stock. Specials are marked as non-stock items and bought directly to the job. We also have an outside vendor stock the bins for us. We give him a printout of the items we want stocked and the min's. He gives us a list of what he stocked and we issue a PO.

We have the same ongoing discussions about whether it is worth tracking for the cost of the items. And we are in a similar industry. We make tooling, fixtures, and special machines. I guess our philosophy is we don't want to have the customer in for a tool tryout and find we can't run the tool, or make the modifications they want on the fly, because we ran out of some screws or nuts.


Kim Trapp
Hawk Technology Ltd

ver 5.1.131

-----Original Message-----
From: tiggle92869 [mailto:eric.tyira@...]
Sent: Monday, April 12, 2004 9:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to handle hardware (bolts, nuts, etc.)


Hey all.

We are running 5.2 and have an ongoing debate over how to handle
hardware. Some feel since we have an MRP, we should be using it to
control the hardware stocking and issuing since that is what it is
designed to do. Others feel it is too much hastle for the minimal
costs involved.

We currently have divided the hardware into 2 groups: standard and
special. The standard items are monitored and refilled by an outside
company who just sends us their invoice. The specials (Stainless,
Structural, etc.) items are handled as individual parts.

We are an OEM that manufactures industrial machinery.

Does anyone have a solution that works for them?

I'm sure this has been brought up in the past, but I am new to this
discussion group and didn't find anything in the search
for "hardware".

Thanks.



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


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



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
* 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 <http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]