Reset the ticket number.

User-to-User general discussions regarding POS Pizza
Member
Posts: 28
Joined: Sat Jul 30, 2005 10:30 am

Reset the ticket number.

Postby hho » Sat Nov 19, 2005 10:10 pm

Scott:

The ticket number is increment daily, how do I reset the ticket number.

Thanks
Hung

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Postby Scott » Mon Nov 21, 2005 9:59 am

You will definitely have dupe numbers (not duped orders) if you reset the ticket numbers. You will also not be able to lookup a customer's previous 3 orders from the POS station.

You can reset the ticket numbers by going into the Management Utility program and going to the "File" menu then "System Config", and then choosing the "Order Handling" tab. On this page, click the "Change" button right next to the "Last Order Number Used" indicator.

Scott

Pizza Roma

Re: Reset the ticket number.

Postby Pizza Roma » Thu Apr 03, 2014 4:10 am

Hi Scott, how are ticket numbers reset in V6? I can't seem to find the referenced 'Order Handling' tab in the Global System Config menu

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Reset the ticket number.

Postby Scott » Thu Apr 03, 2014 7:03 am

Pizza Roma wrote:Hi Scott, how are ticket numbers reset in V6? I can't seem to find the referenced 'Order Handling' tab in the Global System Config menu


In version 6 they are not editable as they are part of the indexing system that allows v6 to reprint past orders, edit past orders etc. Version 5 did not have this since it moved current orders to historical orders on a daily basis.

Scott

Member
Posts: 6
Joined: Mon Dec 23, 2013 12:38 am
Location: MA, USA

Re: Reset the ticket number.

Postby TGates » Tue Apr 07, 2015 4:41 pm

In a way this answers my question. Yet on another note, I have purged the database of all previous orders, etc. and it would be nice to be able to reset the order numbers also in this situation. Fully starting fresh with out hurting any menu or configurations.

Or, is there a way to edit the DB to accomplish this?

Thanks, Tom

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Reset the ticket number.

Postby Scott » Wed Apr 08, 2015 6:49 am

You will need a 3rd party SQLite editor to do this. Something like SQLite Expert would do the trick. Open the database and remove the entry pos_pizza_lastordnum from the main_cfgs_tbl table.

WARNING: Do this only if there are NO ORDERS in the database!

Use extreme caution when using 3rd party editors on the POS Pizza database. We cannot support damage caused by these editors.

Also if you are using the CS version, stop the server before editing the database file with an external editor.

Scott

Member
Posts: 6
Joined: Mon Dec 23, 2013 12:38 am
Location: MA, USA

Re: Reset the ticket number.

Postby TGates » Fri Apr 10, 2015 1:59 pm

Thanks Scott, this is what I was looking for.

-Tom

Return to General Information about v5

Who is online

Users browsing this forum: No registered users and 1 guest