Skip to Content
This question has been flagged
xmldatefieldopenerp
2 Replies
5079 Views
Avatar
TestUser

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?

Avatar
Discard
Avatar
Ray Carnes
Best Answer

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.

Avatar
Discard
TestUser
Author

Thanks, that helped me a lot.

Avatar
Gustavo
Best Answer

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

Avatar
Discard
Related Posts Replies Views Activity
How select the month of a date type ?
xml date field time type
Avatar
Avatar
1
Mar 15
6980
HOW TO GET MONTH AS TEXT
date field v15
Avatar
Avatar
1
Nov 22
2780
How can I calculate difference between two dates ? Solved
date field difference
Avatar
Avatar
Avatar
3
Nov 21
25080
limit field in xml
views xml date
Avatar
Avatar
1
Aug 21
3193
How to add Salary rule as data in Base salary structure Solved
xml openerp odooV8
Avatar
Avatar
3
May 16
9808