Enter into SQLSYSSETTING.EXE within the manexSQL root directory. Enter password when prompted. | ![]() |
Select Production > Quality Defect Codes from the menu. | ![]() |
The following screen will be displayed:

Items may be re-sorted by dragging the box of the left side of the defect to the (vertical) position desired, and when you exit the re-order will be saved. This order will be displayed in the pull-down menus when using this list in other modules within the system.
Suggestion: have the most used at the top of the list. The user initiates a new defect code by selecting the Add button from the main tool bar.
Note: when creating a new defect code, have it as descriptive as possible, because this is what appears in the Pareto Chart in the SQC module information. Also, the "Defect Code" field is not editable once it has been saved.

To associate a work center with a defect code, select the Edit button from the main tool bar and place the cursor in the ID Work Center window, as illustrated.
Select the Work Center. | ![]() |
Enter in the maximum NPF number. Type in the desired number of times for Maximum number of inspections /WC. Keep in mind this field is for serial number use only.
If the user selects the “Skip Serial Number” field, then this max number will become invisible in the Shop Floor Tracking module under the Inspections section. Once the pass number of a serial number exceeds the max number, as set up here, a supervisor or special rights password is needed to continue.
When all changes have been completed, the user must select the Save or Abandon changes button from the main tool bar.
Select the Edit button from the main toolbar, and work centers assigned to or deleted from the defect code. All fields are editable, except for the "Defect Code" field.

When all changes have been completed, the user must select the Save or Abandon changes button from the main tool bar.
User may only delete a defect code if it has not been used in the SQC module. This information needs to be retained for history/reporting purposes.
User may only delete a defect code if it has not been used in the SQC module. This information needs to be retained for history/reporting purposes.
If the defect code has been used in the SQC module, the user will receive the following warning when trying to delete the defect code:

If defect code has not been used in the SQC module, then the defect code may be deleted.
The user will receive the following confirmation to be sure they want to delete the defect code:

Depress Ok to continue, or Cancel to abandon the deletion.
Where Used: in all statistical quality control tracking operations and reporting.