ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon Import Utilitiies
DrillDown Icon Work Order Number Re-assign
DrillDown Icon Rebuild Accounts Table
DrillDown Icon Load Company Logo
DrillDown Icon Inventory Maintenance by Part Class & Type
DrillDown Icon Prerequisites
DrillDown Icon Change Parameters for the Part/Class
DrillDown Icon Inventory Global Change (Mfgr,Class,Type)
DrillDown Icon Inventory Class/Type Global Replacement
DrillDown Icon Lookup Mfgr Part Number from XL List
DrillDown Icon Global Warehouse Replacement
DrillDown Icon Global Inventory Description Case Changer
DrillDown Icon Global BOM Part Replacement
DrillDown Icon Convert Consigned To Turnkey
DrillDown Icon Inactivate Customer Parts
DrillDown Icon Delete Unwanted Sales Order
DrillDown Icon BOM Obsolete Item Utility
DrillDown Icon Change Phantom to Make Utility
DrillDown Icon Global Inventory Material Type Update
DrillDown Icon FAQs - System Utility
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Global Warehouse Replacement
 

Enter the SQLSYSUTILITY.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, select Inventory Maintenance by Part Class & Type/Global Warehouse Replacement Module

This utility will allow you to globally replace an Old Warehouse with the new Desired Warehouse.

This utility will not allow the user to replace a warehouse with a different GL account assigned to it.
 

 
 

The following screen will be displayed:



Enter the Old Warehouse and the New Warehouse, depress the "Go" button and the old warehouse will be replaced with the new warehouse.

System will NOT allow you to replace the existing warehouse with a warehouse that previously existed and then deleted.  If system locates these types of records the following message will be displayed and  a 'NewWhemoved.xls' spreadsheet will be created with detailed information.



If the system finds parts in inventory which display both the old and the new warehouses, the following message will be displayed and a 'NewWhExists.xls' with detalied information will be created.


 

 

Article ID: 5411