Multiple Cost Adjustments

Yahoo Archive
1
Hi - I highly recommend that you look up a piece of software from
kratronic.com, Mouse and Key Recorder. It's a macro recorder that can
copy your stuff from excel (or txt file) to Vantage etc and do the cost
adjustment. You need a bit of a macro guru to really get the most out
of it, but even without one you'll be able to do some pretty cool stuff
such as job closing pretty quickly. Free trial. $100 USD gives you a
site license and fantastic support...
2
We are trying to find a way to make 100+ cost adjustments. Is there
any way to do this other than manually making all the changes?

Thanks
Dave Grubbs
Vantage 8.03.305L
3
The easiest way we have found is to select the parts you want then from
list view copy out to a spreadsheet.



Once all corrections are made you can then paste back in using "paste
update" from a right click.



Make sure to add a reason code to the updated data



We have found this the fastest way to update our part costs which are
generated from rules and length dependant so price increases are not
always a simple %age



If anyone knows a better way I would love to hear it but this at least
gets the data in and out of Vantage and lets us use Excel to re-cost the
parts from rules and formulae



Regards,

-

David Watt



Mob. +44 (0) 7809 586 797

Tel. +44 (0) 1793 647 140





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cdaveg
Sent: 23 December 2008 16:34
To: vantage@yahoogroups.com
Subject: [Vantage] Multiple Cost Adjustments



We are trying to find a way to make 100+ cost adjustments. Is there
any way to do this other than manually making all the changes?

Thanks
Dave Grubbs
Vantage 8.03.305L





[Non-text portions of this message have been removed]
4
The easiest way we have found is to select the parts you want then from list view copy out to a spreadsheet.

Once all corrections are made you can then paste back in using "paste update" from a right click.

Make sure to add a reason code to the updated data

We have found this the fastest way to update our part costs which are generated from rules and length dependant so price increases are not always a simple %age

If anyone knows a better way I would love to hear it but this at least gets the data in and out of Vantage and lets us use Excel to re-cost the parts from rules and formulae

We also use a similar method to update supplier price list for purchased parts where the cost and price are the same
Regards,
Â
David Watt

Mob. +44 (0) 7809 586 797
Tel. Â +44 (0) 1793 647 140
Â

________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cdaveg
Sent: 23 December 2008 16:34
To: vantage@yahoogroups.com
Subject: [Vantage] Multiple Cost Adjustments

We are trying to find a way to make 100+ cost adjustments. Is there
any way to do this other than manually making all the changes?

Thanks
Dave Grubbs
Vantage 8.03.305L