Auto Increment Order Number

[planetsolutions]

Hi

I have an auto increment order number which resets at work period end. Can any one help me with

1. How to prevent number gets duplicated rarely when tickets are added from different terminals
2. Is there a possibility to build a screen (like enitity screen) where these auto incremented order numbers get listed and from the main counter the user can click and go to the particular ticket and settle

[Jesse]

We need to see how you implemented it to suggest options.

[planetsolutions]

With the help detailed on https://forum2.sambapos.org/index.php/topic,97.msg671.html#msg671

[anasjalak]

did you get a solution

[Memo]

Here’s something I put together for an order number sequence that you can reset:

After ending a work period then starting a new one the order numbers are continuing instead of starting from 1

Here’s a script for a sequence with floating zeros: function get() { var q = "SELECT Value From dbo.ProgramSettingValues WHERE Name = 'SequenceNumber'"; var r = sql.Query(q).First; var sequenceNumber = r; if (r == null) { var q = "INSERT INTO dbo.ProgramSettingValues (Value, Name) VALUES ('1', 'SequenceNumber')"; sql.Exec(q); sequenceNumber = 1; } else { sequenceNumber++; } q = "UPDATE dbo.ProgramSettingValues SET Value = '"+sequenceNumber+"' WHERE…