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

[Rob Charles]

Is there anything available now to do this via FS? I am using 1.4.1 I did
not see anything regarding deleting invoices... there is a delete payment or
unapply payment but no deleting invoices.... unless I missed it....

Or other possibility is to start over , but can I export everything except
invoice/payment info then erase entire database then import the data without
invoice/payment data?

I am doing this cuz my dev FS after so much data entry and testing suddenly
became a Prod server..
:)

Thanks..



Rob Charles
TheHostMasters
Montreal, Canada
514-846-0006
Rob at TheHostMasters.com
http://www.TheHostMasters.com



----- Original Message -----
From: "Kristian Hoffmann" <khoff at pc-intouch.com>
To: <ivan-freeside at sisd.com>; "Rob Charles" <rob at thehostmasters.com>
Sent: Thursday, August 28, 2003 2:08 AM
Subject: Re: [freeside] How to delete an invoice.....


> 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
> > >
> >
> >
>