[Emerald] Upgrading to 2.5

Emerald ( (no email) )
Wed, 28 Jul 1999 16:28:21 -0400

Hi Dale,

We are planning to upgrade this weekend (yea we have a backup server so if
it messes up we won't be down) and I'm currently getting all the pieces
together and doing a practice run on a temp sql server and database right
now. (Before you ask, yes we have a support contract but I was told to email
you this request via the list.)

I have two concerns though.

First, looking at the ftp site I see there is the base 2.5 package and then
there in the updates directory are the following files:

checkdb.sql
consol.sql
emeraldadmn_288.exe
emerald_278.exe
invoice.rpt
receipt.rpt
updtcalls.sql
updtports.sql

I'd like to know what these extra files are for, I'm assuming they fix
problems but it would be incredibly handy to know in advance what problems.

The second thing, and this one is REALLY critical, I realize this is in the
upgrade notes but we create a number of manual invoices in 2.2, when you do
that the "current balance" field on the billing tab is not adjusted by the
amount of the manual invoice. As a result of this, when the customer pays
their invoice, you end up with a balance other than zero. After converting
to 2.5, what happens is emerald carries the incorrect balance over generates
an invoice (or I assume a credit) based on this balance. We did a dry run
and ended up with about 500 invoices that shouldn't have existed due to
this.

Is there a script I can run against either the 2.2 or 2.5 database that will
go thru and total up all unpaid/unvoided invoices and correct this total so
I don't have to manually call up thousands of accounts to correct it?

Geo.
Netlink Services

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart