# Changing Costing Methods
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-01-12 08:46 UTC
**Views:** 838
**Replies:** 9
**URL:** https://www.epiusers.help/t/changing-costing-methods/1905
---
## Post #1 by @system
Inquire about the Vantage Tool called Master File Import/Export/Copy Utility from Custom Programming. It will allow you to export the Part Master File and open it as an xls file, so that you can use the replace function to mass-change "A" with "S". You can then use the utility to import the modified file back.
Our consultant wrote us a lengthy email detailing this and other methods, and the pro's and con's of each method. (The above method does not leave an audit trail.) For more information, contact Ann Bollmeier at
abollmeier@...
----- Original Message -----
From: Denise Brown
To: vantage@egroups.com
Sent: Wednesday, January 10, 2001 9:10 AM
Subject: [Vantage] Changing Costing Methods
We're running Vantage 4.0, and currently have our purchased parts set
up using Average costing and everything else is set to Standard
costing. We want to change to using Standard for everything. I'm
told that to accomplish this, we'll need to go into each part
individually that we want to change, and zero out the quantities,
change the costing method, and then add the quantity back in. Does
anyone know of an easier way to do this?
Thanks!
Denise Brown
eGroups Sponsor
Click here for Business information
We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
[Non-text portions of this message have been removed]
We're running Vantage 4.0, and currently have our purchased parts set
up using Average costing and everything else is set to Standard
costing. We want to change to using Standard for everything. I'm
told that to accomplish this, we'll need to go into each part
individually that we want to change, and zero out the quantities,
change the costing method, and then add the quantity back in. Does
anyone know of an easier way to do this?
Thanks!
Denise Brown
---
## Post #3 by @system
Epicor told us there was a utility that could be run to solve this.
However due to its complexity they suggested booking a days consultancy,
So yes there is another method but what's most important to you time or
money!?
Sophie
> -----Original Message-----
> From: Denise Brown [SMTP:dbrown@...]
> Sent: 10 January 2001 14:11
> To: vantage@egroups.com
> Subject: [Vantage] Changing Costing Methods
>
> We're running Vantage 4.0, and currently have our purchased parts set
> up using Average costing and everything else is set to Standard
> costing. We want to change to using Standard for everything. I'm
> told that to accomplish this, we'll need to go into each part
> individually that we want to change, and zero out the quantities,
> change the costing method, and then add the quantity back in. Does
> anyone know of an easier way to do this?Â
> Thanks!
> Denise Brown
>
>
>
> eGroups Sponsor
>
> Click here for Business informationClick here for Business information
> <http://rd.yahoo.com/M=155181.1283799.2880018.2/D=egroupmail/S=1700007
> 183:N/A=527834/*http://ad.doubleclick.net/clk;2178697;5122774;t?http:/
> /www.business.com/>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:Â
> <http://www.egroups.com/files/vantage/>
> (Note:Â If this link does not work for you the first time you try it,
> go to www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>
Do you know what utility it is? Is it something we already have or
can download? When I called, they told me my only solution was to
get a quote from custom programming. Wouldn't be the first time I
heard different answers from different techs though!
Denise
--- In vantage@egroups.com, Jill Seath <JillSeath@w...> wrote:
> Epicor told us there was a utility that could be run to solve this.
> However due to its complexity they suggested booking a days
consultancy,
> So yes there is another method but what's most important to you
time or
> money!?
>
> Sophie
>
> > -----Original Message-----
> > From: Denise Brown [SMTP:dbrown@f...]
> > Sent: 10 January 2001 14:11
> > To: vantage@egroups.com
> > Subject: [Vantage] Changing Costing Methods
> >
> > We're running Vantage 4.0, and currently have our purchased parts
set
> > up using Average costing and everything else is set to Standard
> > costing. We want to change to using Standard for
everything.Â
I'm
> > told that to accomplish this, we'll need to go into each part
> > individually that we want to change, and zero out the quantities,
> > change the costing method, and then add the quantity back in.Â
Does
> > anyone know of an easier way to do this?Â
> > Thanks!
> > Denise Brown
> >
> >
> >
> > eGroups Sponsor
> >
> > Click here for Business informationClick here for Business
information
> >
<http://rd.yahoo.com/M=155181.1283799.2880018.2/D=egroupmail/S=1700007
> >
183:N/A=527834/*http://ad.doubleclick.net/clk;2178697;5122774;t?http:/
> > /www.business.com/>
> >
> > We no longer allow attachments to files. To access/share
Report
> > Files, please go to the following link:Â
> > <http://www.egroups.com/files/vantage/>
> > (Note:Â If this link does not work for you the first time you
try
it,
> > go to www.egroups.com, login and be sure to save your password,
choose
> > My Groups, choose Vantage, then choose Files. If you save the
> > password, the link above will work the next time you try it.)
> >
Denise,
I'll give our consultant a call and get back to you.
Sophie
> -----Original Message-----
> From: Denise Brown [SMTP:dbrown@...]
> Sent: 10 January 2001 14:47
> To: vantage@egroups.com
> Subject: [Vantage] Re: Changing Costing Methods
>
> Do you know what utility it is? Is it something we already have or
> can download? When I called, they told me my only solution was to
> get a quote from custom programming. Wouldn't be the first time I
> heard different answers from different techs though!
> Denise
>
> --- In vantage@egroups.com, Jill Seath <JillSeath@w...> wrote:
> > Epicor told us there was a utility that could be run to solve this.
> > However due to its complexity they suggested booking a days
> consultancy,
> > So yes there is another method but what's most important to you
> time or
> > money!?
> >
> > Sophie
> >
> > > -----Original Message-----
> > > From:Â Â Â Â Â Denise Brown [SMTP:dbrown@f...]
> > > Sent:Â Â Â Â Â 10 January 2001 14:11
> > > To:Â Â Â Â Â vantage@egroups.com
> > > Subject:Â Â Â Â Â [Vantage] Changing Costing Methods
> > >
> > > We're running Vantage 4.0, and currently have our purchased parts
> set
> > > up using Average costing and everything else is set to Standard
> > > costing. We want to change to using Standard for
> everything.Â
> I'm
> > > told that to accomplish this, we'll need to go into each part
> > > individually that we want to change, and zero out the quantities,
> > > change the costing method, and then add the quantity back in.Â
> Does
> > > anyone know of an easier way to do this?Â
> > > Thanks!
> > > Denise Brown
> > >
> > >
> > >
> > > eGroups Sponsor    Â
> > >
> > > Click here for Business informationClick here for Business
> information
> > >
> <
> <http://rd.yahoo.com/M=155181.1283799.2880018.2/D=egroupmail/S=1700007
> >
> > >
> 183:N/A=527834/*
> <http://ad.doubleclick.net/clk;2178697;5122774;t?http:/>
> > > /www.business.com/>Â Â Â Â Â
> > >
> > > We no longer allow attachments to files. To access/share
> Report
> > > Files, please go to the following link:Â
> > > < <http://www.egroups.com/files/vantage/>>
> > > (Note:Â If this link does not work for you the first time you
> try
> it,
> > > go to www.egroups.com, login and be sure to save your password,
> choose
> > > My Groups, choose Vantage, then choose Files. If you save the
> > > password, the link above will work the next time you try it.)
> > >
>
>
>
> eGroups Sponsor
>
> Click here to Win a 2001 Acura MDXClick here to Win a 2001 Acura MDX
> <http://rd.yahoo.com/M=155181.1283799.2880018.2/D=egroupmail/S=1700007
> 183:N/A=548475/*http://ad.doubleclick.net/clk;2267767;5122774;q?http:/
> /www.business.com/challenge>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:Â
> <http://www.egroups.com/files/vantage/>
> (Note:Â If this link does not work for you the first time you try it,
> go to www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>
Go to the Advanced Bill of Materials- General Operations- Standard Cost
Replace. Be sure to have Standard Cost in Purchased Parts.
The Cost information is taken from the Bill of Materials and the
Router(Operations). This only for Manufactured Parts. You have the Chose
of a Mass Cost Replacement or a individual Part. This will allow you look
at the Cost Rolls before actual replacement.
I would not recommend a mass Cost Replacement- Unless you sure all Cost
information on Labor Routers and Bill of Materials is Correct.
I hope this helps
Jamie Harrington -
jharrington@...
-----Original Message-----
From: Denise Brown [mailto:
dbrown@...]
Sent: Wednesday, January 10, 2001 6:11 AM
To:
vantage@egroups.com
Subject: [Vantage] Changing Costing Methods
We're running Vantage 4.0, and currently have our purchased parts set
up using Average costing and everything else is set to Standard
costing. We want to change to using Standard for everything. I'm
told that to accomplish this, we'll need to go into each part
individually that we want to change, and zero out the quantities,
change the costing method, and then add the quantity back in. Does
anyone know of an easier way to do this?
Thanks!
Denise Brown
We no longer allow attachments to files. To access/share Report Files,
please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Denise:
That's the way I was told we would have to do it also.
Lydia
We want to change to using Standard for everything. I'm told that to
accomplish this, we'll need to go into each part individually that we want
to change, and zero out the quantities, change the costing method, and then
add the quantity back in. Does anyone know of an easier way to do this?
Thanks!
Denise Brown
---
## Post #8 by @system
I'm only exporting a list of our purchased part numbers - the macro will
then read this list and type in the key-strokes to change the costing
method field in Vantage (part file maintenance) - there is no import
required. I'm just trying to automate the process of going through every
part one by one.
Nigel.
> -----Original Message-----
> From: vantage@egroups.com [SMTP:vantage@egroups.com]
> Sent: 10 January 2001 19:12
> To: vantage@egroups.com
> Subject: [Vantage] Digest Number 1100
>
> Date: Wed, 10 Jan 2001 18:33:57 -0000
> From: "Denise Brown" <dbrown@...>
> Subject: Re: FW: Chainging Costing Methods
>
> Nigel,
>
> But how will you get the data back in to Vantage? I didn't think
> there was an import?
>
> Denise
>
> --- In vantage@egroups.com, Nigel Roberts <nigelr@m...> wrote:
> >
> > Almost forgot - the problem with changing the costing method for a
> part
> > of course is that there has to be zero on-hand quantity - luckily
> we can
> > cope with this as we're implementing inventory at this time also.
> >
> > > -----Original Message-----
> > > From: Nigel Roberts
> > > Sent: 10 January 2001 16:48
> > > To: 'Vantage User List (US)'
> > > Subject: Chainging Costing Methods
> > >
> > >
> > >
> > > I'm currently trying to do this by exporting a report of part
> numbers
> > > which now use average costing (for instance) and then using Macro
> > > Express to run through these parts and change the costing method
> to
> > > standard. I'm not entirely sure it's going to be a robust
> solution but
> > > at least it's only needed once!
> > >
> > > Nigel Roberts
> > > MC Sheet Metal
> > > Wales, UK
> > >
> > >
> > > -----Original Message-----
> > > Date: Wed, 10 Jan 2001 14:10:55 -0000
> > > From: "Denise Brown" <dbrown@f...>
> > > Subject: Changing Costing Methods
> > >
> > > We're running Vantage 4.0, and currently have our purchased parts
> set
> > > up using Average costing and everything else is set to Standard
> > > costing. We want to change to using Standard for everything.
> I'm
> > > told that to accomplish this, we'll need to go into each part
> > > individually that we want to change, and zero out the quantities,
> > > change the costing method, and then add the quantity back in.
> Does
> > > anyone know of an easier way to do this?
> > > Thanks!
> > > Denise Brown
> > >
>
I used a similar process to change a bunch of parts that had (accidentally) multiple active Rev's. I did the export via a Crystal report so that I could filter out parts that didn't need to be changed. When I had an accurate list of part numbers (there were hundreds), I put these part numbers in a text file and used the macro that is on onelist right now to pick each part, and do the appropriate keyboard and/or mouse clicks to change the revs to the current rev.
I actually think changing from Standard to Average would be a bit simpler because of the screens to do so are a bit less complicated.
The above process, according to my calculations, took about 4 hours as compared to an estimated three days doing each one by hand.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Nigel Roberts
To: 'vantage@egroups.com'
Sent: Thursday, January 11, 2001 12:36 AM
Subject: RE: [Vantage] Changing Costing Methods
I'm only exporting a list of our purchased part numbers - the macro will
then read this list and type in the key-strokes to change the costing
method field in Vantage (part file maintenance) - there is no import
required. I'm just trying to automate the process of going through every
part one by one.
Nigel.
> -----Original Message-----
> From: vantage@egroups.com [SMTP:vantage@egroups.com]
> Sent: 10 January 2001 19:12
> To: vantage@egroups.com
> Subject: [Vantage] Digest Number 1100
>
> Date: Wed, 10 Jan 2001 18:33:57 -0000
> From: "Denise Brown" <dbrown@...>
> Subject: Re: FW: Chainging Costing Methods
>
> Nigel,
>
> But how will you get the data back in to Vantage? I didn't think
> there was an import?
>
> Denise
>
> --- In vantage@egroups.com, Nigel Roberts <nigelr@m...> wrote:
> >
> > Almost forgot - the problem with changing the costing method for a
> part
> > of course is that there has to be zero on-hand quantity - luckily
> we can
> > cope with this as we're implementing inventory at this time also.
> >
> > > -----Original Message-----
> > > From: Nigel Roberts
> > > Sent: 10 January 2001 16:48
> > > To: 'Vantage User List (US)'
> > > Subject: Chainging Costing Methods
> > >
> > >
> > >
> > > I'm currently trying to do this by exporting a report of part
> numbers
> > > which now use average costing (for instance) and then using Macro
> > > Express to run through these parts and change the costing method
> to
> > > standard. I'm not entirely sure it's going to be a robust
> solution but
> > > at least it's only needed once!
> > >
> > > Nigel Roberts
> > > MC Sheet Metal
> > > Wales, UK
> > >
> > >
> > > -----Original Message-----
> > > Date: Wed, 10 Jan 2001 14:10:55 -0000
> > > From: "Denise Brown" <dbrown@f...>
> > > Subject: Changing Costing Methods
> > >
> > > We're running Vantage 4.0, and currently have our purchased parts
> set
> > > up using Average costing and everything else is set to Standard
> > > costing. We want to change to using Standard for everything.
> I'm
> > > told that to accomplish this, we'll need to go into each part
> > > individually that we want to change, and zero out the quantities,
> > > change the costing method, and then add the quantity back in.
> Does
> > > anyone know of an easier way to do this?
> > > Thanks!
> > > Denise Brown
> > >
>
eGroups Sponsor
Click here for Business information
We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
[Non-text portions of this message have been removed]
P.S. Most of the 4 hours it took was just learning how to use the Macro program.
Troy
----- Original Message -----
From: Nigel Roberts
To: 'vantage@egroups.com'
Sent: Thursday, January 11, 2001 12:36 AM
Subject: RE: [Vantage] Changing Costing Methods
I'm only exporting a list of our purchased part numbers - the macro will
then read this list and type in the key-strokes to change the costing
method field in Vantage (part file maintenance) - there is no import
required. I'm just trying to automate the process of going through every
part one by one.
Nigel.
> -----Original Message-----
> From: vantage@egroups.com [SMTP:vantage@egroups.com]
> Sent: 10 January 2001 19:12
> To: vantage@egroups.com
> Subject: [Vantage] Digest Number 1100
>
> Date: Wed, 10 Jan 2001 18:33:57 -0000
> From: "Denise Brown" <dbrown@...>
> Subject: Re: FW: Chainging Costing Methods
>
> Nigel,
>
> But how will you get the data back in to Vantage? I didn't think
> there was an import?
>
> Denise
>
> --- In vantage@egroups.com, Nigel Roberts <nigelr@m...> wrote:
> >
> > Almost forgot - the problem with changing the costing method for a
> part
> > of course is that there has to be zero on-hand quantity - luckily
> we can
> > cope with this as we're implementing inventory at this time also.
> >
> > > -----Original Message-----
> > > From: Nigel Roberts
> > > Sent: 10 January 2001 16:48
> > > To: 'Vantage User List (US)'
> > > Subject: Chainging Costing Methods
> > >
> > >
> > >
> > > I'm currently trying to do this by exporting a report of part
> numbers
> > > which now use average costing (for instance) and then using Macro
> > > Express to run through these parts and change the costing method
> to
> > > standard. I'm not entirely sure it's going to be a robust
> solution but
> > > at least it's only needed once!
> > >
> > > Nigel Roberts
> > > MC Sheet Metal
> > > Wales, UK
> > >
> > >
> > > -----Original Message-----
> > > Date: Wed, 10 Jan 2001 14:10:55 -0000
> > > From: "Denise Brown" <dbrown@f...>
> > > Subject: Changing Costing Methods
> > >
> > > We're running Vantage 4.0, and currently have our purchased parts
> set
> > > up using Average costing and everything else is set to Standard
> > > costing. We want to change to using Standard for everything.
> I'm
> > > told that to accomplish this, we'll need to go into each part
> > > individually that we want to change, and zero out the quantities,
> > > change the costing method, and then add the quantity back in.
> Does
> > > anyone know of an easier way to do this?
> > > Thanks!
> > > Denise Brown
> > >
>
eGroups Sponsor
Click here for Business information
We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
[Non-text portions of this message have been removed]