Hi there
hope you are all doing well!
Our organisation are taking on a new warehouse and moving many thousands of lines of stock into the new warehouse.
I’m hoping for some advice on how whether it is possible to move inventory in bulk in a more efficient way than creating transport tasks. I’ve been looking at the migration tool and was wondering whether this could be used or if there Are any other options?
We’re currently using Apps 9.
Thank you to you all in advance 😀
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. [probably 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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
