Contributors

contributors@odoo-community.org

Re: Implementing Real Cost

Hi Daniel, for Romania we have done more related to FIFO, like FIFO per location and lot valuated started from v14.0 in l10n_ro_stock_account, and also Odoo has starting from 18.0 i think the possibility for lot_valuated.

Best Regards.,

Mihai Fekete

NextERP Romania S.R.L.
600B, Peciu Nou, Romania

E-mail: feketemihai@nexterp.ro
Telefon: ‪0788-749989‬
Website: https://nexterp.ro

On Thu, Dec 4, 2025 at 9:32 AM Daniel Reis <notifications@odoo-community.org> wrote:

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

by Mihai Fekete - 08:46 - 4 Dec 2025

Reference

Implementing Real Cost

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

by Daniel Reis - 08:31 - 4 Dec 2025

7 replies 7 replies

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 Tashiro

Quartile

On 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 deMeester

Development QA

+61 3 9135 1900

+61 403 767 676

richard.demeester@willdooit.com

www.willdooit.com

WilldooIT 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 Cost
Hi 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 deMeester

Development QA

	+61 3 9135 1900
	+61 403 767 676
	richard.demeester@willdooit.com
	www.willdooit.com

WilldooIT 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 Cost

Hi 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

12 attachments 12 attachments

Re: Implementing Real Cost

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.

by Pedro M. Baeza - 09:01 - 4 Dec 2025

Archives

Contributors

contributors@odoo-community.org

Re: Implementing Real Cost

Re: Implementing Real Cost

Reference

Implementing Real Cost

Re: Implementing Real Cost

Re: Implementing Real Cost

Re: Implementing Real Cost

Re: Implementing Real Cost

Re: Implementing Real Cost

GET INVOLVED

APP STORE

GITHUB

PRIVACY

CONTACT

Fund the OCA

The team

Archives

Contributors

Re: Implementing Real Cost

Reference