Computed Field Using Two Different Models

computed-fields Studio

1 Odgovori

4943 Prikazi

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.

Jainesh Shah(Aktiv Software)

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

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi

Related Posts	Odgovori	Prikazi
Upgrading from 17 to 18 : Computed fields computed-fields Studio v18	1 feb. 25	3621
Computed field with two conditions with STUDIO Solved conditional computed-fields Studio	4 jan. 24	4139
How to compute a bool field in Studio? Solved fields: computed-fields Studio	1 maj 21	6265
ValueError: forbidden opcode(s) in 'lambda': STORE_ATTR computed-fields	1 jun. 25	19828
Make stored compute filed recompute after changing it logic but not depedencies. computed-fields	3 apr. 25	9685

This question has been flagged

Enjoying the discussion? Don't just read, join in!