Cannot end work period---Resolved

V5 Question
1

Hi

one of the user couldnt end work period . saying 2 open ticket .

i checked there are no open ticket.

what else can i do and see ?

thanks

POS: 5.1.59
DB: sql 2014

2

Back date in ticket viewer. First try 1 day back. Then 1 week back then 1 month back. You should definitely find it

3

i have already did that cant find any open ticket …

i have checked from database also there doesnt seem to be any open ticket

4

someone might messed up tickets. ticket may be mark as paid but may be not mark as closed. In database you may look for isClosed

5

i have checked all are marked as isclosed =1
but there were 3 tickets which show islocked = 0

6

Sorry, maybe isLocked I confused lol.

7

no you are correct i run the query for start till today

found 2 entry with isclosed = 0

somebody modified the 2015 ticket in 2017

so showing 2 open ticket

8

let me summarize:

error shown: there are 2 open ticket can not close work period

Troubleshoot:

  1. check under ticket module for open ticket
    if cannot find keep for that period than
    check from starting of POS till to date for any open ticket.

for those who know sql you may run the query:

SELECT *
FROM [SambaPOS5].[dbo].[Tickets]
where IsClosed=0

this will show all the open ticket since starting of time till to date.

the purpose for checking from starting time is sometime user might go and reopen a ticket and do some action which may cause the ticket to remain open
or the system date might be change

for either case it is best to check from starting time till to date.

Resolve:

once open ticket are found

goto ticket module

open the ticket and close it meaning settle the payment and it will be closed

thanks