Jump to content

Community

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


Go to solution Solved by Paul E.,

Recommended Posts

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?

Link to post
Share on other sites
  • 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.
Link to post
Share on other sites
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy