Resetting ticket number


#1

hellow, im trying to reset the ticket number following this emre method:
but…it doesnt reset the number generator…im using sambapos in spanish…i have also try to set the "where name = " to my column table name that is is spanish but it also doesnt work…any idea why?
Or any other method please

Yes you can use database tools.

  • Open [MyDocuments]\SambaPOS4\Database Tasks folder.
  • Create a new file and name it as [CBL]Reset Ticket Number Generator.sql . Be sure it’s extension is .sql

  • Edit that file with a text editor (notepad) add that script and save it.

Update Numerators set Number = 29119 where Name = 'Ticket Number Generator'

  • When you open database tools you should see your script listed here. Be sure Task Type is SQL.

Click on that task and click Execute Task button.

With that method you can run any sql snippet we release here.

Note: For anyone interested [CBL] part means C onfirm, B ackup, L ogout and you can execute tasks with Execute Database Task action.


#2

Do you really want to set the Ticket Number to 29119 ?


#3

i have tried “29119” “1” “10” a bunch of numbers but with no luck.


#4

the number is not the problem…the problem is that it doesnt work :(, i just want to ressetit to 0.


#5

zero (0) or one(1) its my goal


#6

Show the table in SQL for numerator.


#7

Did you see this? You should not use this to reset to 0


#8

@Jesse

i have tried “29119” “1” “10” a bunch of numbers but with no luck

.


#9


#10


#11

Why are you wanting this?