How To Reset The Sale No

0

Hi, how to reset the Sale No ?
not reference number or order_ref

Question Resolved For: Stock Manager Advance with All Modules 0 Votes 4 Answers 232 Views
Asked by Mehdi boudhir 3 years ago

0

Answered by Enyinnaya Gift 3 years ago

Do you mean, Sale ID?

0

Answered by Mian Saleem 3 years ago

Hello,

The sale number is the sma_sales table AI. If you have sales, you can't reset it. Otherwise feel free to update your database table as you need.

Thank you

0

Answered by Mehdi boudhir 3 years ago

I have no sales, sma_sales is empty but when I make a sale the invoice number starts from 72

0

Answered by Mian Saleem 3 years ago

Hello,

Table AI won't be reset if you delete records.

You will need to reset it manually on your table. This isn't anything that is related to SMA but your database. You can reset it as you like. There could be multiple way to doing this, delete table and creating it again or truncate it or alter to update.

ALTER TABLE `sma_sales` AUTO_INCREMENT = 1;

OR truncate table

TRUNCATE TABLE `sma_sales`;

Thank you

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.