Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 18, 20214 yr Our client would like to use a different number scheme for Invoice Numbers. Still numbers, but they do not want to start from 1. Is is possible to modify the starting Invoice number? Or perhaps a plugin/hook that allows this?
February 18, 20213 yr Solution This is probably an incrementing ID, controlled by MySQL. If so, you can run the following operation on whatever the invoice table is: ALTER TABLE wherever_invoices_live AUTO_INCREMENT = 999999; Where 999999 is the number you'd like to start from. Backup everything first. Then back it up again. Just in case. Edited February 18, 20213 yr by Paul E. Maybe, just a guess.
February 18, 20213 yr Author Yes! Of course! Thanks @Paul E.! ALTER TABLE nexus_invoices AUTO_INCREMENT=1001; The most elegant and simple method. Thanks.