I need to reset my SambaPOS V2.99 database and investigated the following link to find the solution.
http://forum2.sambapos.org/index.php/topic,60.msg251.html
In the above link it states that: " I attached a SQL Script for you to clear all transaction data from database. If you run this script it will keep your settings but clear all tickets, work periods etc. " I cannot find any attached script in this post. Also had a quick look at the files in the SambaPos folder but nothing came to mind.