Stock Location Warehouse

This module extends stock locations with a new Warehouse field. On the location form, the field appears right after the Company field, so users can see at a glance which warehouse a given location belongs to.

The value is not typed by hand: it is computed automatically from the location's position in the location tree. The module looks at the parent chain of the location and matches the second level of that chain against the view location of each warehouse. If a match is found, that warehouse is assigned to the location. Because the field is stored, the value is saved in the database and can be used in filters, groupings and reports.

When a location is moved under a different parent, the stored value is recalculated, so the warehouse association follows the new hierarchy. The computation also depends on the warehouses linked to the location, so changes on the warehouse side can trigger a refresh.

• New field: Warehouse on stock locations.
• Shown on the standard location form, after the Company field.
• Filled automatically from the parent location hierarchy.
• Stored, so it can be searched and grouped.
• Recalculated when the location's parent path changes.

It touches the stock.location model and the stock.warehouse model through the link between warehouses and their view locations. No new menus or reports are added.