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.
Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!
Tilmeld dig| Relaterede indlæg | Besvarelser | Visninger | Aktivitet | |
|---|---|---|---|---|
|
|
0
aug. 23
|
3708 | ||
|
1
jun. 21
|
4441 | ||
|
1
mar. 26
|
932 | ||
|
3
sep. 23
|
4262 | ||
|
2
dec. 25
|
5212 |
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.