Warehouse functionality - "Bin Location" Transfers

[Laimonas]

Hi everyone,

I have a question about specifying exact "Bin locations" when using the Warehouse functionality.

Here’s my situation:

• I have two Warehouses: "A" and "B."
• My product is a Needle, and I currently have 9,000 Needles in Warehouse "A."
• The Needles do not have a permanent "bin location" and can be placed in multiple bin locations within Warehouse "A":
  • 3,000 pcs in bin "1-1-2"
  • 3,000 pcs in bin "1-1-3"
  • 3,000 pcs in bin "1-1-4"
• I need to transfer 2,000 Needles from bin "1-1-3" in Warehouse "A" to bin "4-6-2" in Warehouse "B."
• The quantity should be deducted from bin "1-1-3" in Warehouse "A" and added to bin "4-6-2" in Warehouse "B."

How can I do this correctly?

Thanks in advance for your help!

[yuri]

Hi,

The sales pack does not have Warehouse Management System capabilities. It does have the Inventory Management System capabilities. Meaning it does not cover internal warehouse storage locations. But it can track location of items in a specific warehouse.

For your case, you would need a separate Warehouse entities for every location you want to track. It can be two different records which represent two locations in a single physical warehouse.

To move between warehouses, you need to utilize the Transfer Order entity type.

https://docs.espocrm.com/extensions/sales-pack/inventory-management/#transfer-orders

[Laimonas]

Thank you for the answer. If I understand correctly, the suggestion is to create a warehouse record for each location (e.g., "1-1-2" as a warehouse record, which we can call a "location-as-warehouse").

If that's the case, I have two questions:

1. I see a potential issue since I have nearly 200 locations within two physical warehouses. If I create all 200 "location-as-warehouses" records in advance (so regular users don’t have to do it), will all of them be visible in the Inventory tab of the Product bottom panel? Ideally, I would only want to see "location-as-warehouses" that contain stock for a specific product. For example, if Needles are only stored in three locations, I wouldn’t want to see the other 197 "location-as-warehouses" in the Inventory tab of the Product bottom panel. How would this work?
2. Are there any plans to develop Warehouse Management System capabilities in the near future?

[yuri]

There's no currently plans to implement WMS. If we every do, it should be a separate extension with quite a high price. It's a complex software.

[yuri]

> will all of them be visible in the Inventory tab of the Product bottom panel

Maybe we could have a panel filter for such a case. I currently cannot look into this issue deeper. If you could file a feature request, it would help us.

[Laimonas]

Thanks