(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