Never mind I figured it out:
Update invoices set previousbalance=0 where previousbalance is NULL
If it was then the PreviousBalance is set for a NULL and 2.5.225/227 will
not void it.. it is looking for a 0
I had this problem and I ran a short to script to replace all
previousbalances that were null with a 0
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Chris A.
Christopher
Sent: Friday, February 26, 1999 8:59 AM
To: emerald@iea-software.com
Subject: [Emerald] THIRD REQUEST VOIDING INVOICE PROBLEM
This is the third day that I have not been able to void invoices to make
date corrections. I still get a "Runtime error 13 Type Mismatch". What is
the fix please?
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html