How to determine historical cost of a part

Yahoo Archive
1
Hi Tony,



Would you happen to have any examples of how you did this?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Friday, June 22, 2012 1:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to determine historical cost of a part





Thanks Tony.

Would you happen to have anything that you can share that shows how you did the calculations from day one?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Tony Hughes
Sent: Friday, June 22, 2012 12:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How to determine historical cost of a part

Joe,
I have done this with version 8.
I don't know how different parttran is from 8 to 9, or if there's anything that makes the chore easier, but just start at day one and calculate cost up to the day you define. I don't know of any other way to do it.
I think this is why the standard Stock Status report takes so long to run.
I have not had to do this with any lot costed parts, so I am not sure if that changes anything.

--- On Fri, 6/22/12, Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com> > wrote:

From: Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com> >
Subject: [Vantage] How to determine historical cost of a part
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Date: Friday, June 22, 2012, 1:16 PM

Hello,

I need to compare the cost of inventory as it was in 2011 to what it is

now.

Almost all of our parts have either FIFO or Lot FIFO as the cost method.

We are on Epicor 9.04.507A.

Is there a way to do this?

Off the top of my head, I can't see how I could do this without

processing PartTran records buy either taking today's cost and rolling

back any cost adjustments or taking the cost on day one of Epicor and

rolling forward all cost adjustments.

I'm hoping someone has already done this before and can shed some light

on how they did it. Fingers crossed. :)

Joe Rojas | Director of Information Technology | Mats Inc

dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

jrojas@... <mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

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

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

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

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












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


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



I need to compare the cost of inventory as it was in 2011 to what it is
now.

Almost all of our parts have either FIFO or Lot FIFO as the cost method.

We are on Epicor 9.04.507A.



Is there a way to do this?



Off the top of my head, I can't see how I could do this without
processing PartTran records buy either taking today's cost and rolling
back any cost adjustments or taking the cost on day one of Epicor and
rolling forward all cost adjustments.



I'm hoping someone has already done this before and can shed some light
on how they did it. Fingers crossed. :)










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
Joe,
I have done this with version 8.
I don't know how different parttran is from 8 to 9, or if there's anything that makes the chore easier, but just start at day one and calculate cost up to the day you define. I don't know of any other way to do it.
I think this is why the standard Stock Status report takes so long to run.
I have not had to do this with any lot costed parts, so I am not sure if that changes anything.




--- On Fri, 6/22/12, Joe Rojas <jrojas@...> wrote:

From: Joe Rojas <jrojas@...>
Subject: [Vantage] How to determine historical cost of a part
To: vantage@yahoogroups.com
Date: Friday, June 22, 2012, 1:16 PM
















Â









Hello,



I need to compare the cost of inventory as it was in 2011 to what it is

now.



Almost all of our parts have either FIFO or Lot FIFO as the cost method.



We are on Epicor 9.04.507A.



Is there a way to do this?



Off the top of my head, I can't see how I could do this without

processing PartTran records buy either taking today's cost and rolling

back any cost adjustments or taking the cost on day one of Epicor and

rolling forward all cost adjustments.



I'm hoping someone has already done this before and can shed some light

on how they did it. Fingers crossed. :)















Joe Rojas | Director of Information Technology | Mats Inc

dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring



This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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



























[Non-text portions of this message have been removed]
4
Thanks Tony.



Would you happen to have anything that you can share that shows how you did the calculations from day one?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tony Hughes
Sent: Friday, June 22, 2012 12:59 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How to determine historical cost of a part





Joe,
I have done this with version 8.
I don't know how different parttran is from 8 to 9, or if there's anything that makes the chore easier, but just start at day one and calculate cost up to the day you define. I don't know of any other way to do it.
I think this is why the standard Stock Status report takes so long to run.
I have not had to do this with any lot costed parts, so I am not sure if that changes anything.

--- On Fri, 6/22/12, Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> > wrote:

From: Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> >
Subject: [Vantage] How to determine historical cost of a part
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Friday, June 22, 2012, 1:16 PM



Hello,

I need to compare the cost of inventory as it was in 2011 to what it is

now.

Almost all of our parts have either FIFO or Lot FIFO as the cost method.

We are on Epicor 9.04.507A.

Is there a way to do this?

Off the top of my head, I can't see how I could do this without

processing PartTran records buy either taking today's cost and rolling

back any cost adjustments or taking the cost on day one of Epicor and

rolling forward all cost adjustments.

I'm hoping someone has already done this before and can shed some light

on how they did it. Fingers crossed. :)

Joe Rojas | Director of Information Technology | Mats Inc

dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

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

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












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


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