Jump to content

Featured Replies

Posted

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?

Solved by CoffeeCake

Go to solution
  • 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 by Paul E.
Maybe, just a guess.

  • Author

Yes! Of course! Thanks @Paul E.!

ALTER TABLE nexus_invoices AUTO_INCREMENT=1001;

The most elegant and simple method. Thanks.

 

Recently Browsing 0

  • No registered users viewing this page.