Skip to Content
Menú
This question has been flagged
4 Respostes
168 Vistes

my client need to have multi warehouses with different products average cost ,so if product in warehouse A ,the average cost of this product should be different if it's in warehouse B 

any idea differet from creating different companies because i've more than 34 warehouse 

Avatar
Descartar
Autor

the point that when we sell product from warehouse A for example it should take the cost in warehouse A and if sell it from B so it should take cost in B 

Best Answer

Hi,


In Odoo, product cost methods like average cost are managed at the product level, not per warehouse, so by default you can’t maintain separate average costs for the same product across different warehouses. The common workaround is to use different companies for each warehouse, but since you have 34 warehouses, that isn’t practical. To achieve this, you would need custom development to extend Odoo’s costing logic so that the average cost is tracked per warehouse, rather than globally for the product.


Hope it helps

Avatar
Descartar
Best Answer

Hello Imam,

You can check the ready app at the link below to see if it meets your requirements
https://apps.odoo.com/apps/modules/18.0/sh_warehouse_avg_costing

You can also request a demo of the module before making a purchase. you can contact support@softhealer.com for demo URL

Avatar
Descartar
Best Answer

Odoo's standard inventory valuation, including the average cost method, is typically managed at the company level, not per individual warehouse.



  The standard_price field on the product template represents a single, global average cost for that product across all warehouses within the same company.

  Therefore, Odoo does not natively support maintaining different average costs for the same product in various warehouses without creating separate companies.

  Achieving warehouse-specific average costing would require significant custom development to modify Odoo's core costing engine and valuation reports. This is a complex undertaking.


If you'd like to explore this further for your specific use case, you're welcome to connect with us at Pragmatic Techsoft.

Avatar
Descartar
Best Answer

I would look into Lot based costing - https://www.odoo.com/documentation/18.0/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/valuation_by_lots.html

Each LOT has a different cost, which follows it from warehouse to warehouse (if applicable).

Also, Landed Costs - https://www.odoo.com/documentation/18.0/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/landed_costs.html - when you move products from Warehouse to Warehouse via Delivery (out) and Receipt (in) operations.

Avatar
Descartar