[Karsten Johnson]

We are have setup a new Bin in 1 of our sites in a Multi-Bin environment. We are now trying to figure out how to add that bin to the Item Site Default Bin list without having to update each item individually.

Is there a script to update the IV00117 table for all items for the new bin in our site or a utility we can run.

Any suggestions are appreciated.

——————————
Karsten Johnson
IT Manager
MAC’S, Inc.
Moorhead MN
218-359-2704
——————————

[Silver Subie]

If no script available, have you looked into using macro? You should be able to use macro under Item Quantity Maintenance window to assign Bins.——————————————-

[Windi Epperson]

Karsten,
You could use the Table Import function.  I don’t normally recommend this tool because it does no accounting validation, it just pushes data into the table.  But when you’re looking at a table that only has 3 fields it’s not as worrisome.  That said, you should definitely try this in a test company before doing it your live company.   

The easiest way to navigate to it is to open the Site Bin Maintenance window, then go to ToolsIntegrateTable Import.  Choose Site Bin Master and you’ll get the Table Definition Import Window.  Once you enter a definition id, you’ll see the fields below.  You can browse out to an Excel spreadsheet, then map the fields.   Note that this import will bring in the header info in the spreadsheet, so you really need to remove the headers.

Again, run this in test first.
Thanks
Windi

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-