>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'
>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. www.iea-software.com
>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