Archives
Contributors
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
Follow-Ups
-
Re: Tracking packagings in stock
Probably I am missing something here.However, please let me offer my 2c by asking the following:- wouldn't it be that the natural solution is to manage the type of packaging in parallel to the type of products? In my experience, dealing with products in various physical structures (solid, gas, liquid, powder) and not having the various types of packaging is "insane" :-).On Tue, May 28, 2024 at 12:17 AM Kevin Khao <notifications@odoo-community.org> 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: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,_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by milori2006 - 12:21 - 28 May 2024 -
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