Skip to Content
This question has been flagged
stockconstraintsqlfloatodooV8
1 Respondre
7298 Vistes
Avatar
Alberto

Suppose, in a custom module, I have fields for:

product_id, stock_location, stock_move, etc

And on another custom module I have a Float field, which will have a quantity, it will represent a fiscal year.


So, before I do any movement, I should check for this Float field, and somehow compare it's data with the product, or products I will be moving (product have a field called 'sale_price' but it could be even a custom Float also on product)


I don't know if I'm explaining myself, but what I want is to compare these fields, and give a constraint to the action, if custom_fiscal Float field has a lower value than the product_price Float one, then show a ValidationError or something like that.


I'm not sure if this scenario could be achievable by using a _constraint or _sql_constraint


Any ideas?


Avatar
Descartar
Avatar
Avinash Nk
Best Answer
Hi kristian,
 
What I can understand from your question is, you have to compare the value of a field on your record with a field in another record.
 
for that, you can create any function.
 
for example, you can call the function on the onchange of your field.
 
Ex:
 
from openerp.exceptions import ValidationError
@api.multi
@api.onchange('your_field')
def function_name(self):
       model_of_the_needed_field = self.env['needed.model'].browse(needed_record_id)
       #now you can compare the value of your field and the othor field.
       if self.your_field == model_of_the_needed_field.other_field:
           raise ValidationError(_("*****You can raise any message here.****"))
Thank you.
Avatar
Descartar
Alberto
Autor

Thank You very much :)

Related Posts Respostes Vistes Activitat
can we calculate product_qty moved from location to a location in a specific hour?
stock sql product.product stock.move odooV8
Avatar
0
de set. 15
3436
how to use constraint and sql constraint? Solved
constraint sql
Avatar
Avatar
Avatar
Avatar
Avatar
6
de des. 23
67731
Override SQL constraint
constraint sql
Avatar
Avatar
1
de març 19
11400
Diagramme de classes relatif au module de stock odoo Solved
stock odooV8 wms
Avatar
Avatar
Avatar
2
de febr. 25
7649
Import stock in products
stock import odooV8
Avatar
Avatar
Avatar
Avatar
3
de juny 24
10157