RE: [Emerald] Invoice print outs

Christian Lawrence ( (no email) )
Wed, 26 May 1999 14:16:04 -0500

There is no previousbalance column in the invoices table.

-----Original Message-----
[] On Behalf Of Sheryl D. Weidner
Sent: Wednesday, May 26, 1999 12:24 PM
Subject: Re: [Emerald] Invoice print outs


If you upgraded from Emerald 2.1 to 2.5 and the invoice you are trying to
void is an old one, run the following in ISQL_w against your Emerald

update invoices
set previousbalance=0
where previousbalance is null

The old invoices don't contain the PreviousBalance field, which the new
voiding routine checks for.

Sheryl D. Weidner - -
IEA Software Customer Support Manager
Phone: (831) 459-9430 - Fax: (831) 459-9434
Billing and Customer Care for ISPs and Communications Companies

-----Original Message-----
From: Christian Lawrence <>
To: <>
Date: Wednesday, May 26, 1999 9:56 AM
Subject: RE: [Emerald] Invoice print outs

:When I try to void an invoice I get "13:Type Mismatch".
:-----Original Message-----
:[] On Behalf Of Dale E. Reed Jr.
:Sent: Tuesday, May 25, 1999 5:55 PM
:Subject: Re: [Emerald] Invoice print outs
:Christian Lawrence wrote:
:> I have tried to print out invoices but it seems the billing dates are
:> on 2/1/99 and if I change the billing in the master account it does not
:> effect the invoice. Also, I had to change the description on the account
:> type and that change also did not take place on the invoice even though
:> does show on the account information as taking place. The invoice is
:> showing what was originally entered there. Everything is also correct in
:> the database.
:Once an invoice is created, changing the MBR information has no
:affect on the invoice itself. You would need to void the invoice,
:change the information, then re-create the invoice (like using the
:Master...Invoice Next Term option).
:> Am I correct in saying that the crystal reports print engine is not the
:> thing as crystal reports.
:Crystal Reports is typically meaning the Editor. The Print Enginer just
:allows you to display reports, not modify them.
:Dale E. Reed Jr. Emerald and RadiusNT
:IEA Software, Inc.