Mass Update of Costing Method with Access

A very generous user sent me a progress routine that does the whole thing in about two minutes. Thanks.
Thanks for your suggestions. I hadn't thought of doing several machines at the same time. And I haven't tried the import/export before either.

Troy Funte
Liberty Electronics
----- Original Message -----
From: Troy Funte
To: Vantage
Sent: Friday, April 13, 2001 9:30 PM
Subject: [Vantage] Mass Update of Costing Method with Access


I wonder if Someone who has the source code for Vantage 3.0 would be willing to look something up for me.

We need to change all of our 9,323 parts from Average to Standard. I did some testing and calculations, and with a macro that does the keystrokes in Vantage, it takes 11 seconds per part which comes to over 28 hours of processing. Trying to pack that 28 hours time into the same weekend that we upgrade to 4.0 (15 hrs to run schema's and Database conversion in my test) and then 5.0 (another long process), and I don't think our weekend will be long enough - especially if something goes wrong.

The idea came to me to use Microsoft Access to mass-change the "A" in the Part.CostMethod field to a "S". I've heard it can be done (although not something we want users to know about). I believe it could be done much faster than 28 hours.

What I would like to know is whether any other fields get changed in Vantage when a part is changed from Average Cost to Standard Cost. Will I break any links or disrupt any tables by directly changing the Cost Method from outside of Vantage.

Thanks for any time and effort you can take to look this up.

Troy Funte
Liberty Electronics



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


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I wonder if Someone who has the source code for Vantage 3.0 would be willing to look something up for me.

We need to change all of our 9,323 parts from Average to Standard. I did some testing and calculations, and with a macro that does the keystrokes in Vantage, it takes 11 seconds per part which comes to over 28 hours of processing. Trying to pack that 28 hours time into the same weekend that we upgrade to 4.0 (15 hrs to run schema's and Database conversion in my test) and then 5.0 (another long process), and I don't think our weekend will be long enough - especially if something goes wrong.

The idea came to me to use Microsoft Access to mass-change the "A" in the Part.CostMethod field to a "S". I've heard it can be done (although not something we want users to know about). I believe it could be done much faster than 28 hours.

What I would like to know is whether any other fields get changed in Vantage when a part is changed from Average Cost to Standard Cost. Will I break any links or disrupt any tables by directly changing the Cost Method from outside of Vantage.

Thanks for any time and effort you can take to look this up.

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]
You can run your macro on more than one machine. If you are running your
macro for each part, write a second macro to move down in the browse then
run your first macro, move down in the browse twice, three times, etc... I
have done blocks of 50 at a time. This will also speed up the process. If
you are using ground control, drop your Millisecond delay between windows to
3 or 400 this will also help. You should be able todo 10,000 parts in 3 or 4
hours not 28. This way you are still keeping your database integrity.

Patrick

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, April 13, 2001 8:30 PM
To: Vantage
Subject: [Vantage] Mass Update of Costing Method with Access


I wonder if Someone who has the source code for Vantage 3.0 would be willing
to look something up for me.

We need to change all of our 9,323 parts from Average to Standard. I did
some testing and calculations, and with a macro that does the keystrokes in
Vantage, it takes 11 seconds per part which comes to over 28 hours of
processing. Trying to pack that 28 hours time into the same weekend that we
upgrade to 4.0 (15 hrs to run schema's and Database conversion in my test)
and then 5.0 (another long process), and I don't think our weekend will be
long enough - especially if something goes wrong.

The idea came to me to use Microsoft Access to mass-change the "A" in the
Part.CostMethod field to a "S". I've heard it can be done (although not
something we want users to know about). I believe it could be done much
faster than 28 hours.

What I would like to know is whether any other fields get changed in Vantage
when a part is changed from Average Cost to Standard Cost. Will I break any
links or disrupt any tables by directly changing the Cost Method from
outside of Vantage.

Thanks for any time and effort you can take to look this up.

Troy Funte
Liberty Electronics



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



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I have made changes similar to this with the master file import/export
routine. I export the parts file then update the field in excel or access
then import the file back in. This takes only a few minutes. But be sure
no one is making changes while you have the parts table out.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, April 13, 2001 8:30 PM
To: Vantage
Subject: [Vantage] Mass Update of Costing Method with Access


I wonder if Someone who has the source code for Vantage 3.0 would be willing
to look something up for me.

We need to change all of our 9,323 parts from Average to Standard. I did
some testing and calculations, and with a macro that does the keystrokes in
Vantage, it takes 11 seconds per part which comes to over 28 hours of
processing. Trying to pack that 28 hours time into the same weekend that we
upgrade to 4.0 (15 hrs to run schema's and Database conversion in my test)
and then 5.0 (another long process), and I don't think our weekend will be
long enough - especially if something goes wrong.

The idea came to me to use Microsoft Access to mass-change the "A" in the
Part.CostMethod field to a "S". I've heard it can be done (although not
something we want users to know about). I believe it could be done much
faster than 28 hours.

What I would like to know is whether any other fields get changed in Vantage
when a part is changed from Average Cost to Standard Cost. Will I break any
links or disrupt any tables by directly changing the Cost Method from
outside of Vantage.

Thanks for any time and effort you can take to look this up.

Troy Funte
Liberty Electronics



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



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/