stock_move_quantity_product_uom

у stock-logistics-warehouse · джерело на GitHub

computes stock.move's quantity in the uom of the product.

Категорія: Inventory/Inventory · ForgeFlow S.L. · LGPL-3

2026-09-10 18:24:45,537 1 INFO job_d4ac3be27dc0 odoo.modules.loading: loading stock/security/ir.access.csv
2026-09-10 18:24:46,151 1 INFO job_d4ac3be27dc0 odoo.registry: Registry changed, signaling through the database
2026-09-10 18:24:46,161 1 INFO job_d4ac3be27dc0 odoo.modules.loading: Module stock loaded in 13.68s, 5348 queries (+5348 other)
2026-09-10 18:24:46,162 1 INFO job_d4ac3be27dc0 odoo.modules.loading: Loading module stock_move_quantity_product_uom (43/44)
2026-09-10 18:24:46,221 1 ERROR job_d4ac3be27dc0 odoo.sql_db: bad query: b'\n        UPDATE stock_move sm\n        SET quantity_product_uom = sm.quantity\n        FROM product_product pp\n        JOIN product_template pt ON pt.id = pp.product_tmpl_id\n        WHERE sm.product_id = pp.id\n          AND pt.uom_id = sm.product_uom\n        '
ERROR: column sm.product_uom does not exist
LINE 7:           AND pt.uom_id = sm.product_uom
                                  ^
HINT:  Perhaps you meant to reference the column "sm.product_id" or the column "sm.product_qty".

2026-09-10 18:24:46,232 1 WARNING job_d4ac3be27dc0 odoo.modules.loading: Transient module states were reset
2026-09-10 18:24:46,233 1 ERROR job_d4ac3be27dc0 odoo.registry: Failed to load registry
2026-09-10 18:24:46,233 1 CRITICAL job_d4ac3be27dc0 odoo.service.server: Failed to initialize database `job_d4ac3be27dc0`.
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 1559, in preload_registries
    registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 67, in locked
    return func(inst, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/odoo/orm/registry.py", line 222, in new
    contextvars.Context().run(
  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 446, in load_modules
    load_module_graph(
  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 179, in load_module_graph
    getattr(py_module, pre_init)(env)
  File "/mnt/pool/stock_move_quantity_product_uom/hook.py", line 7, in pre_init_quantity_product_uom
    env.cr.execute(
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 418, in execute
    self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: column sm.product_uom does not exist
LINE 7:           AND pt.uom_id = sm.product_uom
                                  ^
HINT:  Perhaps you meant to reference the column "sm.product_id" or the column "sm.product_qty".

2026-09-10 18:24:46,238 1 INFO job_d4ac3be27dc0 odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-10 18:24:46,238 1 INFO job_d4ac3be27dc0 odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-10 18:24:46,239 1 INFO job_d4ac3be27dc0 odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-10 18:24:46,341 1 INFO job_d4ac3be27dc0 odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connections

2026-09-18 16:12:40,664 1 INFO job_3a53f0255b33 odoo.modules.loading: loading stock/security/ir.access.csv
2026-09-18 16:12:41,483 1 INFO job_3a53f0255b33 odoo.registry: Registry changed, signaling through the database
2026-09-18 16:12:41,493 1 INFO job_3a53f0255b33 odoo.modules.loading: Module stock loaded in 16.00s, 5626 queries (+5626 other)
2026-09-18 16:12:41,493 1 INFO job_3a53f0255b33 odoo.modules.loading: Loading module stock_move_quantity_product_uom (43/44)
2026-09-18 16:12:41,551 1 ERROR job_3a53f0255b33 odoo.sql_db: bad query: b'\n        UPDATE stock_move sm\n        SET quantity_product_uom = sm.quantity\n        FROM product_product pp\n        JOIN product_template pt ON pt.id = pp.product_tmpl_id\n        WHERE sm.product_id = pp.id\n          AND pt.uom_id = sm.product_uom\n        '
ERROR: column sm.product_uom does not exist
LINE 7:           AND pt.uom_id = sm.product_uom
                                  ^
HINT:  Perhaps you meant to reference the column "sm.product_id" or the column "sm.product_qty".

2026-09-18 16:12:41,560 1 WARNING job_3a53f0255b33 odoo.modules.loading: Transient module states were reset
2026-09-18 16:12:41,562 1 ERROR job_3a53f0255b33 odoo.registry: Failed to load registry
2026-09-18 16:12:41,562 1 CRITICAL job_3a53f0255b33 odoo.service.server: Failed to initialize database `job_3a53f0255b33`.
Traceback (most recent call last):
  File "/opt/odoo/odoo/service/server.py", line 1520, in preload_registries
    registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/odoo/odoo/tools/func.py", line 67, in locked
    return func(inst, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/odoo/odoo/orm/registry.py", line 222, in new
    contextvars.Context().run(
  File "/opt/odoo/odoo/modules/loading.py", line 449, in load_modules
    load_module_graph(
  File "/opt/odoo/odoo/modules/loading.py", line 179, in load_module_graph
    getattr(py_module, pre_init)(env)
  File "/mnt/pool/stock_move_quantity_product_uom/hook.py", line 7, in pre_init_quantity_product_uom
    env.cr.execute(
  File "/opt/odoo/odoo/sql_db.py", line 418, in execute
    self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: column sm.product_uom does not exist
LINE 7:           AND pt.uom_id = sm.product_uom
                                  ^
HINT:  Perhaps you meant to reference the column "sm.product_id" or the column "sm.product_qty".

2026-09-18 16:12:41,566 1 INFO job_3a53f0255b33 odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-18 16:12:41,566 1 INFO job_3a53f0255b33 odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-18 16:12:41,567 1 INFO job_3a53f0255b33 odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-18 16:12:41,670 1 INFO job_3a53f0255b33 odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connections

Код модуля на 19.0

Рядки — фізичні, разом із порожніми й коментарями, як wc -l. Тести — файли test_*.py у теці tests/. Моделі — рядки з _name = і _inherit =. Це факти про код, а не оцінка: більше рядків не означає ні краще, ні гірше. Зміряно 2026-08-28 на дереві cc852d082741.

У каталозі apps.odoo.com є листинг під тією самою технічною назвою на 19.0: apps.odoo.com/apps/modules/19.0/stock_move_quantity_product_uom. Збіг назви не доводить збіг коду — як ми це рахували.

Залежить від

Від нього залежать

1 модуль на 19.0 оголошує його своєю залежністю.

Історія

Переклади й коміти ботів у підрахунок не входять.

Результат виглядає неправильним? Повідомте — ми покажемо лог або перепрогонимо. Повідомити про хибний результат

Дізнатися, коли цей модуль змінить стан