How To Clear Only Transaction Data

Version 4 V4 Question
1

I Need to Clear Only my transaction Data. I don’t want to loose my menu and customer info. SambaPOS seems to lag when there are to many work period history.

2

Sambapos should work just fine even if you had million transactions.
Any way you can erased transactions using database tools module.
Install this module from sambamarket.

1 Like
3

Are you using CE databse?
I had lag when first starting using CE, if you are, I recommend switching to SQL Express, much better, never looked back :smile:

2 Likes
4

Hello,

Please i also want to clear the database and leave the configurations for my new branch.

But i am unable to buy the database tools because of the payment mode.

Please help me if you can

Thanks

5

Can you explain what your problem is?

6

I mean i am unable to purchase the database tools to carry out clearing of transactions because paypal doesnt work in my country.

Can you help me with a procedure to delete transactions using the management studio?

Thanks

7

SQL:

DELETE FROM [TicketEntities]
GO
DELETE FROM [Tickets]
GO
DELETE FROM [AccountTransactionDocuments]
GO
DELETE FROM [AccountTransactions]
GO
DELETE FROM [AccountTransactionValues]
GO
DELETE FROM [Calculations]
GO
DELETE FROM [CostItems]
GO
DELETE FROM [InventoryTransactionDocuments]
GO
DELETE FROM [InventoryTransactions]
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
4 Likes
8

@ QMcKay,

Thank you very much . All transactions are off

Thanks again for your help

1 Like