search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.29k stars 2.74k forks source link

Suggest qty / lot into shipment of sub warehouse when we select a parent warehouse as source warehouse #14496

Closed StephaneLesage closed 3 years ago

StephaneLesage commented 4 years ago

Bug

We have many sub-locations STK.A, STK.B, STK.C.1, STK.C.2 ... in a main warehouse CLAIX. So I have imported them as children warehouses of the main parent warehouse. The products are spread across all these sub-warehouses. So when creating a shipping order, we select the main parent warehouse, but the page doesn't show the stock of the children warehouses...

Environment

Screenshots to reproduce

I have a product with serial numbers. Stock is 2 pieces in warehouse "CLAIX.STK.C.2": Capture produit

This warehouse is child of main parent warehouse "CLAIX": Capture Warehouse

I create a new shipping from a customer order and select parent warehouse "CLAIX": Capture New shipping order

Shipping order page says there is no stock in parent house CLAIX, which is strictly correct, but should display stock of children, the same way as when we leave the warehouse field empty: Capture no stock in parent warehouse

BebZ commented 4 years ago

Hello,

can you push a screenshot please ? it is quite long to reproduce the bug...

StephaneLesage commented 4 years ago

can you push a screenshot please ? it is quite long to reproduce the bug...

@BebZ Yes I edited the first comment.

dpriskorn commented 4 years ago

very nice screenshots, thank you. Is this expected to work? Does Dolibarr officially support child warehouses?

Honestly it sounds to me like added complexity and I can't see the benefit. Could you explain what this is good for? Why not just have 1 warehouse per physical location/address?

StephaneLesage commented 4 years ago

Does Dolibarr officially support child warehouses? Is this expected to work?

I should hope so, there is no hidden option, this plain standard out-of-the-box dolibarr.

There are already other threads here (#11659) and on the forum about people needing 'sub-places' inside warehouses like very other ERP on the planet. People using Dolibarr always say: "we don't need that, you can already use hierarchical warehouses for this". So I just try to do it Dolibarr's way.

Honestly it sounds to me like added complexity and I can't see the benefit. Could you explain what this is good for?

A small-size real-world warehouse of 200m²x10m high is something 5 columns x 5 rows x 4 places in height. Do you expect the storekeeper to look everywhere for each product of an order ?

No,.. The basic process of companies needing serious storage is;

We are a small company with 15 people and only 1 storekeeper and we already need this... I Imported 487 warehouses from our current ERP CEGID Manufacturing PMI.

Advanced users would also need:

Why not just have 1 warehouse per physical location/address?

This is true for the main parent warehouses (2 sites here). In our case, we have other "virtual warehouses" on the main site:

dpriskorn commented 4 years ago

Thank you for the thorough explanation 😀 I have a small company with only a few hundred products so I have not needed that.

Using multiple warehouses forces you to select the subwarehouse that holds the product. Is that a problem? I don't think so because Dolibarr helpfully shows you the stock per warehouse for each warehouse in the drop down select box.

You could further model this using tags/categories on products. One tag for row and one for shelf or using extrafields on the product or stock module.

Dolibarr is extremely flexible and has few limitations on how to use it, but I recommend you to ask in the forums or hire help before importing your existing data so it is modelled well in Dolibarr.

I'm not sure that the extrafields or tags would show up on the shipping card though, so if you need that I suggest creating a feature request.

dpriskorn commented 4 years ago

I have built a python library for dolibarr and it could easily help you check that all products have row/shelf and import/export the information as you like with a high degree of flexibility.

github-actions[bot] commented 3 years ago

This issue is stale because it has been open 1 year with no activity. If this is a bug, please comment to confirm it is still present on latest stable version. if this is a feature request, please comment to notify the request is still relevant and not yet covered by latest stable version. This issue may be closed automatically by stale bot in 10 days (you should still be able to re-open it if required).