Hello,
I have a Stock field and I want it to record the quantity available based on the quantities of product receipts and issues registered.
I need the stock field to update automatically
The stock field should be a calculated field, where the calculation is a subtraction between the input quantity field and the output quantity field.
I have tried to do it in several ways but I can't get the expected result.
I am using Odoo Studio free version
I have tried to create the stock (integer) calculated field with the following code:
for record in self:
record['x_studio_stock_disponible'] = record.x_studio_unidades - record.x_studio_enviado
The Stock field is from the Warehouse model and the fields to be subtracted are related fields, one from the Input model and the other from the Output model. The three models are related.
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 | Activiteit | |
|---|---|---|---|---|
|
|
0
aug. 23
|
3696 | ||
|
1
jun. 21
|
4426 | ||
|
1
mrt. 26
|
929 | ||
|
3
sep. 23
|
4252 | ||
|
2
dec. 25
|
5184 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Could you share first what you have tried already?
I have tried to create the stock (integer) calculated field with the following code:
for record in self:
record['x_studio_stock_disponible'] = record.x_studio_unidades - record.x_studio_enviado
The Stock field is from the Warehouse model and the fields to be subtracted are related fields, one from the Input model and the other from the Output model. The three models are related.