RE: Create Warehouse Bin Locations
Hello Pharma18969,
For your first Question, Microsoft Dynamics SL is having the Warehouse bin locations (10.340.00) screen to create the new bin locations against Site Id. This screen can be found at Inventory module.
I believe that you are having the list of inventories where the bin location for those inventories needs to have the new bin location. If that is the case, there is no such window to preset those locations.
You can change the default locations of Inventory under Item defaults tab of Inventory Items (10.250.00) screen. This is time consuming process if you are trying to change the locations one by one.
Instead, you can use the “Transaction Import” to update the default inventory locations. You need the following files to do the Transaction import.
- Control file of Inventory Items (10.250.00) – you can get the screen control file using control macro generator screen.
- Data file (CSV) - you need to prepare the data file based on your list of inventories. The Data file should be comma separated file.
- However you are not creating new inventory item, you are just updating the existing inventory with new bin location. The level of data file should be “Level0, Update” to update the existing record.
I hope you are familiar with Transaction Import process. If not, you can refer the help Pdf files (system manager.pdf for SL 2011 & sl_sm.pdf for SL 7) available in User Guides folder which can be found at Solomon Root folder.
You can simply prepare the SQL query to update the locations of inventory items.
Hope this explains.