Mass Change to Unit Price

Yahoo Archive
1
Steve notes:
> Yes you can do this, but keep in mind that vantage tracks cost for
> inventor by using the cost adj in the trans record. If this does not
> match the part cost record it will give you variance every time you
> do a trans.

This is true if you're changing a part's cost but not its selling price.

Mark W.
2
Does anyone know how you would mass change unit pricing in Vantage 8?
For instance, if you are going to implement a 1% price increase on
specific "product groups", what is the best way to handle? We have
thousands of parts that would need to be changed, and don't want to
have to manually key in each change into the part masterfile.

Any input would be appreciated!
3
Where do you want to change the price? On the Part Maintenance
Screen or in a Price List??

Scott Way
MIC Industries, Inc




--- In vantage@yahoogroups.com, "how2wow" <mhow@...> wrote:
>
> Does anyone know how you would mass change unit pricing in Vantage
8?
> For instance, if you are going to implement a 1% price increase on
> specific "product groups", what is the best way to handle? We
have
> thousands of parts that would need to be changed, and don't want
to
> have to manually key in each change into the part masterfile.
>
> Any input would be appreciated!
>
4
In part maintenance- the unit price field.

--- In vantage@yahoogroups.com, "jpfinch1" <sway@...> wrote:
>
> Where do you want to change the price? On the Part Maintenance
> Screen or in a Price List??
>
> Scott Way
> MIC Industries, Inc
>
>
>
>
> --- In vantage@yahoogroups.com, "how2wow" <mhow@> wrote:
> >
> > Does anyone know how you would mass change unit pricing in
Vantage
> 8?
> > For instance, if you are going to implement a 1% price increase
on
> > specific "product groups", what is the best way to handle? We
> have
> > thousands of parts that would need to be changed, and don't want
> to
> > have to manually key in each change into the part masterfile.
> >
> > Any input would be appreciated!
> >
>
5
I am trying to do exactly the same thing. The price list doesnt seem
to do this, and it doesn't appear that there are any other programs in
Vantage that gives me this capability. If you find anything out, could
you let me know?

--- In vantage@yahoogroups.com, "how2wow" <mhow@...> wrote:
>
> In part maintenance- the unit price field.
>
> --- In vantage@yahoogroups.com, "jpfinch1" <sway@> wrote:
> >
> > Where do you want to change the price? On the Part Maintenance
> > Screen or in a Price List??
> >
> > Scott Way
> > MIC Industries, Inc
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "how2wow" <mhow@> wrote:
> > >
> > > Does anyone know how you would mass change unit pricing in
> Vantage
> > 8?
> > > For instance, if you are going to implement a 1% price increase
> on
> > > specific "product groups", what is the best way to handle? We
> > have
> > > thousands of parts that would need to be changed, and don't want
> > to
> > > have to manually key in each change into the part masterfile.
> > >
> > > Any input would be appreciated!
> > >
> >
>
6
Version 6.1 supports (with a little arm twisting) exporting price lists to
excel and back again. The arm twisting requires knowledge of some
formatting issues but it works with a little effort. Doesn't 8.0 allow the
same thing?



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

<http://www.riten.com/> www.riten.com



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
laidig.systems
Sent: Thursday, February 01, 2007 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Change to Unit Price



I am trying to do exactly the same thing. The price list doesnt seem
to do this, and it doesn't appear that there are any other programs in
Vantage that gives me this capability. If you find anything out, could
you let me know?

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"how2wow" <mhow@...> wrote:
>
> In part maintenance- the unit price field.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"jpfinch1" <sway@> wrote:
> >
> > Where do you want to change the price? On the Part Maintenance
> > Screen or in a Price List??
> >
> > Scott Way
> > MIC Industries, Inc
> >
> >
> >
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"how2wow" <mhow@> wrote:
> > >
> > > Does anyone know how you would mass change unit pricing in
> Vantage
> > 8?
> > > For instance, if you are going to implement a 1% price increase
> on
> > > specific "product groups", what is the best way to handle? We
> > have
> > > thousands of parts that would need to be changed, and don't want
> > to
> > > have to manually key in each change into the part masterfile.
> > >
> > > Any input would be appreciated!
> > >
> >
>





[Non-text portions of this message have been removed]
7
I'd think that , using ODBC, a app. could be written in VB ( using ADO ) that would loop thru the proper table , and update prices, as dictated.

Mitchell Kirby <m.kirby@...> wrote: Version 6.1 supports (with a little arm twisting) exporting price lists to
excel and back again. The arm twisting requires knowledge of some
formatting issues but it works with a little effort. Doesn't 8.0 allow the
same thing?

Sincerely,

Mitchell Kirby

Riten Industries, Inc.

<http://www.riten.com/> www.riten.com

740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
laidig.systems
Sent: Thursday, February 01, 2007 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Change to Unit Price

I am trying to do exactly the same thing. The price list doesnt seem
to do this, and it doesn't appear that there are any other programs in
Vantage that gives me this capability. If you find anything out, could
you let me know?

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"how2wow" <mhow@...> wrote:
>
> In part maintenance- the unit price field.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"jpfinch1" <sway@> wrote:
> >
> > Where do you want to change the price? On the Part Maintenance
> > Screen or in a Price List??
> >
> > Scott Way
> > MIC Industries, Inc
> >
> >
> >
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"how2wow" <mhow@> wrote:
> > >
> > > Does anyone know how you would mass change unit pricing in
> Vantage
> > 8?
> > > For instance, if you are going to implement a 1% price increase
> on
> > > specific "product groups", what is the best way to handle? We
> > have
> > > thousands of parts that would need to be changed, and don't want
> > to
> > > have to manually key in each change into the part masterfile.
> > >
> > > Any input would be appreciated!
> > >
> >
>

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






---------------------------------
Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.

[Non-text portions of this message have been removed]
8
Yes you can do this, but keep in mind that vantage tracks cost for
inventor by using the cost adj in the trans record. If this does not
match the part cost record it will give you variance every time you
do a trans.

Steve Erboe

--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:
>
> I'd think that , using ODBC, a app. could be written in VB ( using
ADO ) that would loop thru the proper table , and update prices, as
dictated.
>
> Mitchell Kirby <m.kirby@...> wrote: Version 6.1 supports
(with a little arm twisting) exporting price lists to
> excel and back again. The arm twisting requires knowledge of some
> formatting issues but it works with a little effort. Doesn't 8.0
allow the
> same thing?
>
> Sincerely,
>
> Mitchell Kirby
>
> Riten Industries, Inc.
>
> <http://www.riten.com/> www.riten.com
>
> 740-333-8719 Direct
>
> 800-338-0027 Sales
>
> 800-338-0717 FAX
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> laidig.systems
> Sent: Thursday, February 01, 2007 11:40 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass Change to Unit Price
>
> I am trying to do exactly the same thing. The price list doesnt seem
> to do this, and it doesn't appear that there are any other programs
in
> Vantage that gives me this capability. If you find anything out,
could
> you let me know?
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "how2wow" <mhow@> wrote:
> >
> > In part maintenance- the unit price field.
> >
> > --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com,
> "jpfinch1" <sway@> wrote:
> > >
> > > Where do you want to change the price? On the Part Maintenance
> > > Screen or in a Price List??
> > >
> > > Scott Way
> > > MIC Industries, Inc
> > >
> > >
> > >
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com,
> "how2wow" <mhow@> wrote:
> > > >
> > > > Does anyone know how you would mass change unit pricing in
> > Vantage
> > > 8?
> > > > For instance, if you are going to implement a 1% price
increase
> > on
> > > > specific "product groups", what is the best way to handle? We
> > > have
> > > > thousands of parts that would need to be changed, and don't
want
> > > to
> > > > have to manually key in each change into the part masterfile.
> > > >
> > > > Any input would be appreciated!
> > > >
> > >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites to find
flight and hotel bargains.
>
> [Non-text portions of this message have been removed]
>
9
> I'd think that , using ODBC, a app. could be written in VB ( using ADO )
> that would loop thru the proper table , and update prices, as dictated.

If you want to use a .Net language, the code is pretty simple to use the
Business Objects directly. Doing so does not require ServiceConnect or the
overhead of web services and, unlike ODBC, ensures that all business rules are
enforced.

The code below shows how to update the price field. You could export the
current parts and prices to Access, make your changes, and then have this
program read each part and update the price.

HTH,

Mark W.


Dim strPart, errMsg As String
Dim objSess as Epicor.Mfg.Core.Session
Dim objPart as Epicor.Mfg.BO.Part
Dim dsPart as Epicor.Mfg.BO.PartDataSet

Try
' Start a new session
objSess = New Epicor.Mfg.Core.Session("manager", "manager",
"AppServerDC://UFMERP:8301", Epicor.Mfg.Core.Session.LicenseType.Default)

' Create Business Objects
objPart = New Epicor.Mfg.BO.Part(objSess.ConnectionPool)
dsPart = New Epicor.Mfg.BO.PartDataSet

Catch ex As Exception
Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error:1")
Application.Exit()
End Try

Try
' For each Part
strPart = <part number>
' See if part exists
If objPart.PartExists(strPart) Then
' Update part
dsPart = objPart.GetByID(strPart)
dsPart.Part.Item(0).UnitPrice = <New Price>
Try
objPart.Update(dsPart)
Catch ex As Exception
Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error:2")
End Try
End If
Catch ex As Exception
Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error:3")
End Try

objSess.Close()