[freeside] How to delete an invoice.....

Cal cal361 at yahoo.com
Sat Aug 23 07:39:41 PDT 2003


I too have a need to remove invoices at times.  Can
anyone provide a list of tables that reference the
invoice number so one could make a call to remove all
of these refernces properly without munging the
database?

--- Kristian Hoffmann <khoff at pc-intouch.com> wrote:
> Down this road leads madness.
> 
> There are other tables in the schema that references
> invoices in
> cust_bill by their invnum.  The short answer is,
> direct database
> manipulation is almost always a really bad idea,
> even if you know what
> you're doing.
> 
> -Kristian
> 
> On Fri, 22 Aug 2003, Rob Charles wrote:
> 
> > ok it seems if I delete an invoice number in the
> table cust_bill it disapears off the clients file...
> >
> > Is this ok to do or will it muck up other stuff??
> >
> >
> > Thanks...
> >
> >
> > Rob Charles
> > TheHostMasters
> > Montreal, Canada
> > 514-846-0006
> > Rob at TheHostMasters.com
> > http://www.TheHostMasters.com
> >
> >
> >
> >   ----- Original Message -----
> >   From: Rob Charles
> >   To: ivan-freeside at sisd.com
> >   Sent: Friday, August 22, 2003 8:54 AM
> >   Subject: [freeside] How to delete an
> invoice.....
> >
> >
> >   I know your not suppose to be able to delete and
> invoice and all payments that go with it, but is
> there a way?
> >
> >   I messed a dew too many and its confusing now I
> want to clean up without having to re install
> everything..
> >
> >   Any ideas??
> >
> >   Thanks..
> >
> >
> >   Rob Charles
> >   TheHostMasters
> >   Montreal, Canada
> >   514-846-0006
> >   Rob at TheHostMasters.com
> >   http://www.TheHostMasters.com
> >
> >
> >
> >
> 


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com



More information about the freeside-users mailing list