I am making a few assumptions here: 1) you used to run Emerald 2.1 or 2.2,
2) you have upgraded to version 2.5.
2.5 cannot void invoices from earlier versions because it is looking for a
PreviousBalance field, which did not exist until 2.5. To fix the problem,
open ISQL_w and run the following query against your Emerald database:
update Invoices
set PreviousBalance=0
where PreviousBalance is NULL
This will leave your 2.5-created invoices alone but allow you to void your
old ones by assigning a value of zero to the PreviousBalance field in the
new table.
If this is not your situation, let me know and I'll be happy to troubleshoot
further.
Sheryl D. Stover - sds@iea-software.com - http://www.iea-software.com
IEA Software Account Management and Customer Service
Phone: (509) 444-2455 ext. 51 - Fax: (509) 624-9903
Billing and Customer Care for ISPs and Communications Companies
-----Original Message-----
From: Chris A. Christopher <management@labyrinth.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Friday, February 26, 1999 8:51 AM
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