Re: [Emerald] Accounts to Zero script.....

Dale E. Reed Jr. ( (no email) )
Fri, 12 Nov 1999 09:32:30 -0800

Gabriel Sponsler wrote:
>
> Sorry about being vague. We have not used Emerald for billing as of
> yet, just authentifacation. We have allotted some odd-ball charges on some
> of the MBR accounts. So I would like each account to start with zero money
> owed, but at the same time retaining all of the customer details.

Try this Script:

Update InvoiceItems
Set PaymentID = NULL
GO

Update Charges
Set ItemID = NULL
GO

Delete From CallHistory
Go

Delete From InvoiceItems
Go

Delete From Charges
Go

Delete From ExternalTrans
Go

Delete From Invoices
Go

Delete From Payments
Go

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart