Re: Clear Invoices

Dale E. Reed Jr. ( (no email) )
Sat, 25 Apr 1998 00:20:11 -0700

> 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