In the course of warehouse reorganization, the warehouse sublevels are often adjusted and the bin locations restructured. Since SAP Business One requires you to use the codes of the warehouse and warehouse sublevels to compose the bin location codes, you may need to modify the bin location codes as a result of the reorganization.
In SAP Business One, you can modify the bin location codes one by one or in batches. Once you have successfully changed a source bin location code to a target bin location code, SAP Business One automatically transfers the inventory from the source bin location to the target bin location and deactivates the source bin location.
With the bin location code modification, you can do the following:
Changing a source bin location code to a target bin location code
Changing a range of source bin location codes into one target bin location code
In this case, SAP Business One transfers the inventory from all source bin locations to the target bin location and deactivates all source bin locations.
Changing a range of source bin location codes to a range of target bin location codes
Note
As every bin location code is unique in SAP Business One, you must merge the bin location codes when either of the following conditions arises:
The target bin location code already exists.
In this case, you must merge the source bin location code with the existing target bin location code.
Multiple source bin location codes share one target bin location code.
In this case, you must merge all source bin location codes into one.
To merge bin location codes, select the Merge Bin Location Codes checkbox in the Bin Location Code Modification – Preview window.
If the target bin location code does not exist, SAP Business One automatically creates the target bin location with the same properties as those of the source bin location.
However, in case you change a range of source bin location codes into a target bin location code that does not exist, the target bin location is created with the same properties as those of the first bin location in the source range.
You have enabled bin locations for your warehouse.
For more information, see Enabling Bin Locations.
From the SAP Business One Main Menu, choose
.The Bin Location Code Modification window opens.
In the Select Bin Location Codes section, select a range of bin location codes that you want to modify.
In the Modify Sublevels for Selected Bin Location Codes, select the sublevel code segments you want to modify and specify the new sublevel codes.
Note
To remove a sublevel code segment from the selected bin location codes, select the checkbox on the left side of the sublevel and leave the field on the right side empty.
Choose the OK pushbutton.
The Bin Location Code Modification – Preview window opens, where you can preview the target bin location codes.
In the Bin Location Management – Update Preview window, select the bin location codes you want to modify, specify whether you allow the merge of bin location codes, and choose the Modify pushbutton.
Note
If the source bin location codes cannot be modified due to certain conflicts with the target bin location codes, SAP Business One marks the rows in red. You can see the detailed error description in the Error Details column.
For a more convenient selection of the bin locations, use the SAP Business One sort feature by double-clicking any column header.
Warehouse A has the following sublevels:
Sublevel 1 – Wing
Sublevel codes – WINGEAST and WINGWEST, which refer to the east and west wings in the warehouse, respectively
Sublevel 2 – Area
Sublevel codes – AREAX and AREAY, which represent area X and Y in each wing.
Sublevel 3 – Shelf
Sublevel codes – SHELF01 and SHELF02, which stand for shelf 01 and 02 in each area.
Removing a Sublevel Segment from Bin Location Codes
During the warehouse reorganization, all the shelves have been removed and the areas now have become the bin locations where the goods are stored.
In order to update the codes of the bin locations in the warehouse accordingly, you remove sublevel 3 and get the following:
Source Bin Location Code |
Target Bin Location Code |
Modification Results |
---|---|---|
A-WINGEAST-AREAX-SHELF01 |
A-WINGEAST-AREAX |
Target bin location is created with the same properties as those of bin location A-WINGEAST-AREAX-SHELF01. Inventory in the two source bin locations is transferred to the target bin location, and both source bin locations are deactivated. |
A-WINGEAST-AREAX-SHELF02 |
||
A-WINGEAST-AREAY-SHELF01 |
A-WINGEAST-AREAY |
Target bin location is created with the same properties as those of bin location A-WINGEAST-AREAY-SHELF01. Inventory in the two source bin locations is transferred to the target bin location, and both source bin locations are deactivated. |
A-WINGEAST-AREAY-SHELF02 |
||
A-WINGWEST-AREAX-SHELF01 |
A-WINGWEST-AREAX |
Target bin location is created with the same properties as those of bin location A-WINGWEST-AREAX-SHELF01. Inventory in the two source bin locations is transferred to the target bin location, and both source bin locations are deactivated. |
A-WINGWEST-AREAX-SHELF02 |
||
A-WINGWEST-AREAY-SHELF01 |
A-WINGWEST-AREAY |
Target bin location is created with the same properties as those of bin location A-WINGEAST-AREAY-SHELF01. Inventory in the two source bin locations is transferred to the target bin location, and both source bin locations are deactivated. |
A-WINGWEST-AREAY-SHELF02 |
Modifying a Sublevel Segment in Bin Location Codes
During the warehouse reorganization, shelf 01 in all areas in the warehouse has been removed and replaced by containers.
To reflect this change in the bin location codes, you modify sublevel 3 and get the following:
Source Bin Location Code |
Target Bin Location Code |
Modification Results |
---|---|---|
A-WINGEAST-AREAX-SHELF01 |
A-WINGEAST-AREAX-CONTAINER |
Target bin location is created with the same properties as those of the source bin location. Inventory in the source bin location is transferred to the target bin location, and the source bin location is deactivated. |
A-WINGEAST-AREAY-SHELF01 |
A-WINGEAST-AREAY-CONTAINER |
Target bin location is created with the same properties as those of the source bin location. Inventory in the source bin location is transferred to the target bin location, and the source bin location is deactivated. |
A-WINGWEST-AREAX-SHELF01 |
A-WINGWEST-AREAX-CONTAINER |
Target bin location is created with the same properties as those of the source bin location. Inventory in the source bin location is transferred to the target bin location, and the source bin location is deactivated. |
A-WINGWEST-AREAY-SHELF01 |
A-WINGWEST-AREAY-CONTAINER |
Target bin location is created with the same properties as those of the source bin location. Inventory in the source bin location is transferred to the target bin location, and the source bin location is deactivated. |