How to clear account details

[shreekanth]

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

[pizzaeilat4]

How to use Database Tools Module

Database Tools Module is an Add On Module for SambaPOS. You can install it through SambaMarket. When you install Database Tools Module Database Tools link will appear under Management > Settings section. ##Database Tasks [image] On the main screen you can see Database Tasks screen. You can select an action from the list and click Execute Task to start the task. I’ll give more details about Database Tasks at the end of this tutorial. ##Tools [image] On tools screen there are two use…

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

[shreekanth]

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 ?

[pizzaeilat4]

I guess Database tools module designed for v.4

[QMcKay]

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.

[shreekanth]

This script doesn’t worked on pos3

[QMcKay]

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”.

[shreekanth]

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

[QMcKay]

@QMcKay

Paste the script into a Query Editor and execute it.

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