Skip to Content

Contributors

Re: Tracking packagings in stock

On 27/05/2024 19:17, Kevin Khao wrote:

> Dear OCA members,

> 

> I have been confronted with the following issue, and made a module with 

> the link below for something of a fix.

> 

> Here is the use case: in addition to knowing how many units of products 

> we have in stock, we want to know under what packagings there products 

> are. For example: not only do I want to know I have 95 units in stock, I 

> want to know that I have 5 packages of 10 units and 2 packages of 25 

> (because one has been opened and 5 units taken out from it).

> 

> It seems modifying the stock.quant model to take into account these 

> packagings would be a hairy task as it is a core model that is read 

> to/written to in a bunch of places.

> 

> Our simple solution is to create an intermediary model and a computed 

> field on stock.quants and products that will store this information:

> 

> https://github.com/OCA/stock-logistics-warehouse/pull/2050/files 

> <https://github.com/OCA/stock-logistics-warehouse/pull/2050/files>

> 

> This allows to preserve native Odoo functionality but also serves our 

> requirement (we only care about showing this, for some data that we 

> receive from a connector to another WMS). It works in our situation but 

> someone out there might have thought of a more general approach, what do 

> you think ?

Did you check 
https://github.com/OCA/stock-logistics-warehouse/tree/16.0/stock_product_qty_by_packaging 
?



-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.com


by Alexandre Fayolle - 12:11 - 28 May 2024

Reference

  • Tracking packagings in stock
    Dear OCA members,

    I have been confronted with the following issue, and made a module with the link below for something of a fix.

    Here is the use case: in addition to knowing how many units of products we have in stock, we want to know under what packagings there products are. For example: not only do I want to know I have 95 units in stock, I want to know that I have 5 packages of 10 units and 2 packages of 25 (because one has been opened and 5 units taken out from it).

    It seems modifying the stock.quant model to take into account these packagings would be a hairy task as it is a core model that is read to/written to in a bunch of places.

    Our simple solution is to create an intermediary model and a computed field on stock.quants and products that will store this information: 


    This allows to preserve native Odoo functionality but also serves our requirement (we only care about showing this, for some data that we receive from a connector to another WMS). It works in our situation but someone out there might have thought of a more general approach, what do you think ?

    Best regards,

    by "Kevin Khao" <kevin.khao@akretion.com.br> - 07:16 - 27 May 2024