Re: Clear Invoices

David Moore ( (no email) )
Mon, 27 Apr 1998 09:56:35 +1000

It won't let me delete records from invoices as there are call history
records if is there a way around this

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: Emerald Software <emerald@iea-software.com>
Date: Sunday, April 26, 1998 3:20 AM
Subject: Re: Clear Invoices

>> David Moore wrote:
>>
>> As I cant get the Invoices to work the way I wish, I would like to delete
the
>> existing INVOICES in our system, when I go to delete the invoice an error
>> mesage says no charges found How can I get rid of these Invoices
>
>You would have to delete them manually. The easiest way to delete them
>is via isql_w:
>
>delete from InvoiceItems
>Go
>Delete from invoices
>go
>
>You may have relationships in the charges or payments tables as well.
>
>What problems are you having with the invoices?
>
>--
>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
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>