Changing from AVG cost system to STD cost system

Yahoo Archive
1
We have a quote to buy DMT. Can you share your list of steps, we are on Vantage  8.03.408B and are looking at doing the same thing the eventually going to 9..



Thanks,



James



----- Original Message -----


From: "Elizabeth" <gracefulthreads@...>
To: vantage@yahoogroups.com
Sent: Friday, May 25, 2012 1:30:24 PM
Subject: [Vantage] Re: Changing from AVG cost system to STD cost system

Â




Mike,

We're on 9.04, but the story is the same. I've created a 17-step checklist of all the things I have to do inside Epicor to make it come out properly. Loading in the costs is only 1 of the steps.

Oops... it's up to 19 steps (I just checked again).

Do you have the Data Migration Tool (DMT)? If not, it will be a nightmare.

As it is, once I get all the cost info from my CFO and he says to pull the switch, it's probably half a day's work (admittedly mostly watching the screen update).

I can be more specific if you'd like.

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com , Mike Abell <mabell@...> wrote:
>
> Thanks Vic, we are on Progress. I was just wondering if we were to change it at the Company level vs. the part level, what were the implications....I appreciate your help...
>
> Mike..
>
> From: vantage@yahoogroups.com <mailto: vantage@yahoogroups.com > [mailto: vantage@yahoogroups.com ] On Behalf Of Vic Drecchio
> Sent: Wednesday, May 23, 2012 11:27 AM
> To: vantage@yahoogroups.com <mailto: vantage@yahoogroups.com >
> Subject: RE: [Vantage] Changing from AVG cost system to STD cost system
>
>
>
> Mike, it may not be as easy as it seems.
>
> If you have any on-hand inventory that you want to switch costing methods,
> you must back them out of inventory, change the cost type, update costs and
> then put those items back into inventory. Depending on how many part
> numbers you're talking about, this could be a very long manual process.
>
> Others can comment on other potentail repercussions; I'm far from a costing
> expert. If you happen to be SQL and want to automate this, I've written
> some pretty intense scripts that [safely] automate this process. Contact me
> offline, if so.
>
> Good luck.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>] On Behalf Of
> flexial_ma
> Sent: Wednesday, May 23, 2012 12:23 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Changing from AVG cost system to STD cost system
>
> We have a new CFO and she wants to change our costing system from AVG to
> STD. If we "threw the switch", has anyone ever done this? We are on Vantage
> 8.03. What are the repercussions??? Thanks in Advance
>
> Mike...
>
> No virus found in this message.
> Checked by AVG - www.avg.com< http://www.avg.com >
> Version: 2012.0.2176 / Virus Database: 2425/5017 - Release Date: 05/23/12
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
2
We have a new CFO and she wants to change our costing system from AVG to STD. If we "threw the switch", has anyone ever done this? We are on Vantage 8.03. What are the repercussions??? Thanks in Advance

Mike...
3
Mike, it may not be as easy as it seems.



If you have any on-hand inventory that you want to switch costing methods,
you must back them out of inventory, change the cost type, update costs and
then put those items back into inventory. Depending on how many part
numbers you're talking about, this could be a very long manual process.



Others can comment on other potentail repercussions; I'm far from a costing
expert. If you happen to be SQL and want to automate this, I've written
some pretty intense scripts that [safely] automate this process. Contact me
offline, if so.



Good luck.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
flexial_ma
Sent: Wednesday, May 23, 2012 12:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Changing from AVG cost system to STD cost system





We have a new CFO and she wants to change our costing system from AVG to
STD. If we "threw the switch", has anyone ever done this? We are on Vantage
8.03. What are the repercussions??? Thanks in Advance

Mike...



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2176 / Virus Database: 2425/5017 - Release Date: 05/23/12



[Non-text portions of this message have been removed]
4
Thanks Vic, we are on Progress. I was just wondering if we were to change it at the Company level vs. the part level, what were the implications....I appreciate your help...

Mike..

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, May 23, 2012 11:27 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] Changing from AVG cost system to STD cost system



Mike, it may not be as easy as it seems.

If you have any on-hand inventory that you want to switch costing methods,
you must back them out of inventory, change the cost type, update costs and
then put those items back into inventory. Depending on how many part
numbers you're talking about, this could be a very long manual process.

Others can comment on other potentail repercussions; I'm far from a costing
expert. If you happen to be SQL and want to automate this, I've written
some pretty intense scripts that [safely] automate this process. Contact me
offline, if so.

Good luck.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
flexial_ma
Sent: Wednesday, May 23, 2012 12:23 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Changing from AVG cost system to STD cost system

We have a new CFO and she wants to change our costing system from AVG to
STD. If we "threw the switch", has anyone ever done this? We are on Vantage
8.03. What are the repercussions??? Thanks in Advance

Mike...

No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.2176 / Virus Database: 2425/5017 - Release Date: 05/23/12

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



[Non-text portions of this message have been removed]
5
Hi Mike: Just want to add little clarification. There isn't a way to "throw the switch" so to speak at the company level. The costing method is controlled by each individual part record. So as Vic said, if you have any parts on-hand you have to go through the process that Vic outlined.

From a process perspective, going to Std. costing means you need to make sure you are accurately maintaining all your MOM's. It is very important to make sure that your costing lot sizes are accurate. You will also need to verify that your labor and burden rates are as accurate as possible for each resource group. You will need to perform cost roll-ups on a regualar basis and as you add new parts a cost roll-up will need to be done to create the Std cost for that part. The cost roll-up process will determine the Std. cost of each part based on the MOM. You will need to determine whether you are going to mark components as "Pull as assembly" for the cost roll-up. The costing method also effects how the system determines your manufacturing variances when receiving parts to inventory. Are you using backflush and auto receive to inventory?

I am sure there are other considerations which others who are far more knowledgeable about inventory then me can shed some light on, but these should get you started.

HTH,
Virginia Joseph
Deep Hole Specialists
440-708-5239


--- In vantage@yahoogroups.com, Mike Abell <mabell@...> wrote:
>
> Thanks Vic, we are on Progress. I was just wondering if we were to change it at the Company level vs. the part level, what were the implications....I appreciate your help...
>
> Mike..
>
>
6
I was working with a client who wanted to change costing methods and, as it
would change their inventory costing basis, they had to get IRS permission
to do so. Might be something to look into.



As to changing the costing method at the Company level..all that will do is
change the default for new parts created. It has no effect on existing
parts. Vic is right that this can be a really long and drawn out process.



I'll second Vic's "Good Luck".





Claudia



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

We have done this about a year ago. Our approach wa to use a Service connect workflow that did quantity adjustments. We exported our stock status by WhseBin and ran it thru SC, zeroing out the inventory. We then ran a small SC workflow that changed the sot method from Avg to std and of course had already calculated std costs for everything. We then ran the inventory list back using the SC Workflow (but with a switch set to adjust in).

Worked well

Two issues:
Service Connect isn't the fastest so it takes some time
The workflow that we wrote didn't deal well with negative inventory quantities (that we had in a few places)
Service Connect didn't like processing a huge file so we had to brreak teh quantity adjust file into several pieces.
If you ahave any BPM's that are triggered by QtyAdj, you probably should disable them (We did)

And by writing a quiery of stock status, we could show that the "before" and "fter" quantities were identical
And all the cost differences went to the AdjQty .

For us it was an all night exercise but, in my opinion,and in our case well worth it as std cost is much preferable in many situations.
Carl Heeder

Carl Heeder
281-797-2200

[Non-text portions of this message have been removed]
8
We used DMT to do the QTY adjustments, and then change the cost methods, but we only had a few parts to change -
That is also an option if you don't have a Service Connect Guru...

--- In vantage@yahoogroups.com, "Carl Heeder" <carl.heeder@...> wrote:
>
> Mike,
>
> We have done this about a year ago. Our approach wa to use a Service connect workflow that did quantity adjustments. We exported our stock status by WhseBin and ran it thru SC, zeroing out the inventory. We then ran a small SC workflow that changed the sot method from Avg to std and of course had already calculated std costs for everything. We then ran the inventory list back using the SC Workflow (but with a switch set to adjust in).
>
> Worked well
>
> Two issues:
> Service Connect isn't the fastest so it takes some time
> The workflow that we wrote didn't deal well with negative inventory quantities (that we had in a few places)
> Service Connect didn't like processing a huge file so we had to brreak teh quantity adjust file into several pieces.
> If you ahave any BPM's that are triggered by QtyAdj, you probably should disable them (We did)
>
> And by writing a quiery of stock status, we could show that the "before" and "fter" quantities were identical
> And all the cost differences went to the AdjQty .
>
> For us it was an all night exercise but, in my opinion,and in our case well worth it as std cost is much preferable in many situations.
> Carl Heeder
>
> Carl Heeder
> 281-797-2200
>
> [Non-text portions of this message have been removed]
>
9
Mike,

We're on 9.04, but the story is the same. I've created a 17-step checklist of all the things I have to do inside Epicor to make it come out properly. Loading in the costs is only 1 of the steps.

Oops... it's up to 19 steps (I just checked again).

Do you have the Data Migration Tool (DMT)? If not, it will be a nightmare.

As it is, once I get all the cost info from my CFO and he says to pull the switch, it's probably half a day's work (admittedly mostly watching the screen update).

I can be more specific if you'd like.

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, Mike Abell <mabell@...> wrote:
>
> Thanks Vic, we are on Progress. I was just wondering if we were to change it at the Company level vs. the part level, what were the implications....I appreciate your help...
>
> Mike..
>
> From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
> Sent: Wednesday, May 23, 2012 11:27 AM
> To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
> Subject: RE: [Vantage] Changing from AVG cost system to STD cost system
>
>
>
> Mike, it may not be as easy as it seems.
>
> If you have any on-hand inventory that you want to switch costing methods,
> you must back them out of inventory, change the cost type, update costs and
> then put those items back into inventory. Depending on how many part
> numbers you're talking about, this could be a very long manual process.
>
> Others can comment on other potentail repercussions; I'm far from a costing
> expert. If you happen to be SQL and want to automate this, I've written
> some pretty intense scripts that [safely] automate this process. Contact me
> offline, if so.
>
> Good luck.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> flexial_ma
> Sent: Wednesday, May 23, 2012 12:23 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Changing from AVG cost system to STD cost system
>
> We have a new CFO and she wants to change our costing system from AVG to
> STD. If we "threw the switch", has anyone ever done this? We are on Vantage
> 8.03. What are the repercussions??? Thanks in Advance
>
> Mike...
>
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2012.0.2176 / Virus Database: 2425/5017 - Release Date: 05/23/12
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>