What is the recommend approach to update 9.05 (SQL) with a mass

Thanks Miquel.

At this point, we are trying to weight the pros and cons of using a price list versus having the price listed in the part master.

--- In vantage@yahoogroups.com, Miguel Santillan <msantillan@...> wrote:
>
> We had a similar issue, had about 100 SO's that we needed to update. I created an Updatable Dashboard with the Unit Price that was updatable.
>
> We pulled a certain customer, with SO due after a certain date. Then the person sorted by part number and easily updated the pricing within 10 minutes.
>
> Not sure if you are updating a Price List or Sales Orders.
>
> Miguel Santillan
> ERP Administrator
> Compass Manufacturing Services
> DL: 510-661-6666
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John Driggers
> Sent: Friday, December 16, 2011 5:16 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: What is the recommend approach to update 9.05 (SQL) with a mass price increase?
>
> We have a little program we wrote to load price-lists from our vendors.
> There is/was a built in program for loading the lists. We ended up writing our own as our parts personnel were not capable of reliably arranging the columns on the spreadsheets to match Epicor's expected format.
>
> On Fri, Dec 16, 2011 at 8:05 AM, Tim Vonderhaar < tvonderhaar@...> wrote:
>
> > **
> >
> >
> > Anyone?
> >
> >
> > --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > >
> > > What is the recommend approach to perform a mass price increase
> > > (field
> > Sales Unit Price) in 9.05? Is there something built in or do we need
> > to run some external script?
> > >
> > > Tim
> > >
> >
> >
> >
>
>
>
> --
> *John Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
What is the recommend approach to perform a mass price increase (field Sales Unit Price) in 9.05? Is there something built in or do we need to run some external script?

Tim
Anyone?

--- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
>
> What is the recommend approach to perform a mass price increase (field Sales Unit Price) in 9.05? Is there something built in or do we need to run some external script?
>
> Tim
>
We have a little program we wrote to load price-lists from our vendors.
There is/was a built in program for loading the lists. We ended up writing
our own as our parts personnel were not capable of reliably arranging the
columns on the spreadsheets to match Epicor's expected format.

On Fri, Dec 16, 2011 at 8:05 AM, Tim Vonderhaar <
tvonderhaar@...> wrote:

> **
>
>
> Anyone?
>
>
> --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
> >
> > What is the recommend approach to perform a mass price increase (field
> Sales Unit Price) in 9.05? Is there something built in or do we need to run
> some external script?
> >
> > Tim
> >
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


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

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> We have a little program we wrote to load price-lists from our vendors.
> There is/was a built in program for loading the lists. We ended up writing
> our own as our parts personnel were not capable of reliably arranging the
> columns on the spreadsheets to match Epicor's expected format.
>
> On Fri, Dec 16, 2011 at 8:05 AM, Tim Vonderhaar <
> tvonderhaar@...> wrote:
>
> > **
> >
> >
> > Anyone?
> >
> >
> > --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > >
> > > What is the recommend approach to perform a mass price increase (field
> > Sales Unit Price) in 9.05? Is there something built in or do we need to run
> > some external script?
> > >
> > > Tim
> > >
> >
> >
> >
>
>
>
> --
> *John Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
We had a similar issue, had about 100 SO's that we needed to update. I created an Updatable Dashboard with the Unit Price that was updatable.

We pulled a certain customer, with SO due after a certain date. Then the person sorted by part number and easily updated the pricing within 10 minutes.

Not sure if you are updating a Price List or Sales Orders.

Miguel Santillan
ERP Administrator
Compass Manufacturing Services
DL: 510-661-6666

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John Driggers
Sent: Friday, December 16, 2011 5:16 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: What is the recommend approach to update 9.05 (SQL) with a mass price increase?

We have a little program we wrote to load price-lists from our vendors.
There is/was a built in program for loading the lists. We ended up writing our own as our parts personnel were not capable of reliably arranging the columns on the spreadsheets to match Epicor's expected format.

On Fri, Dec 16, 2011 at 8:05 AM, Tim Vonderhaar < tvonderhaar@...> wrote:

> **
>
>
> Anyone?
>
>
> --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
> >
> > What is the recommend approach to perform a mass price increase
> > (field
> Sales Unit Price) in 9.05? Is there something built in or do we need
> to run some external script?
> >
> > Tim
> >
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links