(no subject)
Dale E. Reed Jr. ( (no email) )
Fri, 15 May 1998 01:25:09 -0700
Ed and Kathy Tate wrote:
>
> Dale and Sheryl,
>
> Jeff Cox at OnlineMac has been waiting several weeks for scripts that will
> clear all balances, payment histories, invoice records, etc. so that we can
> have a clean start and put Emerald into a parallel billing run against the
> current billing system. The last time we spoke you indicated that these
> might be ready by May 1st but we have yet to hear from you or see any
> scripts. This is severely impacting our accounting department and we must
> be able to implement Emerald as soon as possible. Please let me know when
> these scripts can be available. I have left several e-mail and voice
> messages regarding this issue.
The following script can be ran against an Emerald database to clear out
the billing information. It does not handle setting balances. YOu can
run this from isql_w.
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 Invoices
Go
Delete From Payments
Go
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com