Reset Invoice Number
0
Hello, I am trying to reset the invoice numbers without reinstalling the system. I have looked at the database, but I can`t figure out how to do it. I have set up the settings to auto-increment (MySQL), starting the invoice from 1, 2, etc. The problem is that when I begin to create invoices for testing, it will auto-increment. In real business, this needs to be reset to 1, as I may have 5 invoices for testing that are deleted, leading to the invoice itself showing number 6 in real business.
Can you please guide me on how to do this?
Regards
0
Hello,
The invoice number are saved in the settings and companies tables.
Please check the columns for invoice_number, quotation_number & payment_number
Thank you
Instantly elevate your business, earn more money, attract more clients, and deliver exceptional digital experiences. Tecdiary is the leading independent provider of inventory & e-commerce solutions for digital experiences. What sets our solution apart for partners is our modular, flexible architecture and customizable licensing model. With Tecdiary, partners are free to build, customize, and extend the platform to create amazing digital experiences for your individual clients or to support your own packaged solution.
We use Cookies
We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.