Purchase_stock_price_unit_sync: Stock Valuation Layer unit_cost and total_value not sync

[Jaimermaccione]

Stock Valuation Layer unit_cost and total_value desynchronization

Module

purchase_stock_price_unit_sync

Describe the bug

When updating the unit price or discount in a confirmed purchase order (purchase.order.line) after a receipt has been completed, the corresponding unit cost (unit_cost) in the stock valuation layer (stock.valuation.layer) is updated correctly, but the total value (total_value) is not recalculated. This leads to an inconsistent stock valuation, where the total inventory value does not match the expected computation:

The stock valuation should remain consistent when price updates affect received inventory.

To Reproduce

Affected versions

• Odoo 14.0, 15.0, 16.0 (potentially others)

Steps to reproduce the behavior

1. Create a purchase order with a product that uses one of the following cost methods:
   • Standard (standard)
   • FIFO (fifo)
   • Average Cost (avco)
2. Confirm the purchase order and receive the product.
3. Check the created stock valuation layer (stock.valuation.layer) entry.
4. Go back to the purchase order line and update the price unit or discount.
5. Observe that:
   • unit_cost in the stock valuation layer updates correctly.
   • value (total_value) remains unchanged, causing an inconsistency.

Expected behavior

When the unit cost (unit_cost) is updated, the corresponding total value should also be recalculated to maintain consistency in stock valuation.

The expected behavior is:

If unit_cost changes due to a price update in a confirmed purchase order, total_value should reflect this new cost.

Additional context

• Odoo 14.0, 15.0, 16.0
• Standard Odoo modules without modifications.
• The issue has been tested with products using Standard, FIFO, and AVCO cost methods, and the behavior remains the same across all methodologies.

Impact

This issue affects accounting accuracy for companies relying on real-time inventory valuation methods (FIFO/AVCO). It may also impact cost-based margin calculations.

Please review and confirm if this is the intended behavior or if it should be adjusted to maintain valuation consistency. Thank you!

[HaraldPanten]

@pedrobaeza Could you confirm that this is a bug? We'll make a FIX, after confirmation.

THX!

[pedrobaeza]

I don't think this is related to purchase_stock_price_unit_sync. In fact, that module has nothing to do with the totalized values.