- Mailing Lists
- Contributors
- Re: Tracking packagings in stock
Archives
- By thread 1419
-
By date
- August 2019 59
- September 2019 118
- October 2019 165
- November 2019 97
- December 2019 35
- January 2020 58
- February 2020 204
- March 2020 121
- April 2020 172
- May 2020 50
- June 2020 158
- July 2020 85
- August 2020 94
- September 2020 193
- October 2020 277
- November 2020 100
- December 2020 159
- January 2021 38
- February 2021 87
- March 2021 146
- April 2021 73
- May 2021 90
- June 2021 86
- July 2021 123
- August 2021 50
- September 2021 68
- October 2021 66
- November 2021 74
- December 2021 75
- January 2022 98
- February 2022 77
- March 2022 68
- April 2022 31
- May 2022 59
- June 2022 87
- July 2022 141
- August 2022 38
- September 2022 73
- October 2022 152
- November 2022 39
- December 2022 50
- January 2023 93
- February 2023 49
- March 2023 106
- April 2023 47
- May 2023 69
- June 2023 92
- July 2023 64
- August 2023 103
- September 2023 91
- October 2023 101
- November 2023 94
- December 2023 46
- January 2024 75
- February 2024 79
- March 2024 104
- April 2024 63
- May 2024 40
- June 2024 160
- July 2024 80
- August 2024 70
- September 2024 62
- October 2024 121
- November 2024 117
- December 2024 89
- January 2025 59
- February 2025 104
- March 2025 96
- April 2025 107
- May 2025 52
- June 2025 72
- July 2025 60
- August 2025 81
- September 2025 124
- October 2025 63
- November 2025 22
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