Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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?
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.
Yes, you can create a trigger or stored procedure in the database to do that.
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
1
mars 15
|
7311 | ||
|
1
nov. 22
|
3196 | ||
|
3
nov. 21
|
25817 | ||
|
1
août 21
|
3500 | ||
|
3
mai 16
|
10232 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
