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. <>
To: Emerald Software <>
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
>> 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
>Delete from invoices
>You may have relationships in the charges or payments tables as well.
>What problems are you having with the invoices?
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List