Magento - custom invoice number

Question

I need to modify my default invoice number from 100000001 to 2012 - 00001.

I know where I can found increment_last_id in table eav_entity_store. But I don't know what I must set that to be taken new format of invoice number.

Please help with some advice.

Answer 1

If you want to do it manually then take a look @ How to Change the Invoice Increment ID and Prefix in Magento (remember to always make a backup)