Hi @Jesse ,
One of our customers has noticed that some of the ticket numbers are missing while creating new tickets. When tried I got the same that some ticket numbers are missing while creating new. we are not deleting any transaction and all. Could you help me to resolve this am attaching the screenshot with this and if you want DB backup I can message you.
Thank you.
Is it possible that those tickets were deleted or merged into other tickets?
Merge.
Cancelled.
You can get skipped ticket numbers as they are generated at ticket creation. So canceling all orders would result in skipped ticket.
Ticket ID will not skip numbers as they are generated on submission to db however you can get empty/0 value tickets for ticket id following a merge/moving all orders away
You a full void would leave 0 value but still have orders.
No we didn’t cancelled and merged
We didn’t do merging and cancellation.
And how the ticket number is skipping ?
Well cancel and merge are default buttons, have you actually removed them? Never presume staff dont do something because you told them not to.
As I already said, ticket number is generated on ticket creation, unlike ticket ID which is on DB save/submittion.
Ticket ID will always have a ticket although possibly nill value.
Ticket number can have skips, typically for the reason outlined above.
Hello @alvin,
Can you show your printing actions? Update Ticket Number field is not supposed to be set as True if it is so change it back to blank. You can see attached images for referance.
Main Menu > Manage > Automation > Actions > Execute Bill Print Job
Main Menu > Manage > Automation > Actions > Execute Kitchen Orders Print Job
Hi @Nizam,
Thank you for your reply.
I havn’t made True for Update Ticket Number for both print bill and Kitchen order print.
This can happen if you start a ticket on a terminal and another waiter starts a ticket on a different terminal at the same time and the first person cancels the order. There is something your not telling us specific to this.
It wont just skip ticket numbers there is always a reason.
Hi @Jesse,
Thanks for your reply.
We are using one terminal only. Anyway I have send the DB to Nizam
Click on Number field to sort by Number, I have notice that the tickets are sorted by Op-Cls by default, if someone merged a ticket or something else I think that the missing number should be at the bottom
Hello @alvin
I got a problem the same to you. My ticket number has skipped !
Did you solve you issue yet? if yes, please some idea. Thanks team.
This wont change for default ticket number, it is applied at ticket creation.
Maybe look to change to ticket Id instead. However while you wont get skipped ticket ids you may get 0 value is all voided or when merging tickets.
It was resolved for him. He had Update Ticket Number in the action set to blank. That was set to False and actions added back to appropriate rules.
But this may not be the same issue as @Sunday_Thuok is having. We need to know more about the system.
Voiding entire tickets can cause it for example.
Hello@Jesse
Thank you, I am check it and change it to False.
Hello team,
After I following your guideline suggestion (Also please check Update Ticket Number part of Execute Print Job and Execute Kitchen Orders Print Job Actions, it should be set to False.)
I notice that some of receipt do not have ticket number. You can see in the attach picture.
Give me some idea and solutions!
Thanks in advance.
Show your ticket template please.
[LAYOUT]
-- Bill 01
<div style="font-size:12px;font-family:Calibri;text-align: center;">
<BMP>C:\Users\POS\Documents\SambaPOS5\index1.jpg
<div style="font-size:12px;font-family:Calibri;text-align: center;">
<div style="font-size: 15px; font-weight: bold">SIEM REAP SOURCE CAFE</div>
<div style="font-size: 20px; font-weight: bold;margin-top: 10px">Reciept</div>
</div>
<div style="font-size:12px;font-family:Calibri;text-align: left;">
-- <div>Order Method: {TICKET TAG: Order Method}</div>
<div>Ticket No: #{TICKET NO} Date:{TICKET DATE} {TICKET TIME}</div>
<div>Cashier: {USER NAME} {ENTITIES}</div>
</table>
</div>
<div style="font-size:11px;font-family:Calibri;background: black">
<table>
<tr>
<td width=150><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Description</div></td>
<td width=30 align=center><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Qty</div></td>
<td width=40 align=center><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Price</div></td>
<td width=50 align=center><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Total</div></td>
</tr>
{ORDERS}
</table>
<div style="font-size:13px;">
<table>
<tbody>
<tr>
<td colspan="2">------------------------------------------------------------------</td>
<td></td>
</tr>
<tr>
<td align=Left><span style="width:150px">Sub-Total </span></td>
<td align=Right><div style="padding-right: 5px;">$ {PLAIN TOTAL: }</div></td>
</tr>
{DISCOUNTS}
{TAXES}
<tr>
<td align=Left>GRAND TOTAL(USD)</td>
<td align=Right><div style="padding-right: 5px;">$ <span style="float:right; background-color: #000;color:#fff;font-weight:bold">{TICKET TOTAL}</span></div></td>
</tr>
<tr>
<td align=Left>GRAND TOTAL(RIEL)</td>
<td align=Right><div style="padding-right: 5px;">R <span style="background-color: #000;color:#fff;font-weight:bold"> [=F(TN('{TICKET TOTAL}')*4000,'#,##0.##')] </span></div></td>
</tr>
<tr>
<td align=Left>Recieved {PAYMENTS}</td>
<td align=Right><div style="padding-right: 5px;">{TENDERED TOTAL}</div></td>
</tr>
<tr>
<td align=Left>Change</td>
<td align=Right><div style="padding-right: 5px;">{CHANGE TOTAL}</div></td>
</tr>
</tbody>
</table>
<div>--------------------------------------------------------------------</div>
</div>
<div style="font-size:12px;font-family:Calibri;text-align: center;">
<div>NOTE: We accept cash only & regret that we are unable to eccept damages US dollar bills, $2 bills and bill older than 1995. 10% VAT tax is included!</div>
<div style="font-size:9px;font-family:Calibri;background: black">
<div>---POWER BY: IDATA SOLUTION---</div>
[ORDERS]
-- Default format for orders
<tr>
<td width=150 align=Left>- {NAME}</td>
<td width=30 align=center>{QUANTITY}</td>
<td width=40 align=center>{PRICE}</td>
<td width=50 align=center>{TOTAL AMOUNT}</td>
</tr>
{ORDER TAGS}
[ORDER TAGS]
-- Format for order tags
<tr>
<td width=120 align=Left> * {ORDER TAG NAME}</td>
</tr>
[ORDERS:Void]
-- Nothing will print for void lines
[ORDERS:Gift]
-- Nothing will print for void lines
<tr>
<td width=150 align=Left>- {NAME}</td>
<td width=30 align=center>{QUANTITY}</td>
<td width=40 align=center>{PRICE}</td>
<td width=50 align=center>**Gift**</td>
</tr>
[ENTITIES:Table]
-- Table entity format
<L00>Table: {ENTITY NAME}
<tr>
<td align=Left>Recieved</td>
<td align=Right><div style="padding-right: 5px;">{TENDERED TOTAL}</div></td>
</tr>
[DISCOUNTS]
<tr>
<td width=200 align=Left>{CALCULATION NAME} ({CALCULATION AMOUNT}%)</td>
<td align=Right width=50><div style="padding-right: 5px;">{CALCULATION TOTAL}</div></td>
</tr>
--- [TAXES]
<tr>
<td align=Left>VAT 10%</td>
<td align=Right><div style="padding-right: 5px;">{TAX TOTAL}</div></td>
</tr>
[PAYMENTS]
-- Payment Type entity format
({PAYMENT NAME})
When you pull the ticket up in ticket explorer what ticket number does it show.
When is the ticket printed?