MRO and Tooling Items in Epicor 9

Yahoo Archive
1
Rob, we are taking the same approach you are with the exception that we are not maintaining MRO inventory anywhere.

Brad Boes
Metalworks


--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> We went through similar discussions not too long ago, for the same purposes (like you we don't maintain these parts on a BOM so they aren't consumed by jobs). After much discussion we felt the benefits of having everything completely in vantage didn't outweigh the negatives (larger part master, additional inventory transactions etc). We ended up going with a hybrid approach, where we created purchase orders for MRO/supply items line by line as an 'other' type purchase so we could get visibility of when, who, and how much, but without all the inventory transaction overhead. We do of course receive the items in through receipt entry of course so the PO's close and we can be aware of vendor performance for on time delivery and open requirements. Inventory levels and MRO part master, as well as PO suggestions are maintained in a 3rd party database. We use service connect to make the 3rd party system transparent to Vantage by creating the PO's in vantage and reconciling receipts in Vantage to the other system.
>
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<http://www.dsmfg.com/>
> (Click the logo to view our site)<http://www.dsmfg.com/>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert
> Sent: Wednesday, November 30, 2011 7:07 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MRO and Tooling Items in Epicor 9
>
>
>
> We currently use an Access database constructed in house many years ago to keep track of MRO and tooling items for inventory and purchasing purposes. I would like to set up all the MRO items from the tool crib as parts in Epicor 9 so that we can better track and report on them, especially for historical reporting.
>
> Some people say this is a great idea, but the accounting department says that this should be in a separate system to keep it separate from our actual inventory. It seems like the best solution would be to put these items into Epicor as we create PO's for these items and our current system doesn't really allow for historical reporting on who we bought it from when and for how much. We would want to keep track of prices, inventory, prices, inventory transactions, etc... (similar to how inventory parts are kept track of in Epicor now).
>
> How is everybody else in a manufacturing environment handling these MRO parts in their system. I have looked at doing this in Epicor and it appears the only way to consume these parts is to do an ADJ-QTY for them as they are not used in jobs.
>
> Robert Nupp
>
>
>
> [Non-text portions of this message have been removed]
>
2
We currently use an Access database constructed in house many years ago to keep track of MRO and tooling items for inventory and purchasing purposes. I would like to set up all the MRO items from the tool crib as parts in Epicor 9 so that we can better track and report on them, especially for historical reporting.

Some people say this is a great idea, but the accounting department says that this should be in a separate system to keep it separate from our actual inventory. It seems like the best solution would be to put these items into Epicor as we create PO's for these items and our current system doesn't really allow for historical reporting on who we bought it from when and for how much. We would want to keep track of prices, inventory, prices, inventory transactions, etc... (similar to how inventory parts are kept track of in Epicor now).

How is everybody else in a manufacturing environment handling these MRO parts in their system. I have looked at doing this in Epicor and it appears the only way to consume these parts is to do an ADJ-QTY for them as they are not used in jobs.

Robert Nupp
3
We went through similar discussions not too long ago, for the same purposes (like you we don't maintain these parts on a BOM so they aren't consumed by jobs). After much discussion we felt the benefits of having everything completely in vantage didn't outweigh the negatives (larger part master, additional inventory transactions etc). We ended up going with a hybrid approach, where we created purchase orders for MRO/supply items line by line as an 'other' type purchase so we could get visibility of when, who, and how much, but without all the inventory transaction overhead. We do of course receive the items in through receipt entry of course so the PO's close and we can be aware of vendor performance for on time delivery and open requirements. Inventory levels and MRO part master, as well as PO suggestions are maintained in a 3rd party database. We use service connect to make the 3rd party system transparent to Vantage by creating the PO's in vantage and reconciling receipts in Vantage to the other system.


Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert
Sent: Wednesday, November 30, 2011 7:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MRO and Tooling Items in Epicor 9



We currently use an Access database constructed in house many years ago to keep track of MRO and tooling items for inventory and purchasing purposes. I would like to set up all the MRO items from the tool crib as parts in Epicor 9 so that we can better track and report on them, especially for historical reporting.

Some people say this is a great idea, but the accounting department says that this should be in a separate system to keep it separate from our actual inventory. It seems like the best solution would be to put these items into Epicor as we create PO's for these items and our current system doesn't really allow for historical reporting on who we bought it from when and for how much. We would want to keep track of prices, inventory, prices, inventory transactions, etc... (similar to how inventory parts are kept track of in Epicor now).

How is everybody else in a manufacturing environment handling these MRO parts in their system. I have looked at doing this in Epicor and it appears the only way to consume these parts is to do an ADJ-QTY for them as they are not used in jobs.

Robert Nupp



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