Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I want to get the value/amount from a particular location.
I call the stock_value field from product.product model, but it returns the value from overall location, I just want to get the value from a specific loc like if I have two locs Wh/Main and Wh/Extra, I only want to fetch it from extra, how can I do it, I tried the with_context but It has an error comparing apples and oranges.
stock valuation using filters, do not solve this?
I tried to use it like product_id.with_context({'location':self.location_id}).stock_value, but it still return the overall so I just use the sm = self.env['stock.move'].search([('location_id','=',self.location_id.id),('product_id','=',product_id.id)]) then a = sum([rec.value for rec in sm]) then I got what I wanted but I dunno if this is a way to do it, Im afraid it will slower the performance
There is a module here that make this function and its available for all versions
https://apps.odoo.com/apps/modules/13.0/product_warehouse_quantity/
hope it will help you
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
7
kwi 18
|
10227 | ||
|
1
sie 25
|
157 | ||
|
Inventory Value Issue from Adjustment/Update
Rozwiązane
|
|
1
lip 21
|
3762 | |
|
4
sie 24
|
14365 | ||
|
2
mar 23
|
8474 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
