I am hoping someone else has had a similar problem to us and had a bespoke solution created that we can use. Our problem is around Virtual Bins that unfortunately NS does not support.
[LIST]
[*]We sell clothing. We have a warehouse with 4,000 bins all arranged and numbered by aisle/bay/shelf/bin number e.g. B-12-K-4
[*]Within our business, we have three separate divisions RETAIL – WHOLESALE – ONLINE. We have stock manufactured against each division, but it is the same stock.
[*]So, for example we will have manufactured a specific short of a specific size and a specific colour, one single SKU.
[*]So, let’s say it’s a Short - Blue - Size 42 and we order 30 from the manufacturer – 10 of these are for RETAIL, 10 are for WHOLESALE and 10 are for ONLINE.
[*]These divisions need to own their own stock BUT we don’t have three warehouses, only one.
[*]They come into our warehouse and we then want to place all 30 in ONE BIN, but we want NetSuite to tell us that 10 belong to Retail, 10 belong to Wholesale, and 10 belong to Online.
[*]When an order comes in for Retail for say 5 pieces we want to be directed to that bin to pick the 5 to send out and then we want the stock on NS to show Retail = 5 Online = 10 Wholesale = 10.
[*]If necessary we also want to ‘virtually transfer’ stock from say Wholesale to Retail.
[*]NS cannot do this.
[*]We have spent months trying to find solutions/workarounds none of which really work. We are down to
1) putting three bar codes on each bin e.g. B-12-K-4-R and B-12-K-4-W and B-12-K-4-O and recording stock picking and allocation that way or
2) splitting our single warehouse in to three physical warehouse which is quite impractical.
[/LIST]
There must be other companies out there who have come across the same issue. I hope I have explained things in a way that is easily understood, be glad to engage further