Open SQLSYSSETTING.EXE within the manexSQL root directory.

 

Enter password when prompted.

Select Material > Warehouse Setup from the menu.


 

 

The following screen will appear:


This setup screen is used to enter all the warehouses used in your company. This information is used when adding and editing the Item Master. When an Item Master record is created, the system will automatically add the designated default warehouse. The default warehouse assignment is accomplished by checking the default box for the selected default warehouse. 

Note: Changing the default warehouse once inventory parts are assigned to that default is not recommended.
 

To add a new warehouse, click the Add icon and enter your password. Type the warehouse abbreviation into the "warehouse" field and enter a description pertaining to the warehouse into the "description" field. If this is the default warehouse, check the "default" box.  
 
You must have at least one default warehouse. If no default warehouse is set up, the user will receive the following warning upon attempting to save:



If Accounting is installed, click the down arrow next to the "Inventory GL No" field. The GL Number account selection window will appear:


The user can search by Account Type or Account Numbers using the "Find By" dropdown. Depending on the selection, either GL types or account numbers will appear. 

Highlight the type or account number of your choice and click "OK." The account number will appear in the Inventory GL Number field. 

This process can be repeated for the selection of the Shrinkage GL number. 

Note: General Ledger numbers are required if the Accounting Module is active. Choosing the accounting GL numbers with care is recommended, as it is inadvisable to change them once the selection is saved. 
 
WIP and MRB GL numbers must be unique. The system will not allow GL numbers that have been used by other warehouses to be entered for WIP and/or MRB warehouses, and other warehouses cannot use the same GL numbers that are currently in use by WIP and/or MRB warehouses.

If there has been no activity in a warehouse, the user may delete it. To do this, highlight the warehouse and click the Delete icon, then click "Yes" to confirm the deletion.

Note: A default warehouse cannot be deleted. If you would like to delete a warehouse currently assigned as default, you must assign the default status to another warehouse first. 

Where Used: Materials, Production, and WIP functions