Skip to Content
This question has been flagged
1 Respondre
154 Vistes
Avatar
Sergio Mesa

Buenos dias , necesito ayuda por favor tengo problema al momento de migrar me sale que la base de datos y pues al modificarla no es la que se esta usando para la migracion y no he podido avanzar no se como solucionarlo dice que es una formula de python 


odoo.exceptions.ValidationError: Fórmula incorrecta "if price_unit:

result = price_unit * quantity * 0.19

else:

result = product['list_price'] * quantity * 0.19" en la posición 0




('website_sale.menu_orders_orders', 431, 'Website > eCommerce > Orders > Orders', 593):

 

2025-11-26 21:00:35,602 5658 INFO db_3438367 odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 2 connections

[ERROR]::Error during the upgrade: command execution has failed with the error code 1

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,
Your migration is failing because a Studio formula field contains multi-line Python code, and Odoo Studio only accepts one-line expressions. The formula you wrote uses an if/else block, which is invalid during validation, so the migration stops with a “Incorrect formula” error. To fix it, open that field in Studio and rewrite the compute formula as a single-line ternary expression. For example, instead of using multiple lines, rewrite it as
(price_unit * quantity * 0.19) if price_unit else (product['list_price'] * quantity * 0.19).
After saving this correction in your current Odoo instance, the migration validation will pass.

Hope it helps.

Avatar
Descartar