Re: [Emerald] error 13

Sheryl D. Weidner ( (no email) )
Tue, 31 Aug 1999 13:16:05 -0700

If you are trying to void an invoice which was created with an older
(2.1 or 2.2) version of Emerald, the error is caused by the older
invoices having a null value in a column which is required in 2.5. Run
the following query against your Emerald database to reset those values
to 0 instead of null, and voiding should work:

update invoices
set previousbalance=0
where previousbalance is null

> Thomas Browner wrote:
> Hi
> When I go to void a invoice out I get a Emerald error 13:type
> mismatch. Has anyone had this problem when trying to void out a
> invoice.
> Thomas Browner

For more information about this list (including removal) go to: