Adding Inventory Locations

Actually, I had to add a warehouse location to a store this past week.  I didn't take it quite as far as you did, but now that I have seen what you have posted I may propose such a change to the client.

I'm actually exited about what you have done.  It used to be easy for us to find stuff in the warehouse, but as we have gotten larger.  Now it is sometimes hard to find items, especially the overflow boxes.  We have only a certain amount of space on the reachable shelves and some items need to be parked somewhere else in addition to what is on the shelves.    They usually end up on the bottom shelf or somewhere else on top.  The areas we don't like to reach that often and therefore prevent back injuries.  That is where all our overflow goes.  Perhaps that can also be incorporated with what you have done, unless that field allows more content.  This has been request several times in the past and I think it is time to add it.    It would be nice, if you share the files with IE.  Perhaps they will incorporate it.
Thanks for sharing your images.
Katharina

I think what you have would be just fine.
We have things by row and shelf letter.  Kind of what you show.
Row 3, shelf B = 3B
I would list the normal shelf and overflow like: 3B, 5D
Right after the original one, no explanation needed for us.  This would be enough since the 2nd entry is overflow.  Your field width of 20 characters would work just fine for us. 
Lets keep our fingers crossed that they will take it from you.  I love that you are willing to share it with them, and I see the cut back on maintenance on your end.
Katharina

OK, so a little while back I asked about our general development strategy.   We frequently need to add a column to the database for some additional data element.  Let's take, for example, a link to a related manual.  At that time, you stated that we should continue our strategy of adding a field manually to the database, then add the field to the various admin tools.

Katharina: too many code changes would be required and they would be a duplication of what Custom Search Fields already allow. We understand that there is a "last step" that requires some knowledge of ASP, but this is what we created a "WIKI" for.

Specifically, what we can do is posting more instructions on the WIKI on how to accomplish this, when we have a bit of time. Or anyone else can do so and then post those instructions in the WIKI as a "How To" article.

Let us stress the fact that if you use Custom Search Fields, this becomes a really, really small custom development project. Probably an hour of work at the most. It's just a matter of querying the right field on the Pick List page (batchPrintPickList.asp) and display it.

You can use the code shown here as a starting point to query the field (this code returns all custom search fields for the product, so you will have to filter by the one custom search field you are using for the inventory location).


Edited by earlyimp - 05-January-2009 at 1:14pm