How to clear account details

Every month i have to clear all my account detail and now i have installed data base tools also .So please show the procedure to clear account


First click on Create Default task Then on the task that was created and click the execute Task
You’ll notice that it will erase all your transactions
It is highly recommended to create a backup before

1 Like

Lot of thanks its working it cleared all my old transaction in sambapos 4.But in samba pos 3 I am not getting
Data base tool why ?

I guess Database tools module designed for v.4

1 Like

Clear Database Transactions is a simple SQL script that you can run against V3 or V4. It looks like this:

DELETE FROM [TicketEntities];
 
DELETE FROM [Tickets];
 
DELETE FROM [AccountTransactionDocuments];
 
DELETE FROM [AccountTransactions];
 
DELETE FROM [AccountTransactionValues];
 
DELETE FROM [Calculations];
 
DELETE FROM [CostItems];
 
DELETE FROM [InventoryTransactionDocuments];
 
DELETE FROM [InventoryTransactions];
 
DELETE FROM [Orders];
 
DELETE FROM [PaidItems];
 
DELETE FROM [PeriodicConsumptionItems];
 
DELETE FROM [PeriodicConsumptions];
 
DELETE FROM [ProductTimerValues];
 
DELETE FROM [Payments];
 
DELETE FROM [WarehouseConsumptions];
 
DELETE FROM [WorkPeriods];
 
UPDATE [Numerators] SET Number = 0;
 
UPDATE [EntityStateValues] SET EntityStates = '[{"S":"Available","SN":"Status"}]' Where EntityStates like '%Status%';

Paste the script into a Query Editor and execute it.

2 Likes

This script doesn’t worked on pos3

What do you mean by “doesn’t work”? In fact it does work. The Query was written during development of V3 (or V2), before V4 even existed.

Are you getting an error? Are the results not what you want or expect? You need to elaborate on “doesn’t work”.

OK sir If you show step by step in sambapos v3 its easy for us to configure.
I pasted this script on notepad and tried to execute it. Sorry in fact I didn’t know this script was written during V3 development

Which DB Engine are you running? CE or Express? You need to execute it from a Query Editor. Notepad has no such functionality.

SQL Express : use Management Studio
CE : use Compact Query Analyzer

1 Like