Computed Field Using Two Different Models

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Computed Field Using Two Different Models

computed-fields Studio

1 Beantwoorden

2659 Weergaven

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Upgrading from 17 to 18 : Computed fields computed-fields Studio v18	1 feb. 25	1524
Computed field with two conditions with STUDIO Opgelost conditional computed-fields Studio	4 jan. 24	1985
How to compute a bool field in Studio? Opgelost fields: computed-fields Studio	1 mei 21	4603
ValueError: forbidden opcode(s) in 'lambda': STORE_ATTR computed-fields	1 jun. 25	15558
Make stored compute filed recompute after changing it logic but not depedencies. computed-fields	3 apr. 25	5820

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!