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

[partomas]

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/...ransfer-orders

Hi everyone,

I’d like to propose a concept for improving our warehouse management by repurposing the existing product variants functionality. Specifically, what if we could use the product variant creation mechanism to manage internal warehouse bin locations? The idea is simple:

• User-Defined Attributes: Allow users to add attributes that segment the warehouse space (e.g., zones, rows, columns).
• Automated Cell Generation: Use an algorithm to automatically generate specific warehouse cells based on those attributes.
• Granular Tracking: This method would enable more detailed tracking of goods without requiring extensive new development.

This approach could streamline our inventory control by leveraging the current functionality, providing a practical and scalable solution for managing warehouse locations.

I’m eager to hear yuri thoughts and feedback on this proposal.

[yuri]

I'm not sure. I'm not a fun of quick solutions that might work if we were working on a bespoke software for a single customer. We have not a one-to-one but a one-to-many relationship with imposed backward compatibility burden. It's much more harder to develop an on-premise software targeted for the vast audience, many don't realize. It's unlikely that we consider the warehouse management in the nearest future as we have different plans now.