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

[Rob Charles]

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
>