Why not suggest starting at say 1000. That way you don't have to go through
the bother of changes all past invoices. Either change the last invoice to
1000 or create a new one and edit it along with the references to it, to
1000.
ron
> The guy using the freetrade as his store wants to start over with the
> invoices since there were quite a few used for orders tests and a few that
> seem to have vanished.
>
> Shawn
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Chuck
> Gartland
> Sent: June 6, 2001 4:58 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [FreeTrade-dev] Clearing out database invoices
>
>
> Shawn,
>
> Perhaps you have a good reason to do this. I really do not find it likely
> though. Assuming that you have a good reason you need to write a script.
> The script should update each existing invoice with some sort of prefix.
> The script should also make sure that if the invoice number is referenced
> anywhere else (customer history or something like that) that the invoice
> number is updated. Then you can start over with one. If you start over
at
> one with out getting rid of all traces of the old invoice numbers you will
> wind up with duplicate invoice numbers and would deserve to be spanked.
And
> not by anyone from whom a spanking may be a good thing. You could update
> all the invoice numbers and references to them manually but that would
> introduce quite a bit of room for human error.
>
> Why are you wanting to restart at one? Is this just an arbitrary decision
> or will restarting at one some how improve performance or customer
service?
>
> Hope this helps,
> Chuck
>
>
> -------------------------------------------------
> Chuck Gartland || [EMAIL PROTECTED]
> Project 27 || www.project27.com
> 1836 Palm Avenue || 808 465-1381
> Pearl City, HI 96782 || GMT -10:00 hours
> -------------------------------------------------
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Shawn
> > Honeychurch
> > Sent: Wednesday, June 06, 2001 12:43 PM
> > To: [EMAIL PROTECTED]
> > Subject: [FreeTrade-dev] Clearing out database invoices
> >
> >
> > Hello all;
> >
> > Does anyone know of a quick and effective way to reset the invoice
numbers
> > in the freetrade database? I just want to restart all the
> > invoices at 1 and
> > go from there without affecting the items or customer orders
> > already in the
> > database.
> >
> > Shawn
> >
> > _______________________________________________
> > FreeTrade-dev mailing list
> > [EMAIL PROTECTED]
> > http://share.whichever.com/mailman/listinfo/freetrade-dev
> >
>
> _______________________________________________
> FreeTrade-dev mailing list
> [EMAIL PROTECTED]
> http://share.whichever.com/mailman/listinfo/freetrade-dev
>
>
> _______________________________________________
> FreeTrade-dev mailing list
> [EMAIL PROTECTED]
> http://share.whichever.com/mailman/listinfo/freetrade-dev
>
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
