Computed Field Using Two Different Models

computed-fields Studio

1 Besvara

4932 Vyer

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

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
Upgrading from 17 to 18 : Computed fields computed-fields Studio v18	1 feb. 25	3621
Computed field with two conditions with STUDIO Löst conditional computed-fields Studio	4 jan. 24	4139
How to compute a bool field in Studio? Löst fields: computed-fields Studio	1 maj 21	6263
ValueError: forbidden opcode(s) in 'lambda': STORE_ATTR computed-fields	1 juni 25	19827
Make stored compute filed recompute after changing it logic but not depedencies. computed-fields	3 apr. 25	9682

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!