Mass change of terms to all customers

I think we will be investig in the DMT tool to do this type of updates.

I have now 4 outstanding things to use it for 1) Close list of P/O 2) Close
list of Jobs 3) Change Terms 4) Change Supplier groups

Ephraim


On Thu, Dec 9, 2010 at 3:37 PM, Waffqle Driggers <waffqle@...> wrote:

> It's not really 'recommended procedure'. But you're only changing one field
> and you're setting them all to the same thing; so it's pretty safe. Of
> course, you'll still want to run your code against your test DB first.
>
> We've done it here and there for a number of things. Just make sure you
> test
> thoroughly and know the ramifications of the changes.
>
> On Thu, Dec 9, 2010 at 1:56 PM, Ephraim Feldman <effgroups@...>
> wrote:
>
> >
> >
> > yes i have the compiler
> >
> > But is it safe to change this via direct DB access?
> >
> >
> > On Thu, Dec 9, 2010 at 8:54 AM, Waffqle Driggers <waffqle@...
> <waffqle%40gmail.com>>
> > wrote:
> >
> > > You can do this via progress if you have the compiler.
> > >
> > > On Thu, Dec 9, 2010 at 7:57 AM, <effgroups@...<effgroups%
> 40gmail.com>>
> > wrote:
> > >
> > > >
> > > >
> > > > I know that. The problem is the company is not willing to spent the
> 3k
> > > now.
> > > >
> > > >
> > > > Any other solutions ?
> > > > Ephraim Feldman
> > > > Programmer / Analyst
> > > > Axis Lighting
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: "Rupert" <r.oo@... <r.oo%40firenet.uk.net> <r.oo%
> > 40firenet.uk.net>>
> > > > Sender: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> <vantage%
> > 40yahoogroups.com>
> > > > Date: Thu, 09 Dec 2010 10:42:11
> > > > To: <vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> > 40yahoogroups.com>>
> > > > Reply-To: vantage@yahoogroups.com <vantage%40yahoogroups.com
> ><vantage%
> > 40yahoogroups.com>
> > > > Subject: [Vantage] Re: Mass change of terms to all customers
> > > >
> > > > DMT will do this in minutes
> > > >
> > > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> > 40yahoogroups.com>, Ephraim
> >
> > > > Feldman <effgroups@...> wrote:
> > > > >
> > > > > Hi
> > > > >
> > > > > I need to mass change the payment terms for all customers how can i
> > > > > accomplish that?
> > > > >
> > > > > Ephraim
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > >
> > > [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
> >
> > >
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [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
>
>
>
>


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

I need to mass change the payment terms for all customers how can i
accomplish that?

Ephraim


[Non-text portions of this message have been removed]
DMT will do this in minutes

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Hi
>
> I need to mass change the payment terms for all customers how can i
> accomplish that?
>
> Ephraim
>
>
> [Non-text portions of this message have been removed]
>
I know that. The problem is the company is not willing to spent the 3k now.

Any other solutions ?
Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: "Rupert" <r.oo@...>
Sender: vantage@yahoogroups.com
Date: Thu, 09 Dec 2010 10:42:11
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass change of terms to all customers

DMT will do this in minutes

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Hi
>
> I need to mass change the payment terms for all customers how can i
> accomplish that?
>
> Ephraim
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
You can do this via progress if you have the compiler.

On Thu, Dec 9, 2010 at 7:57 AM, <effgroups@...> wrote:

>
>
> I know that. The problem is the company is not willing to spent the 3k now.
>
>
> Any other solutions ?
> Ephraim Feldman
> Programmer / Analyst
> Axis Lighting
>
>
> -----Original Message-----
> From: "Rupert" <r.oo@... <r.oo%40firenet.uk.net>>
> Sender: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Date: Thu, 09 Dec 2010 10:42:11
> To: <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> Reply-To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Mass change of terms to all customers
>
> DMT will do this in minutes
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Ephraim
> Feldman <effgroups@...> wrote:
> >
> > Hi
> >
> > I need to mass change the payment terms for all customers how can i
> > accomplish that?
> >
> > Ephraim
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
yes i have the compiler

But is it safe to change this via direct DB access?

On Thu, Dec 9, 2010 at 8:54 AM, Waffqle Driggers <waffqle@...> wrote:

> You can do this via progress if you have the compiler.
>
> On Thu, Dec 9, 2010 at 7:57 AM, <effgroups@...> wrote:
>
> >
> >
> > I know that. The problem is the company is not willing to spent the 3k
> now.
> >
> >
> > Any other solutions ?
> > Ephraim Feldman
> > Programmer / Analyst
> > Axis Lighting
> >
> >
> > -----Original Message-----
> > From: "Rupert" <r.oo@... <r.oo%40firenet.uk.net>>
> > Sender: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > Date: Thu, 09 Dec 2010 10:42:11
> > To: <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> > Reply-To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Mass change of terms to all customers
> >
> > DMT will do this in minutes
> >
> > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Ephraim
> > Feldman <effgroups@...> wrote:
> > >
> > > Hi
> > >
> > > I need to mass change the payment terms for all customers how can i
> > > accomplish that?
> > >
> > > Ephraim
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [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
>
>
>
>


[Non-text portions of this message have been removed]
It's not really 'recommended procedure'. But you're only changing one field
and you're setting them all to the same thing; so it's pretty safe. Of
course, you'll still want to run your code against your test DB first.

We've done it here and there for a number of things. Just make sure you test
thoroughly and know the ramifications of the changes.

On Thu, Dec 9, 2010 at 1:56 PM, Ephraim Feldman <effgroups@...> wrote:

>
>
> yes i have the compiler
>
> But is it safe to change this via direct DB access?
>
>
> On Thu, Dec 9, 2010 at 8:54 AM, Waffqle Driggers <waffqle@...<waffqle%40gmail.com>>
> wrote:
>
> > You can do this via progress if you have the compiler.
> >
> > On Thu, Dec 9, 2010 at 7:57 AM, <effgroups@...<effgroups%40gmail.com>>
> wrote:
> >
> > >
> > >
> > > I know that. The problem is the company is not willing to spent the 3k
> > now.
> > >
> > >
> > > Any other solutions ?
> > > Ephraim Feldman
> > > Programmer / Analyst
> > > Axis Lighting
> > >
> > >
> > > -----Original Message-----
> > > From: "Rupert" <r.oo@... <r.oo%40firenet.uk.net> <r.oo%
> 40firenet.uk.net>>
> > > Sender: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > > Date: Thu, 09 Dec 2010 10:42:11
> > > To: <vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>>
> > > Reply-To: vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com>
> > > Subject: [Vantage] Re: Mass change of terms to all customers
> > >
> > > DMT will do this in minutes
> > >
> > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>, Ephraim
>
> > > Feldman <effgroups@...> wrote:
> > > >
> > > > Hi
> > > >
> > > > I need to mass change the payment terms for all customers how can i
> > > > accomplish that?
> > > >
> > > > Ephraim
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [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
>
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>


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