Ticket missing from POS. I have ticket printed

[na1978]

Has anyone else experienced missing tickets after they were printed. I have a ticket number 14949 that went missing. The server had a printed copy. Ticket total was about $40. My cash drawer was short by the exact amount.

I searched the forum and found one instance which is identical to mine. @WingoLED have you exprienced this again?

Did anyone experience missing ticket even though it is printed?

I just run into a strange issue which I have not completely investigated. I have a ticket say 1965 PRINTED but it is no where to be found in the the ticket listers. Note: It is not a simple skipping Ticket No which I understand why. Ticket 1965 is printed and order made plus being paid, but this Ticket No. seems not in the system anymore. The final total in report also reflects the balance of the missing record not the proper total. Any suggestion where to look or what had happened? I will…

I ran the query that was suggested and ticket 14949 is missing from database.

Any idea how to fix it or prevent it from happening again or should I just ignore it as a anomaly since I have never seen this before.

Thanks in advance for your help.

[Jesse]

Likely the issue is related to communication between SQL server and local cache. Something happened that interrupted it.

I think it’s safe to say your ok but keep watching just in case. It seems to be very ultra rare and we don’t have enough info to understand it yet.

[JTRTech]

Your not manipulating ticket dates anywhere are you?
Have you tried used WHERE [TICKETNumber] = 14949 without the date filter?

[Jesse]

Yes check all possible dates for that ticket it is possible a clock got changed however I have my doubts that is it.

[na1978]

Thanks Kendash. It is pretty weird, ticket went in the kitchen, it was printed and it disappeared. Total for the day was short by the exact amount of this ticket. My SQL database is eating up my tickets.

[na1978]

Thanks JTRTech,

I have not done anything with dates. I ran the query to find that ticket number, but it did not return anything.

[na1978]

Kendash and JTRTech, thank you both for all the help you give here. I call this a SQL glitch.

[QMcKay]

@na1978

I ran the query to find that ticket number, but it did not return anything.

Your query shows looking for 149489 instead of 14949

[na1978]

Thanks QMcKay.

I was trying different numbers and posted the wrong picture. I ran the query again with same result.

[WingoLED]

I did not run into the same issue after that particular case and so far I have not been able to locate that ticket due to my work load in my shop. Sorry that I cannot give any more information about this as my cashier is also a person who is unable to relate the sequence of what she has done and/or what strange(or not strange) things leading to it.

[na1978]

Thanks WingoLED for your feedback. I have been using SambaPOS for awhile now and this is the first instance of this problem. I think, we can just ignore it as a SQL anomaly.