Open SQLSYSSETTING.EXE within the manexSQL root directory.
Enter password when prompted. | |
Select Material > Material Type Setup from the menu. | ![]() |
The following screen will be displayed:

Inventory Material Type Setup tab
The material types displayed here are hard-coded into the system and cannot be removed.
Select the Add icon from the main toolbar to add a new Inventory Material Type, or select the Edit button from the main toolbar to edit an Inventory Material Type. When finished, click the Save icon to save changes or the Abandon Changes icon to abandon any changes made.
If Inventory Material Type is set to automatic, the user will receive the following message:

If Inventory Material Type is set to manual, the user will receive the following message:
AVL Material Type Setup tab
The material types displayed here are hard-coded into the system and cannot be removed.
Select the Add button from the main toolbar to add a new AVL Material Type, or select the Edit button from the main toolbar to edit an AVL Material Type. When finished, click the Save icon to save changes or the Abandon Changes icon to abandon any changes made.
If Inventory Material Type is set to automatic, the user will receive the following message:
If Inventory Material Type is set to manual, the user will receive the following message: