Simple Invoices - Forum

berniberni

Hi, i have made the workaround suggested in this post by Ruben and worked fine... http://simpleinvoices.org/forum/discussion/237/
Unfortunately, I typed a too long number, so now, my invoice number looks like this: 20100007

The Invoice standard view, cant' show the full number and hide the last digit.
I can manually enlarge the column but it is frustraing... all the times.

How can I re-edit the last invoice number in order to shorten the number? I would like to delete the firs 2 digits

I try editing the database:

Mysql admin... si_invoices... shows 20100007 and edited the ID of the last invoice like this: 100007

But making a new invoice, the new invoice number is, again , 20100008 (with the initial "20")

How can I fix it?

Bye bye
berber

justin

hey berber

you can go back into phpmyadmin and change the autoincrement to 20100

this will fix it for new invoices

wont fix it for old invoices :(

cheers

justin

berniberni

Tks a lot.

I have some trouble editing the autoincrement field because with phpmyadmin I can't find this option.

I can find:

si_invoices table... and the "id" line with an extra filed auto_increment.

I can edit the value in the ID filed, but can't touch the auto_increment filed

Can you give me some one more ints to edit this variable?

Bye bye

justin

hey berniberni

if you go to the 'Operations' tab in phpMyAdmin you will see a 'table options' section

here you can alter the auto-increment

let us know how you go

cheers

justin

Simple Invoices - Forum

Categories