Calculating with fields without module changes

Question

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 · 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 p

Gustavo · Answer

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

関連投稿	返信	ビュー
How select the month of a date type ? xml date field time type	1 3月 15	7219
HOW TO GET MONTH AS TEXT date field v15	1 11月 22	3098
How can I calculate difference between two dates ? 解決済 date field difference	3 11月 21	25652
limit field in xml views xml date	1 8月 21	3425
How to add Salary rule as data in Base salary structure 解決済 xml openerp odooV8	3 5月 16	10114

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！