Heres one I used a while back. PLEASE be careful with this. I added
the last command for you. Moving to renewal would need to update the
BillingCycleID. You'd have to find which BC you want the users
under, and change that as well.
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
Update MasterAccounts
Set Balance = 0
--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