* 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:
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: email@example.com
> [mailto:firstname.lastname@example.org]On Behalf Of PowerNet
> Sent: Tuesday, February 15, 2000 12:42 PM
> To: email@example.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 ....
> Update Payments
> Are there any other issues I need to be concerned about?
> *********** 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 <firstname.lastname@example.org>
> >To: Emerald <email@example.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
> >> 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:
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: