Computed Field Using Two Different Models

1 Răspunde

4184 Vizualizări

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!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
Upgrading from 17 to 18 : Computed fields computed-fields Studio v18	1 feb. 25	2880
Computed field with two conditions with STUDIO Rezolvat conditional computed-fields Studio	4 ian. 24	3401
How to compute a bool field in Studio? Rezolvat fields: computed-fields Studio	1 mai 21	5535
ValueError: forbidden opcode(s) in 'lambda': STORE_ATTR computed-fields	1 iun. 25	18029
Make stored compute filed recompute after changing it logic but not depedencies. computed-fields	3 apr. 25	8493

Această întrebare a fost marcată

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