Changing bin locations for a range of stock lines using Multi Select instead of copy and paste - 7.02.01 SR1 and higher

How can I change the bin locations against a number of stock on hand records?

Step-by-step guide

1. On the Inventory > S.O.H. > Transaction Detail tab there is a context menu option to allow Multi Select - right click on the column header of the grid to turn that on.  The state of the Multi Select context menu item (checked or unchecked) is persisted per user per grid.
   
   
   

   Open

   

   
   
   
   

2. Select the lookup buttons, not the Bin Location text field by selecting a button, then pressing and holding the shift key and pressing the down and up arrows

   1. To select the lookup button without clicking it, select the Bin Location text field next to the lookup, then use your arrow key to move your cursor across to the lookup button.  It will be highlighted without actioning it.
      
      
      
      
      

3. Right-click the column header again to bring up the context menu and select Set Value
   
   
   
   
   

4. The search dialog for the Bin Location selection appears
   
   
   
   
   

5. Select the desired bin location and the values for each row selected will be set
   
   
   
   

When multiple warehouses exist in a database, make sure you tick Specific Warehouse to select relevant stock on hand lines and bin locations for the selected warehouse.

Open

If you only want to move some of a stock line, see Split a stock line

Related articles