Re: [Emerald] Voiding an invoice

Dale E. Reed Jr. ( (no email) )
Mon, 01 Feb 1999 12:29:51 -0800

Daniel Wood wrote:
>
> I just upgraded to Emerald 2.5 and now when I try to void an
> invoice is says "Type Mismatch" and locks up Emerald. Can
> anybody help with this?

The problem arises from NULL PreviousBalance fields in your
Invoices table (which result in Invoices created with 2.2 or
lower). Run this query to fix the problem:

Update Invoices
Set PreviousBalance = 0
Where PreviousBalance IS NULL

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html