I’d like to put all the data in zero (tickets) without erasing the configuration, articules menus tables mozo. Just data related to sales before done. How shlould proced? thanks.

[image] Delete Transaction History after Testing V5 Question In your Documents folder on C drive go to SambaPOS5/Database Tasks folder. Insert your SQL Scripts there. Name them [CBL]scriptname.sql you can create them in Notepad then just save them as format i just show…

You could purchase database tools module and use clear transactions. Or you can use sql to do it. With version 5 database tools module is included free.

Here is the SQL Script. If you dont want to reset Work Period ID just remove the last line in script. DELETE FROM [TicketEntities] GO DELETE FROM [Tickets] GO DELETE FROM [InventoryTransactionDocuments] GO DELETE FROM [InventoryTransactions] GO DELETE FROM [AccountTransactionDocuments] GO DELETE FR…

Thanks Kendash i will try it but now i have another problems . i was luking in the forum but i did not any change yet i dont know wath is happenning the issue is: [General Info] Application: SambaPOS Version: 4.1.82 Region: en DB: SQ Machine: ZODIAKO-ACER User: …

[image] Aldop84: but i did not any change yet i Well SambaPOS doesn’t just randomly do this. You must have done something. It looks like it timed out trying to execute something.

yes you are right. i said that in order to tell you that i didnt try yours previous recomendations about to put the base in zero. Actually, yesterday i delete one items and adde one and changed some prices. But nothing important, at least i think that and thank you for being such quick answering…

I have the Database tools but i cant find the option “Clear transactions”

Should be a button at bottom to create default tasks.

Seting the database to zero without deleting the configuration

Version 4

sukasem September 18, 2016, 12:13am 2