Re: [Emerald] What version of Emerald should we be using?

Josh Hillman ( (no email) )
Tue, 2 Mar 1999 13:25:06 -0500

From: Dale E. Reed Jr. <>
>Please note that this does NOT do much justice to the voiding
>process. You have to modify the balance and roll back any dates
>if its the last one. The balance is the must crucial, but correcting
>the ExpireDate/BilledThru back to the start of the invoice is also
>crucial (or you give that invoice period for free).

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 <>
>> >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