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.
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 | Verksamhet | |
|---|---|---|---|---|
|
|
0
aug. 23
|
3714 | ||
|
1
juni 21
|
4448 | ||
|
1
mars 26
|
942 | ||
|
3
sep. 23
|
4269 | ||
|
2
dec. 25
|
5248 |
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.