mcsg Posted February 18, 2021 Posted February 18, 2021 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?
Solution CoffeeCake Posted February 18, 2021 Solution Posted February 18, 2021 (edited) 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, 2021 by Paul E. Maybe, just a guess. bfarber 1
mcsg Posted February 18, 2021 Author Posted February 18, 2021 Yes! Of course! Thanks @Paul E.! ALTER TABLE nexus_invoices AUTO_INCREMENT=1001; The most elegant and simple method. Thanks.
Recommended Posts