Odoo Help


Calculating with fields without module changes

on 4/17/13, 6:16 AM 2,241 views

I have products with an expiry date. The amount of days are stored in a field (product model).

Is it possible to calculate this amount of days to a field (type of date) without any module changes?

The expiry date has to be shown in a delivery order. I tried several things with ReportDesigner in LibreOffice... something using timedelta-function but that was not working in LibreOffice.

Is there another way? Maybe a solution by using xml?


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/18/13, 12:49 AM

One solution is to leverage serial numbers (really lot numbers).

Each can have a 'best before date', and an 'end of life date' which can probably easily be shown alongside the product on each line.

You need to enable 'Track serial number on products' and 'Expiry date on serial numbers' under

Settings --> Configuration --> Warehouse

Each time you deliver goods, you assign each product that expires to a serial number. The serial number already shows up on the Delivery Order PDF so the other properties of the serial number should be available.

Haven't tried.

Thanks, that helped me a lot.

on 4/22/13, 5:33 AM
On 4/17/13, 9:21 AM

Yes, you can create a trigger or stored procedure in the database to do that.

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

0 follower(s)


Asked: 4/17/13, 6:16 AM
Seen: 2241 times
Last updated: 3/16/15, 8:10 AM