Simple Invoices - Forum

When editing an existing consulting type invoice I cannot add or remove invoice items.

Yes this is something needs correcting.

and thus one ends up with mulitple unwanted invoices.

Thats the idea. To keep track of invoices sent and payments made to respective invoices. Oh but you mean when you either make a mistake in the invoice you can't correct or want to add more to the invoice you can't! Hence the invoice is useless and you have to create another.

I think allowing the invoices to be fully edited is the way forward.

Also after my first tests I tried to clean up the DB by hand but could not re-initialise the invoice numbers to zero to start with a fresh list.

The invoice id's, client id's auto increment. This is an absolute must in order for the records to stay unique and the data to stay relational.
If you start changing numbers around you're gonna be in trouble.

You can empty tables or the SI database to clear it our completely but you must then run the flush command to reset the auto increment column back to beginning. WARNING! Doing this will wipe all data from your tables/database. Do it at your own risk!

Maybe one solution would be to have # status : "draft", "final", "sent",.. and the invoice would have a number only at final stage.

Possibly but then if you create an invoice and never send it, why would the invoice/number ever enter in to your paperwork!!

Yes a status column is something that needs implementing! Hopefully someone will do it. I've also considered having the invoices remove themselves from the 'manage invoices' screen when the have been paid.
They would still be accessible but from another menu link e.g. Paid Invoices.

I don't really need to run report at this stage but when testing it I've the red error oops message and I've the php-xsl package for PHP5 installed.

Do a search in the forums for more info.
However chances are it's working okay. Try pulling a report up, if you get data it's working and the error is temporary err.... lets call it a glitch!!

Regards

Danny

Hey Guys

Danny - thanks for the great reply

Catherine
re - When editing an existing consulting type invoice I cannot add or remove invoice items.
-- yep, this is planned for the future

re - reports
-- refer: http://simpleinvoices.org/forum/topic.php?id=87
-- you'll get the message even if you have xsl installed - hopefully i can adjust this in the future

re - but could not re-initialise the invoice numbers to zero to start with a fresh list.
-- if you open phpMyAdmin and in the table you want to re-initialise, go into the Operations section and change the auto-increment back to 0 (or whatever you want) (note: make sure there are no items in that table that could conflict with the new numbering format)

re - It would be great to be able to change the invoices numbers and date (if allowed in the general parameters).
-- re invoice number
--- refer: http://simpleinvoices.org/forum/topic.php?post=245#post245
--- and http://simpleinvoices.org/forum/topic.php?id=104
-- re date
--- when creating and editing an invoice you can choose whatever date you want for the invoice - from the calendar icon
---- let me know if your referring to something else

re - Maybe one solution would be to have # status : "draft", "final", "sent",.. and the invoice would have a number only at final stage.
-- ive been thinking about implementing different statuses for invoices for awhile but am not convinced yet- still think about it thought :)

Cheers

Justin

Thats fantastic, I was thinking the same thing :) With status being draft, final, and sent, I was thinking if it gets implemented to have traffic lights indicating its status (green being sent, red being draft :P ). Bit of a far flung thing but yeah.

Hey Guys

re status

refer: http://code.google.com/p/simpleinvoices/issues/detail?id=62
im still thinking about this so there no guarantee it'll get done soon - but in the long term it probably will as an add-on

still thinking :)

Cheers

Justin