Odoo Help


How to set or update fields.function value of existing data ?

Jeudy Nicolas
on 4/5/13, 12:09 PM 13,929 views


I just add a fields.function(_myfunc, .... , store=True) on one OpenERP V7 model. This instance allready has some value in database.

How can I force openERP to compute the value for this field ? New data are ok (set when write method is launch) but for existing one nothing ...!


If a change store=True with store=False, my data are ok, but I need to add this field on search filters.

thanks for your help,


I recently came across this kind of problem (needed to update computed values) and I created a module to add 2 methods to the ORM (compute and compute_all).

You can find it here if you want, and if you ever get a chance to test if on Odoo 8+, let me know (I'm using OpenERP 7.0)


Hope this helps.

Thanks Henri! It works for v8 in my case!

on 10/30/15, 10:01 AM
Antonio Antiun
On 6/2/15, 6:24 PM

You could remove the column from database, for example, for field 'margin' at sale.order model you could execute next SQL with psql:

your_database=> alter table sale_order drop column if exists margin;

Then update the addon in Configuration > Local modules

If you look at Odoo log file you will see one line like:

openerp.models: Storing computed values of sale.order fields margin


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 4/5/13, 9:42 PM

Export the model records, then import them.

This will trigger the write and the values for the functional field will be computed and stored.

If I trigger a write method all my value will be updated ?

Tuxservices, Jeudy Nicolas
on 4/6/13, 5:42 AM

Hy, is this the only way to do this? Isn't it possible to generate a write trigger during installation process?

Mind & Go, Mind And Go
on 6/11/13, 7:05 PM

The best answer I found is here : http://forum.openerp.com/forum/topic30196.html

Mind & Go, Mind And Go
on 6/11/13, 7:46 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/5/13, 12:09 PM
Seen: 13929 times
Last updated: 6/2/15, 6:24 PM