That's a good point. The balances could be easily fixed by running that
same script you provided back in January. You'd still have to recreate any
charges that may have been associated with those newly-voided invoices.
Also, expiration dates, billed-thru dates, etc. would also need to be
>Josh Hillman wrote:
>> From: Ed Miller <firstname.lastname@example.org>
>> >We have over 150 Invoices to void. Does anyone have a SQL statement
>> >will void all invoices that were made on a given date?
>> You can add to the end of this, anything else that you may want to
>> it with:
>> update invoices
>> set type = 'Void', lastmodifydate = getdate()
>> where date = '2/27/99'
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html