February 18, 2021 in Technical Problems
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?
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.
Yes! Of course! Thanks @Paul E.!
ALTER TABLE nexus_invoices AUTO_INCREMENT=1001;
The most elegant and simple method. Thanks.
Started 18 hours ago
Started January 23
Started 4 hours ago