Archives
Contributors
contributors@odoo-community.org
Implementing Real Cost
Odoo supports FIFO costing, but this is not the same as real cost.
For example, when using Lots, I can buy lot A and then Lot B.
If I choose to consume Lot B first, it will carry the purchase cost of Lot A.
As far as I know this is a common request from customers, but I couldn't find an existing implementation for it.
Is there anything I missed out there?
Thank you!
MANAGING PARTNER
>> Schedule time on my calendar.
M:
+351 919 991 307
E:
dreis@OpenSourceIntegrators.com
A:
Avenida da República 3000, Estoril Office Center, 2649-517
Cascais
![[Logo OpenSourceIntegrators.com]](https://www.opensourceintegrators.com/images/opensource-logo-2022.svg){kind=logo}
by Daniel Reis - 08:31 - 4 Dec 2025
Follow-Ups
-
Re: Implementing Real Cost
Hello Daniel,In case you are on 16.0, we have added major improvements to stock_valuation_fifo_lot to achieve specific identification in https://github.com/OCA/stock-logistics-workflow/pull/1676. It's been in production use with no major issues.Best regards,--Yoshi TashiroQuartileOn Thu, Dec 4, 2025 at 5:02 PM Richard deMeester <notifications@odoo-community.org> wrote:Hi Daniel,
On version 18.0+, there is a field "lot_valuated" (only visible for products with tracking).
lot_valuated = fields.Boolean(
"Valuation by Lot/Serial number",
compute='_compute_lot_valuated', store=True, readonly=False,
help="If checked, the valuation will be specific by Lot/Serial number.",
)I think that is what you are looking for?Richard
Kind regards,Richard deMeesterDevelopment QAWilldooIT is a member of the PNORS Technology Group.
This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you may not disclose or use the information in this email in any way. If you have received this email in error please notify the sender. Although reasonable precautions have been taken to ensure no viruses are present in this email, no responsibility is accepted by PNORS Technology Group Pty Ltd or its related entities for any loss or damage arising from the use of this email or attachments. Any views expressed in this email or file attachments are those of the individual sender only, unless expressly stated to be those of PNORS Technology Group Pty Ltd or any of its related entities.
From: Frederik Kramer <notifications@odoo-community.org>
Sent: Thursday, 4 December 2025 6:52 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Implementing Real CostHi Daniel,
afaik there is also AVCO (Average Costing) but there is no LIFO (even if that would be allowed in many localisations). I am not aware of anyone or any module that has touched this and i personally would issue that reqirement directly to Odoo instead of developing something one by one, because that is very core to accounting compliance
Best Frederik
Am 04.12.25 um 08:32 schrieb Daniel Reis:
Hello,
Odoo supports FIFO costing, but this is not the same as real cost.
For example, when using Lots, I can buy lot A and then Lot B.
If I choose to consume Lot B first, it will carry the purchase cost of Lot A.
As far as I know this is a common request from customers, but I couldn't find an existing implementation for it.
Is there anything I missed out there?
Thank you!
--
DANIEL REIS
MANAGING PARTNER>> Schedule time on my calendar.
M: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office Center, 2649-517 Cascais
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Yoshi Tashiro - 10:15 - 4 Dec 2025 -
Re: Implementing Real Cost
Daniel wasn't asking for LIFO, but for what he calls "real cost", which seeing the description, I think it's a valuation by lots.Regards.
by Pedro M. Baeza - 09:26 - 4 Dec 2025 -
Re: Implementing Real Cost
Hi Pedro, just to get it right / complete, even though valuation by lots i more precisely what most companies would use today, LIFO still isn't among the list of options if i am not mistaken. So companies that use this valuation method still have no other choice then to switch to one of the supported methods - AVCO - FIFO and - Valuation by Lots right? Or are you aware of any LIFO implementation Best Frederik Am 04.12.25 um 09:02 schrieb Pedro M. Baeza: > Odoo has implemented cost by lot in Odoo 18+, so nothing extra to do > except configuring it AFAIK. > > https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/inventory_valuation/valuation_by_lots.html > > Regards. > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe > -- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
by Frederik Kramer. - 09:21 - 4 Dec 2025 -
Re: Implementing Real Cost
Hi Daniel,
On version 18.0+, there is a field "lot_valuated" (only visible for products with tracking).
lot_valuated = fields.Boolean(
"Valuation by Lot/Serial number",
compute='_compute_lot_valuated', store=True, readonly=False,
help="If checked, the valuation will be specific by Lot/Serial number.",
)I think that is what you are looking for?Richard
Kind regards,Richard deMeesterDevelopment QAWilldooIT is a member of the PNORS Technology Group.
This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you may not disclose or use the information in this email in any way. If you have received this email in error please notify the sender. Although reasonable precautions have been taken to ensure no viruses are present in this email, no responsibility is accepted by PNORS Technology Group Pty Ltd or its related entities for any loss or damage arising from the use of this email or attachments. Any views expressed in this email or file attachments are those of the individual sender only, unless expressly stated to be those of PNORS Technology Group Pty Ltd or any of its related entities.
From: Frederik Kramer <notifications@odoo-community.org>
Sent: Thursday, 4 December 2025 6:52 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Implementing Real CostHi Daniel,
afaik there is also AVCO (Average Costing) but there is no LIFO (even if that would be allowed in many localisations). I am not aware of anyone or any module that has touched this and i personally would issue that reqirement directly to Odoo instead of developing something one by one, because that is very core to accounting compliance
Best Frederik
Am 04.12.25 um 08:32 schrieb Daniel Reis:
Hello,
Odoo supports FIFO costing, but this is not the same as real cost.
For example, when using Lots, I can buy lot A and then Lot B.
If I choose to consume Lot B first, it will carry the purchase cost of Lot A.
As far as I know this is a common request from customers, but I couldn't find an existing implementation for it.
Is there anything I missed out there?
Thank you!
--
DANIEL REIS
MANAGING PARTNER>> Schedule time on my calendar.
M: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office Center, 2649-517 Cascais
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by "Richard deMeester" <richard.demeester@willdooit.com> - 09:01 - 4 Dec 2025 -
Re: Implementing Real Cost
Odoo has implemented cost by lot in Odoo 18+, so nothing extra to do except configuring it AFAIK.Regards.
by Pedro M. Baeza - 09:01 - 4 Dec 2025
