I need to add a custom invoice number to my orders in addition to the order ID. I have already modified the order table but for the life of me I can not figure out where to place the code for inserting the invoice number. The field in the table is indexed.

Can you advise me as to where I would want this modification?

Thanks