This question has been flagged
2 Replies
4141 Views

Hi,

I would like to know if it is possible to create a custom field, for example a threshold for a product, and when the quantity of products is lower than the threshold, the system sends a mail to one of the entities of the system (like Administrator or other people...)

Anybody knows how to perform it?


Thanks all

Avatar
Discard
Best Answer

Hi,

I think you can achieve this by defining your own custom field and you can use your script for checking that number in write method and if its positive you can send e-mail(by using script).

By giving the script in write method it will execute and check every time when the value is changed.

Or you can use scheduled actions, but it will execute only at given intervals.

Hope this helps.

Avatar
Discard
Best Answer

Hi Francesco,

I thought you can achieve by Automated actions, here is what i'm suggested, Try this.

from openerp import models, fields, api
class product_template_inherit(models.Model):
    _inherit = 'product.template'
    threshold = fields.Integer('Threshold')

    def check_product_qty(self, cr, uid, context=None):
        ids = self.search(cr, uid, [], context)
        products = self.browse(cr, uid, ids, context)
for product in products:
            if product.qty_available < product.threshold:
                // Write actions for sending mail here
<openerp>
<data>
        <record model="ir.cron" id="check_poduct_qty_with_threshold">
        <field name="name">Threshold</field>
        <field name="interval_number">1</field>
        <field name="interval_type">minutes</field>
        <field name="numbercall">-1</field>
        <field eval="False" name="doall"/>
        <field eval="'product.template'" name="model"/>
        <field eval="'check_product_qty'" name="function"/>
        <field eval="'()'" name="args"/>
    </record>
    </data>
</openerp>

Avatar
Discard