> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
> Sent: Tuesday, February 15, 2000 1:16 PM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] Upgrade to 2.5.327
>
>
> That's exactly what I saw, but I wanted to try and verify with
> someone sine I really can't afford problems with Emerald.
>
> We are using 300 and it works, but there are some new features
> that we could immediately implement.
>
> Thanks,
> John
>
>
> *********** REPLY SEPARATOR ***********
>
> On 2/15/00, at 12:56 PM, Ronnie Franklin wrote:
>
> >The following need to be done...
> >
> >* Added a paymethod of "Closed" to the list. You need to add the
> > payment closed to your PayMethods table using the following statement,
> > or you will get an error if you try to save a user with that paymethod.
> >
> > INSERT INTO PayMethods(PayMethod, GrooupID, SortOrder)
> > VALUES('Closed', NULL, 8)
> >
> >* Emerald was NOT updating the InvoiceID in the payments table.
> > This was causing the payments section of the Invoice to always
> > be blank. You *MUST* run this scrip to update your database,
> > or afer your first billing all payments for each customer will
> > appear on their next bill:
> >
> > Update Payments
> > Set InvoiceID = (Select Max(InvoiceID)
> > From Invoices i
> > Where i.CustomerID = Payments.CustomerID
> > and Payments.Date >= i.Date)
> > Where InvoiceID is NULL
> >
> >and I think that is all, but since I am not an Employee of IEA.. I only
> >speak from what I read and see!!!!!!!!!!!!!!!!
> >
> >
> >
> >
> >
> >> -----Original Message-----
> >> From: emerald-request@iea-software.com
> >> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
> >> Sent: Tuesday, February 15, 2000 12:42 PM
> >> To: emerald@iea-software.com
> >> Subject: Re: [Emerald] Upgrade to 2.5.327
> >>
> >>
> >> I want to upgrade from 2.5.300 to 2.5.327
> >> Looking at the release notes, below should be all I need to do.
> >>
> >> Run these scripts?
> >> Insert into Paymethods ....
> >> and
> >> Update Payments
> >>
> >> Are there any other issues I need to be concerned about?
> >>
> >> Thanks
> >>
> >> *********** REPLY SEPARATOR ***********
> >>
> >> On 2/14/00, at 2:01 PM, Ronnie Franklin wrote:
> >>
> >> >Yes... read the .txt files that come with the new programs..
> >> look where the
> >> >.3xx versions started and you will see what you need to run...
> >> >
> >> >
> >> >----- Original Message -----
> >> >From: Frank Canode <fcanode@mc2k.com>
> >> >To: Emerald <emerald@iea-software.com>
> >> >Sent: Monday, February 14, 2000 1:42 PM
> >> >Subject: [Emerald] Upgrade to 2.5.327
> >> >
> >> >
> >> >> We would like to upgrade Emerald 2.5.278 to 2.5.327 and admin
> >> from 2.5.285
> >> >> to 2.5.323. Are there any "special" scripts that need to be
> run against
> >> >the
> >> >> database before making these changes?
> >> >>
> >> >> FrankC
> >> >>
> >> >>
> >> >> For more information about this list (including removal) go to:
> >> >> http://www.iea-software.com/support/maillists/liststart
> >> >>
> >> >
> >> >
> >> >For more information about this list (including removal) go to:
> >> >http://www.iea-software.com/support/maillists/liststart
> >>
> >> For more information about this list (including removal) go to:
> >> http://www.iea-software.com/support/maillists/liststart
> >>
> >
> >
> >For more information about this list (including removal) go to:
> >http://www.iea-software.com/support/maillists/liststart
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart