manexSQL users may identify an unlimited number of warehouses in which to store materials. If the user wishes, it is possible to establish a wide variety of warehouses for special needs. If the user is involved in a great deal of consigned activity, it is possible to set up a warehouse for each customer and their material. A warehouse may be set up as a secure location for high value material, with additional physical security precautions in place to access this area.

For those users who want to separate Finished Goods from Raw Materials Inventory, be sure to include a Finished Goods Warehouse.  

The MRB (Materials Review Board) Warehouse is required for the DMR (Discrepant Material Return) module. 

There are at least two warehouses that cannot be removed from the system: WIP and WO-WIP. These warehouse locations are used by manexSQL to track materials within the manufacturing process. For more detail on WO-WIP, see Article #3061.  Additionally, any warehouse that has material purchased to be placed in it, or has inventory in it, may not be deleted. All other warehouses may be deleted.   

 

A deleted warehouse is flagged as deleted but is still retained within the tables for history preservation. It may be restored by clicking the "Restore Deleted Warehouse" icon.
 

One warehouse must be selected as the default warehouse. This is generally the "Main1" warehouse. 

 

Associated with each warehouse is a warehouse code (6 characters), a warehouse description (25 characters), a division designation (if applicable), and an Inventory General Ledger account number (set up in the GL Account Setup). 

 


  


Turn On/Off for All Warehouses to Allow Auto Create Location at Receiving - If this box is checked, auto-location at Receiving will be allowed. If this box is unchecked, auto-location at Receiving will not be allowed. The "Allow to Auto Create Location at Receiving" box located in Inventory Control, AVL level must also be checked for this option to work properly.  

 

Allow to Auto Create Location at Receiving -  Checking this box (along with checking the box in Inventory Control, AVL level) will allow the user to create a location at the PO level, PO Receiving level, and/or Inventory Handling Receiving level for this warehouse. Unchecking the "Auto Create" option disables that warehouse from being used on the fly. 

Remove location with this warehouse from the Inventory when qty on hand gets to zero - This option will only be available if the user checks the “Allow to Auto Create Location at Receiving” box. Check this box to allow for warehouses and locations (created at the Inventory level, PO level, or PO Receiving level) to be rendered inactive (invisible on most screens) once the Inventory for that part reaches a quantity of 0. If the Work Order is de-kitted, the warehouse will be reactivated and the product inserted.

Default - If none of the warehouse or inventory AVLs are marked for auto-location creation, the system will automatically assign a default warehouse upon creation of a new part number/AVL. If the auto-location creation option is enabled, the system will leave the warehouse section blank for new parts, allowing the user to create new locations from PO Receiving.

Do Not Use in Auto-Kit - If this box is checked, the warehouse will not be used in auto-kitting.

Add Default warehouse automatically upon saving a part whenever a new AVL is added to the part and no other warehouses are set up for the AVL - If this option is selected, the default warehouse will be added automatically upon saving when (a) a new AVL is added, and (b) no other warehouses are set up for that AVL. If the "Allow to Auto Create Location at Receiving" box is checked and the "Add Default warehouse automatically..." box is unchecked, however, the system will not add a warehouse within the Inventory module upon saving. This works in conjunction with the "Allow to Auto Create Location at Receiving" option.


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. 

It is also vital that the account number for WO-WIP is not the same as the WIP account number. 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.