| Enter into SQLSYSSETTING.EXE within the manexSQL root directory Enter password when prompted |  |
| Select General Setup > Number System from the menu. |  |
The following screen will be displayed;
To modify this screen, the user must click on the Edit button and supply the password. That action will enable the screen, and the user can then select which option to apply.
To enable auto numbering, check the box by clicking on the radio/box. Unchecking the radio/box will indicate manual numbering. To start the number sequence, for a number type, at a number other than the one shown, type in the new starting number. Do not enter a number less than an existing number.
When auto numbering is selected, you will need to enter the starting number in the appropriate field on the right-hand column titled, "Starting Number." If no starting number is entered, the system will automatically start assigning numbers, beginning with number one. manexSQL will automatically assign the next available sequential number (with no revision) when adding a new record to a selected module, and you may then enter a revision if applicable. Once the next number is selected, the counter moves to the succeeding number. if the abandon changes button is depressed, the number will be considered as used, and will be skipped even though the record was never saved.
If auto mode is unchecked, the system will require manual assignment of starting numbers. Manual mode is where 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. When in manual mode, you may combine alphabetic and numeric characters up to the length of the field.
If you begin with the manual mode of tracking numbers, it is recommended that they begin with an alphabetical character. If you decide to change to auto-numbering mode, 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 manexSQL setup.
The user must Save or Abandon changes after entering Edit mode.
Where Used: All activities that issue control numbers.