← Back to featured work

Inventory / Warehouse / Valuation

Multi-UoM Inventory & Stock Valuation

Customized inventory processes for multiple units of measure, conversion ratios, lot/UoM counting, and stock valuation adjustments.

Odoo 14PythonInventoryFIFOPostgreSQL

01 / Overview

The project context.

An Odoo Inventory customization for products handled across different operational units, including lot-based counting and FIFO valuation considerations.

Business problem

Products could be purchased, counted, and processed using different operational units, requiring conversion and valuation logic beyond the default workflow.

02 / Key requirements

What the workflow needed to handle.

  • 01Custom UoM ratio model
  • 02Purchase UoM customization
  • 03Fallback to default purchase UoM
  • 04Lot + UoM inventory counting
  • 05Separate inventory lines by lot/UoM
  • 06Quantity conversion
  • 07Rounding handling
  • 08FIFO valuation adjustments

03 / My role

Contribution to the customization

  • Analyzed UoM and inventory-counting requirements
  • Designed product-ratio and conversion behavior
  • Modified inventory models and valuation-related workflows
  • Implemented validation for conversion and rounding
  • Debugged stock and FIFO valuation behavior

04 / Solution

The Odoo approach

  • Added a custom product-ratio approach to support purchase and operational UoM handling.
  • Kept inventory counts distinct by lot and UoM while converting quantities through defined ratios.
  • Applied rounding and FIFO valuation considerations to preserve consistent inventory behavior.

05 / Technical implementation

Relevant technical areas.

product UoMstock.movestock.quantstock.valuation.layerFIFOinventory adjustmentsOdoo ORMPythonPostgreSQL

06 / Challenges

Technical considerations

  • Converting quantities across operational units
  • Handling quantity rounding
  • Maintaining inventory consistency by lot and UoM
  • Accounting for UoM effects in FIFO valuation

07 / Result & impact

Qualitative outcomes

  • Improved control over multi-UoM inventory processes
  • Improved traceability in lot and UoM-based counts
  • Supported valuation adjustments aligned with operational units

08 / Technologies & modules

Technology focus.

Odoo 14PythonInventoryFIFOPostgreSQL
Back to Projects