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 =3D (Select Max(InvoiceID)
> From Invoices i
> Where i.CustomerID =3D Payments.CustomerID
> and Payments.Date >=3D 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