Rhonda,
You are absolutely correct in the assessment of the value of using the tools
that we purchased. We also assign part numbers to virtually everything in
our system (some 19,000+ discrete part numbers at present) for all the
reasons you listed. When we add an alpha character to the end of the part
number that is in the inventory master, it will sort in Purchase Order
Tracker right after the un-modified number. Since our buyer is the one who
is tracking the history, the loss of global (Part Tracker) visibility does
not cause us a problem.
We only use this "work around" for items that are expensed and consumed as
manufacturing supplies. These would include; fasteners, pneumatic fittings,
electrical connectors, wire and the like. The beauty of having the item in
the part master file is we still show the items on the BOM with a reference
on the assembly drawing. We set these up in the parts master as
"Type-Manufactured" even though they are 'purchased' and then we add them to
the BOM as an "ASM" without any operations. This way when we get details in
the job module, these items do not create any transactions yet the correct
items are referenced for our assembly group and for our customers spare
parts reference.
If we ever need a large quantity for a particular assembly, we add the part
in as a "MTL" on the BOM and then buy it to the job as we normally would for
most commercial items.
We are also working to establish a similar system for our office supplies.
We currently use the 'make up a part number and hope' process. Soon we will
have part numbers for supplies where the base number is in the part master
so we can attach a part class and the vendor information w/part number. When
we purchase it, we will modify the number with a letter so the part will not
have an inventory transaction to worry about. Our buyer can track purchasing
history, accounting does not have to do any adjustments and if I want to
know what kind of paper we use on our plotter, Part Tracker is available to
me for vendor information.
This works well for us although I would welcome other plans for
accommodating this scenario.
Ford
-----Original Message-----
From: Sherer, Rhonda [mailto:rhonda@...]
Sent: Monday, January 06, 2003 5:47 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: Handling of "NON-STOCK" items
Okay, I'm in purchasing, and have some thoughts on this. We use an
inventory
number for all shop supplies, office supplies, packing stuff, etc. These
are not usually "consumed" by the jobs, as BOM items. You get the computer
system to not only keep good records for you, but also a tool for others who
would come after you. I was hired after someone abruptly left the company,
and had to figure everything out, because they did not use the computer for
simple historic collection.
If you have your inventory # and make a change to it as you purchase, will
you not loose all the traceability? How then, is a person to evaluate
trends, to be sure they are getting all the company needs from its
suppliers? This is a pretty nice piece of software we use. It will do a
bunch of stuff for us that we can use as a tool to improve much of what we
do. But we also have to give it something with which to work that magic. I
say use the tool.
Don't get me wrong. I also "hot load" miscellaneous purchases, same as
James's "on-the-fly". It is a flexibility feature that is necessary. And
yes, accounting does have to adjust these items out of "stock". She
chooses to do it on a fairly regular basis.
Ford, if I'm wrong about the assumption I made, please let me know.
Just my two cents, as one who does the purchasing.
Rhonda Sherer
Reeder & Kline Machine Co.
--------------------------------
Message: 1
Date: Sat, 4 Jan 2003 20:01:52 -0700
From: "James Martin Jr." <jmartin@...>
Subject: RE: Handling of "NON-STOCK" items
Not sure if what we do would have much bearing for your situation, but, here
at ElectriTek, we don't set up expense items in the inventory master at all.
Rather, when we place a PO for packing material, misc computer stuff from
CDW or new system from Dell, we just make up a part number and description
on the fly (and use a vendor part number in the appropriate field on the
PO). Items are received when they come in against the PO issued and costs
are directed to the expense account code associated with the vendor (this
can be over-ridden if need be). What we must police carefully here is that
invoices for these items are matched to the receipt so accrued accounts
payable doesn't get messed up and expense items don't get doubled up.
We use Stock and Non-stock on inventory items more depending on whether the
part is built to stock (very few for us) or built to order (most parts for
us). Material items are stock or non-stock depending on if the part is
received to stock and then issued to job (most for us), or purchased
directly to job (something I can't seem to persuade operations to try).
Our method seems similar to Ford's explaination at Kinematic.
James Martin
ElectriTek, Inc.
-----Original Message-----
From: Ford Garratt [mailto:fgarratt@...]
Sent: Friday, January 03, 2003 6:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Handling of "NON-STOCK" items
Paul,
We use a different system for handling parts that are non-inventory items
but are still resident in our part master file. This transaction has no
relationship to stock or non-stock status in the part master. If you have a
part number in the item master that you wish to purchase and receive without
the quantity going into inventory simply modify the part number slightly in
the purchase order. We add an "M" to the part number which automatically
tells our receiving department to route the item to our rotating min/max
floor stock system. When the purchase order line is received in the
receiving module the part quantity does not go into inventory because the
part number does not match a part master file. For lack of a better term
there is a "La-La-Land" in the purchasing module that will allow you to buy
and receive an item that is neither received into inventory or purchased to
a job requirement. The purchase order module will then route the cost to the
G/L account attached to the part class assigned to the item within the
purchase order. This can be the class from the part master file or it may be
edited during purchasing. You can also just create the part record in the
purchase order module which will have the same result from an inventory and
G/L perspective. You of course loose the ability to use this part number on
BOM's and elsewhere.
Hope this helps more than it hurts,
Ford Garratt
Director of Operations
Kinematic Automation, Inc.
-----Original Message-----
From: Paul Pachniak [mailto:paul.pachniak@...]
Sent: Friday, January 03, 2003 2:41 PM
To: Vantage Group List (E-mail)
Subject: [Vantage] Handling of "NON-STOCK" items
We are looking at turning on the G/L interface for Inventory and I was
wondering how others users are handling the purchase of "NON-STOCK" items.
We currently have these parts (examples: boxes, maintenance supplies,
drills, etc.) set up in part master so that we can cut a PO for their
purchase, then we receive them so that we can match the receipt to the A/P
invoice for payment. We have the parts marked as NON-STOCK but that does
very little as you know.
To me NON-STOCK means that the items will be expensed when purchased, which
is what we do, but when they are received Vantage also puts the parts into
stock, which is where the problem lies. If I do a qty adj entry to clear
out the "NON-STOCK" items that don't belong in stock in the first place,
another entry is going to be made to DR. MFG. Variance and CR. Inventory,
which will cause me to make another entry to reverse it, because it is not
valid. It seems like a lot of trouble. This is something that is SO basic
I do not understand how it has not been handled already.
I have an enhancement request that covers this and was wondering what the
other users think about it. If you agree please call Epicor and ask to be
added to the enhancement.
I would appreciate any feedback.
Thanks!
Page ID 8089MPS
Issue:
The part master record for a part should have an extra button in addition to
nonstock, titled expense. So when the part is purcahsed and received, it
will not increase onhand qty and the transaction would be recorded as an
expense. It is to cumbersome right now to receive these items into a
nonnettable bin, which will still have qty building up in it.
Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 114)
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=241773.2725424.4169802.1925585/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=241773.2725424.4169802.1925585/D=egroupweb/S=17050071
http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_580
<http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_580>
2,FF.html> HGTV Dream Home Giveaway
<
http://us.adserver.yahoo.com/l?M=241773.2725424.4169802.1925585/D=egroupmai
<http://us.adserver.yahoo.com/l?M=241773.2725424.4169802.1925585/D=egroupmai
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/.>
< 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>
< 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>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <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/.
<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>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
This message including all attachments is the sole property of Electritek
Inc. The dissemination, distribution, use or copying of this message or or
attachments is strictly prohibited without the express written consent of
Electritek Inc.
________________________________________________________________________
________________________________________________________________________
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=234081.2821106.4184440.1925585/D=egroupweb/S=17050071
83:HM/A=1327986/R=0/*http://ad.doubleclick.net/clk;4870027;7586687;a?http://
www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>
<http://us.adserver.yahoo.com/l?M=234081.2821106.4184440.1925585/D=egroupmai
l/S=:HM/A=1327986/rand=245363903>
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>
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]
You are absolutely correct in the assessment of the value of using the tools
that we purchased. We also assign part numbers to virtually everything in
our system (some 19,000+ discrete part numbers at present) for all the
reasons you listed. When we add an alpha character to the end of the part
number that is in the inventory master, it will sort in Purchase Order
Tracker right after the un-modified number. Since our buyer is the one who
is tracking the history, the loss of global (Part Tracker) visibility does
not cause us a problem.
We only use this "work around" for items that are expensed and consumed as
manufacturing supplies. These would include; fasteners, pneumatic fittings,
electrical connectors, wire and the like. The beauty of having the item in
the part master file is we still show the items on the BOM with a reference
on the assembly drawing. We set these up in the parts master as
"Type-Manufactured" even though they are 'purchased' and then we add them to
the BOM as an "ASM" without any operations. This way when we get details in
the job module, these items do not create any transactions yet the correct
items are referenced for our assembly group and for our customers spare
parts reference.
If we ever need a large quantity for a particular assembly, we add the part
in as a "MTL" on the BOM and then buy it to the job as we normally would for
most commercial items.
We are also working to establish a similar system for our office supplies.
We currently use the 'make up a part number and hope' process. Soon we will
have part numbers for supplies where the base number is in the part master
so we can attach a part class and the vendor information w/part number. When
we purchase it, we will modify the number with a letter so the part will not
have an inventory transaction to worry about. Our buyer can track purchasing
history, accounting does not have to do any adjustments and if I want to
know what kind of paper we use on our plotter, Part Tracker is available to
me for vendor information.
This works well for us although I would welcome other plans for
accommodating this scenario.
Ford
-----Original Message-----
From: Sherer, Rhonda [mailto:rhonda@...]
Sent: Monday, January 06, 2003 5:47 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: Handling of "NON-STOCK" items
Okay, I'm in purchasing, and have some thoughts on this. We use an
inventory
number for all shop supplies, office supplies, packing stuff, etc. These
are not usually "consumed" by the jobs, as BOM items. You get the computer
system to not only keep good records for you, but also a tool for others who
would come after you. I was hired after someone abruptly left the company,
and had to figure everything out, because they did not use the computer for
simple historic collection.
If you have your inventory # and make a change to it as you purchase, will
you not loose all the traceability? How then, is a person to evaluate
trends, to be sure they are getting all the company needs from its
suppliers? This is a pretty nice piece of software we use. It will do a
bunch of stuff for us that we can use as a tool to improve much of what we
do. But we also have to give it something with which to work that magic. I
say use the tool.
Don't get me wrong. I also "hot load" miscellaneous purchases, same as
James's "on-the-fly". It is a flexibility feature that is necessary. And
yes, accounting does have to adjust these items out of "stock". She
chooses to do it on a fairly regular basis.
Ford, if I'm wrong about the assumption I made, please let me know.
Just my two cents, as one who does the purchasing.
Rhonda Sherer
Reeder & Kline Machine Co.
--------------------------------
Message: 1
Date: Sat, 4 Jan 2003 20:01:52 -0700
From: "James Martin Jr." <jmartin@...>
Subject: RE: Handling of "NON-STOCK" items
Not sure if what we do would have much bearing for your situation, but, here
at ElectriTek, we don't set up expense items in the inventory master at all.
Rather, when we place a PO for packing material, misc computer stuff from
CDW or new system from Dell, we just make up a part number and description
on the fly (and use a vendor part number in the appropriate field on the
PO). Items are received when they come in against the PO issued and costs
are directed to the expense account code associated with the vendor (this
can be over-ridden if need be). What we must police carefully here is that
invoices for these items are matched to the receipt so accrued accounts
payable doesn't get messed up and expense items don't get doubled up.
We use Stock and Non-stock on inventory items more depending on whether the
part is built to stock (very few for us) or built to order (most parts for
us). Material items are stock or non-stock depending on if the part is
received to stock and then issued to job (most for us), or purchased
directly to job (something I can't seem to persuade operations to try).
Our method seems similar to Ford's explaination at Kinematic.
James Martin
ElectriTek, Inc.
-----Original Message-----
From: Ford Garratt [mailto:fgarratt@...]
Sent: Friday, January 03, 2003 6:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Handling of "NON-STOCK" items
Paul,
We use a different system for handling parts that are non-inventory items
but are still resident in our part master file. This transaction has no
relationship to stock or non-stock status in the part master. If you have a
part number in the item master that you wish to purchase and receive without
the quantity going into inventory simply modify the part number slightly in
the purchase order. We add an "M" to the part number which automatically
tells our receiving department to route the item to our rotating min/max
floor stock system. When the purchase order line is received in the
receiving module the part quantity does not go into inventory because the
part number does not match a part master file. For lack of a better term
there is a "La-La-Land" in the purchasing module that will allow you to buy
and receive an item that is neither received into inventory or purchased to
a job requirement. The purchase order module will then route the cost to the
G/L account attached to the part class assigned to the item within the
purchase order. This can be the class from the part master file or it may be
edited during purchasing. You can also just create the part record in the
purchase order module which will have the same result from an inventory and
G/L perspective. You of course loose the ability to use this part number on
BOM's and elsewhere.
Hope this helps more than it hurts,
Ford Garratt
Director of Operations
Kinematic Automation, Inc.
-----Original Message-----
From: Paul Pachniak [mailto:paul.pachniak@...]
Sent: Friday, January 03, 2003 2:41 PM
To: Vantage Group List (E-mail)
Subject: [Vantage] Handling of "NON-STOCK" items
We are looking at turning on the G/L interface for Inventory and I was
wondering how others users are handling the purchase of "NON-STOCK" items.
We currently have these parts (examples: boxes, maintenance supplies,
drills, etc.) set up in part master so that we can cut a PO for their
purchase, then we receive them so that we can match the receipt to the A/P
invoice for payment. We have the parts marked as NON-STOCK but that does
very little as you know.
To me NON-STOCK means that the items will be expensed when purchased, which
is what we do, but when they are received Vantage also puts the parts into
stock, which is where the problem lies. If I do a qty adj entry to clear
out the "NON-STOCK" items that don't belong in stock in the first place,
another entry is going to be made to DR. MFG. Variance and CR. Inventory,
which will cause me to make another entry to reverse it, because it is not
valid. It seems like a lot of trouble. This is something that is SO basic
I do not understand how it has not been handled already.
I have an enhancement request that covers this and was wondering what the
other users think about it. If you agree please call Epicor and ask to be
added to the enhancement.
I would appreciate any feedback.
Thanks!
Page ID 8089MPS
Issue:
The part master record for a part should have an extra button in addition to
nonstock, titled expense. So when the part is purcahsed and received, it
will not increase onhand qty and the transaction would be recorded as an
expense. It is to cumbersome right now to receive these items into a
nonnettable bin, which will still have qty building up in it.
Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email: paul.pachniak@...
Phone: 1-262-252-4003 (ext 114)
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=241773.2725424.4169802.1925585/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=241773.2725424.4169802.1925585/D=egroupweb/S=17050071
>83:HM/A=1394044/R=0/*
http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_580
<http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_580>
2,FF.html> HGTV Dream Home Giveaway
<
http://us.adserver.yahoo.com/l?M=241773.2725424.4169802.1925585/D=egroupmai
<http://us.adserver.yahoo.com/l?M=241773.2725424.4169802.1925585/D=egroupmai
>l/S=:HM/A=1394044/rand=196945272>
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/.>
< 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>
< 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>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <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/.
<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>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
This message including all attachments is the sole property of Electritek
Inc. The dissemination, distribution, use or copying of this message or or
attachments is strictly prohibited without the express written consent of
Electritek Inc.
________________________________________________________________________
________________________________________________________________________
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=234081.2821106.4184440.1925585/D=egroupweb/S=17050071
83:HM/A=1327986/R=0/*http://ad.doubleclick.net/clk;4870027;7586687;a?http://
www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>
<http://us.adserver.yahoo.com/l?M=234081.2821106.4184440.1925585/D=egroupmai
l/S=:HM/A=1327986/rand=245363903>
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>
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]