0
Hi, how to reset the Sale No ?
not reference number or order_ref
0
Do you mean, Sale ID?
0
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
I have no sales, sma_sales is empty but when I make a sale the invoice number starts from 72
0
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.