Tools to put ticket number on zero

Version 4
1

I have configured Sambapos and made some test orders to see that everything is Ok. It is working well. Now it is time to work. How its is possible to put tickets number on zero? I mean delete all order and tickets… and beginning from a clean page? Maybe a tool from Sambapos Market?

I would like to end workperiod and i have this message. I dont find this open tickets to close them. Under tickets aren’t there.

2

Under tickets yoi can filter to “open” and it will show the 5 tickets you need to settle

There is an sql task in samba that you can run and it will clear al transactions (tickets, inventort purchases, accounts etc etc)

Think you need to download the database tools module from samba market within the pos

3 
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
1 Like
4

Thank you for Reply.
Under Ticket I have filtered all options, it is coming nothing.

Pasted image1866×181 13.7 KB

Under all tickets I see following, all tickets:

Pasted image1047×935 150 KB

5

Change the dates and make sure they are not from yesterday, the date will default to today.
Clearing transaction history with task or kendash SQL script will delete these open tickets anyway.

1 Like
6

I have changed, it must shows normally.

                    23.12 2016 - 23.12.2016
                    23.12.2016 - 24.12.2016
7

I have installed Databse Tools from Market and executed “Clear Database Transaction” Now all orders and Payments are deleted My first ticket is coming now with number 1 . Perfect!

On Payment Screen,it is possible to translate this some words or they are hardcoded ?

Pasted image1232×986 72.3 KB

8

Accounts > Document Types.
Change the headers to translate these buttons.

9

Wouldn’t it be the payment selector headers?

1 Like
10

Sorry, it shouldn’t be done from payment selectors or document types.
Payment Selectors changes commands under numberpad that on settle screen.

@dcelik you can change it from Ticket > Payment Types

2 Likes