We did this 3 years ago, took one warehouse and split it into two new ones that were aligned along product divisions.  Here were the major steps we had to do, we end up having a programmer write a script to do this work because even with migration jobs, there were too many details to work out to make a clean switch.  Then even after doing this work, we had to monitor the old warehouse, clean up all sorts of default locations that got missed for various reasons and generally police it so that it didn’t get reactivated.  Re-opening old shop orders and various other transactions would inadvertently move a piece of inventory back in.  Locking it up tight is actually a bit hard.

 

The following steps will need to be completed 
1)Add HFA/LFA information from spreadsheet attached to the inventory location description as a prefix- for all parts in site 510/582, in all warehouses.'HFA ' || (exisitng description)  SDB - we used the description field to create a map from old to new location by making them match to where they were to go]

2)Need to create 2 new warehouses SHOP_HFA and SHOP_LFA to split the existing shop warehouse into HFA and LFA for sites 510/582. (Only recreate these if the original warehouse is SHOP.)

2.5)Recreate all the SHOP inventory locations in the new warehouses, distributing them between SHOP_HFA and SHOP_LFA according to the spreadsheet. Any NULLs in bay/row/tier/bin should be changed to 0.   SDB - getting rid of the null values in some fields cleared up some duplication issues that had occurred over time]

3)Once we have the new locations created, update default location for ALL the parts in the existing Shop warehouse on sites 510/582 and assign them to the newly created locations. Same Bay/row/bin - diff warehouse of HFA/LFA depending on the segmentation

4)We also need to assign it to any outstanding shop orders and transport tasks, again can be done by migration job but script can do. tprobably the best way to get the link between old and new locs is to write the new into the old loc description.

5)Issue and return ALL NON RESERVED inventory to the new locations

6)Review all Quick reports for the use of SHOP warehouse and update

7)Clean up duplicate locations - according to attached analysis

 

 

In short, there is no easy or singular option to do this work.