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

[Kristian Hoffmann]

If it was development before, then just delete all the billing data, or
start fresh by dropping the database and running freeside-setup.  There's
no method for deleting invoices because Ivan believes (I think rightly
so), that you shouldn't be able to delete invoices.  That's what credits
and refunds are for.

-Kristian


On Thu, 28 Aug 2003, Rob Charles wrote:

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