I need to reset the ticket count
just 1 time i found ways to do it with sql, but my samba pos is a standalone and not using the sql multiuser install
how can i do this ? is it even possible or would i just have to reset the whole thing all together
thank you in advance for the help.
You would need to clear transactions else you would have clashing of ticket numbers between old and new tickets.
Pretty sure clear database transactions does this but you will loose sales data. Products etc will NOT be cleared with that tool.
it ok if i delete all transaction.
but now the problem is this:
i dont have that option
if i am running with no sql
how can i delete the transactions
Maybe not then… not sure, never really used options other than SQL but thought these worked with CE database… Sure your not using TEXT.
What shows in header if you double click on samba logo in top left?
hmmmm
this is what shows on my samba install
seems like its using SQ but then why wont it let me install the extension
The paid modules are all greyed out, not sure if its because your logged in and haven’t paid for them… never noticed that before if it is the case but my dev machine im not all the time is never logged in.
On version 4 you must pay for the modules first at www.sambamarket.com then logout and restart sambapos and log back in and activate/install them. Version 5 license includes all those modules for free.
The module you need is Database Tools. Or just run this sql script in MSSMS.
DELETE FROM [TicketEntities]
GO
DELETE FROM [Tickets]
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 [CostItems]
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
DELETE FROM [Tasks]
GO
UPDATE [Numerators] SET Number = 0
GO
UPDATE [EntityStateValues] SET EntityStates = '[{"S":"Available","SN":"Status"}]' Where EntityStates like '%Status%'
GO
Was able to install the extansion like you said and worked perfectly.
Thank you very much for your help.