I have looked in multiple posts and found similar threads but there is a specific case that I have not located.
We will stock Widget A in our warehouse and we will also drop ship Widget A from our vendor's warehouse.
Scenarios:
1) In order to properly estimate shipping costs, we intend to use multiple locations (warehouses). One for our warehouse and one for each of our vendors warehouses.
2) If we have no stock in our warehouse, we need to know if our vendor has stock in their warehouse. If they do not, then we need to pull the item from our web site.
3) We will list an item on our web site when there is only one available at our vendor. If we sell that one item, we need to immediately pull it from the site so we do not disappoint our customers.
4) Each item can be purchased from one and only one vendor.
Our plan:
1) Use inventory items and mark them as drop ship. We understand that in v11.x this will make the item appear out of stock on the site if we do not have inventory in our warehouse but we understand that v2007 has the ability to set a preference to list it without out of stock in our warehouse.
2) Create an additional quantity on hand field for the vendor's location (warehouse). Write java script that will decrement this quantity if when we create a drop ship PO. We cannot use the out of the box quantity on hand field because it would effect the balance sheet.
3) Have our vendors send us a quantity on hand file every day to update the quantity on hand at the vendor. This update will remove any items from the site where there is no stock at our warehouse or the vendor's warehouse.
4) We will have to manually set the location (warehouse) on the item record to properly estimate shipping costs.
Would anyone have any comments or suggestions on this matter?