Re: [Emerald] error 13

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Thomas Browner: "[Emerald] error 13"
Next message: Adam Greene: "[Emerald] Table Corrupt"
Maybe in reply to: Thomas Browner: "[Emerald] error 13"

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
> www.ddyne.com

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

Previous message: Thomas Browner: "[Emerald] error 13"
Next message: Adam Greene: "[Emerald] Table Corrupt"
Maybe in reply to: Thomas Browner: "[Emerald] error 13"