Skip to Content
This question has been flagged
computed-fieldsStudio
1 Reply
3665 Views
Avatar
Abrar Asghar

Problem Description:

I am building a form using Odoo Studio. The form has two section (Similar to sales form). In the top section I have three fields namely:

  • L
  • W
  • A (This is computed field = L x W)

The Value of A is calculated successfully. Below that I have a list (similar to order lines in sales order). The list has Five fields as follows:

  • Material (a text field, manual input)
  • MPA (decimal field, manual input similar to price in sales order line)
  • TM (decimal field, calculated = MPA x A)

As evident, the calculation of TM uses a field A which belongs to a different model. I am unable to perform this calculation.

How I have Tried to Solve It

I have used Odoo Studio and adopted the following approach:

In the compute of TM field I have added the following code:

for record in self:
    record['TM'] = record.A * record.MPA

Version Information

Odoo Online Version 16.04+e(Enterprise)


Any help to resolve this issue will be much appreciated.

Regards.

Avatar
Discard
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hello @Abrar Asghar 


I hope you are doing well,


First of all, for you to access the element of a different module there should be some relation between both for example take a look the sales form in odoo standard, here the relation is one2many in sale.order model and many2one in sale.order.line model.


- As described you have 3 fields(L, W, A) where A is compute (L x W).


Now in the list below(Order lines) again there are 3 fields (Material, MPA, TM) and TM needs to be the compute of MPA and A from above.

Please find code in comment. 

Hope this answer helps you.

Thanks & Regards,
Email: odoo@aktivsoftware.com     

Skype: kalpeshmaheshwari

Avatar
Discard
Jainesh Shah(Aktiv Software)

Please find code here :-

For the compute to work correctly you need to write the compute on TM as below.

def compute_method_name(self):
for record in self:
record.TM = record.m2o_field.A * record.MPA

Related Posts Replies Views Activity
Upgrading from 17 to 18 : Computed fields
computed-fields Studio v18
Avatar
1
फ़र॰ 25
2321
Computed field with two conditions with STUDIO Solved
conditional computed-fields Studio
Avatar
Avatar
Avatar
Avatar
4
जन॰ 24
2891
How to compute a bool field in Studio? Solved
fields: computed-fields Studio
Avatar
1
मई 21
5217
ValueError: forbidden opcode(s) in 'lambda': STORE_ATTR
computed-fields
Avatar
Avatar
1
जून 25
16827
Make stored compute filed recompute after changing it logic but not depedencies.
computed-fields
Avatar
Avatar
Avatar
Avatar
3
अप्रैल 25
7416