Is it possible to change the Invoice Number used in Nexus?

[mcsg]

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?

[CoffeeCake]

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.

[mcsg]

Yes! Of course! Thanks @Paul E.!

ALTER TABLE nexus_invoices AUTO_INCREMENT=1001;

The most elegant and simple method. Thanks.