Simple Invoices - Forum

Hey Phmc,

you can do the above with mysql, just alter the auto increment number or th id column in si_invoices to say 200705

then all invoices will auto have that prefix with no php code change required :)

Cheers

Justin

Hey all, Sorry to bring an old topic up again but I'm sure a lot of people would be interested in modifying their Invoice number. So, with the si_invoices autoincrement part, where can we alter its beginning number, and change how much it increments (I know a few places that increment up spaces of 100, so it is 21000, 211100, 211200 etc... instead of 1 2 3 4..)

If I can modify it easily enough in sql, I might think of working on a "cheat sheet" page, where a bit of html and forms, and we can alter it ourselves without needing to rely on mysql all the time.

I think I will implement this one (not in the next 4 weeks) as a custom field. Because it's not really a good way to change the invoice id because all other data depends on this number...

Thats fair enough.... so if existing invoices there, it would not be a good idea to change it. However, for installations from scratch, how would you start it to continue on from a paper based one, which already might be up to 02xxx or something..

Hey Guys,

if you want to change the invoice number of invoices going forward (ie not changing already existing invoice ids)

just open phpmyadmin, go to the si_invoices table, select operations, and change the auto-increment number to whatever you want (ie. change it from 5 to 2007070 etc..)

but this only increment by 1 at a time - don't think it can be changed to increment by 100s - might be wrong though - google it :)

Cheers

Justin

but i think we'll need to move invoice number away from being an auto increment primary key field (in si_invoices) soon to achieve some of the other stuff we want to do

Cheers

Justin

this will be possible with the new custom-field system without a problem. so don't worry :-D

cool,

thanks aplysia

cheers

justin

Ok, the invoice number stuff is in the repositorie now. Please check out the newest svn-version and test it...

Cool!! Is it pretty stable?

I just hope so. But still need some testing. I think it won't make it in the next release, because first we also have to write a conversion script to import the fields from the old system.