Reset invoice number

Request for general support related to Logic Invoice.
gabomazzotti
Posts: 9
Joined: Tue Aug 30, 2016 10:09 am

Reset invoice number

Postby gabomazzotti » Sat Nov 19, 2016 4:39 am

Hello,
I need to reset the invoice number, I deleted all the invoices and serched for the last invoice number on the DB (and delete all the result) but the invoice number continues to be as before, How can I reset it to 1?

User avatar
Esmond
Site Admin
Posts: 241
Joined: Tue Sep 15, 2015 3:08 pm
Location: Singapore
Contact:

Re: Reset invoice number

Postby Esmond » Sat Nov 19, 2016 8:37 am

Run the SQL query below. Remember to change the table name to your table name accordingly with the DB prefix.

Code: Select all

ALTER TABLE invoice AUTO_INCREMENT=1;

gabomazzotti
Posts: 9
Joined: Tue Aug 30, 2016 10:09 am

Re: Reset invoice number

Postby gabomazzotti » Thu Dec 01, 2016 11:50 pm

it worked perfect

Thanks!


Return to “General Support”

Who is online

Users browsing this forum: No registered users and 1 guest