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
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]