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

Ed Miller ( (no email) )
Tue, 2 Mar 1999 12:42:36 -0500

Yes I agree but it takes 5 'click here' for each Invoice.
Do you have a way to do a Mass Void?


>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'
>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).
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list, including removal,
>please see

For more information about this list, including removal,
please see