The Number System setup determines whether your company will use an automatic or manual numbering method for the items listed. manexSQL provides these features for flexibility and ease of use. As an example, take customer codes, in many systems the user is required to remember the customer code in order to process customer information. In such a system, a mnemonic code is usually assigned so the user can remember the customer code. The manexSQL user does not need to customize the customer codes, but can let manexSQL automatically apply a new number for each new customer. As this example shows, the numbering system and features manexSQL provides makes this process easier and efficient. 

If auto numbering is selected, the user will need to enter the starting number in the space provided on the right-side of the form (starting number). If no starting number is entered, the system will automatically start assigning numbers beginning with number one. Moreover, manexSQL will automatically assign the next available sequential number (with no revision) when adding a new record in a selected module, and at this time the user may enter a revision if applicable. Once the next number is selected, the counter moves to the next number. If the abandon changes button is depressed, that number will be considered as used and will be skipped even though the record was never saved.  


If manual mode is selected, the user will need to maintain a manual numbering sequence log and manually enter the number when adding a new record in a selected module. It is not necessary to fill in the starting number field when using manual mode. In manual mode, the user may combine alphanumeric characters up to the length of the field.

If the user desires to begin with manual assignment of tracking numbers, it is recommended that they begin with an alphabetical character imbedded in the numbers. If the user decides to change to automatic number assignment, there will be no possibility of duplicate numbers, because all of the auto-numbering systems only use numbers.  It may be appropriate for the user to enter the last number used in a manual system as the starting number for auto-numbering in the manex setup.