Sequence Numbers

Overview ​ ProfiSystem utilizes a Sequence ID number in many of the data tables, like events, ticket numbers, rental order numbers ..etc.. ​ This form keeps track of the last sequence number used for the various sequence numbers in ProfiSystem©(customer ID, event ID, etc.) You can change a sequence number here and the next time ProfiSystem© needs a number it will use your new number, plus one. Remember, this form shows the last number used. ​ You can cause serious data problems by changing these numbers incorrectly. For example, if your current customer ID sequence number is 51 (meaning this was the last one used), and you change it back to 50, the next time ProfiSystem© needs a customer ID it will get 51. This would duplicate an ID already on file. ​ The system prefixes all sequence numbers with the current store's Store ID. ProfiSystem© by default will use the number 1 as your Store ID for single store implementations.. The store ID should be entered in Store setup before transactions are entered in the system.

In Multi-Store implementations of ProfiSystem, the user may assign a Store ID to new stores added to the system. Optionally the system will insert a dash between the Store ID and the sequence number, example 1-51. This can be turned on or off via the System->Store Setup->Options . In multiple store implementations the dash is desirable due to the ease in which transactions can be identified. ​ By default the system does not prefix inventory barcodes sequence numbers with the Store ID. This can be turned on via the System/Store Setup. However, most implementations prefer to have the barcode omit the Store ID, this will guarantee the SCW barcode will be 8 characters.. ​ An added option for sequence numbers is to maintain a separate set of Sequence numbers for each store in a multistore implementation. Turn this on via the System/Store Setup->Options Tab: Make Sequence numbers store specific.

FIELDS Primary Key This identifies form/table the sequence number applies to: Current Key This is the last value used in the form / table. Maximum key value This is the maximum value the number will reach before it resets to 1. Pad with Zeros to ___ characters This setting determines the number of characters of the number. You must take the maximum key value into consideration when entering a value here, for example. Say the Store ID is 1, no dash is used and the maximum value is 100000 with a pad of 7. Your first sequence number would be: 1000001. If the pad value was modified to 6 the sequence number would look like: 000001. The system takes the pad value number of characters from the right. Another example of the pad value of 2 would be: 01. Don't add store ID prefix to sequence numbers? (checkbox) ... Checked the system will NOT PREFIX the store id o the sequence number. By prefixing the store ID and adding a DASH, guarantees sequence numbers between stores will not be duplicated and easily recognizable as to where the transaction originated. .