Open SQLSYSSETTING.EXE within the manexSQL root directory.

 

Enter password when prompted.

Select Material > General Inventory Setup from the menu.

 
 
The following screen will be displayed:


 
Automatically number (MAKE and PHANTOM parts)Check this box to have the system automatically number new MAKE and PHANTOM parts.  
Suppress Locations with 0 Qty

Users can select the default to suppress locations with 0 quantity. The following reports will take this default when printing: ICM Module Reports: Inv On Hand Report, Inv and WIP Valuation Report, Unused Inv List Report, Kitting and Shortage Report: Kit Pick Worksheet. 

Disable Automatic BOM AVL Update

If this box is left unchecked, manexSQL will add the new AVLs (added within the ICM module) to all existing BOMs and check them as "approved."

If this box is checked, the AVL information will appear on the BOMs, but they will be marked as "not approved." They will not drive any demands or be available for pulling to that kit. The user will then have to manually enter each individual BOM and check the new AVLs that they would like to use.  

Purchase History By:

This field allows users to select whether to use "Order Date" or "Edit Date" on the PO when displaying the POs in the Purchase History within the ICM module. This selection will be the default in the ICM module.   

Include PO with Status:

This field allows users to select the status of the Purchase Orders they would like to have displayed in the Purchase History within the ICM module. Statuses include "Open and Closed (Approved)," "New and Editing (Waiting for Appr.)," and "All." This selection will be the default in the ICM module.

When Showing Purchase History include last

This field allows users to set up the number of Purchase Orders they would like displayed in the Purchase History within the ICM module. This selection will be the default in the ICM module. 

Number of Purchase Orders used in the calculation of the Weighted Cost

This field allows users to set up the number of Purchase Orders they would like used in the calculation of the weighted cost within the ICM module. This selection will be the default in the ICM module.