Let me explain, I wanted to have a separate number for Invoices, as in a document with sequential number that will be given to the client only when asked, so its different from ticket number.
What I did was a setup where I add orders, add a client and at the end you print the bill and client verifies that everything is correct. When ticket is locked a button is activated to CONVERT TICKET to Invoice, it just changes ticket status to Invoice and hides the convert button, and adds a TICKET TAG called InvoiceNumber.
Now this ticket tag is unmapped and clean, and the automation command CONVERT TICKET has another action that Updates Program Setting and rises ticket tag by 1 every time its clicked.
So far everything is perfect. I tested. It works and all marvelous. Now I want to reset ticket tag number back to zero… but cant find it… should I do it directly in database?