Hey everyone,
I hate using the tag URGENT, but we’re set to go live this night. However, from testing, there’s still a ton of fake transaction I need to clear from the system in order to get running properly, and not have a fight with the IRS 
Since rebuilding the database tasks does not seem to work, I can’t run the task that is supposed to clear all transactions. I also tried using the .txt file for clearing sales, but no luck.
Does anyone have a importable .sql .bat or .vbs database task file for me that clears all transactions. I know it’s there when you rebuild the default tasks, but somehow it won’t on my system.
Thanks in advance,
Diego
DELETE FROM [TicketEntities]
GO
DELETE FROM [Tickets]
GO
DELETE FROM [CostItems]
GO
DELETE FROM [InventoryTransactionDocuments]
GO
DELETE FROM [InventoryTransactions]
GO
DELETE FROM [AccountTransactionDocuments]
GO
DELETE FROM [AccountTransactions]
GO
DELETE FROM [AccountTransactionValues]
GO
DELETE FROM [Calculations]
GO
DELETE FROM [Orders]
GO
DELETE FROM [PaidItems]
GO
DELETE FROM [PeriodicConsumptionItems]
GO
DELETE FROM [PeriodicConsumptions]
GO
DELETE FROM [ProductTimerValues]
GO
DELETE FROM [Payments]
GO
DELETE FROM [WarehouseConsumptions]
GO
DELETE FROM [WorkPeriods]
GO
UPDATE [Numerators] SET [Number] = 0
GO
UPDATE [EntityStateValues] SET
[EntityStates] = '[{"S":"Available","SN":"Status"}]'
WHERE [EntityStates] like '%Status%'
GO
Clear Database Transactions is a SQL file that contains the script shown at the top of my post, and the Tasks you see in the Database Tools section are stored in the following location:
[Documents]\SambaPOS5\Database Tasks
C:\Users\USERNAME\Documents\SambaPOS5\Database Tasks
1 Like
Thanks man,
Pasting it in notepad, save as .sql, and putting it in the SAMBAPOS5 Database tasks folder under My Documents was all it took.
You saved a life today 0:-)
