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

[Kristian Hoffmann]

If you really need to delete invoices, you're better off doing it through
the FS api.  Directly manipulating the database is asking for disaster.  I
can't stress that enough.  One misplaced 'where' statement and you can
accidentally delete all of your customers, passwords, etc.

-Kristian


On Wed, 27 Aug 2003, Rob Charles wrote:

> Here are the tables that reference "invnum" feilds...
>
> h_cust_bill
> h_cust_credit_bill
> cust_bill_pay
> cust_credit_bill
> cust_pay_batch
> cust_bill_pkg
> cust_bill_event
> cust_bill
> h_cust_bill_pay
> h_cust_bill_event
> h_cust_pay_batch
> h_cust_bill_pkg
>
> I see these in a dump I did but do not see them in the database....
> So it might just be the ones above.. so that means we must remove any line
> associated with a invnum in it?
>
>
> h_cust_credit_bill2
> cust_bill_pay2
> cust_credit_bill2
> cust_pay_batch1
> cust_bill_pkg2
> cust_bill_event1
> h_cust_bill_pay2
> h_cust_bill_event1
> h_cust_pay_batch1
> h_cust_bill_pkg1
> h_cust_bill_pkg2
> cust_bill_pkey
>
>
>
> Rob Charles
> TheHostMasters
> Montreal, Canada
> 514-846-0006
> Rob at TheHostMasters.com
> http://www.TheHostMasters.com
>
>
>
> ----- Original Message -----
> From: "Cal" <cal361 at yahoo.com>
> To: <ivan-freeside at sisd.com>
> Sent: Saturday, August 23, 2003 10:39 AM
> Subject: Re: [freeside] How to delete an invoice.....
>
>
> > 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
> >
>
>